View Full Version : Determine Working Capital from a partial balance sheet
 
 hhuynhly
Dec 9, 2010, 11:41 AM
Presented below is a partial trial balance for the Kansas Instruments Corporation at December 31, 2011.
 
    Account Title Debits Credits 
  Cash 21,000       
  Accounts receivable 134,000       
  Raw materials 31,000       
  Note receivable 107,000       
  Interest receivable 4,100       
  Interest payable     4,700   
  Marketable securities 35,000       
  Land 46,000       
  Buildings 1,270,000       
  Accumulated depreciation—buildings     580,000   
  Work in process 46,500       
  Finished goods 93,000       
  Equipment 220,000       
  Accumulated depreciation—equipment     124,000   
  Patent (net of amortization) 129,000       
  Prepaid rent (for the next two years) 66,000       
  Unearned revenue     34,000   
  Accounts payable     170,000   
  Note payable     340,000   
  Cash restricted for payment of note payable 73,000       
  Allowance for uncollectible accounts     12,200   
  Sales revenue     880,000   
  Cost of goods sold 540,000       
  Rent expense 19,000       
 
--------------------------------------------------------------------------------
 
  Additional information: 
1. The note receivable, along with any accrued interest, is due on November 22, 2012.
 
2. The note payable is due in 2015. Interest is payable annually.
 
3. The marketable securities consist of treasury bills, all of which mature in the next year.
 
4. Unearned revenue will be earned equally over the next two years.
 
  Required: 
Determine the company's working capital at December 31, 2011.
 Just Looking
Dec 9, 2010, 11:47 AM
Working capital is current assets minus current liabilities.  Can you identify which items are current assets?  Current liabilities?  If you'll post your answers, we can check to see that you understand.  Thanks.
 hhuynhly
Dec 9, 2010, 12:28 PM
Hi, that's what I'm having trouble with.  I think I'm mixing up which are current assets and liabilities.  
 
Current Assets:
Cash $21000
A/R $134,000
Notes Receivable $107,000 (since it's due 11/22/12 less than a year)
Interest Receivable $4,100
Prepaid Rent $66,000 (paid for 2 years, are all prepaid expenses current assets?)
Marketable Securities $35,000 (mature in the next year)
 
Curent Liabilities:
Current Maturity of long term liability $73000
Interest Payable $4700
Unearned Revenue $34000 (does it matter that the additional information says UR is the same each year?)
Accounts Payable $170000
 
Thank you!
 hhuynhly
Dec 9, 2010, 12:46 PM
When I subtract the current asset with current liabilities, I'm not getting the right answer.  Can you tell me if my current asset and liabilites are correct?
 Just Looking
Dec 9, 2010, 01:01 PM
Hi, that's what I'm having trouble with.  I think I'm mixing up which are current assets and liabilities.  Our policy is to check homework only, not do the problem.  That's why I asked for your input.   You did a pretty good job.  See comments below.
 
Current Assets:
Cash $21000  
A/R $134,000
Notes Receivable $107,000 (since it's due 11/22/12 less than a year)
Interest Receivable $4,100
Prepaid Rent $66,000 (paid for 2 years, are all prepaid expenses current assets?)  You only count the part that will be consumed within a year.
Marketable Securities $35,000 (mature in the next year)
 
Curent Liabilities:
Current Maturity of long term liability $73000  The cash restricted is cash that is set aside for a particular use or event.  Its classification depends on its purpose and whether that is short or long term.  In this case, it is being set aside for paying the note payable.  Since that is due in 2015 and is long-term, the restricted cash in long-term.
Interest Payable $4700
Unearned Revenue $34000 (does it matter that the additional information says UR is the same each year?)  It says it will be earned equally over the next 2 years, meaning $17,000 is due in year one and $17,000 is due in year 2.  You only want what will be due in a year.
Accounts Payable $170000
 
Thank you!
 
Inventory is also a prepaid expense.  Can you identify the accounts above that are inventory accounts?
 
The allowance for doubtful accounts is also a current asset (well, contra-asset - but it reduces current assets).  Do you understand why?
 hhuynhly
Dec 9, 2010, 01:10 PM
Are the raw material accounts considered inventory?  
 
So allowance for uncollectible accounts is a current asset also?  Does that mean it'll get deducted when I add up all of the current assets?  
 
I'm just really confused on this problem, thank you for helping.
 hhuynhly
Dec 9, 2010, 01:13 PM
Are raw material, WIP, and finished goods considered an inventory account?  There for a current asset?  Is there anything else that I'm missing?  Thank you!
 Just Looking
Dec 9, 2010, 01:20 PM
The allowance for doubtful accounts is that portion of accounts receivable that the company does not expect to receive, so it does have to be deducted from the current assets.
 
You are correct on your list of inventory accounts.
 
I think you have it all, but if you want to make corrections and post again I'll double-check to make sure nothing got lost in translation.  Thanks.
 hhuynhly
Dec 9, 2010, 01:21 PM
OH!  I see, you have to deduct allowances from accounts receivable!  I got the right answer!  Thank you so much for your help!
 ikeprinkess
Dec 9, 2010, 09:05 PM
I have the same problem! And I can't figure out! Please help me
 ikeprinkess
Dec 9, 2010, 09:06 PM
Can some one please help me! I have the same problem and I'm all confuse
 
Presented below is a partial trial balance for the Kansas Instruments Corporation at December 31, 2011.
 
  Account Title 	Debits 	Credits
  Cash 	22,000 	  	  	 
  Accounts receivable 	141,000 	  	  	 
  Raw materials 	33,000 	  	  	 
  Note receivable 	114,000 	  	  	 
  Interest receivable 	3,400 	  	  	 
  Interest payable 	  	  	4,000 	 
  Marketable securities 	35,000 	  	  	 
  Land 	49,000 	  	  	 
  Buildings 	1,350,000 	  	  	 
  Accumulated depreciation—buildings 	  	  	670,000 	 
  Work in process 	42,000 	  	  	 
  Finished goods 	91,000 	  	  	 
  Equipment 	360,000 	  	  	 
  Accumulated depreciation—equipment 	  	  	137,000 	 
  Patent (net of amortization) 	126,000 	  	  	 
  Prepaid rent (for the next two years) 	64,000 	  	  	 
  Unearned revenue 	  	  	36,000 	 
  Accounts payable 	  	  	174,000 	 
  Note payable 	  	  	410,000 	 
  Cash restricted for payment of note payable 	71,000 	  	  	 
  Allowance for uncollectible accounts 	  	  	11,900 	 
  Sales revenue 	  	  	780,000 	 
  Cost of goods sold 	460,000 	  	  	 
  Rent expense 	26,000 	  	  	 
 
Additional information:
1. 	
 
The note receivable, along with any accrued interest, is due on November 22, 2012.
2. 	
 
The note payable is due in 2015. Interest is payable annually.
3. 	
 
The marketable securities consist of treasury bills, all of which mature in the next year.
4. 	
 
Unearned revenue will be earned equally over the next two years.
 
Required:
 
Determine the company's working capital at December 31, 2011. (Omit the "$" sign in your response.)
 ikeprinkess
Dec 9, 2010, 09:17 PM
Presented below is a partial trial balance for the Kansas Instruments Corporation at December 31, 2011.
 
  Account Title 	Debits 	Credits
  Cash 	22,000 	  	  	 
  Accounts receivable 	141,000 	  	  	 
  Raw materials 	33,000 	  	  	 
  Note receivable 	114,000 	  	  	 
  Interest receivable 	3,400 	  	  	 
  Interest payable 	  	  	4,000 	 
  Marketable securities 	35,000 	  	  	 
  Land 	49,000 	  	  	 
  Buildings 	1,350,000 	  	  	 
  Accumulated depreciation—buildings 	  	  	670,000 	 
  Work in process 	42,000 	  	  	 
  Finished goods 	91,000 	  	  	 
  Equipment 	360,000 	  	  	 
  Accumulated depreciation—equipment 	  	  	137,000 	 
  Patent (net of amortization) 	126,000 	  	  	 
  Prepaid rent (for the next two years) 	64,000 	  	  	 
  Unearned revenue 	  	  	36,000 	 
  Accounts payable 	  	  	174,000 	 
  Note payable 	  	  	410,000 	 
  Cash restricted for payment of note payable 	71,000 	  	  	 
  Allowance for uncollectible accounts 	  	  	11,900 	 
  Sales revenue 	  	  	780,000 	 
  Cost of goods sold 	460,000 	  	  	 
  Rent expense 	26,000 	  	  	 
 
Additional information:
1. 	
 
The note receivable, along with any accrued interest, is due on November 22, 2012.
2. 	
 
The note payable is due in 2015. Interest is payable annually.
3. 	
 
The marketable securities consist of treasury bills, all of which mature in the next year.
4. 	
 
Unearned revenue will be earned equally over the next two years.
 
Required:
 
Determine the company's working capital at December 31, 2011. (Omit the "$" sign in your response.)
 
This is my problem,
 
I have
Current Asset
Cash 22,000
A/R 141,000 - 11,900 ( allowance )
Note Receivable 114,000
Interest Receivable 3,400
Prepaid rent 64,000
Marketable securities 35,000
Raw materials + WIP + finish goods = 33k+42k+91K = 166k
 
Current liabilites:
Current maturity of long term liability 71,000
Interest payable 4,000
Unearn revenue 36,000
And Account payable 174,000
 
so I have 533,500-285,000 = 248,500 But somehow it is not correct. Please help me! What did I do wrong?
 hhuynhly
Dec 10, 2010, 06:28 AM
Prepaid rent is for 2 years, so to count it as a current asset you have to divide it by 2.  Do the same thing for Unearned Revenue and take out the Current maturity of long term liability 71,000.
 
I hope this helps!