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

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

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

Occupational Fraud And Abuse

Authors: Joseph T. Wells

1st Edition

1889277088, 978-1889277080

More Books

Students also viewed these Accounting questions

Question

Define Decision making

Answered: 1 week ago

Question

What are the major social responsibilities of business managers ?

Answered: 1 week ago

Question

What are the skills of management ?

Answered: 1 week ago