AutoSave Of HB Problem 6 Excel Template (1) - Excel O Search File Insert Home Draw Data Page Layout Formulas View Review Help 336 fx H Thayer Company Balance Sheet December 31, 2021 A B C D E F G INSTRUCTIONS Below is the Trial Balance for Thayer Company. Using formulas and cell links, complete the B Balance Sheet The format is provided Leave off $. The cells are already formatted 4 5 Thayer Company 6 Trial Balance 7 7 December 31, 2021 8 9 Account Debit Credit 10 Cash 50,000 11 Accounts Receivable 105,000 12 Allowance for Bad Debts 3,000 13 Prepard Advertising 5000 14 Supphes 1,860 15 Land 137 320 16 Building 80,400 17 Accumulated Depreciation-Building 15 000 18 Equipment 70.000 19 Accumulated Depreciation--Equipment 10,000 20 Notes Payable 5 000 21 Taxes Payable 3,000 22 Salaries and Wages Payable 900 23 Interest Payable 600 24 Bonds Payable, due December 31, 2025 50,000 25 Common Stock 70 000 26 Dividends 10 600 27 Retained Earnings, January 1, 2021 154,000 28 Service Revenue 215,000 29 Interest Expense 2,400 30 Utilities Expense 1,320 31 Advertising Expense 1,500 32 Salaries and Wages Expense 53,040 33 Depreciation Expense 8,000 34 526 500 526,500 35 36 Calculate inding RE below and use in the Balance Sheel 37 36 39 40 45 Assets Current Assets Cash Accounts Receivable Allowance for Bad Debts Supplies Prepaid Advertising Total Current Assets Property Plant, & Equipment Land Building Accumulated Depreciation Building Equipment Accumulated Depreciation Equipment Total Property, Plant & Equipment Total Assets Liabilities & Stockholders' Equity Current Liabilities Notes Payable Taxes Payable Salanes and Wages Payable Interest Payable Total Current Liabilities Long term Liabilities Bonds Payable, due December 31, 2025 Total Liabilities Stockholders' Equity Common Stock Retained Earrings Total Stockholders' Equity Total Liabilities & Stockholders' Equity Sheet1 + +