Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Its STILL January 1, 2023, and youll be going on Shark Tank in 2 weeks. You are unhappy with your previous Sales Forecast (Milestone 1)
Its STILL January 1, 2023, and youll be going on Shark Tank in 2 weeks. You are unhappy with your previous Sales Forecast(Milestone 1) because using your current level of sales to residences was not a good predictor of your upcoming sales to commercial builders. You believe your sales will increase significantly and that each order will result in a higher profit. You decide to change your forecasting method to a combination of Ratios, Percent-of-Sales, and Pro Forma forecasting. Required: 1(20 pts) Using the information on the Assumptions tab, create a 5-year forecasted Income Statement on the Forecasted Financials tab. 2(30 pts) Using the information on the Assumptions tab, create a 5-year forecasted Balance Sheet on the Forecasted Financials tab. 3(30 pts) On the Milestone 2 Metrics tab, compute various metrics based upon your forecasted financials. 4(20 pts) Answer questions about your results on the Milestone 2 Questions tab.
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