Question: use excel to solve Time remaining 1:14:1 A new intern in the financial advisory company was asked to calculate FCFF basing on the data in
Time remaining 1:14:1 A new intern in the financial advisory company was asked to calculate FCFF basing on the data in the white tables. He/she did it in the grey table, unfortunately not without a few mistakes. Find the mistakes and calculate the "grey table" presenting FCFF correctly. + Earnings before interest and taxes (1 - 1) Deprecation and amortization Change in noncash working capital - (Capital expenditures - Disinvestments) =Cash flow to firm 0 143 000 1 000 000 1143 000 B4 000 -250 000 218 400 0 52.400 137040 500 000 171 600 0 -191 360 163 997 193 440 -750 000 1 000 000 183 760 0 0 0 -397 243 -806 360 0 4 Year Earnings before interest and taxes (1 - 1) Depreciation and amortization 1 84 000 250 000 2 137040 250 000 3 163 997 250 000 193 440 250 000 0 3 Year Change In noncash working capital Noncash working capital 143 000 143 000 1 75 400 218 400 2 46 800 171 600 4 188 760 17160 188 760 0 0 1 2 3 4 Year Capital expenditures 1 000 000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
