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 |
Present value of operations | $149.58 million |
Time | FCFF, millions | Present value | Horizon value | Net CF |
0 | ||||
1 | -2 | -1.69 | -1.69 | |
2 | 10 | 7.18 | 7.18 | |
3 | 18 | 10.96 | 10.96 | |
4 | 30 | 15.47 | 15.47 | |
5 | 52 | 22.73 | 22.73 | |
6 | 56 | 20.74 | 20.74 | |
7 | 59 | 18.52 | 18.52 | |
8 | 61 | 16.23 | 388.88 | 405.10 |
9 | 0 | |||
10 | 0 | |||
Present value of operations | $149.58 |