Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The purpose of this homework is to perform a financial analysis of a company using your knowledge of financial statements and financial analysis. Please select
The purpose of this homework is to perform a financial analysis of a company using your knowledge of financial statements and financial analysis.
- Please select a publicly-traded company on the New York Stock Exchange that has at least 3 years of financial statements. AT&T
- Prepare an analysis covering 3 years (this can be any contiguous 3-year period) that includes: 2016-2019
- Evaluation of the operating performance in each year and as a trend over the 3 years.
- Analysis of the financial performance in each year and as a trend over the 3 years. Be sure to use a comprehensive set of financial ratios from those presented in the book and other analyses from the book you deem appropriate. Provide a description of each ratio, explaining its meaning and what the numbers for this company convey. (Survey Of Accounting- Carl S Warren)
- Provide a summary analysis that indicates whether the company is in good financial condition and what you expect for the near future (and why).
The report should be professional in appearance and well-written. I will grade the report on thoroughness of analysis, accuracy of analysis, and quality. 3 pages max
By the way, you can include copy-and-pasted images of the financial statements or you can recreate the financial statements. Either is fine.
Selected Financial and Operating Data Dollars in millions except per share amounts 2018 2017 2016 2015 2014 $ $ $170,756 $144,660 $ 26,096 $ 7,957 $ (48) $ 6,782 $ 4,920 $ 19,953 $160,546 $140,576 $ 19,970 $ 6,300 $ (128) $ 1.597 S (14.708) $ 29,847 $163,786 $140,243 $ 23,543 4,910 $ 98 1,081 $ 6,479 $ 13,333 $146.801 $126,439 $ 20,362 $ 4120 S 79 S 4,371 $ 7,005 $ 13,687 $132,447 $113,860 $ 18,587 3,613 $ 175 $ (4.794) $ 3,619 $ 6,736 $ $ $ (583) $ 19,370 S (397) $ 29,450 $ (357) $ 12.976 $ (342) $ 13,345 (294) 6,442 $ $ 2.85 S 4.77 $ 2.10 S 2.37 $ 1.24 At December 31 and for the year ended Financial Data Operating revenues Operating expenses Operating Income Interest expense Equity In net Income (Loss) of affiliates Other Income (expense) - net Income tax (benefit) expense Net Income Less: Net Income Attributable to Noncontrolling Interest Net Income Attributable to AT&T Earnings Per Common Share: Net Income Attributable to AT&T Earnings Per Common Share - Assuming Dilution: Net Income Attributable to AT&T Cash and cash equivalents Total assets Long-term debt Total debt Capital expenditures: Dividends declared per common share Book value per common share Ratio of earnings to fixed charges Debt ratio Net debt ratio Welghted average common shares outstanding (000,000) Welghted average common shares outstanding with dilution (000,000) End of period common shares outstanding (000.000) $ $ 2.85 $ 5,204 $531,864 $166,250 $176,505 $ 21,251 $ 2.01 $ 26.63 3.42 47.7% 46.2% 6,778 S 2.37 $ 5,121 $402,672 $118.515 $126.151 $ 20,015 2.10 $ 5.788 $403,821 $113,681 $123,513 $ 22,408 $ 1.93 20.22 3.59 S 4.76 $ 50,498 $444,097 $125,972 $164.346 $ 21,550 S 1.97 S 23.13 2.63 53.6% 37.2% 6,164 $ 1.24 $ 8,603 $296,834 $ 75,778 $ 81,834 $ 21,433 $ 1.85 17.40 S S $ 1.89 20.12 4.01 $ 149.9% 2.91 47.5% 42.6% 5,205 50.5% 48.5% 5.628 47.5% 6.168 6,806 7,282 6,183 6,139 6.189 6,139 5,646 6,145 5,221 5,187 268,540 281,450 243,620 Number of employees 268,220 254,000 Includes FirstNet reimbursements of $1,429 in 2018. $279 in 2017 and $0 in 2016-2014 (see Note 19). Percent Change 2018 vs. 2017 vs. 2017 2016 2018 2017 2016 $152,345 18,411 170,756 $145,597 14,949 160,546 $148,884 14,902 163,786 4.6% 23.2 6.4 (2.2)% 0.3 (2.0) 16.6 Operating revenues Service Equipment Total Operating Revenues Operating expenses Operations and support Depreciation and amortization Total Operating Expenses Operating Income Interest expense Equity in net income (Loss) of affiliates Other income (expense) - net Income Before Income Taxes Net Income Net Income Attributable to AT&T 2.9 1.6 (5.6) 0.2 (15.2) 28.3 30.7 116,230 28,430 144,660 26,096 7,957 (48) 6,782 24,873 19,953 $ 19,370 116,189 24,387 140,576 19,970 6,300 (128) 1,597 15,139 29,847 $ 29,450 114,396 25,847 140,243 23,543 4,910 98 1,081 19,812 13,333 $ 12,976 26.3 62.5 47.7 (23.6) 64.3 (33.1) (34.2)% -% Selected Financial and Operating Data Dollars in millions except per share amounts 2018 2017 2016 2015 2014 $ $ $170,756 $144,660 $ 26,096 $ 7,957 $ (48) $ 6,782 $ 4,920 $ 19,953 $160,546 $140,576 $ 19,970 $ 6,300 $ (128) $ 1.597 S (14.708) $ 29,847 $163,786 $140,243 $ 23,543 4,910 $ 98 1,081 $ 6,479 $ 13,333 $146.801 $126,439 $ 20,362 $ 4120 S 79 S 4,371 $ 7,005 $ 13,687 $132,447 $113,860 $ 18,587 3,613 $ 175 $ (4.794) $ 3,619 $ 6,736 $ $ $ (583) $ 19,370 S (397) $ 29,450 $ (357) $ 12.976 $ (342) $ 13,345 (294) 6,442 $ $ 2.85 S 4.77 $ 2.10 S 2.37 $ 1.24 At December 31 and for the year ended Financial Data Operating revenues Operating expenses Operating Income Interest expense Equity In net Income (Loss) of affiliates Other Income (expense) - net Income tax (benefit) expense Net Income Less: Net Income Attributable to Noncontrolling Interest Net Income Attributable to AT&T Earnings Per Common Share: Net Income Attributable to AT&T Earnings Per Common Share - Assuming Dilution: Net Income Attributable to AT&T Cash and cash equivalents Total assets Long-term debt Total debt Capital expenditures: Dividends declared per common share Book value per common share Ratio of earnings to fixed charges Debt ratio Net debt ratio Welghted average common shares outstanding (000,000) Welghted average common shares outstanding with dilution (000,000) End of period common shares outstanding (000.000) $ $ 2.85 $ 5,204 $531,864 $166,250 $176,505 $ 21,251 $ 2.01 $ 26.63 3.42 47.7% 46.2% 6,778 S 2.37 $ 5,121 $402,672 $118.515 $126.151 $ 20,015 2.10 $ 5.788 $403,821 $113,681 $123,513 $ 22,408 $ 1.93 20.22 3.59 S 4.76 $ 50,498 $444,097 $125,972 $164.346 $ 21,550 S 1.97 S 23.13 2.63 53.6% 37.2% 6,164 $ 1.24 $ 8,603 $296,834 $ 75,778 $ 81,834 $ 21,433 $ 1.85 17.40 S S $ 1.89 20.12 4.01 $ 149.9% 2.91 47.5% 42.6% 5,205 50.5% 48.5% 5.628 47.5% 6.168 6,806 7,282 6,183 6,139 6.189 6,139 5,646 6,145 5,221 5,187 268,540 281,450 243,620 Number of employees 268,220 254,000 Includes FirstNet reimbursements of $1,429 in 2018. $279 in 2017 and $0 in 2016-2014 (see Note 19). Percent Change 2018 vs. 2017 vs. 2017 2016 2018 2017 2016 $152,345 18,411 170,756 $145,597 14,949 160,546 $148,884 14,902 163,786 4.6% 23.2 6.4 (2.2)% 0.3 (2.0) 16.6 Operating revenues Service Equipment Total Operating Revenues Operating expenses Operations and support Depreciation and amortization Total Operating Expenses Operating Income Interest expense Equity in net income (Loss) of affiliates Other income (expense) - net Income Before Income Taxes Net Income Net Income Attributable to AT&T 2.9 1.6 (5.6) 0.2 (15.2) 28.3 30.7 116,230 28,430 144,660 26,096 7,957 (48) 6,782 24,873 19,953 $ 19,370 116,189 24,387 140,576 19,970 6,300 (128) 1,597 15,139 29,847 $ 29,450 114,396 25,847 140,243 23,543 4,910 98 1,081 19,812 13,333 $ 12,976 26.3 62.5 47.7 (23.6) 64.3 (33.1) (34.2)% -%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started