|  
               
                |  |  | 
                    
                    
                    
                 |  
 
	
	
		
	
	
  | 
    
      
                |  | New Member |  | 
 
                  
                      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
 |  
    |  |  
	
		
	
	
  | 
    
      
                |  | Uber Member |  | 
 
                  
                      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?
 |  
    |  |  
	
		
	
	
  | 
    
      
                |  | New Member |  | 
 
                  
                      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
 |  
    |  |  
	
		
	
	
  | 
    
      
                |  | Uber Member |  | 
 
                  
                      Aug 24, 2010, 12:17 AM
                  
                 |  |  
  
    | 
        
        
        
       
                  
        
	
		
			
			
				
					  Originally Posted by mommamoon64   
 Bob Steely, Capital December 1, 2008	10,000
 But this was 12,000 in your first post.  That's why your exactly 2000 off.
     |  
    |  |  
	
		
	
	
  | 
    
      
                |  | New Member |  | 
 
                  
                      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.
     |  
    |  |  
	
		
	
	
  | 
    
      
                |  | Uber Member |  | 
 
                  
                      Aug 24, 2010, 01:02 AM
                  
                 |  |  
  
    | 
        
        
        
       
                  
        You're welcome. :-)
 |  
    |  |  
	
		
	
	
  | 
    
      
                |  | New Member |  | 
 
                  
                      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.
     |  
    |  |  
	
		
	
	
  | 
    
      
                |  | Uber Member |  | 
 
                  
                      Aug 25, 2010, 03:14 PM
                  
                 |  |  
  
    | 
        
        
        
       
                  
        Hey cool.  Congrats. :-)
 |  
    |  |  
	
		
	
	
  | 
    
      
                |  | New Member |  | 
 
                  
                      Mar 12, 2011, 12:08 PM
                  
                 |  |  
  
    | 
        
        
        
       
                  
        22,580
     |  
    |  |  
 
 
 
  
    | Question Tools | Search this Question |  
    |  |  |  
 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...
 
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
 
 |