Download the attached Spreadsheet (Links to an external site.). Prepare a Common Size Analysis and Trend Analysis for three years for the Income Statement, Balance
Download the attached Spreadsheet (Links to an external site.). Prepare a Common Size Analysis and Trend Analysis for three years for the Income Statement, Balance Sheet and Cash Flows Statement of Excel Corporation (There is a separate worksheet for each of these analyses). Once you have completed the Common Size and Trend Analyses review your work and prepare a written summary of insights to management of how the Excel Corporation is performing (There our 2 separate worksheets for your written analysis).
RUBRIC
Criteria Ratings Pts This criterion is linked to a Learning OutcomeCommon Size Analysis Common Size Analysis for each Financial Statement prepared accurately, completely, and professionally. 15.0 pts This criterion is linked to a Learning OutcomeTrend Analysis Trend Analysis for each Financial Statement prepared accurately, completely, and professionally. 15.0 pts This criterion is linked to a Learning OutcomeWritten Analysis Insights of both common size and trend analysis were completed fully and appropriately. Writing was professional and free of grammar and spelling errors. Any help you can provide would be greatly appreciated! I am so lost!
2 3 Excel Corporation BALANCE SHEETS (In millions) June 30, 4 2019 2018 2017 2019 2018 2017 5 T 0 11,356 $ 122,463 $ 29,524 $ 2,063 $ 10,146 $ 175,552 $ 11,946 $ 121,822 $ 26,481 $ 2,662 $ 6,751 $ 169,662 $ 7,663 125,318 22,431 2,181 5,103 162,696 2 3 Assets Current assets: Cash and cash equivalents $ Short-term investments $ Accounts receivable, net of allowance for doubtful accounts of $411 and $377 $ 1 Inventories Other $ Total current assets $ 4 5 Property and equipment, net of accumulated depreciation of $35,330 and $29, $ 6 Operating lease right-of-use assets $ 7 Equity investments $ 8 Goodwill $ Intangible assets, net $ Other long-term assets -1 2 Total assets $ 36,477 $ 7,379 $ 2,649 $ 42,026 7,750 $ 14,723 $ 29,460 $ 6,686 $ 1,862 $ 35,683 $ 8,053 $ 7,442 $ 23,734 6,555 6,023 35,122 10,106 6,076 9 , 286,556 $ 250.312 -5 $ 4 Liabilities and stockholders' equity Current liabilities: & Accounts payable -7 Short Term Debt Current portion of long-term debt Accrued compensation EO Short-term income taxes =1 Short-term unearned revenue =2 Other Total current liabilities 7,390 9,072 1,049 5,819 =8 $ $ $ 9,382 $ $ 5,516 $ 6,830 $ 5,665 $ 32,676 $ 9,351 $ 69,420 $ 8,617 $ $ 3,998 $ 6,103 $ 2,121 28,905 $ 8,744 $ 58,488 $ $ 718 $ $ 24,013 7,684 55,745 $ $ $ $ =5 Long-term debt E6 Long-term income taxes =7 Long-term unearned revenue =8 Deferred income taxes 9 Operating lease liabilities 10 Other long-term liabilities 11 12 Total liabilities 66,662 $ 29,612 $ 4,530 $ 233 $ 6,188 7,581 $ 72,242 $ 30,265 $ 3,815 $ $ 5,568 $ 5,211 $ 541 76,073 13,485 2,643 5,734 5,372 3,549 $ 184,226 $ 176,130 $ 162,601 14 Commitments and contingencies 15 Stockholders' equity: 16 Common stock and paid-in capital - shares authorized 24,000; outstanding 7.4 $ Retained earnings Accumulated other comprehensive loss 17 64 78,520 $ 24,150 $ (340) $ 71,223 $ 13,682 $ (2,187) $ 69,315 17,769 627 102,330 $ 82,718 $ 87,711 FO Total stockholders' equity 1 =2 Total liabilities and stookholders' equity 64 286,556 $ 258,848 $ 250,312 2 3 Excel Corporation BALANCE SHEETS (In millions) June 30, 4 2019 2018 2017 2019 2018 2017 5 T 0 11,356 $ 122,463 $ 29,524 $ 2,063 $ 10,146 $ 175,552 $ 11,946 $ 121,822 $ 26,481 $ 2,662 $ 6,751 $ 169,662 $ 7,663 125,318 22,431 2,181 5,103 162,696 2 3 Assets Current assets: Cash and cash equivalents $ Short-term investments $ Accounts receivable, net of allowance for doubtful accounts of $411 and $377 $ 1 Inventories Other $ Total current assets $ 4 5 Property and equipment, net of accumulated depreciation of $35,330 and $29, $ 6 Operating lease right-of-use assets $ 7 Equity investments $ 8 Goodwill $ Intangible assets, net $ Other long-term assets -1 2 Total assets $ 36,477 $ 7,379 $ 2,649 $ 42,026 7,750 $ 14,723 $ 29,460 $ 6,686 $ 1,862 $ 35,683 $ 8,053 $ 7,442 $ 23,734 6,555 6,023 35,122 10,106 6,076 9 , 286,556 $ 250.312 -5 $ 4 Liabilities and stockholders' equity Current liabilities: & Accounts payable -7 Short Term Debt Current portion of long-term debt Accrued compensation EO Short-term income taxes =1 Short-term unearned revenue =2 Other Total current liabilities 7,390 9,072 1,049 5,819 =8 $ $ $ 9,382 $ $ 5,516 $ 6,830 $ 5,665 $ 32,676 $ 9,351 $ 69,420 $ 8,617 $ $ 3,998 $ 6,103 $ 2,121 28,905 $ 8,744 $ 58,488 $ $ 718 $ $ 24,013 7,684 55,745 $ $ $ $ =5 Long-term debt E6 Long-term income taxes =7 Long-term unearned revenue =8 Deferred income taxes 9 Operating lease liabilities 10 Other long-term liabilities 11 12 Total liabilities 66,662 $ 29,612 $ 4,530 $ 233 $ 6,188 7,581 $ 72,242 $ 30,265 $ 3,815 $ $ 5,568 $ 5,211 $ 541 76,073 13,485 2,643 5,734 5,372 3,549 $ 184,226 $ 176,130 $ 162,601 14 Commitments and contingencies 15 Stockholders' equity: 16 Common stock and paid-in capital - shares authorized 24,000; outstanding 7.4 $ Retained earnings Accumulated other comprehensive loss 17 64 78,520 $ 24,150 $ (340) $ 71,223 $ 13,682 $ (2,187) $ 69,315 17,769 627 102,330 $ 82,718 $ 87,711 FO Total stockholders' equity 1 =2 Total liabilities and stookholders' equity 64 286,556 $ 258,848 $ 250,312
