Ben Walter Valuation Case Draft (worth 45 points) Due Week 6 Final Case (worth 30 points) Due Week 8 Step #1:Prepare pro-forma financial statements (income statement and balance sheet) for (30 pts)4 years (2022-2026) for BOTH scenarios. Include base assumptions for each scenario. Statements should be in Excel with appropriate formulas and formatting. Scenario 1: Maintain low margins and high-volume sales growth (base case). Scenario 2: Increased margins and reduced future growth rate and debt load. Hints: #1: See chapter 12 for assistance in preparing pro-forma financials. #2: 2022 pro-forma is provided for you. #3: Be sure to include base