6 The basic mathematical operators are +, -, and/ 7 Addition: To add the values in cells A1 and B4, the formula is =A1+B4 8 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-84 9 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*84 10 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 11 12 THIS FILE REQUIRES THE USE OF -SUM FOR ALL TOTALS AND SUBTOTALS 13 The-SUM function adds all values within a range of cells. 14 For example, the formula to calculate total attendees in cell 819 is =SUM(B16:818). 15 16 Men 850 17 Women 930 18 Children 1,145 19 Total 2,925 20 21 22 E 1 me: 2 ur score: 34 4 5 69 7 8 chris 0% The adjusted trial balance for Chris Company as of December 31, 2022 is presented below. REQUIRED: Prepare an income statement and statement of owner's equity for the year-ended December 31. Prepare a classified balance sheet as of December 31. There were no owner investments during the year. All yellow cells require either an account title or a valid formula. All totals must include the SUM function. Trial Balance 9 Account Title Debit Credit 10 Cash $20,200 11 Short-term investments 15,200 12 Accounts receivable, net 28,300 13 Supplies 7,100 14 Prepaid expenses 5,700 15 Long-term notes receivable 32,000 16 Investments in stocks and bonds 26,000 17 Equipment 46,800 18 Accumulated Depreciation $9,400 19 Land 37,000 20 Copyrights 8,000 21 Accounts payable 11,100 22 Unearned Fees 2,200 23 Long-term notes payable 28,000 24 chris, Capital 160,010 25 chris, Withdrawals 10,400 26 Services revenue 67,900 27 28 Interest revenue Rent expense 3,500 8,100 29 Salaries expense 27,200 30 Miscellaneous expenses 5,430 31 32 Depreciation expense Totals -4,680 $282,110 $282,110 33 34 35 36 37 Chris Company Income Statement For the Year Ended December 31, 2022 38 Revenues: Instructions Financial Statements + 21 me Insert Draw Formulas Page Layout Data Review View Calibri (Body) 11 v AA V A ste X In A Name: 4 Your score: B BIU fx chris 0% TULBIS Revenues: Total revenues Expenses: Total expenses Net income 58 C D E $202,110 $202,110 Chris Company Income Statement For the Year Ended December 31, 2022 Chris Company Statement of Owner's Equity For the Year Ended December 31, 2022 chris, Capital, December 31, prior year Add: Investments by owner Net income Less: Withdrawals by owner chris, Capital, December 31, current year Chris Company Balance Sheet December 31, 2022 Assets Current assets Instructions Financial Statements + Ready 0 $0 51 52 53 64 Current assets 65 66 67 68 69 70 71 72 73 Long-term investments 74 45 75 76 77 Total long-term investments Plant assets: 78 79 80 81 Total plant assets Intangible assets: 82 83 Total assets 84 85 Current liabilities: 86 87 88 89 90 91 92 93 94 Total current liabilities Long-term liabilities: Total liabilities Total liabilities and equity 95 96 Instructions Chris Company Balance Sheet December 31, 2022 Assets Equity Liabilities Financial Statements +