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) Year Ended June 30, 4 2019 2018 2017 2019 2018 2017 5 7 $ 39,240 $ 16,571 $ 25,489 $ $ 11,682 4,652 (792) $ $ 10,261 3,940 (2,212) 64 8,778 3,266 (2,073) $ (6,463) a m as (5,143) $ (829) $ $ $ $ $ 6 Operating Activities Net income Adjustments to reconcile net income to net 8 cash from operations: 9 Depreciation, amortization, and other 10 Stock-based compensation expense Net recognized gains on investments and 11 derivatives 12 Deferred income taxes 13 Changes in operating assets and liabilities: 14 Accounts receivable 15 Inventories 16 Other current assets 17 Other long-term assets 18 Accounts payable 19 Unearned revenue 20 Income taxes 21 Other current liabilities 22 Other long-term liabilities 23 24 Net cash from operations 25 26 Financing Activities Repayments of short-term debt, maturities of 27 90 days or less, net 28 Proceeds from issuance of debt 29 Repayments of debt 30 Common stock issued 31 Common stock repurchased 32 Common stook cash dividends paid 33 Other, net (2,812) 597 (1,718) (1,834) 232 4,462 2,929 1.419 591 (3,862) (465) (952) (285) 1,148 5,922 18,183 798 (20) HA HA (1,216) 50 1,028 (917) 81 3,820 1,792 356 (118) $ $ $ $ $ $ $ $ $ $ $ $ $ $ 52,185 43,884 $ 39,507 $ (7,324) $ (4,963) $ $ $ $ $ $ (4,000) 1,142 (19,543) (13,811) (675) $ $ $ $ $ $ 7,183 (10,060) 1,002 (10,721) (12,699) (971) $ $ $ $ $ $ 44,344 (7,922) 772 (11,788) (11,845) (190) $ (36,887) $ (33,590) $ 8,408 $ $ (13,925) (2,388) $ $ (11,632) (888) $ $ (8,129) (25,944) $ $ $ $ (57,697) 20,043 38,194 $ $ $ (137,380) 26,360 117,577 (98) $ $ $ $ (176,905) 28,044 136,350 (197) 35 Net cash from (used in) financing 36 37 Investing Activities 38 Additions to property and equipment Acquisition of companies, net of cash 39 acquired, and purchases of intangible and 40 Purchases of investments 41 Maturities of investments 42 Sales of investments 43 Securities lending payable 44 45 Net cash used in investing 46 Effect of foreign exchange rates on cash and 47 cash equivalents 48 49 Net change in cash and cash equivalents 50 Cash and cash equivalents, beginning of 51 52 Cash and cash equivalents, end of period 53 $ (15,773) $ (6,061) (46,781) $ (115) 50 $ 19 $ (590) 11,946 4,283 7,663 $ $ 1,153 6,510 $ 11,356 11,946 $ 7,663 (In millions) Year Ended June 30, 4 2019 2018 2017 2019 2018 2017 5 7 $ 39,240 $ 16,571 $ 25,489 $ $ 11,682 4,652 (792) $ $ 10,261 3,940 (2,212) 64 8,778 3,266 (2,073) $ (6,463) a m as (5,143) $ (829) $ $ $ $ $ 6 Operating Activities Net income Adjustments to reconcile net income to net 8 cash from operations: 9 Depreciation, amortization, and other 10 Stock-based compensation expense Net recognized gains on investments and 11 derivatives 12 Deferred income taxes 13 Changes in operating assets and liabilities: 14 Accounts receivable 15 Inventories 16 Other current assets 17 Other long-term assets 18 Accounts payable 19 Unearned revenue 20 Income taxes 21 Other current liabilities 22 Other long-term liabilities 23 24 Net cash from operations 25 26 Financing Activities Repayments of short-term debt, maturities of 27 90 days or less, net 28 Proceeds from issuance of debt 29 Repayments of debt 30 Common stock issued 31 Common stock repurchased 32 Common stook cash dividends paid 33 Other, net (2,812) 597 (1,718) (1,834) 232 4,462 2,929 1.419 591 (3,862) (465) (952) (285) 1,148 5,922 18,183 798 (20) HA HA (1,216) 50 1,028 (917) 81 3,820 1,792 356 (118) $ $ $ $ $ $ $ $ $ $ $ $ $ $ 52,185 43,884 $ 39,507 $ (7,324) $ (4,963) $ $ $ $ $ $ (4,000) 1,142 (19,543) (13,811) (675) $ $ $ $ $ $ 7,183 (10,060) 1,002 (10,721) (12,699) (971) $ $ $ $ $ $ 44,344 (7,922) 772 (11,788) (11,845) (190) $ (36,887) $ (33,590) $ 8,408 $ $ (13,925) (2,388) $ $ (11,632) (888) $ $ (8,129) (25,944) $ $ $ $ (57,697) 20,043 38,194 $ $ $ (137,380) 26,360 117,577 (98) $ $ $ $ (176,905) 28,044 136,350 (197) 35 Net cash from (used in) financing 36 37 Investing Activities 38 Additions to property and equipment Acquisition of companies, net of cash 39 acquired, and purchases of intangible and 40 Purchases of investments 41 Maturities of investments 42 Sales of investments 43 Securities lending payable 44 45 Net cash used in investing 46 Effect of foreign exchange rates on cash and 47 cash equivalents 48 49 Net change in cash and cash equivalents 50 Cash and cash equivalents, beginning of 51 52 Cash and cash equivalents, end of period 53 $ (15,773) $ (6,061) (46,781) $ (115) 50 $ 19 $ (590) 11,946 4,283 7,663 $ $ 1,153 6,510 $ 11,356 11,946 $ 7,663

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

Effective Use Of Teams For IT Audits

Authors: Martin Krist

1st Edition

0849398282, 978-0849398285

More Books

Students also viewed these Accounting questions

Question

The models used to analyse different national cultures.

Answered: 1 week ago

Question

The nature of the issues associated with expatriate employment.

Answered: 1 week ago