Homework Help is Here – Start Your Trial Now!
Business
Finance
Year Earnings and FCF Forecast ($ million) 1 Sales 2 Growth vs. Prior Year 3 Cost of Goods Sold 4 Gross Profit 5 Selling, General, & Admin. 6 Depreciation 7 EBIT 8 Less: Income Tax at 25% 9 Plus: Depreciation 10 Less: Capital Expenditures 11 Less: Increase in NWC 12 Free Cash Flow 433.0 468.0 8.1% (313.6) 154.4 (93.6) (7.0) 53.8 (13.5) 7.0 (7.7) (6.3) 33.4 2 516.0 10.3% (345.7) 170.3 (103.2) (7.5) 59.6 (14.9) 7.5 (10.0) (8.6) 33.6 3 547.0 6.0% (366.5) 180.5 (109.4) (9.0) 62.1 (15.5) 9.0 (9.9) (5.6) 40.1 574.3 5.0% (384.8) 189.5 (114.9) (9.5) 65.2 (16.3) 9.5 (10.4) (4.9) 43.1

Year Earnings and FCF Forecast ($ million) 1 Sales 2 Growth vs. Prior Year 3 Cost of Goods Sold 4 Gross Profit 5 Selling, General, & Admin. 6 Depreciation 7 EBIT 8 Less: Income Tax at 25% 9 Plus: Depreciation 10 Less: Capital Expenditures 11 Less: Increase in NWC 12 Free Cash Flow 433.0 468.0 8.1% (313.6) 154.4 (93.6) (7.0) 53.8 (13.5) 7.0 (7.7) (6.3) 33.4 2 516.0 10.3% (345.7) 170.3 (103.2) (7.5) 59.6 (14.9) 7.5 (10.0) (8.6) 33.6 3 547.0 6.0% (366.5) 180.5 (109.4) (9.0) 62.1 (15.5) 9.0 (9.9) (5.6) 40.1 574.3 5.0% (384.8) 189.5 (114.9) (9.5) 65.2 (16.3) 9.5 (10.4) (4.9) 43.1

Intermediate Financial Management (MindTap Course List)
Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter8: Basic Stock Valuation
Section: Chapter Questions
Problem 6MC
See similar textbooks
icon
Related questions
Question
Year Earnings and FCF Forecast ($ million) 1 Sales 2 Growth vs. Prior Year 3 Cost of Goods Sold 4 Gross Profit 5 Selling, General, & Admin. 6 Depreciation 7 EBIT 8 Less: Income Tax at 25% 9 Plus: Depreciation 10 Less: Capital Expenditures 11 Less: Increase in NWC 12 Free Cash Flow 0 433.0 1 468.0 8.1% (313.6) 154.4 (93.6) (7.0) 53.8 (13.5) 7.0 (7.7) (6.3) 33.4 2 516.0 10.3% (345.7) 170.3 (103.2) (7.5) 59.6 (14.9) 7.5 (10.0) (8.6) 33.6 3 547.0 6.0% (366.5) 180.5 (109.4) (9.0) 62.1 (15.5) 9.0 (9.9) (5.6) 40.1 4 574.3 5.0% (384.8) 189.5 (114.9) (9.5) 65.2 (16.3) 9.5 (10.4) (4.9) 43.1
Transcribed Image Text:Year Earnings and FCF Forecast ($ million) 1 Sales 2 Growth vs. Prior Year 3 Cost of Goods Sold 4 Gross Profit 5 Selling, General, & Admin. 6 Depreciation 7 EBIT 8 Less: Income Tax at 25% 9 Plus: Depreciation 10 Less: Capital Expenditures 11 Less: Increase in NWC 12 Free Cash Flow 0 433.0 1 468.0 8.1% (313.6) 154.4 (93.6) (7.0) 53.8 (13.5) 7.0 (7.7) (6.3) 33.4 2 516.0 10.3% (345.7) 170.3 (103.2) (7.5) 59.6 (14.9) 7.5 (10.0) (8.6) 33.6 3 547.0 6.0% (366.5) 180.5 (109.4) (9.0) 62.1 (15.5) 9.0 (9.9) (5.6) 40.1 4 574.3 5.0% (384.8) 189.5 (114.9) (9.5) 65.2 (16.3) 9.5 (10.4) (4.9) 43.1
Sora Industries has 62 million outstanding shares, $124 million in debt, $47 million in cash, and the following projected free cash flow for the next four years: a. Suppose Sora's revenue and free cash flow are expected to grow at a 3.6% rate beyond year four. If Sora's weighted average cost of capital is 14.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.)
Transcribed Image Text:Sora Industries has 62 million outstanding shares, $124 million in debt, $47 million in cash, and the following projected free cash flow for the next four years: a. Suppose Sora's revenue and free cash flow are expected to grow at a 3.6% rate beyond year four. If Sora's weighted average cost of capital is 14.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.)
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
SEE MORE TEXTBOOKS