Can You Help Me??? 5 Star Work ONLY!!!

At the end of each module, you will apply the module’s concepts by completing comprehensive assignments from the textbook.

Complete problems P3-43 (p. 185) and P4-38 (p. 252) in your text book.

Present your analysis of the assigned problems in Excel format. Enter non-numerical responses in the same worksheet using textboxes.

P3-43

This prblem continues the Haupt Consulting situation from problem 2-64 of chapter 2. Start from the trial balance and the posted t-accounts that Haupt consulting prepared at Decmber 18, as follows:

Haupt Consulting

Trial Balance

December 18, 2010

cash 8,100 debit

accounts receivable 1,700 debit

supplies 300 debit

equipment 2,000

accumulated depreciation---equipment 

furniture 3,600

accumulated depreciation---furniture

accounts payable 3,900

salary payable 

unearned service revenue

Carl Haupt, Capital 10,000 credit

Carl Haupt, Withdrawals

service revenue 2,500 credit

rent expense 500 debit

utilities expense 200

salary expense

depreciation expense---equipment

depreciation expense---furniture

supplies expense

total 16,400 debit 16,400 credit

later in December, the business completed these transactions, as follows:

Dec. 21 received $900 in advance for client service to be performed evenly over the next 30 days

Dec. 21 hired a secretary to be paid $1,500 on the 20th day of each month. The secretary begins work immediately.

Dec. 26 Paid $300 on account

Dec. 28 collected $600 on account

Dec. 30 owner withdrew $1,600

P4-38

this problem continues the Haupt Consulting situation from problem 3-43 of chapter 3. Start from the posted t-accounts and the adjusted trial balance that haupt consulting prepared for the company at Dec 31

Haupt Consulting

Adjusted Trial Balance

December 31, 2010

cash 7,700 debit

accounts receivable 1,500 debit

supplies 100 debit

equipment 2,000 debit

accumulated depreciation---equipment 33 credit

furniture 3,600 debit

accumulated depreciation---furniture 60 credit

accounts payable 3,600 credit

salary payable 700 credit

unearned servie revenue 600 credit

Carl Haupt, Capital 10,000 credit

Carl Haupt, Withdrawals 1,600 debit

service revenue 3,200 credit

rent expense 500 debit

utilities expense 200 debit

salary expense 700 debit

depreciation expense---equipment 33 debit

depreciatioin expense---furniture 60 debit

supplies expense 200

total 18,193 debit 18,193 credit

requirments

1. complete the accounting work sheet at dec 31

2. journalize and post the closing entries at dec 31. denote each closing amount as Clo and an account balance as Bal.

3. prepared a classified balance sheet at dec 31