Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

J A B C D E F G H . 106 Required Homework Questions 107 108 You are the Comptroller of a company. Write formulas

image text in transcribedimage text in transcribed

J A B C D E F G H . 106 Required Homework Questions 107 108 You are the Comptroller of a company. Write formulas that calculate each of the GAAP Cash Flow Statement components from the data below. 109 Also, write formulas that calculate 'Sources' and 'Uses' using the SFAM Cash Flow presentation. 110 111 2018 2019 112 Research & Development 3 5 113 Equity 40 37 114 Depreciation 8 10 115 Repurchase of Equity 0 10 116 Net income 10 12 117 Amortization 3 7 118 CapEx 10 12 119 Cash Flow Invested in Acquisition 0 12 120 Issue of Debt 0 15 121 Dividends 5 5 122 Net Trade Working Capital 10 12 123 Debt 5 20 124 Cash & Cash Equivalents 10 125 Cash & Marketable Securities 15 126 GAAP Methodology 2019 Cash Flow from Operations* * Hint: Refer to the definition in Row 30 on this Sheet and the more detailed explanation in the 'ACCOUNTS Cash Flow Statement' Sheet Row 48. Cash Flow from Investing Cash Flow from Financing DDDD Total Cash Flow Free Cash Flow (FCF) Use the inputs above to calculate 2017 Equity. J A B C D E F G H . 106 Required Homework Questions 107 108 You are the Comptroller of a company. Write formulas that calculate each of the GAAP Cash Flow Statement components from the data below. 109 Also, write formulas that calculate 'Sources' and 'Uses' using the SFAM Cash Flow presentation. 110 111 2018 2019 112 Research & Development 3 5 113 Equity 40 37 114 Depreciation 8 10 115 Repurchase of Equity 0 10 116 Net income 10 12 117 Amortization 3 7 118 CapEx 10 12 119 Cash Flow Invested in Acquisition 0 12 120 Issue of Debt 0 15 121 Dividends 5 5 122 Net Trade Working Capital 10 12 123 Debt 5 20 124 Cash & Cash Equivalents 10 125 Cash & Marketable Securities 15 126 GAAP Methodology 2019 Cash Flow from Operations* * Hint: Refer to the definition in Row 30 on this Sheet and the more detailed explanation in the 'ACCOUNTS Cash Flow Statement' Sheet Row 48. Cash Flow from Investing Cash Flow from Financing DDDD Total Cash Flow Free Cash Flow (FCF) Use the inputs above to calculate 2017 Equity

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_2

Step: 3

blur-text-image_3

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

Sound Investing, Chapter 1 - The Financial Pressure

Authors: Kate Mooney

2nd Edition

0071719237, 9780071719230

More Books

Students also viewed these Accounting questions