In: Finance
A company’s free cash flow next year is expected to be -$11.2
million, $3.6 million the following year, and $6.2 million in the
third year. Thereafter, the free cash flow is expected to grow
forever at a rate of 4.8% per year. The company’s weighted average
cost of capital is 11.1% per year and the market value of its debt
is $35.2 million. If the company has four million shares of common
stock outstanding, what is the value per share?
Please complete in excel and post formulas and answer. Thank
you!
Step-1:Calculation of present value of next three years dividend | ||||||||||
Year | Cash flow | Discount factor | Present Value | |||||||
a | b | c=1.111^-a | d=b*c | |||||||
1 | $ -11.2 | 0.9001 | $ -10.08 | Million | ||||||
2 | $ 3.6 | 0.8102 | $ 2.92 | Million | ||||||
3 | $ 6.2 | 0.7292 | $ 4.52 | Million | ||||||
Total | $ -2.64 | Million | ||||||||
Step-2:Present value of cash flow after year 3 | ||||||||||
Present Value | = | (C3*(1+g)/(Ke-g)*DF3 | Where, | |||||||
= | (6.2*(1+0.048)/(0.111-0.048))*0.7292 | C3 | $ 6.2 | |||||||
= | $ 75.21 | Million | g | 0.048 | ||||||
Ke | 0.111 | |||||||||
DF3 | 0.7292 | |||||||||
Step-3:Calculation of Value of firm | ||||||||||
Present Value of all future cash flows | = | $ -2.64 | + | $ 75.21 | ||||||
= | $ 72.56 | Million | ||||||||
Value of firm is the present value of cash flows. | ||||||||||
So, value of firm is | $ 72.56 | Million | ||||||||
Step-4:Calclation of Value of per share | ||||||||||
Million | ||||||||||
Value of firm | $ 72.56 | |||||||||
Less:Value of debt | $ 35.20 | |||||||||
Value of Equity | $ 37.36 | |||||||||
/ Number of shares outstanding | 4 | |||||||||
Value per share | $ 9.34 | |||||||||
Thus, | ||||||||||
Value per share is | $ 9.34 | |||||||||