In: Finance
You are analyzing the U.S. equity market based upon the S&P Industrials Index and using the present value of free cash flow to equity technique. Your inputs are as follows:
Beginning FCFE: $90 | ||
k = 0.09 | ||
Growth Rate: | ||
Year | 1–3: | 9% |
4–6: | 8% | |
7 and beyond | 7% |
You should -Select-underweightoverweightmarket weightItem 1 the U.S. equity market as the estimated value of the stock of $ is -Select-higher thanlower thanequal torItem 3 the S&P Industrials Index.
You should -Select-underweightoverweightmarket weightItem 4 the U.S. equity market as the estimated value of the stock of $ is -Select-higher thanlower thanequal torItem 6 than the S&P Industrials Index.
F0 | Beginning FCFE | $90 | |||||||||
g1 | Growth Rate Year1-3 | 9% | |||||||||
F1=F0*(1+g1) | FCFE in Year 1 | $98.10 | |||||||||
F2=F1*(1+g1) | FCFE in Year 2 | $106.93 | |||||||||
F3=F2*(1+g1) | FCFE in Year 3 | $116.55 | |||||||||
g2 | Growth Rate Year4-6 | 8% | |||||||||
F4=F3*(1+g2) | FCFE in Year 4 | $125.88 | |||||||||
F5=F4*(1+g2) | FCFE in Year 5 | $135.95 | |||||||||
F6=F5*(1+g2) | FCFE in Year 6 | $146.82 | |||||||||
g3 | Growth Rate Year7 and beyond | 7% | |||||||||
F7=F6*(1+g3) | FCFE in Year 7 | $157.10 | |||||||||
Present Value (PV) of Cash Flow: | |||||||||||
(Cash Flow)/((1+i)^N) | |||||||||||
i=Discount Rate=k=0.09 | |||||||||||
N=Year of Cash Flow | |||||||||||
Horizon Value in year 6 under constant growth rate of 7% | |||||||||||
H6=F7/(k-g3) | Horizon value in year 6 =157.10/(0.09-0.07) | $7,855.02 | |||||||||
N | Year | 1 | 2 | 3 | 4 | 5 | 6 | ||||
a | Free Cash flow | $98.10 | $106.93 | $116.55 | $125.88 | $135.95 | $146.82 | ||||
b | Horizon value | $7,855.02 | |||||||||
c=a+b | TotalCash Flow | $98.10 | $106.93 | $116.55 | $125.88 | $135.95 | $8,001.84 | SUM | |||
PV=c/(1+0.09)^N | Present value of Free Cash Flow to Equity | $90.00 | $90.00 | $90.00 | $89.17 | $88.36 | $4,771.23 | $5,218.77 | |||
Total Present Value of Free cash flow to equity | $5,218.77 | ||||||||||
You should underweight the U.S. equity market the S&P Industrials Index. | |||||||||||
as the estimated value of the stock of $ is lower thanthe S&P industrial index | |||||||||||
b | |||||||||||
F0 | Beginning FCFE | $90 | |||||||||
g1 | Growth Rate Year1-3 | 11% | |||||||||
F1=F0*(1+g1) | FCFE in Year 1 | $99.90 | |||||||||
F2=F1*(1+g1) | FCFE in Year 2 | $110.89 | |||||||||
F3=F2*(1+g1) | FCFE in Year 3 | $123.09 | |||||||||
g2 | Growth Rate Year4-6 | 10% | |||||||||
F4=F3*(1+g2) | FCFE in Year 4 | $135.40 | |||||||||
F5=F4*(1+g2) | FCFE in Year 5 | $148.94 | |||||||||
F6=F5*(1+g2) | FCFE in Year 6 | $163.83 | |||||||||
g3 | Growth Rate Year7 and beyond | 9% | |||||||||
F7=F6*(1+g3) | FCFE in Year 7 | $178.57 | |||||||||
|