Question

Auto loan Electric bill Telephone bill Total short-term liabilities Long-Term Liabilities Long-term portion of mortgage Total long-term liabilities (2) Total Liabilities Net Worth (1) - (2) Total Liabilities and Net Worth पी पी पी पी 100.0%
4. Personal balance sheet

Juan and Maria Gomez have been married for over 10 years. They both have good jobs with consistent incomes, and they are good savers. They believe that their financial picture is good, but they have never prepared a balance sheet. Juan and Maria pulled together the following items from bank statements, pay stubs, and bills.

Check the items that would appear on a balance sheet. Do not be concerned about whether the amounts are correct. Check all that apply.

IRA investments $ 6,875

AAA Bank mutual fund 5,775

Auto: 2010 Suburban (cost) 27,025

Auto: 2007 Honda Pilot (cost) 23,500

Auto loan balance (last payment) 938

Bonds 11,000

City Bank—checking 36,000

City Bank—savings 45,000

Cash 300

Juan’s salary 45,000

Balance due on American Express credit card 1,688

Unpaid electric bill $ 438

Life Insurance (cash value) 5,500

Balance due on Master Card 813

Balance due on Visa credit card 188

Primary home 350,000

Primary home mortgage 291,667

Unpaid property taxes 2,625

Maria’s diamond earrings 5,875

Stocks 13,750

Unpaid telephone bill 188

Amount paid last month for telephone 500

In addition, the Gomez’s provided the following information:

•	Based on comparable homes listed for sale in their neighborhood, the Gomez’s believe that their home value is about 8% more than what they paid for it.
•	The principal portion of their mortgage payments is approximately $972 per month.
•	A reliable jeweler said that Maria’s diamond earrings could be sold at the value provided.
•	After looking at Kelley Blue Book, they believe their cars can be sold for about 55% of original cost.

Use this information to fill in the missing amounts on Juan and Maria’s balance sheet. You can use what you checked above to make sure you accounted for everything.

Note: Some amounts are given to check your work. Round your percent to the one decimal place.

Answer 1

Percentage Balance sheet Particulars Amount Assets Monetary assets Cash on hand $ 300.00 Saving account $ 45,000.00 Checking account $ 36,000.00 Total monetary assets $ 81,300.00 0.06% 8.40% 6.72% 15.17% Tangible assets Home Automobiles Personal property Total Tangible assets $3,78,000.00 $ 27,789.00 $ 5,875.00 $4,11,664.00 70.54% =350000*108% 5.19% =(27025+23500) *55% 1.10% 76.82% Investment assets Mutual funds Stocks Bonds Life insurance cash value IRA'S Total investment assets 1.08% 2.57% 2.05% $ 5,775.00 $ 13,750.00 $ 11,000.00 $ 5,500.00 $ 6,875.00 $ 42,900.00 1.03% 1.28% 8.01% Total assets $5,35,864.00 100.00% Liabilities Short term labilities Current portion of mortgage Credit card debt Property taxes Auto loan Electric bill Telephone bill Total short term liabilities $ $ $ $ $ $ $ 11,664.00 2,689.00 2,625.00 938.00 438.00 188.00 18,542.00 2.18% =972*12 0.50% 0.49% 0.18% 0.08% 0.04% 3.46% Long term liabilities Long term portion of mortgage Total Long term liabilities $2,80,003.00 $ 2,80,003.00 52.25% =291667-(972*12) 52.25% Total Liabilities Net worth Total liabilities and net worth $ 2,98,545.00 $ 2,37,319.00 $5,35,864.00 55.71% 44.29% 100.00%