complete this six-step excel workbook

125% ... View Zoom Add Category T Text Insert Table Chart Shape Media Comment Collaborate + Sheet1 Step 1: Journalize business transactions: Account Debit Credit Debit Credit 1. Investors contribute $20,000 in exchange for common stock 2. Company purchases equipment in the amount of $5,000 Step 2: Prepare Trial Balance Account Cash Supplies Prepaid Insurance Buildings Equipment Accounts Payable Unearned Revenue Mortgage Payable Common Stock Service Revenue Wage expense Advertising expense 3. Company purchases building (on a mortgage) for $100,000 4. Company purchases supplies on account for $10,000 5. Company receives $3,000 in advance payment from customer TOTAL $0.00 $0.00 6. Company purchases a one year insurance policy for $600 7. Company receives $9,000 for services performed 8. Company pays employees $800 from work performed 9. Company pays $150 for one month of advertising TV 125% % Zoom . View Add Category Insert Table Chart Text Shape Media Comment Q Collaborate + Sheet1 Step 3: Prepare Adjusting Entries She 1. Building and equipment depreciate $4,000 total for the year Account Debit Credit She 2. Supply count shows $2,000 of supplies on hand at year end Back 3. $1,500 of services have been performed for previous advance payment received 4. Full year insurance policy in the amount of $600 has been used Step 4: Prepare Adjusted Trial B Account Cash Accounts Receivable Supplies Prepaid Insurance Buildings Equipment Accumulated Depreciation Accounts Payable Wages payable Unearned Revenue Interest payable Mortgage Payable Common Stock Service Revenue Wage expense Advertising expense Depreciation Expense Supply expense Insurance Expense Interest expense Dividends 5. Company bills $5,500 for services performed 6. $5,000 of interest is accrued on the mortgage 7. Employees are owed $700 at year end 8. The company pays a $500 cash dividend TOTAL 125% Zoom .. T View ul Chart Add Category Co Collaborate Insert Table Text Shape Media Comment + Sheet1 Adjusted Trial Balance Debit Step 5: Prepare Financial Statements Credit Step 6: Prepare Closing Entries Account Debit Credit Income Statement able e preciation ue e Statement of Retained Earnings: nse ense Balance Sheet: $0.00 $0.00