Please solve using Microsoft Excel and provide formulatext screenshots

In addition to the AAA Ltd. financial statements in Problem One, you are given more information as follows. Sales are forecast to increase by 60% in 2023 . Notes Payable, Short-term Debt, Long-term Debt, and Common Stock will not change. Net Plant and Equipment is forecasted to be $11,250,000 next year. In 2023, the company's dividend payout ratio will be 85%. Cost of goods sold is expected to be 55% of sales. Selling expenses will be 10% of sales. Administrative expenses will be 8% of sales. Advertising expenses will be 6% of sales. Depreciation expense in 2023 is expected to be $1,015,500. Cash is expected to be 2% of sales, accounts receivable will be 16% of sales and inventory will be 8% of sales. Accounts payable will be 7% of sales. Accrued wages payable will be 3% of sales. Income taxes payable will be 6% of the forecasted net income for 2023 . The company is expected to pay 4% per year compounded annually on its notes payable, 5% per year compounded annually on its short-term bank loan and 9% per year compounded annually on its long-term debt. The interest expense on the notes payable in 2023 is calculated as: [interest rate on notes payable * amount of notes payable outstanding at the end of 2022]. The interest expense on the short-term debt in 2023 is calculated as: [interest rate on short-term debt * amount of short-term debt outstanding at the end of 2022]. The interest expense on the long-term debt in 2023 is calculated as: [interest rate on longterm debt * amount of long-term debt outstanding at the end of 2022] The company's tax rate is 28%. Based on the information provided you are to: a) Complete the pro-forma income statement and balance sheet for 2023 . b) Calculate the amount of Additional Funds Needed in 2023