Ask Experts Questions for FREE Help !
Ask
    monkeypawsoup's Avatar
    monkeypawsoup Posts: 7, Reputation: 0
    New Member
     
    #1

    Apr 24, 2009, 11:48 AM
    Income statement, retained earnings, balance sheet from a worksheet
    Here is the info I got from a worksheet for preparing statements.
    101 Cash 18,800
    112 Acct Receive 16,200
    126 Supplies 2,300
    130 Prepaid Insurance 4,400
    151 Office equipment 44,000
    152 Accumulated Depreciation office equip. 20,000
    200 Notes Payable 20,000
    201 Accounts Payable 8,000
    212 Salaries Payable 2,600
    230 Interest Payable 1,000
    311 Common Stock 30,000
    320 Retained earnings 6,000
    332 Dividends 12,000
    400 Service Revenue 77,800
    610 Advertising Expense 12,000
    631 Supplies expense 3,700
    711 Depreciation expense 8,000
    722 Insurance expense 4,000
    726 Salaries expense 39,000
    905 Interest expense 1,000
    Totals $165, 400 165,4000

    Some additional information: $10,000 of the notes payable become due in 2009. No additional issuance of common stock occurred during 2008. The book also states that the current assets $41,700 and current liabilites $21,600

    Here is my income statement...
    Revenues
    Service Revenue $77,800
    Expenses
    Salaries expense $39,000
    Advertising expense 12, 000
    Supplies expense 3,700
    Insurance expense 4,000
    Interest expense 1,000
    Depreciation expense 8,000
    Total expense 67,700
    $10,100
    Here is my retained earnings...
    Retained earnings January 1, 2008 $6000
    Add: Net income 10,100
    $16,100
    Less: Dividends
    Retained earnings December 31, 2008 12,000
    $4,100
    And here is my balance sheet... which I cannot make add up
    Assets
    Cash 18,800
    Accounts receivable 16,200
    Supplies 1,400
    Prepaid Insurance 400
    Office Equipment 44,000
    Less Accum. Depreciation- office equip. 20,000 24,000
    Total Assets $60,800
    Liabilities and Stockholders’ Equity
    Notes payable 10,000
    Accounts payable 8,000
    Interest payable 1,000
    Advertising payable 12,000
    Salaries payable 2,600
    Total liabilities $21,600
    Stockholders’ equity
    Common Stock 30,000
    Retained earnings 4,100
    Total Liabilities and stockholders’ equity $55,700
    I think the liabilities and shockholders' equity is correct but I am at a loss on what I did wrong for the assets. Please help.
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #2

    Apr 24, 2009, 10:41 PM

    I have answered this question before:-

    DO NOT GIVE UP!

    You are doing very well.

    You have arrived at the correct result of
    $10,100 Profit.

    Next Calculate the NEW RETAINED EARNINGS.

    1) Profit = 10,100
    2) Add old retained = 6,000
    3) Sub-total = 16,100
    4) Less Dividend = 12,000
    _______________________
    5) New retained = 4,100
    _____________________

    All you have to do now is
    FORMULATE A BALANCE SHEET
    monkeypawsoup's Avatar
    monkeypawsoup Posts: 7, Reputation: 0
    New Member
     
    #3

    Apr 25, 2009, 09:58 PM
    It's the balancesheet I need the help with, I can't make the assets line up to the liabilities and stockholders' equity.Assets
    Cash 18,800
    Accounts receivable 16,200
    Supplies 1,400
    Prepaid Insurance 400
    Office Equipment 44,000
    Less Accum. Depreciation- office equip. 20,000 24,000
    Total Assets $60,800
    Liabilities and Stockholders’ Equity
    Notes payable 10,000
    Accounts payable 8,000
    Interest payable 1,000
    Advertising payable 12,000
    Salaries payable 2,600
    Total liabilities $21,600
    Stockholders’ equity
    Common Stock 30,000
    Retained earnings 4,100
    Total Liabilities and stockholders’ equity $55,700
    I think the liabilities and shockholders' equity is correct but I am at a loss on what I did wrong for the assets. Please help.
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #4

    Apr 25, 2009, 10:42 PM

    SEE ABOVE :-

    Total liabilities $21,600 ** NOT CORRECT

    Total Liabilities and stockholders' equity $55,700*** NOT CORRECT.

    Be extra careful with your Maths.

    Also, go back and check every figure with
    The original figures.
    The Balance Sheet still does NOT balance.
    There is a discrepancy of $6,900.
    You must have another figure, or
    One or more of the figures are incorrect.

    Rolcam
    ROLCAM's Avatar
    ROLCAM Posts: 1,420, Reputation: 23
    Ultra Member
     
    #5

    Apr 25, 2009, 10:57 PM

    You keep on sinking!
    The reason is you keep changing figures
    Mid-stream.
    You literally changed 3 figures??

    1) 126 Supplies 2,300 **** Supplies 1,400

    2) 200 Notes Payable 20,000**Notes payable 10,000

    3) 130 Prepaid Insurance 4,400**Prepaid Insurance 400

    ACCURACY is of the utmost importance.
    Fix these discrepancies and you will be right.

    Rolcam
    monkeypawsoup's Avatar
    monkeypawsoup Posts: 7, Reputation: 0
    New Member
     
    #6

    Apr 26, 2009, 12:39 PM
    For the supplies I took supplies expenses away from total supplies, same with prepaid insurance. The reason for the note' s payable is a side note in the book.. "$10,000 of the notes payable become due in 2009 so I figured for the year of 2009 they only paid 10,000 of the 20,000. The book also states that the current assets should be $41,700 and current liabilites $21,600. If the notes payable is only 10,000 then the total liabilites match up, the assets are hidden from me though I cannot make them 41,700.
    Jannellrae's Avatar
    Jannellrae Posts: 1, Reputation: 1
    New Member
     
    #7

    Dec 7, 2010, 03:17 PM
    Note payable 10,000 Cash 18,800
    Account payable 8,000 Account Receivable 16,200
    Salaries payable 2,600 Supplies 2,300
    Interest payable 1,000 Prepaid Insu. 4,400
    Total 2,1000 Total 41,700
    Now do the stock holders equity

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Income statement, retained earnings, balance sheet from a worksheet [ 8 Answers ]

Here is the info I got from a worksheet for preparing statements. 101 Cash 18,800 112 Acct Receive 16,200 126 Supplies 2,300 130 Prepaid Insurance 4,400 151 Office equipment 44,000 152 Accumulated Depreciation office equip. ...

Income statement, retained earnings and balance sheet [ 2 Answers ]

How to create an income statement, retianed earnings statement and balance sheet from. Adjusted Trail Balance Debit Credit Cash... 16,400 Accounts Receivable... 2,200 Office supplies... 1,800 Office...

Balance Sheet and Retained Earnings [ 4 Answers ]

Company X had the following accounts and balances in its general ledger at December 31, 20x9. Cash $45,000 Accounts Payable $80,000 Property & Equipment $200,000 Long Term Debt $ 60,000 Capital Stock $150,000 Accounts Receivable $90,000...


View more questions Search