Assignment 3: Excel Problems

profilelina.a
module_2_working_papers_2.xls
Home>Business & Finance homework help>Accounting homework help>Assignment 3: Excel Problems

3-43

P3- 43
Req. 2
Journal Entry
Date Accounts Debit Credit
Dec.
Journal Entry
Date Accounts Debit Credit
Dec.
Dec.
Dec.
Req. 3
Cash Furniture C. Haupt, Withdrawals
Dec 2 10,000 Dec 2 500 Dec 4 3,600 Dec Dec
18 800 3 2,000
12 200
Bal. Bal.
Bal.
Accounts receivable Accounts payable Service revenue
9 1,700 Dec Dec Dec 4 3,600 Dec Dec 9 1,700
5 300 18 800
Bal. Bal. Bal.
Supplies Unearned service revenue Rent expense
Dec 5 300 Dec Dec Dec 2 500
Bal. Bal. Bal.
Equipment C. Haupt, Capital Utilities expense
Dec 3 2,000 Dec Dec Dec 2 10,000 Dec 12 200
Bal. Bal. Bal.
Req. 4 & 5
Haupt Consulting
Work Sheet
December 31, 2010
Trial Balance Adjustments Adjusted Trial Balance
Account Debit Credit Debit Credit
Cash
Accounts receivable
Supplies
Equipment
Accumulated depreciation–equipment
Furniture
Accumulated depreciation–furniture
Accounts payable
Salary payable
Unearned service revenue
Carl Haupt, Capital
Carl Haupt, Withdrawals
Service revenue
Rent expense
Utilities expense
Salary expense
Depreciation expense–equipment
Depreciation expense–furniture
Supplies expense
Total
Req. 6
Journal Entry
Date Accounts Debit Credit
Dec.
Dec.
Dec.
Dec.
Dec.
Cash Accounts payable Rent expense
Bal. Bal. Bal.
Bal. Bal. Bal.
Accounts receivable Salary payable Utilities expense
Bal. Bal. Bal.
Bal. Bal. Bal.
Supplies Unearned service revenue Salary expense
Bal. Bal. Bal.
Bal. Bal. Bal.
Equipment C. Haupt, Capital Depreciation expense–equip.
Bal. Bal. Bal.
Bal. Bal. Bal.
Accumulated depreciation–equip C. Haupt, Withdrawals Depreciation expense–furn.
Bal. Bal. Bal.
Bal. Bal. Bal.
Furniture Service revenue Supplies expense
Bal. Bal. Bal.
Bal. Bal.
Bal.
Accumulated depreciation–furn.
Bal.
Bal.
Req. 7
Revenue:
Expenses:
Total expenses
Net income
Add:
Less:
Assets Liabilities
Total liabilities
Owner's Equity
Total assets Total liabilities and owner's equity

4-38

P4- 38
Req.1
Haupt Consulting
Work Sheet
December 31,2010
Adjusted Trial Balance Income Statement Balance Sheet
Account Debit Credit Debit Credit Debit Credit
Cash
Accounts Receivable
Supplies
Equipment
Accumulated depriciation-equip.
Furniture
Accumulated depriciation-furn.
Accounts payable
Salary payable
Unearned service revenue
Carl, Haupt, Capital
Carl, Haupt, Withdrawals
Service revenue
Rent Expense
Utilies expense
Salary expense
Depreciation expense-equip.
Depreciation expense-furn.
Supplies expense
Total
Net income
Req.2
JournalEntry
Date Accounts Debit Credit
Dec
Dec
Dec
Dec
C.Haupt,Capital Rent expense
Bal. Bal.
C.Haupt,Withdrawals Utilies expense
Bal. Bal.
Income summary Salary expense
Bal.
Service revenue Depreciation expense-equipment
Bal. Bal.
Depreciation expense-furniture
Bal.
Supplies expense
Bal.
Req.3
Haupt Consulting, Inc.
Balance Sheet
December 31,2010
Assets Liabilities
Owner's equity