1 Problem 6 Chpters 12-13 2 INSTRUCTIONS: Below is the Trial Balance for Thayer Company. Using formulas and cell links, complete the Balance 3 Sheet. The format is provided. Leave off $. The cells are already formatted. B C D E E Thayer Company Trial Balance December 31, 2021 Account Credit Debit 50,000 105,000 3,000 5,000 1,860 137,320 80,400 15,000 70,000 Cash Accounts Receivable Allowance for Bad Debts Prepaid Advertising Supplies Land Building Accumulated Depreciation--Building Equipment Accumulated Depreciation--Equipment Notes Payable Taxes Payable Salaries and Wages Payable 3 Interest Payable 4 Bonds Payable, due December 31, 2025 5 Common Stock 26 Dividends 27 Retained Earnings, January 1, 2021 28 Service Revenue 29 Interest Expense 30 Utilities Expense 31 Advertising Expense 32 Salaries and Wages Expense 33 Depreciation Expense 34 35 36 Calculate ending RE below and use in the Balance Sheet Sheet1 10,000 5,000 3,000 900 600 50,000 70,000 10,600 154,000 215,000 2,400 1,320 1,560 53,040 8,000 526,500 526,500 Merge & Center $ % ) Conditional Format Cell Formatting as Table Styles L H Thayer Company Balance Sheet December 31, 2021 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 abilities Notes Payable Taxes Payable Salaries and Wages Payable Interest Payable Total Current Liabilities Long-term Liabilities Bonds Payable, due December 31, 2025 Total Liabitis Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Labs & Stockholders' Equity