Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started