Sora Industries has 68 million outstanding shares S129 million in debt, $52 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 5743 2 Growth vs. Prior Year 8.1% 10.3% 6.0% 5.0% 3 Cost of Goods Sold (3136) (345.7) (3665) (3848) 4 Gross Profit 1544 170.3 180 5 189.5 5 Selling, General, & Admin (936) (1032) (109.4) (1149) 6 Depreciation (70) (75) (9.0) (9.5) 7 EBIT 53.8 59.6 62.1 65.2 8 Less: Income Tax at 40% (21.5) (238) (248) (26.1) 9 Plus Depreciation 70 7.5 9.0 9.5 10 Less: Capital Expenditures (7.7) (100) (9.9) (10.4) 11 Less: Increase in NWC (6.3) (86) (56) (4.9) 12 Free Cash Flow 25.3 24.6 30.8 33.3 a. Suppose Sora's revenue and free cash flow are expected to grow at a 5 8% rate beyond year four of Sora's weighted average cost of capital is 12.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 ent 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) Sora Industries has 68 million outstanding shares S129 million in debt, $52 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 5743 2 Growth vs. Prior Year 8.1% 10.3% 6.0% 5.0% 3 Cost of Goods Sold (3136) (345.7) (3665) (3848) 4 Gross Profit 1544 170.3 180 5 189.5 5 Selling, General, & Admin (936) (1032) (109.4) (1149) 6 Depreciation (70) (75) (9.0) (9.5) 7 EBIT 53.8 59.6 62.1 65.2 8 Less: Income Tax at 40% (21.5) (238) (248) (26.1) 9 Plus Depreciation 70 7.5 9.0 9.5 10 Less: Capital Expenditures (7.7) (100) (9.9) (10.4) 11 Less: Increase in NWC (6.3) (86) (56) (4.9) 12 Free Cash Flow 25.3 24.6 30.8 33.3 a. Suppose Sora's revenue and free cash flow are expected to grow at a 5 8% rate beyond year four of Sora's weighted average cost of capital is 12.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 ent 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)
