PDA

View Full Version : Don't know if I'm adjusting wrong or what here


schmedes4
Jun 23, 2009, 02:33 PM
Hi all been doing this for 4 hours now and I can't get anything to match up

1.) fees received in advance from clients and recorded as revenue for which service has not been provided 15,000
2.) Services performed for clients that were not recorded by December 31, 2007 total 20,000
3.) Allowance for doubtful accounts should be increased by 1% of total revenues (after considering 1 and 2)
4.) Insurance expired during the year totals 1,300
5.) Furniture and equipment is being depreciated at 10% of cost a year
6.) On December 1, a 90 day not was signed at 6% for 300,000 shown as note payable. Accrue interest for this note
7.) Rent for the building is 4,000 a month. Rent for 2007 has been paid as well as January 2008
8.) Office salaries earned but unpaid as of 31 December are 3,000
9.) Assume 30% income tax rate and that amounts for revenues and expenses are taxable

Unadjusted trial balance:
DR:
Accounts receivable 340,000
cash: 213,000
furniture and equipment : 137,000
misc. office expense 1,300
office salaries expense 166,000
unexpired insurance: 3,700
utilities expense 6,000
CR:
accumulated depreciation 22,000
allowance for doubtful account 2,700
capital stock 100,000
notes payable 300,000
retained earnings 5,300
revenue from consulting fees 500,000

So I have as my adjustments
Revenue 15000
unearned revenue 15000

Accounts receivable 20000
revenue 20000

allowance for doubtful account expense 5050 = (500,000 + 20,000 - 15,000) x 10%
total allowance for doubtful account 5050

insurance expense 1300
unexpired insurance 1300

depreciation expense 13700
accumulated depreciation 13700

interest expense 6000
note payable 6000

rent expense 48,000
prepaid rent 48,000

office salaries expense 3000
office salaries payable 3000

income tax is the kicker. I did 505000 - (169,000 salaries expense + 1300 misc. office expense + 4000 rent expense + 1300 insurance expense + 6000 interest expense + 5050 bad debt expense + 13700 depreciation expense + 6000 utilities expense) = 298650 x .3 = 89595

Now when I add my DR and CR up, they don't match. I get like 1.05 million to 1.12 million

Any help would be appreciated, thanks

schmedes4
Jun 23, 2009, 02:45 PM
I forgot

Supplies inventory 11,000 and
Rent expense 52,000 under DR

schmedes4
Jun 23, 2009, 02:57 PM
Some more

For DR I end up with
Accounts receivable 360,000
Cash 213,000
Furniture and equipment 137,000
misc. office expense 1300
Salaries expense 169,000
Rent expense 4000
Prepaid rent 48,000
Supplies 11,000
Unexpired insurance 2400
Utilities expense 6000
Insurance expense 1300
Doubtful account expense 5050
Depreciation expense 13,700
Income tax 89,595

For cr

Accumulated depreciation 35,700
Allowance for doubtful accounts 7750
Capital stock 100,000
Notes payable 306,000
Retained earnings 214,355
Revenue 505,000
Salaries payable 3000


Which gives me 1067345 dr and 1171805 cr... obviously I'm a little off somewhere

schmedes4
Jun 24, 2009, 01:27 PM
I figured it out, made a couple of dumb mistakes.

The adjustments for prepaid rent and rent expense were wrong and so was the interest expense and interest payable.

AND then I tried to balance the adjusted trial balance with new net income in it too! Silly me