In: Accounting
A manufacturer of air filter systems for industrial facilities, is considering the addition of a new system to its current product line. The following data has been forecasted:
| Years | 2012 | 2013 | 2014 | 2015 |
| Depreciation | 30,000 | 35000 | 40000 | 45000 |
| EBIT | 100,000 | 125,000 | 150,000 | 175,000 |
| Investment in Operating Assets | 30,000 | 40,000 | 50,000 | 60,000 |
The market value of the firm's debt is $500,000 and it has $150,000 in marketable securities. The company also has 10,000 of preferred stocks that just paid an annual dividend of $0.75. Investors require a rate of return of 7% on preferred stocks of similar risk. Moreover, the firm has 200,000 shares of stock outstanding and its weighted average cost of capital is 15%. The expected tax rate is 35% in the next two years and 40% after that.
a. Calculate the free cash flow for each of the next three years.
b. After 2015 the firm's free cash flow is expected to grow at 5% per year indefinitely. What is the value of the stock today?
| Solution (a) | Calculation of cash flow for each of the next 3 years |
| 2015 | 2016 | 2017 | 2018 | |||
| Debt | 500000 | |||||
| share of stock | 200000 | |||||
| Preferred stock*(working) | 107143 | |||||
| Equity and debt investment | 807143 | 1774286 | 1784286 | 1794286 | ||
| Marketable securities (common stock) | 150000 | |||||
| Growth trend of investment in operating assets | 10000 | 10000 | 10000 | 10000 | ||
| (60000-50000) | ||||||
| Tota investment (A) | 1774286 | 1784286 | 1794286 | 1804286 | ||
| Depreciaiton | 40000 | 45000 | 50000 | 55000 | ||
| Growth trend of increase in Depreciation | 5000 | 5000 | 5000 | 5000 | ||
| Net depreciation( B) | 45000 | 50000 | 55000 | 60000 | ||
| Net investment (total investment-depreciation) | 1729286 | 1734286 | 1739286 | 1744286 | ||
| WACC | 15% | 15% | 15% | 15% | ||
| Cash flows | 259393 | 260143 | 260893 | 261643 | ||
| Tax % | 35% | 40% | 40% | 40% | ||
| Less: Tax $ | -90788 | 104057 | 104357 | 104657 | ||
| Net cash flows | 168605 | 364200 | 365250 | 366300 | ||
| Add : Depreciation | 45000 | 50000 | 55000 | 60000 | ||
| Free cash flows | 213605 | 414200 | 420250 | 426300 | ||
| Dividend on Preferred stock % | 7% | 7% | 7% | 7% | ||
| Less: Dividend Preferred stock $ | -7500 | -7500 | -7500 | -7500 | ||
| Free cash flows for equity | 206105 | 406700 | 412750 | 418800 | ||
| *Working | ||||||
| Value of Preferred stock | ||||||
| Dividend paid = 0.75 | ||||||
| Value per preferred stock =0.75/7% =10.7143 | ||||||
| value of Preferred stock =10.7143*10000 = 107143 | ||||||
| Solution (b) | In free cash flow increase 5% per year | |||||
| 2015 | 2016 | 2017 | 2018 | Total | ||
| Free cash flow | 213605 | 224285.65 | 235499.94 | |||
| Grow % | 5% | 5% | 5% | |||
| Increased free cash flows | 224286 | 235500 | 247275 | |||
| Less: Dividend Preferred stock $ | -7500 | -7500 | -7500 | |||
| Increase in value of equity | 216786 | 228000 | 239775 | |||
| Present value (WACC@ 15%) | 0.8696 | 0.7561 | 0.6575 | |||
| Present value of cash flows | 188517 | 172391 | 157652 | 518560 | ||
| Terminal flow (free cash flow on 2018) | 239775 | |||||
| Amount | ||||||
| Value of Investment | 1598500 | |||||
| (Terminal flow/ WACC) | ||||||
| Add: Present value of cash flows | 518560 | |||||
| Total value of investment | 2117060 | |||||
| Less: Debt | -500000 | |||||
| Less : Preferred stock | -107143 | |||||
| Net value of stock | 1509917 |