Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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!

.

image text in transcribed

1 2019 2018 2017 2019 2018 2017 7 $ 9 $ $ 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 WAT $ UM $ $ 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 $ $286,556.00 $258,848.00 $250,312 Excel Corporation 2 BALANCE SHEETS 3 (In millions) 4 June 30, 5 6 Assets Current assets: Cash and cash equivalents Short-term investments 10 Accounts receivable, net of allowance for doubtful accounts of $411 and $377 11 Inventories 12 Other 13 Total current assets 14 15 Property and equipment, net of accumulated depreciation of $35,330 and $29,223 16 Operating lease right-of-use assets 17 Equity investments 18 Goodwill 19 Intangible assets, net 20 Other long-term assets 21 22 Total assets 23 24 Liabilities and stockholders' equity 25 Current liabilities: 26 Accounts payable 27 Short Term Debt 28 Current portion of long-term debt 29 Accrued compensation 30 Short-term income taxes 31 Short-term unearned revenue 32 Other 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 41 42 Total liabilities 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 48 Accumulated other comprehensive loss 49 50 Total stockholders' equity 51 52 Total liabilities and stookholders' equity $ 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 $ 7,390 9,072 1,049 5,819 718 24,013 7,684 55,745 $ $ $ $ $ $ $ 66,662 $ 29,612 $ 4,530 $ 233 $ 6.188 $ 7,581 $ 72,242 $ 30,265 $ 3,815 $ 541 $ 5,568 $ 5,211 $ 76,073 13,485 2,643 5,734 5,372 3,549 184,226 $ 176.130 $ 162,601 78,520 $ 24,150 $ (340) $ 71,223 $ 13,682 $ (2,187) $ 69,315 17,769 627 102,330 $ 82,718 $ 87,711 $ 286,556 $ 258,848 $ 250,312

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditory Cognition And Human Performance: Research And Applications

Authors: Carryl L. Baldwin

1st Edition

0415325943, 978-0415325943

More Books

Students also viewed these Accounting questions