In: Accounting
Sora Industries has
6060
million outstanding shares,
$ 120$120
million in debt,
$ 40$40
million in cash, and the following projected free cash flow for the next four years:
| 
 Year  | 
 0  | 
 1  | 
 2  | 
 3  | 
 4  | 
|||
| 
 Earnings and FCF Forecast ($ million)  | 
||||||||
| 
 1  | 
 Sales  | 
 433.0  | 
 468.0  | 
 516.0  | 
 547.0  | 
 574.3  | 
||
| 
 2  | 
 Growth vs. Prior Year  | 
 8.1%  | 
 10.3%  | 
 6.0%  | 
 5.0%  | 
|||
| 
 3  | 
 Cost of Goods Sold  | 
 (313.6)  | 
 (345.7)  | 
 (366.5)  | 
 (384.8)  | 
|||
| 
 4  | 
 Gross Profit  | 
 154.4  | 
 170.3  | 
 180.5  | 
 189.5  | 
|||
| 
 5  | 
 Selling, General, & Admin.  | 
 (93.6)  | 
 (103.2)  | 
 (109.4)  | 
 (114.9)  | 
|||
| 
 6  | 
 Depreciation  | 
 (7.0)  | 
 (7.5)  | 
 (9.0)  | 
 (9.5)  | 
|||
| 
 7  | 
 EBIT  | 
 53.8  | 
 59.6  | 
 62.1  | 
 65.2  | 
|||
| 
 8  | 
 Less: Income Tax at 25%  | 
 (13.5)  | 
 (14.9)  | 
 (15.5)  | 
 (16.3)  | 
|||
| 
 9  | 
 Plus: Depreciation  | 
 7.0  | 
 7.5  | 
 9.0  | 
 9.5  | 
|||
| 
 10  | 
 Less: Capital Expenditures  | 
 (7.7)  | 
 (10.0)  | 
 (9.9)  | 
 (10.4)  | 
|||
| 
 11  | 
 Less: Increase in NWC  | 
 (6.3)  | 
 (8.6)  | 
 (5.6)  | 
 (4.9)  | 
|||
| 
 12  | 
 Free Cash Flow  | 
 33.433.4  | 
 33.633.6  | 
 40.140.1  | 
 43.143.1  | 
|||
a. Suppose Sora's revenue and free cash flow are expected to grow at a
5.0 %5.0%
rate beyond year four. If Sora's weighted average cost of capital is
10.0 %10.0%,
what is the value of Sora stock based on this information?
b. Sora's cost of goods sold was assumed to be 67% of sales. If its cost of goods sold is actually 70% of sales, how would the estimate of the stock's value change?
c. Return to the assumptions of part
(a)
and suppose Sora can maintain its cost of goods sold at 67% of sales. However, the firm reduces its selling, general, and administrative expenses from 20% of sales to 16% of sales. What stock price would you estimate now? (Assume no other expenses, except taxes, are affected.)
d. Sora's net working capital needs were estimated to be 18% of sales (their current level in year zero). If Sora can reduce this requirement to 12% of sales starting in year 1, but all other assumptions are as in
(a),
what stock price do you estimate for Sora?
(Hint:
This change will have the largest impact on Sora's free cash flow in year 1.)