Ask Experts Questions for FREE Help !
Ask
    mommamoon64's Avatar
    mommamoon64 Posts: 5, Reputation: 1
    New Member
     
    #1

    Aug 23, 2010, 02:10 AM
    Help making a balance sheet
    I am having issues getting a balance sheet to come out right. I have redone this several times and am at a loss as to what I am doing wrong. Can anyone help me out with this? I have attached my documenmts to show what I am working with and where I have gotten stuck. Thanks


    Steely Company
    Adjusted Trial Balance
    For the Year ended December 31, 2008

    Cash 6,130
    Accounts Receivable 2,300
    Prepaid Expenses 750
    Equipment 13,400
    Accumulated Depreciation 1,200
    Accounts Payable 1,700
    Notes Payable - Due on June 30, 2009 5,000
    Bob Steely, Capital 12,000
    Bob Steely, Withdrawals 870
    Fees Earned 6,600
    Wages Expense 1,450
    Rent Expense 900
    Utilities Expense 475
    Depreciation Expense 150
    Miscellaneous Expense 75
    Totals 26,500 26,500





    Steely Co.
    Balance Sheet
    December 31, 2008

    Assets Liabilities
    Current Assets: Current Liabilities:
    Cash 6,130 Acct Pay 1,700
    Acct Rcv 2,300 Notes Pay 5,000
    PrePaid Exp 750 Total Liab 6,700
    Total current assets 9,180
    Property, Equipment: Owner’s Equity
    Equipment 13,400 Bob Steely, capital 12,680
    Less Accum Depr 1,200 Total Liabilities & equity
    Total Prop, Equip 12,200 19,380
    Total assets 21,380
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #2

    Aug 23, 2010, 02:42 AM

    The problem is in the equity. Net income and withdrawals affect equity. You have changed this balance, telling me you know it needs changed, but how did you get 12,680?
    mommamoon64's Avatar
    mommamoon64 Posts: 5, Reputation: 1
    New Member
     
    #3

    Aug 23, 2010, 05:30 AM
    Here were my instructions. Thanks for helping


    Prepare an Income Statement, Balance Sheet, and Statement of Owner's Equity. Assume that the capital account started with a beginning balance of $10,000. 20 points
    ANS:
    Steely Co.
    Income Statement
    For Year Ended December 31, 2008

    Fees earned 6,600
    Expenses:
    Wages Expense 1,450
    Rent Expense 900
    Utilities Expense 475
    Depreciation Expense 150
    Misc Expense 75
    Total Expenses 3,050
    Net Income 3,550

    Steely Co.
    Statement of Owner's Equity
    For Year Ended December 31, 2008

    Bob Steely, Capital December 1, 2008 10,000
    Net income for December 2008 3,550

    Less Withdraws 870
    Increase in Owners Equity 2,680
    Bob Steely, capital, December 31,2008 12,680
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #4

    Aug 24, 2010, 12:17 AM
    Quote Originally Posted by mommamoon64 View Post


    Bob Steely, Capital December 1, 2008 10,000
    But this was 12,000 in your first post. That's why your exactly 2000 off.
    mommamoon64's Avatar
    mommamoon64 Posts: 5, Reputation: 1
    New Member
     
    #5

    Aug 24, 2010, 12:55 AM
    Thank you so much. Greatfulk that you did not give me the answer but illuminated the path so that I could find it myself. I was able to successfullky complete my assignment and am awaiting my grade. Will let you know how it works out. Thanks for you expertise and the extra eye.
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #6

    Aug 24, 2010, 01:02 AM

    You're welcome. :-)
    mommamoon64's Avatar
    mommamoon64 Posts: 5, Reputation: 1
    New Member
     
    #7

    Aug 24, 2010, 07:45 PM
    Thank you so very much... grade in this morning. I scored 147 out of a possible 150 points for the assignment. Hope I don't need help in the future but wonderful to know someone like you is there if I do have a need. Have a great week.
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #8

    Aug 25, 2010, 03:14 PM

    Hey cool. Congrats. :-)
    scoleman's Avatar
    scoleman Posts: 2, Reputation: 1
    New Member
     
    #9

    Mar 12, 2011, 12:08 PM
    22,580

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!

Preparing is, re and balance sheet from Trial balance adjustement sheet [ 3 Answers ]

I am trying to do my income statement, retained earnings and balance sheet from my adjusted trial balance sheet. I am confused from my book about the debits and credits. When I transfer them over from the adjusted sheet. Do they stay on the same sides. For example: assests will be on the...

How to record partners'current acounts in the trial balance and balance sheet [ 1 Answers ]

Two persons started their own business with the amount of dhs 175000 paid by one of them who doesn't work in the company . And the other one work in the company as a general manger .Considering the money as a loan to be paid back to the partner within 18 months, when their first financial...

Making a balance sheet from a trial balance. [ 1 Answers ]

I have come up with the attached balance sheet so far from the trial balance, but as it can obviously be seen it does not balance. I'm not sure where to go from here or where I made a mistake. Any help would be greatly appreciated, thanks in advance.


View more questions Search