Part 1. Use the information provided in column Hand the assumptions in column M to build a forecast income statement and balance sheet for 2022. Iterate until your forecast balance sheet balance. Follow the example we used in class lecture. Part 1 is worth 10 points Part 2 Terations 20221 2022 2022 20228 2021 12,094 10.315 2,579 Assumption 25 B0% Income Statement Net Sales Cost of goods sold Gross profit Expenses Seling general, and administrative expenses Net Interest expense Earnings before Tax Earnings after Dividendi 12 10% 1.542 90 942 330 632 153 25% 25 Balance Sheet 2023 20221 iterations 20221 20221 20227 18 45 dan dan turnover TE 635 1,590 2,579 13 4,822 300 5,122 Keep constant 25 depreciation The company plans to spend $5 on now feeds and cap ex has a depreciation expense of 595 Assets Current Cash and securities Accounts receivable Prepaid expenses Total current Net Totale Liabilities and Owners' quity Current llaties Bank loan Accounts payable CMTD Acred was Total currenties Long-term debe Common och Retained aming Yollabilities and where plug day start with in bank loan for fertion. Hold amortion of del principle constant at $100 and secried wages constant Keep constant 50 904 100 18 1012 300 250 2.000 5,122 0 Long-term debitamente by 100 each year. New common to ed or repurchased the BASE retained in Peyour balance in to the station's bankan the value is positive. It reptive tract from bank Joan. Once an answers, add to marketable Mcurities Part 1. Use the information provided in column Hand the assumptions in column M to build a forecast income statement and balance sheet for 2022. Iterate until your forecast balance sheet balance. Follow the example we used in class lecture. Part 1 is worth 10 points Part 2 Terations 20221 2022 2022 20228 2021 12,094 10.315 2,579 Assumption 25 B0% Income Statement Net Sales Cost of goods sold Gross profit Expenses Seling general, and administrative expenses Net Interest expense Earnings before Tax Earnings after Dividendi 12 10% 1.542 90 942 330 632 153 25% 25 Balance Sheet 2023 20221 iterations 20221 20221 20227 18 45 dan dan turnover TE 635 1,590 2,579 13 4,822 300 5,122 Keep constant 25 depreciation The company plans to spend $5 on now feeds and cap ex has a depreciation expense of 595 Assets Current Cash and securities Accounts receivable Prepaid expenses Total current Net Totale Liabilities and Owners' quity Current llaties Bank loan Accounts payable CMTD Acred was Total currenties Long-term debe Common och Retained aming Yollabilities and where plug day start with in bank loan for fertion. Hold amortion of del principle constant at $100 and secried wages constant Keep constant 50 904 100 18 1012 300 250 2.000 5,122 0 Long-term debitamente by 100 each year. New common to ed or repurchased the BASE retained in Peyour balance in to the station's bankan the value is positive. It reptive tract from bank Joan. Once an answers, add to marketable Mcurities