Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the spreadsheet and the information presented, extend the forecast for this company through 2016 and SHOW ALL YOUR WORK. What is the company's projected
Using the spreadsheet and the information presented, extend the forecast for this company through 2016 and SHOW ALL YOUR WORK.
- What is the company's projected external financing required in 2016? How does this number compare to the 2015 projection?
- Perform a sensitivity analysis on this projection. How does the company's projected external financing required change if the ratio of cost of goods sold to net sales declines from 86 percent to 84 percent? If you link your assumptions in the pro forma to the cells containing the assumptions in the spreadsheet, it will be easy to change one number and see the resulting change.
- Perform a scenario analysis on this projection. How does the company's projected external financing required change if a severe recession occurs in 2016? Assume net sales decline 5 percent, cost of goods sold rises to 88 percent of net sales due to price cutting, and current assets increase to 35 percent of net sales as management fails to cut purchases promptly in response to declining sales.
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