Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance & Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=411)
-   -   Don't know if I'm adjusting wrong or what here (https://www.askmehelpdesk.com/showthread.php?t=368274)

  • Jun 23, 2009, 02:33 PM
    schmedes4
    Don't know if I'm adjusting wrong or what here
    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
  • Jun 23, 2009, 02:45 PM
    schmedes4

    I forgot

    Supplies inventory 11,000 and
    Rent expense 52,000 under DR
  • Jun 23, 2009, 02:57 PM
    schmedes4

    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
  • Jun 24, 2009, 01:27 PM
    schmedes4

    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

  • All times are GMT -7. The time now is 01:38 AM.