Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sora Industries has 68 million outstanding shares, $124 million in debt, $50 million in cash, and the following projected free cash flow for the next

image text in transcribed
image text in transcribed
image text in transcribed
Sora Industries has 68 million outstanding shares, $124 million in debt, $50 million in cash, and the following projected free cash flow for the next four years: Year 0 1 2 3 Earnings and FCF Forecast (5 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 40% (21.5) (23.8) (24.8) (26.1) 9 Plus: Depreciation 7.0 7.5 9.0 9.5 3 Cost of Goods Sold 4 Gross Profit 5 Selling, General, & Admin. 6 Depreciation 7 EBIT 8 Less: Income Tax at 40% 9 Plus: Depreciation 10 Less: Capital Expenditures 11 Less: Increase in NWC 12 Free Cash Flow (313.6) 154.4 (93.6) (7.0) 53.8 (21.5) 7.0 (7.7) (6.3) 25.3 (345.7) 170.3 (103.2) (7.5) 59.6 (23.8) 7.5 (10.0) (8.6) 24.6 (366.5) 180.5 (109.4) (9.0) 62.1 (24.8) 9.0 (9.9) (5.6) 30.8 (384.8) 189.5 (114.9) (9.5) 65.2 (26.1) 9.5 (10.4) (4.9) 33.3 10 Less: Capital Expenditures (7.7) (100) (9.9) (10.4) 11 Less: Increase in NWC (6.3) (8.6) (56) 14.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 3.4% rato beyond year four. If Sora's weighted average cost of capital is 11.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 2ero). I 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.) a. Suppose Sora's revenue and free cash flow are expected to grow at a 34% rate beyond year four. If Sora's weighted average cost of capitalis 110%, what is the value of Sora stock based on this information? The stock price for this case is $ (Round to the nearest cont.) Sora Industries has 68 million outstanding shares, $124 million in debt, $50 million in cash, and the following projected free cash flow for the next four years: Year 0 1 2 3 Earnings and FCF Forecast (5 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 40% (21.5) (23.8) (24.8) (26.1) 9 Plus: Depreciation 7.0 7.5 9.0 9.5 3 Cost of Goods Sold 4 Gross Profit 5 Selling, General, & Admin. 6 Depreciation 7 EBIT 8 Less: Income Tax at 40% 9 Plus: Depreciation 10 Less: Capital Expenditures 11 Less: Increase in NWC 12 Free Cash Flow (313.6) 154.4 (93.6) (7.0) 53.8 (21.5) 7.0 (7.7) (6.3) 25.3 (345.7) 170.3 (103.2) (7.5) 59.6 (23.8) 7.5 (10.0) (8.6) 24.6 (366.5) 180.5 (109.4) (9.0) 62.1 (24.8) 9.0 (9.9) (5.6) 30.8 (384.8) 189.5 (114.9) (9.5) 65.2 (26.1) 9.5 (10.4) (4.9) 33.3 10 Less: Capital Expenditures (7.7) (100) (9.9) (10.4) 11 Less: Increase in NWC (6.3) (8.6) (56) 14.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 3.4% rato beyond year four. If Sora's weighted average cost of capital is 11.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 2ero). I 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.) a. Suppose Sora's revenue and free cash flow are expected to grow at a 34% rate beyond year four. If Sora's weighted average cost of capitalis 110%, what is the value of Sora stock based on this information? The stock price for this case is $ (Round to the nearest cont.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bed And Breakfast IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304131793, 978-1304131799

More Books

Students also viewed these Accounting questions