In: Finance
Using the schedule of cash flows and other information below, estimate the firm's value of operations | ||||||||
by discounting the cash flows back to the present (time value of money formula) | ||||||||
Compute the value of operations a second way by using the NPV formula in Excel | ||||||||
FCFF | See cash flow schedule | |||||||
WACC | 18% | |||||||
Debt | 75 | million | ||||||
Number of shares | 100 | million | ||||||
show excel formulas | ||||||||
Time | FCFF, millions | |||||||
0 | ||||||||
1 | -2 | |||||||
2 | 10 | |||||||
3 | 18 | |||||||
4 | 30 | |||||||
5 | 52 | |||||||
6 | 56 | |||||||
7 | 59 | |||||||
8 | 61 | growing at 2% per year | ||||||
9 | ||||||||
10 |