Name(s) ASSETS S Liquid Assets Cash on hand In checking Savings accounts Money market funds and deposits Certificates of deposit ( 1 yr. to maturity) Mutual funds Real estate Retirement funds, IRA Other Total Investments Real Property Personal Property S S BALANCE SHEET Date February 7, 2013 LIABILITIES Current Liabilities Utilities S Rent Insurance premiums Taxes Medical/dental bills Repair bills 0 Bank credit card balances Dept. store credit card balances Travel and entertainment card balances Gas and other credit card balances Bank line of credit balances Other current liabilities Total Current Liabilities Long-Term Liabilities Primary residence 0 mortgage Second home mortgage Real estate investment mortgage Auto loans 0Appliance/furniture loans Home improvement loans Single-payment loans Primary residence Second home Other Total Real Property Auto(s): Auto(s): Recreational vehicles Household furnishing Jewelry and artwork Other Other Total Personal Property (I)Total Assets 0 0 Education loans Margin loans Other long-term loans Total Long-Term Liabilities (II) Total Liabilities Net Worth (I) (II)] Total Liabilities and Net Worth Editing highlighted in yellow, make sure you click on that. DON'T FOR GET TO SAVE. 3. You do not have to do any math, just enter the data correctly in the right place on the sheets and the results will be calculated for you. Answers must be correct. SALARIES TAKE-HOME PAY GROSS SALARY Terry Evelyn Item $52,500 29,200 $76,000 42,000 Amount $ 5,902 2,300 1. Food 2. Clothing 3. Mortgage payments of $1,400 & property taxes are included in this figure 11,028 4. Travel and entertainment card balances 2.000 5. Gas, electric, water expenses 1.990 6. Household furnishings 4.500 7. Telephone 640 8. Auto loan balance 4,650 9. Common stock investments 7.500 10. Bank credit card balance 675 11. Federal income taxes 22.472 12. State income tax 5,040 13. Social security contributions 9.027 14. Credit card loan payments 2.210 15. Cash on hand 85 16. 2012 Nissan Sentra 10,500 17. Medical expenses (unreimbursed) 18. Homeowner's insurance premiums paid 19. Checking account balance 600 1.300 485 20. Auto insurance premiums paid 1.600 21. Transportation 2.800 22. Cable television 680 23. Estimated value of home 185,000 24. Trip to Europe 5,000 25. Recreation and entertainment 4.000 26. Auto loan payments 2.150 27. Money market account balance 2.500 28. Purchase of common stock 7.500 29. Addition to money market account 500 30. Mortgage on home 148.000