In: Finance
7 Balance sheet preparation Adam and Arin Adams have collected their personal asset and liability information and have asked you to put together a balance sheet as of December 31, 2015. The following information is received from the Adams family.
| Cash | $ 300 | Retirement funds, IRA | $ 2,000 | 
| Checking | 3,000 | 2014 Sebring | 15,000 | 
| Savings | 1,200 | 2010 Jeep | 8,000 | 
| IBM stock | 2,000 | Money market funds | 1,200 | 
| Auto loan | 8,000 | Jewelry and artwork | 3,000 | 
| Mortgage | 100,000 | Net worth | 76,500 | 
| Medical bills payable | 250 | Household furnishings | 4,200 | 
| Utility bills payable | 150 | Credit card balance | 2,000 | 
| Real estate | 150,000 | Personal loan | 3,000 | 
Create a personal balance sheet as of December 31, 2015. It should be similar to a corporate balance sheet.
What must the total assets of the Adams family be equal to by December 31, 2015?
What was their net working capital (NWC) for the year? (Hint: NWC is the difference between total liquid assets and total current liabilities.
| Balance sheet is one of the financial statement in which the financial position of assets and liabilities are reflected as on particular date. | |||||||
| a. | |||||||
| Adam and Arin Adams | |||||||
| Balance Sheet | |||||||
| As on 31st December 2015 | |||||||
| Assets | Liabilities and net worth | ||||||
| Liquid assets | Current liabilities | ||||||
| Cash | $300 | Utility Bills | $150 | ||||
| Checking | $3,000 | Medical Bills | $250 | ||||
| Savings | $1,200 | Credit card balance | $2,000 | ||||
| Money market funds | $1,200 | Total current liabilities | $2,400 | ||||
| Total liquid assets | $5,700 | ||||||
| Long term liabilities | |||||||
| Investments | Mortgage | $100,000 | |||||
| IBM Stock | $2,000 | Auto Loan | $8,000 | ||||
| Retirement funds, IRA | $2,000 | Personal Loan | $3,000 | ||||
| Total investments | $4,000 | Total long term liabilities | $111,000 | ||||
| Real estate | $150,000 | Total liabilities | |||||
| Personal property | |||||||
| 2015 Sebring | $15,000 | Total net worth | $76,500 | ||||
| 2010 Jeep | $8,000 | ||||||
| Household furnishings | $4,200 | ||||||
| Jewelry and artwork | $3,000 | ||||||
| Total personal property | $30,200 | ||||||
| Total assets | $189,900 | Total liabilities and net worth | $189,900 | ||||
| b. | |||||||
| The total assets is equal to the total liabilities plus the net worth of the family. | |||||||
| As on 31st December 2015, the total assets is equal to $189,900 | |||||||
| c. | |||||||
| Net working capital = Total liquid assets -Total current liabilities | |||||||
| Net working capital | 5700-2400 | ||||||
| Net working capital | $3,300 | ||||||