Prepare a Balance Sheet for the following transactions.

M 24% AutoSave OFF 3 H 2 5 v 5 5 Bowers_kit Draw Formulas Data Review View Tell me Home Insert Page Layout X v v % v A. Conditional Formatting 2 Format as Table Cell Styles Paste Font Alignment Number Cells Editing C13 Ax fx Inventory B E F G H Balanced D 1,092,164 Debit xx.xxx 1,092,164 Credit xx.xxx 1,605 1,605 4,210 4 4,210 159,430 79,715 79,715 188,500 188,500 377,000 160,500 5 6 Trx Tnx Date Account 7 HO 1/31 Dr Account (EXAMPLE) 8 Cr Account (EXAMPLE) 9 #1 1/1 Accounts payable 10 Cash 11 #2 1/2 Supplies 12 Accounts payable 13 3 2/15 Inventory 14 Accounts payable 15 Cash 16 84 4/15 Cash 17 Accounts receivable 18 Sales revenue 19 Cost of goods sold 20 Inventory 21 #5 4/30 Rent expense 22 Prepaid rent 23 16 5/1 Prepaid rent 24 25 #7 12/1 Cash 26 Accounts receivable 27 1/31 Dividends 28 Cash 29 A1 Supplies expense 30 Supplies 31 LA2 32 Prepaid rent 33 NA3 Depreciation expense 34 Accumulated depreciation 35 BA4 36 Taxes payable 37 160,500 20,800 20,800 74,400 Cash 74,400 131,950 131,950 79,600 79,600 1,260 Rent expense 1,260 49,600 49,600 18,870 Tax expense 18,870 12939 12,939 Beg TB JES Ledger Adj TB IS W P Home Insert Draw Page Layout Formulas Data Review View Tell X A. % Conditional Formatting Format as Table Cell Styles Paste Font Alignment Number Cells Edit C19 + x vfx B D E F Amounts Totals Formulas shown: A 6 7 Company A 8 Balance Sheet 9 As of December 31, 2020 10 11 Assets 12 Current Assets 13 Cash 14 15 16 217 18 19 Total Current Assets 7020 Missing Formula " the 21 Equipment (Net of Accum. Depr.) $ (28,305) 22 23 Total Assets Missing Formula 24 25 Uabilities 26 27 28 29 Total Liabilities Missing Formula 30 Stockholders' Equity 31 32 33 Total Stockholders' Equity Missing Formula 35 Total Liabilities and Stockholders' Equity Missing Formula 37 Balance Sheet "THEN Check: Balanced 38 FC23-C35, "Balanced","OUT OF BALANCE 39 Total Current Assets Check Figures S 286,105 Total Stockholders' Equity Check Figures 348,031 30 Beg TB Tr JES Ledger Adj TB IS A w P X