Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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 are two separate worksheets for your written analysis). Download the attached Excel Corporation CASH FLOWS STATEMENTS (In millions) Year Ended June 30, 2019 2018 2017 2019 2018 2017 Operating Activities Net income Adjustrments to reconcile net income to net cash from operations Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on irvestments and derivatives Deferred income taxes Changes in operating assets and liabilities. Accounts receivable Invertones Other current assets Other long-term assets Accourits payable Unearned revenue Incorne taxes Other current liabilises Other longterm liabilites $39,240$16,571$25,489 Not cash from operations \begin{tabular}{cccccc} $ & 11,682 & $ & 10,261 & $ & 8,778 \\ $ & 4,652 & $ & 3,940 & $ & 3,266 \\ $ & (792) & $ & (2,212) & $ & (2,073) \end{tabular} Financing Activities Repaythents of short term debt, maturities of 90 $ (6,463)$ (5,143) (829) days or kess, net $ (2,812) $ (3,862)$ (1,216) Proceeds from issuance of debt Pepayments of debt Common stockissued Corrmon stock repurchased Corrmon stock cash dividends paid Ohere, nit $ (7,324) \$ (4,903) \begin{tabular}{r|r} (1,718) & $ \\ (1,834) & $ \\ 232 & $ \\ 4,462 & $ \\ 2,929 & $ \\ 1,419 & $ \\ 591 & $ \end{tabular} (465) $ 50 5 1,028 5 $ (952)(285)55 (917) 5 1,148 $ $ 5,922 18,103 $ $ 5 798 5 s 52,185 5 43.884 15 39,507 ias \begin{tabular}{|rr|rrrr|} \hlines & & $ & 7,183 & $ & 44,344 \\ $ & (4,000) & $ & (10,060) & $ & (7,922) \\ $ & 1,142 & $ & 1,002 & $ & 772 \\ $ & (19,543) & $ & (10,721) & $ & (11,788) \\ $ & (13,811) & $ & (12,699) & $ & (11,845) \\ $ & (675) & $ & (971) & $ & (190) \\ $ & (36,887) & $ & (33,590) & $ & 8,408 \end{tabular} Wet cashifrom (used in) financing 5 s 81 3,820 (20) 1,792 356 (118) \begin{tabular}{|c|c|c|c|c|c|} \hline$ & t) & 5 & (7,324) & $ & (4,903) \\ \hline$ & & & 7,183 & 5 & 44,344 \\ \hlines & (4,000) & $ & (10,060) & 5 & (1,922) \\ \hline$ & 1,142 & 5 & 1,002 & $ & 772 \\ \hline$ & (19,543) & 5 & (10,721) & $ & (11,788) \\ \hline$ & (13,811) & 5 & (12,699) & 5 & (11,845) \\ \hline$ & (675) & 5 & (971) & s & (190) \\ \hline$ & (36,887) & $ & (33,590) & $ & 8,408 \\ \hline \end{tabular} Investino Activities Comince Sile Crs Trend Analyes is Trend Mnalysis tes Trend Analysis CFS Woiten Aralysis of Commen Size Witten Analyas of Trend Written Analysis to Management of Common Size Analysis Written Analysis to Management of Trend Analysis

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

Students also viewed these Finance questions