Please prepare a balance sheet using the following data. Please include any equations or calculations used through excel.

Actual Year 2021 Projected Year 2022 88,200 Revenues - high school students Revenues - adult learners Accounts receivable - high schools 110,300 745,000 571,200 7,400 10,200 Accounts receivable - adult learners 47,600 73,000 Commissions expense 21,400 27,800 Commissions payable 900 1,200 Salaries and benefits expense 638,900 947,000 Rent expense 12,000 12,400 1,200 Prepaid rent 1,200 Prepaid insurance 2,800 3,000 High school expenses (Cost of Sales) 49,400 65,300 Adult learner expenses (Cost of Sales) 68,500 98,700 Long-term debt 0 0 Depreciation expense 10,000 18,000 Other operating expenses 50,000 55,000 Accounts payable 14,800 15,700 Salaries and benefits payable 26,600 37,500 2,700 3,800 0 0 35,000 45,000 Payroll taxes payable Income tax expense Fixed assets, net of accumulated depreciation Retained earnings (Accumulated deficit) Common and preferred stock Cash (96,000) 400,000 255,000 400,000 75,000 Interest expense 0 0