Horizontal and vertical analysis of the income statements

Assignment Help Accounting Basics

Reference no: EM13590191

Complete the following for the communications company "CenturyLink" in an Excel spreadsheet:

1. Horizontal and vertical analysis of the Income Statements for the past three years (all yearly balances set as a percentage of total revenues for that year).

2. Horizontal and vertical analysis of the Balance Sheets for the past three years (all yearly balances set as a percentage of total assets for that year).

3. Ratio analysis (eight ratios of your choosing) for the past three years PLUS a measurement for the creditworthiness of your firm as measured by Altman's Z-score. Note that if you used your chosen firm for our ratio-related discussion posts, then you MUST also present industry-average ratios or current year competitor ratios for your ratio analysis. Comparing your firm's ratios to a close competitor or an industry-average ratio makes your analysis much more meaningful.

Reference no: EM13590191

Questions Cloud

Mary willis is the advertising manager for bargain shoe : mary willis is the advertising manager for bargain shoe store. she is currently working on a major promotional

Connor companys budgeted prices for direct materials direct : connor companys budgeted prices for direct materials direct manufacturing labor and direct marketing distribution labor

You are given a spreadsheet with daily sales numbers : you are given a spreadsheet with daily sales numbers ordered by date from january 1st to december 31st. you have been

Calculate the dividends per share on each class of stock : wallace inc. a developer of radiology equipment has stock outstanding as follows 30000 shares of cumulative preferred 2

Horizontal and vertical analysis of the income statements : complete the following for the communications company centurylink in an excel spreadsheet1. horizontal and vertical

Grunewald company manufacturers a professional grade vacuum : grunewald company manufacturers a professional grade vacuum cleaner and began operations in 2011. for 2011 grunewald

During a january pay period susan works 46 hours susans : susan brauns regular hourly wage rate is 30 and she receives an hourly rate of 45 for work in excess of 40 hours.

The values of the resistance capacitive reactance and : question the ac generator in a series rcl circuit has an rms voltage of 81.3 v. the values of the resistance capacitive

The dining room at monticello thomas jeffersons home in : the dining room at monticello thomas jeffersons home in virgina is 216 inches by 222 inches. of the following which

User Account

All Pages