Question
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!
Excel Corporation INCOME STATEMENTS (In millions, except per share amounts) Year Ended June 30, 2019 2018 2017 2019 2018 2017 Revenue: Product Service and other $ $ 66,069 $ 59,774 $ 64,497 $ 63,811 45,863 $ 32,760 Total revenue $ 125,843 $ 110,360 $ 96,571 Cost of revenue: Product Service and other $ $ 16,273 $ 26,637 $ 15,420 $ 15,175 22,933 $ 19,086 Total cost of revenue $ 42,910 $ 38,353 $ 34,261 Gross margin $ Research and developmen $ Sales and marketing $ General and administrative $ Restructuring $ 82,933 $ 16,876 $ 18,213 $ 4,885 $ $ 72,007 $ 62,310 14,726 $ 13,037 17,469 $ 15,461 4,754 $ 4,481 $ 306 OCTO Operating income Other income, net $ $ 42,959 $ 729 $ 35,058 $ 29,025 1,416 $ 876 Income before income taxe $ Provision for income taxes $ 43,688 $ 4,448 $ 36,474 $ 29,901 19,903 $ 4,412 Net income $ 39,240 $ 16,571 $ 25,489
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