In: Finance
Question 1
| Problem 1 - Using FCFE | |||
| It is 12/31/15. The following data have been accumulated from analysis of Frank | |||
| Beamer Incorporated: | |||
| 1 | 2 | 3 | |
| 2016E | 2017E | 2018E | |
| Annual FCFE | $ 120,000 | $ 160,000 | $ 180,000 |
| Given: | |||
| Net Debt | $ 500,000 | ||
| Shares Outstanding | 200,000 | ||
| Stock Price per share | $ 15.00 | ||
| Effective Tax Rate | 30.0% | ||
| WACC | 8.0% | ||
| Beta | 1.10 | ||
| Risk Free Rate | 4.00% | ||
| Equity Risk Premium | 6.00% | ||
| Terminal Growth Rate | 5.0% | ||
| Calculate the Equity Value per Share for Frank Beamer Incorporated | |||
| as of 12/31/15 using the Free Cash Flows to Equity Approach. | |||
| Is the stock current over or under valued? | |||
| As you work through the problem, fill in the following numbers: | |||
| Show work for partial credit. | |||
| Frank Beamer cost of equity | 10.600% | ||
| Frank Beamer WACC | 8% | ||
| Terminal Value in 2018 (Gordon Growth) | |||
| Enterprise Value | |||
| Equity Value | |||
| Equity Value per Share | |||
| Stock over or under valued? | |||
Question 2
| Problem 1 - using FCFF | |||
| It is 12/31/15. The following data have been accumulated from analysis of Frank | |||
| Beamer Incorporated: | |||
| 1 | 2 | 3 | |
| 2016E | 2017E | 2018E | |
| Annual FCFF | $ 120,000 | $ 160,000 | $ 180,000 |
| Given: | |||
| Net Debt | $ 500,000 | ||
| Shares Outstanding | 200,000 | ||
| Stock Price per share | $ 15.00 | ||
| Effective Tax Rate | 30.0% | ||
| WACC | 8.0% | ||
| Beta | 1.10 | ||
| Risk Free Rate | 4.00% | ||
| Equity Risk Premium | 6.00% | ||
| Terminal Growth Rate | 5.0% | ||
| Calculate the Equity Value per Share for Frank Beamer Incorporated | |||
| as of 12/31/15 using the Free Cash Flows to the Firm Approach. | |||
| Is the stock current over or under valued? | |||
| As you work through the problem, fill in the following numbers: | |||
| Show work for partial credit. | |||
| Frank Beamer cost of equity | |||
| Frank Beamer WACC | 8% | ||
| Terminal Value in 2018 (Gordon Growth) | |||
| Enterprise Value | |||
| Equity Value | |||
| Equity Value per Share | |||
| Stock over or under valued? | |||
1). Valuation using FCFE approach:
Cost of equity (ke) = risk-free rate + beta*risk premium = 4% + (1.10*6%) = 10.6%
| Year | 2016E | 2017E | 2018E | 2019 onwards | |
| Formula | Time period (n) | 1 | 2 | 3 | Terminal |
| Growth rate (g) | 5% | ||||
| Annual FCFE | 120,000 | 160,000 | 180,000 | 189,000 | |
| Terminal
FCFE/(ke-g); ke = 10.60%, g = 5% |
Terminal value in 2018 | 3,375,000 | |||
| Total FCFE | 120,000 | 160,000 | 180,000 | 3,375,000 | |
| 1/(1+ke)^n | Discount factor @ 8% | 0.904 | 0.818 | 0.739 | 0.739 |
| Total FCFE*Discount factor | PV of FCFE | 108,499 | 130,801 | 133,048 | 2,494,643 |
| Total Equity value (TEV) | 2,866,990 | ||||
| Shares O/S (s) | 200,000 | ||||
| (TEV/s) | Value per share ($) | 14.33 | |||
| Net debt (D) | 500,000 | ||||
| (TEV + D) | Enterprise value | 3,366,990 |
Compared to the given stock price of $15, the intrinsic value per share is less so the stock is overvalued.
2). Valuation using FCFF approach:
| Year | 2016E | 2017E | 2018E | 2019 onwards | |
| Formula | Time period (n) | 1 | 2 | 3 | Terminal |
| Growth rate (g) | 5% | ||||
| Annual FCFF | 120,000 | 160,000 | 180,000 | 189,000 | |
| Terminal
FCFF/(k-g); k = 8%, g = 5% |
Terminal value in 2018 | 6,300,000 | |||
| Total FCFF | 120,000 | 160,000 | 180,000 | 6,300,000 | |
| 1/(1+k)^n | Discount factor @ 8% | 0.926 | 0.857 | 0.794 | 0.794 |
| Total FCFF*Discount factor | PV of FCFF | 111,111 | 137,174 | 142,890 | 5,001,143 |
| Enterprise Value (EV) | 5,392,318 | ||||
| Less: Net debt (D) | 500,000 | ||||
| (EV-D) | Equity value (TEV) | 4,892,318 | |||
| Shares O/S (s) | 200,000 | ||||
| (TEV/s) | Value per share | 24.46 |
Compared to the given stock price of $15, the intrinsic value per share is much higher so the stock is undervalued.