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
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