Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

M: Finance

Authors: Marcia Cornett, Troy Adair, John Nofsinger

5th Edition

1260772357, 9781260772357

More Books

Students also viewed these Finance questions