Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To determine the stock value using the discounted cash flow method: Forecast the free cash flows.Start by using the historical data from the financial statements
- To determine the stock value using the discounted cash flow method: Forecast the free cash flows.Start by using the historical data from the financial statements downloaded from Morningstar to compute the three-year average of the following ratios:
- EBIT/Sales
- Tax Rate (income tax expense/income before sales)
- Property, plant & equipment/Sales
- Depreciation/property, plant & equipment
- Net working capital/sales
Done Below:
Ratios 2016 2017 2019 Three Year Average
EBIT/Sales 24.48% 24.58% 24.47% 24.51%
Tax Rate 92.64% 15.01% 12.75% 40.13%
Property, Plant & Equipment/Sales 22.24% 20.88% 21.52% 21.55%
Depreciation/Property, Plant & Equipment 1.44 1.46 1.45 1.45
Net Working Capital/Sales 0.16 0.18 0.11 0.15
I need help with this question below???
Use the average ratios from above to forecast EBIT, property plant & equipment, depreciation, and net working capital for the next five years?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started