Required: 

1 (20 pts) Conduct a 2-year weighted annual sales forecast for the years 2023-2027. Place your results on the Sales line of the Milestone 1 Sales Forecast tab in the highlighted area. 

2 (20 pts) Answer the questions on the Milestone 1 Questions tab. MII 

3 Fill in the yellow highlighted cells with your forecasted figures. 

4 SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Balance Sheet ( 30 points)

Transcribed Image Text:

SCENARIO & REQUIREMENTS (Scroll to see all 3 Milestones) SCENARIO: You invented "Dura-Clear windows" that never need washing! Nothing sticks to them - not pollution, pollen, dirt, dust, bird droppings, fingerprints, nothing. You've invested all your own savings, your parents' savings, and some of your friends' savings as well into the R&D, production, and start-up of your business. It's been three years since you started selling your windows primarily to single-family homeowners, but now apartment building contractors across the nation have been requesting your windows. Unfortunately, you're already operating at full capacity. It's time to make the switch from single-family homes to commercial buildings, but to do so requires a large infusion of funding for expansion. You need more of everything: space, equipment, employees, etc. angel investors ("sharks")--to see it a shark will invest in your company and serve as a mentor as well. Io your surprise, you were accepted to the show! You've already prepared most of your marketing and sales pitches, and now it's time to put together your forecasted financial statements. You intend to show the sharks that backing your business would be a very profitable investment. You also need to determine how much funding to ask for in exchange for how much ownership you'll give up. The following 2 Notes apply to all 3 Milestones! SCENARIO & REQUIREMENTS (Scroll to see all 3 Milestones) SCENARIO: You invented "Dura-Clear windows" that never need washing! Nothing sticks to them - not pollution, pollen, dirt, dust, bird droppings, fingerprints, nothing. You've invested all your own savings, your parents' savings, and some of your friends' savings as well into the R&D, production, and start-up of your business. It's been three years since you started selling your windows primarily to single-family homeowners, but now apartment building contractors across the nation have been requesting your windows. Unfortunately, you're already operating at full capacity. It's time to make the switch from single-family homes to commercial buildings, but to do so requires a large infusion of funding for expansion. You need more of everything: space, equipment, employees, etc. angel investors ("sharks")--to see it a shark will invest in your company and serve as a mentor as well. Io your surprise, you were accepted to the show! You've already prepared most of your marketing and sales pitches, and now it's time to put together your forecasted financial statements. You intend to show the sharks that backing your business would be a very profitable investment. You also need to determine how much funding to ask for in exchange for how much ownership you'll give up. The following 2 Notes apply to all 3 Milestones!

Answer rating: 100% (QA)

Completed table for Sales forecast for 20232027 provided below Explanationcalculations for numbers g... View the full answer