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 Outcome Common Size Analysis Common Size Analysis for each Financial Statement prepared accurately, completely, and professionally. 15.0 pts This criterion is linked to a Learning Outcome Trend Analysis Trend Analysis for each Financial Statement prepared accurately, completely, and professionally. 15.0 pts This criterion is linked to a Learning Outcome Written 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!
 

Transcribed Image Text:

1 Excel Corporation 2 BALANCE SHEETS (In millions) 3 4 June 30, 2019 2018 2017 2019 2018 2017 5 Assets 7 Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net of allow ance for doubtful accounts of $411 and $377 11,946 $ 121,822 $ 26,481 $ 2,662 $ 6,751 $ 169,662 $ %$4 11,356 $ 7,663 125,318 22,431 2,181 5,103 162,696 8 122,463 $ 29,524 $ 2,063 $ 10,146 $ 175.552 $ 10 11 Inventories Other Total ourrent assets 12 13 14 Property and equipment, net of accumulated depreciation of $35,330 and $29,223 Operating lease right-of-use assets Equity investments Goodwill 36,477 $ 7,379 $ 2,649 $ 42,026 $ 7,750 $ 14,723 $ 29,460 6,686 $ 1,862 $ 35,683 $ 8,053 $ 7.442 $ $4 23,734 6,555 6,023 35,122 10,106 6,076 15 16 17 18 Intangible assets, net 20 Other long-term assets 19 21 22 Total assets $286,556.00 $258,848.00 $250,312 23 24 Liabilities and stockholders' equity 25 Current liabilities: 26 Accounts payable 9,382 $ 8,617 $ 7,390 9,072 1,049 5,819 27 Short Term Debt $4 $4 28 Current portion of long-term debt 29 Aoorued compensation Short-term income taxes Short-term unearned revenue 32 Other $4 5,516 $ 6,830 $ 5,665 $ 3,998 $ 6,103 $ 2,121 $ 28,905 $ 8,744 58,488 $ 30 718 32,676 $ 9,351 $ 69,420 $ $4 24,013 7,684 55,745 31 $4 33 Total current liabilities 34 35 Long-term debt 36 Long-term income taxes 37 Long-term unearned revenue 38 Deferred income taxes 39 Operating lease liabilities 40 Other long-term liabilities 66,662 $ 29,612 $ 4,530 $ 233 $ 72,242 $ 30,265 $ 3,815 $ 76,073 13,485 2,643 5,734 5,372 3,549 $4 6,188 $ 7,581 $ 541 $ 5,568 $ 5,211 $ 41 42 Total liabilities 184,226 $ 176,130 $ 162,601 43 44 Commitments and contingencies 45 Stockholders' equity: 46 Common stock and paid-in capital - shares authorized 24,000; outstanding 7,643 and 7,677 47 Retained earnings 78,520 $ 24,150 $ (340) $ 71,223 $ 13,682 $ (2,187) $ 69,315 17,769 48 Accumulated other oomprehensive loss 627 49 50 Total stockholders' equity 102,330 $ 82,718 $ 87,711 51 52 Total liabilities and stockholders' equity 286,556 $ 258,848 $ 250,312 1 Excel Corporation 2 BALANCE SHEETS (In millions) 3 4 June 30, 2019 2018 2017 2019 2018 2017 5 Assets 7 Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net of allow ance for doubtful accounts of $411 and $377 11,946 $ 121,822 $ 26,481 $ 2,662 $ 6,751 $ 169,662 $ %$4 11,356 $ 7,663 125,318 22,431 2,181 5,103 162,696 8 122,463 $ 29,524 $ 2,063 $ 10,146 $ 175.552 $ 10 11 Inventories Other Total ourrent assets 12 13 14 Property and equipment, net of accumulated depreciation of $35,330 and $29,223 Operating lease right-of-use assets Equity investments Goodwill 36,477 $ 7,379 $ 2,649 $ 42,026 $ 7,750 $ 14,723 $ 29,460 6,686 $ 1,862 $ 35,683 $ 8,053 $ 7.442 $ $4 23,734 6,555 6,023 35,122 10,106 6,076 15 16 17 18 Intangible assets, net 20 Other long-term assets 19 21 22 Total assets $286,556.00 $258,848.00 $250,312 23 24 Liabilities and stockholders' equity 25 Current liabilities: 26 Accounts payable 9,382 $ 8,617 $ 7,390 9,072 1,049 5,819 27 Short Term Debt $4 $4 28 Current portion of long-term debt 29 Aoorued compensation Short-term income taxes Short-term unearned revenue 32 Other $4 5,516 $ 6,830 $ 5,665 $ 3,998 $ 6,103 $ 2,121 $ 28,905 $ 8,744 58,488 $ 30 718 32,676 $ 9,351 $ 69,420 $ $4 24,013 7,684 55,745 31 $4 33 Total current liabilities 34 35 Long-term debt 36 Long-term income taxes 37 Long-term unearned revenue 38 Deferred income taxes 39 Operating lease liabilities 40 Other long-term liabilities 66,662 $ 29,612 $ 4,530 $ 233 $ 72,242 $ 30,265 $ 3,815 $ 76,073 13,485 2,643 5,734 5,372 3,549 $4 6,188 $ 7,581 $ 541 $ 5,568 $ 5,211 $ 41 42 Total liabilities 184,226 $ 176,130 $ 162,601 43 44 Commitments and contingencies 45 Stockholders' equity: 46 Common stock and paid-in capital - shares authorized 24,000; outstanding 7,643 and 7,677 47 Retained earnings 78,520 $ 24,150 $ (340) $ 71,223 $ 13,682 $ (2,187) $ 69,315 17,769 48 Accumulated other oomprehensive loss 627 49 50 Total stockholders' equity 102,330 $ 82,718 $ 87,711 51 52 Total liabilities and stockholders' equity 286,556 $ 258,848 $ 250,312

Answer rating: 100% (QA)

Common size Income statement Individual valuetotal revenue 2019 2018 2017 2019 2018 2017 Revenue Pro... View the full answer