MILESTONE 2: Creation of Forecasted Financials (100 points) DUE: WEEK 5 It's STILL January 1, 2023, and you'll be going on Shark Tank in 2 weeks. You are unhappy with your previous Sales Forecast because your current sales to residences do not really predict your upcoming sales to commercial builders. You believe your incoming orders will be much higher than before with each order resulting in a much higher revenue stream. You decide to change your method of forecasting to a mix of Percent-of-Sales and Pro Forma forecasting. Required: 1 (25 pts) Using the information on the Assumptions tab, create a 5-year forecasted Income Statement on the Forecasted Financials tab. 2 3 (30 pts) Using the information on the Assumptions tab, create a 5-year forecasted Balance Sheet on the Forecasted Financials tab. (20 pts) On the Milestone 2 Metrics tab, compute various metrics based upon your forecasted financials. 4 (25 pts) Answer questions about your results on the Milestone 2 Questions tab.