| R. L. Promboin |
| FIN 660-1306 |
|
|
| SVA EXERCISE |
|
|
| Given: | ($ '000) |
| Base sales: | $250,000 |
|
|
| | Base year | Fade rate | Yr. 10 and after | | Note: Fade rate is the year-to-year reduction in the rate to some steady state rate |
| Sales growth: | 1.15 | 0.01 | 1.05 | | Year 1 = 1.14, year 2 = 1.13, etc. |
| Operating PM | 0.20 | 0.01 | 0.1 |
| Fixed capital inv rate | 0.15 | | | | Note: on a per $ of sales basis |
| WC inv rate | 0.08 | | | | Note: on a per $ of sales basis |
| Cash tax rate | 0.39 |
| COC | 0.11 |
| Market securities | $20,000 |
| Debt | $50,000 |
| # shares outstanding | 5,000,000 |
|
|
| | | | | | (all dollars in thousands) |
| | | Year1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Residual |
| Sales | | $285,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Operating Profit | | $54,150.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| NOPAT | | $33,031.50 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| New Investment | | $5,250.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Add'l WC | | $2,800.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Free cash flow | | $24,981.50 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| PV to year 10 |
| Pv after year 10 |
|
|
|
|
| 1. Value years 1-10 |
| 2. Value after year 10 |
|
|
| Market securities |
| Total Value |
|
|
| Less debt |
|
|
| 3. Value of equity |
|
|
| 4. Value of equity/share |
neel
sva-exercise-template-1306_1.xls
