Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE PREPARE COMMON SIZE CASH FLOW STATEMENT FOR REST OF THE YEARS Excel Corporation CASH FLOWS STATEMENTS (In millions) Year Ended June 30, begin{tabular}{|l|l|l|l|l|l|} hline

image text in transcribedimage text in transcribedimage text in transcribed

PLEASE PREPARE COMMON SIZE CASH FLOW STATEMENT FOR REST OF THE YEARS

Excel Corporation CASH FLOWS STATEMENTS (In millions) Year Ended June 30, \begin{tabular}{|l|l|l|l|l|l|} \hline 2019 & 2018 & 2017 & 2019 & 2018 & 2017 \\ \hline \end{tabular} Operating Activities Net income \begin{tabular}{|l|l|l|l|} \$ 39,240 & $ & 16,571 & $ \end{tabular} 25,489 Adjustments to reconcile net income to net cash from pperations: Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable nventories Other current assets Other long-term assets Accounts payable Jnearned revenue ncome taxes Other current liabilities Other long-term liabilities \begin{tabular}{|r|r|r|r|r|r|} \hline$ & 11,682 & $ & 10,261 & $ & 8,778 \\ \hline$ & 4,652 & $ & 3,940 & $ & 3,266 \\ \hline$ & (792) & $ & (2,212) & $ & (2,073) \\ $ & (6,463) & $ & (5,143) & $ & (829) \\ \hline & & & & & \\ \hline$ & (2,812) & $ & (3,862) & $ & (1,216) \\ \hline$ & 597 & $ & (465) & $ & 50 \\ \hline$ & (1,718) & $ & (952) & $ & 1,028 \\ $ & (1,834) & $ & (285) & $ & (917) \\ $ & 232 & $ & 1,148 & $ & 81 \\ $ & 4,462 & $ & 5,922 & $ & 3,820 \\ $ & 2,929 & $ & 18,183 & $ & 1,792 \\ $ & 1,419 & $ & 798 & $ & 356 \\ $ & 591 & $ & (20) & $ & (118) \\ \hline \end{tabular} Net cash from operations $52,185$43,884$39,507 Financing Activities Repayments of short-term debt, maturities of 90 days or less, net Proceeds from issuance of debt Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Other, net \begin{tabular}{|rr|rr|lr|} $ & - & $ & (7,324) & $ & (4,963) \\ $ & - & $ & 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) \\ \hline \end{tabular} Net cash from (used in) financing $(36,887)$(33,590)$8,408 Investing Activities Additions to property and equipment Acquisition of companies, net of cash acquired, and $$(13,925)(2,388)$$(11,632)(888)$$(8,129)(25,944) purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Securities lending payable \begin{tabular}{rrrrrrr|} $ & (57,697) & $ & (1,37,380) & $ & (1,76,905) \\ $ & 20,043 & $ & 26,360 & $ & 28,044 \\ $ & 38,194 & $ & 1,17,577 & $ & 1,36,350 \\ $ & - & $ & (98) & $ & (197) \end{tabular} Net cash used in investing $(15,773)$(6,061)$(46,781) Effect of foreign exchange rates on cash and cash $ (115)$ 50$ 19 equivalents Cash and cash equivalents, end of period 7,663 Excel Corporation CASH FLOWS STATEMENTS (In millions) Year Ended June 30, \begin{tabular}{|l|l|l|l|l|l|} \hline 2019 & 2018 & 2017 & 2019 & 2018 & 2017 \\ \hline \end{tabular} Operating Activities Net income \begin{tabular}{|l|l|l|l|} \$ 39,240 & $ & 16,571 & $ \end{tabular} 25,489 Adjustments to reconcile net income to net cash from pperations: Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable nventories Other current assets Other long-term assets Accounts payable Jnearned revenue ncome taxes Other current liabilities Other long-term liabilities \begin{tabular}{|r|r|r|r|r|r|} \hline$ & 11,682 & $ & 10,261 & $ & 8,778 \\ \hline$ & 4,652 & $ & 3,940 & $ & 3,266 \\ \hline$ & (792) & $ & (2,212) & $ & (2,073) \\ $ & (6,463) & $ & (5,143) & $ & (829) \\ \hline & & & & & \\ \hline$ & (2,812) & $ & (3,862) & $ & (1,216) \\ \hline$ & 597 & $ & (465) & $ & 50 \\ \hline$ & (1,718) & $ & (952) & $ & 1,028 \\ $ & (1,834) & $ & (285) & $ & (917) \\ $ & 232 & $ & 1,148 & $ & 81 \\ $ & 4,462 & $ & 5,922 & $ & 3,820 \\ $ & 2,929 & $ & 18,183 & $ & 1,792 \\ $ & 1,419 & $ & 798 & $ & 356 \\ $ & 591 & $ & (20) & $ & (118) \\ \hline \end{tabular} Net cash from operations $52,185$43,884$39,507 Financing Activities Repayments of short-term debt, maturities of 90 days or less, net Proceeds from issuance of debt Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Other, net \begin{tabular}{|rr|rr|lr|} $ & - & $ & (7,324) & $ & (4,963) \\ $ & - & $ & 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) \\ \hline \end{tabular} Net cash from (used in) financing $(36,887)$(33,590)$8,408 Investing Activities Additions to property and equipment Acquisition of companies, net of cash acquired, and $$(13,925)(2,388)$$(11,632)(888)$$(8,129)(25,944) purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Securities lending payable \begin{tabular}{rrrrrrr|} $ & (57,697) & $ & (1,37,380) & $ & (1,76,905) \\ $ & 20,043 & $ & 26,360 & $ & 28,044 \\ $ & 38,194 & $ & 1,17,577 & $ & 1,36,350 \\ $ & - & $ & (98) & $ & (197) \end{tabular} Net cash used in investing $(15,773)$(6,061)$(46,781) Effect of foreign exchange rates on cash and cash $ (115)$ 50$ 19 equivalents Cash and cash equivalents, end of period 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

Real Estate Finance and Investments

Authors: William Brueggeman, Jeffrey Fisher

14th edition

73377333, 73377339, 978-0073377339

More Books

Students also viewed these Finance questions