Using the trial balance, Prepare a balance sheet, income statement & statement of retained earnings in Excel.

Trial Balance For the vear ended 12/31/17 Accounts Debit Credit Cash Accounts Recieveable Allowance for Doubtful Accounts Supplies Prepaid Insurance Building Equipment Land Accumulated Depreciation Investment in Bonds held to Maturity Accounts Payable Current Maturity of Note Payable Note Payable Unearned Revenue Interest Payable Salaries Payable Common stock Retained earnings Service Revenue Advertising Expense Depreciation Expense Insurance Expense Interest Expense Rent Expense Salaries Expense Supplies Expense Travel Expense Utilities Expense Loss on Sale of Equipment Total 156,500 16,650 1,250 950 1,700 160,000 25,000 11,500 67,000 4,000 5,650 1,000 20,000 2,000 1,500 1,950 49,100 50,000 268,700 6,000 5,600 5,800 1,800 6.700 55,000 2,200 550 6,200 2.000 468,150 468,150