Taser Consulting is a consulting firm owned and operated by Annamarie Phipps. The following end-of-period spreadsheet was prepared for the year ended October 31, 2018:
Taser Consulting
End-of-Period Spreadsheet
For the Year Ended October 31, 2018
Unadjusted Trial Balance Adjustments Adjusted Trial Balance
Account Title Dr. Cr. Dr. Cr. Dr. Cr.
Cash 45,000 45,000
Accounts Receivable 119,200 119,200
Supplies 11,900 7,500 4,400
Office Equipment 400,000 400,000
Accumulated Depreciation 56,000 6,000 62,000
Accounts Payable 20,500 20,500
Salaries Payable 9,000 9,000
Common Stock 75,000 75,000
Retained Earnings 180,700 180,700
Dividends 25,000 25,000
Fees Earned 800,000 800,000
Salary Expense 520,000 9,000 529,000
Supplies Expense 7,500 7,500
Depreciation Expense 6,000 6,000
Miscellaneous Expense 11,100 11,100
1,132,200 1,132,200 22,500 22,500 1,147,200 1,147,200
Required:
1. Prepare an income statement, retained earnings statement, and balance sheet for Taser Consulting.