Question
I need help modeling the financial forecast of this company case study. There are a number of questions that go along with it as well,
I need help modeling the financial forecast of this company case study. There are a number of questions that go along with it as well, seen on the first document.
I am unsure of where to make assumptions and where to carry over numbers year by year.
I would like you to build a simple financial forecast of our performance for the next two years (ignore seasonal effects) and show me what our debt requirements will be at the fiscal years ended 2015 and 2016. I think it is reasonable to expect that Mid-Atlantic's sales will grow at 15 percent each year. Also, you should assume capital expenditures of $8.4 million for plant renovations spread out evenly over the next two years and depreciated over five years on a straight-line basis. Use whatever assumptions seem appropriate to you based on your historical analysis of results. For this forecast, you should assume that any external funding is in the form of debt.
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