1 Problem 6 Chpters 12-13 INSTRUCTIONS: Below is the Trial Balance for Thayer Company. Using formulas and cell links, 3 complete the Balance Sheet. The format is provided. Leave off $. The cells are already formatted. 4 Problem 6 Excel Template (1) [Protected View] - Excel Molly Schleicher 0 x File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X B36 X for E F H J L M N A B D 8 9 Account Debit Credit 10 Cash 50,000 11 Accounts Receivable 105,000 12 Allowance for Bad Debts 3,000 13 Prepaid Advertising 5,000 14 Supplies 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,560 32 Salaries and Wages Expense 53.040 33 Depreciation Expense 8.000 34 526,500 526,500 35 36 Calculate ending RE below and use in the Balance Sheet 37 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 Salaries and Wages Payable Interest Payable Total Current Liabilities Long-term Liabilities Bonds Payable, due December 31, 2025 Total Liabilities Stockholders' Equity Common Stock Sheet1 + Ready 90% Type here to search o + 2:10 PM 10/11/2020 j PL JENG FTODI ew Help Tell me what you want to do G 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 Liabilities Notes Payable Taxes Payable Salaries and Wages Payable Interest Payable Total Current Liabilities Long-term Liabilities Bonds Payable, due December 31, 2025 Total Liabilities Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities & Stockholders' Equity