Question: Use all the information provided to answer question 1 - 12 Figure 1 MicroDrive's Financial Statements in most recent two years Figure 2 Inputs for

Use all the information provided to answer question 1 - 12

Figure 1 MicroDrive's Financial Statements in most recent two years

 Use all the information provided to answer question 1 - 12

Figure 2 Inputs for the Selected Scenarios

Figure 1 MicroDrive's Financial Statements in most recent two years Figure 2

Figure 3 Projections and Valuation

Inputs for the Selected Scenarios Figure 3 Projections and Valuation Figure 2

Figure 2 outlines the assumptions and forecasts. The model suggests that MicroDrive's sales will increase by 10%, 8%, 7%, 5%, and 5% in the next 5 years. And the sales will continue to grow at 5% after 2020 perpetually. All the ratios represented figure 2 remain the same as those in 2015 except for COGS/Sales, Inventory/Sales, and Net PP&E/Sales ratios. Figure 2 indicates the company will successfully improve the efficiency of its operation by lowering COGS, Inventory, and Net PP&E relative to sales. Free cash flows experience non-constant growth rates from 2016 to 2020. Eventually, the growth rate of free cash flow will stay at 5% after 2020. With all the information provided, fill in the blanks in Figure 3. (Refer to the notes for formulas.)

1. Sales in 2016, 2017, 2018, 2019, and 2020

2. Net PP&E in 2016

3. Net operating profits after taxes in 2016

4. Net operating working capital in 2016

5. Total operating capital in 2016

6. Free cash flow in 2016

7. What is the target weighted average cost of capital (WACC)?

8. What is the horizon value 2020 (HV2020)?

9. What is the present value of HV2020?

10. What is the present value of free cash flows from 2016 to 2020?

11. What is the value of operations?

12. What is the estimated intrinsic stock price?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!