Financial planning case 3-2 Victor and Maria Hernandez Victor and Maria, both in their late 30s, have two children: John, age 13 and Joseph, age 15. Victor has had a long sales career with a retail appliance store. Maria works part-time as a medical records assistant. The Hernandezs own two vehicles and their home, on which they have a mortgage. They will face many financial challenges over the next 20 years, as their children drive, go to college, and leave home and go out in the world on their own. Victor and Maria also recognize the need to further prepare for their retirement and the challenges of aging.. Victor and Maria spent some time making up their first balance sheet, which is shown in the table. Balance Sheet for a Couple with Two Children-Victor and Maria Hernandez, January 1, 2018 Dollars Percent ASSETS Monetary Assets Cash on hand 1,200 0.3% Savings account 4,200 1.1% Victor's checking account 2,700 0.7% Maria's checking account 3,300 0.8% Tax refund due 700 0.2% Rent receivable 650 0.2% Total Monetary Assets $12,750 3.2% Tangible Assets Iton Total Tangible Assets. Investment Assets Fidelity mutual funds Scudder mutual fund Ford Motor Company stock New York 2038 bonds Life insurance cash value. IRA accounts Real estate investment Total Investment Assets. Total Assets LIABILITIES Short-Term liabilities Dentist bill Credit card debt Total Short-term Liabilities i Long-Term liabilities Vehicle loan. Home mortgage loan Total long-term liabilities Total Liabilities Net Worth $210,500 4,500 5,500 3,000 4,000 5,300 34,300 113,000 $169,600 $392,850 220 1,700 1,920 8,400 91,900 $100,300 $102,220 $290,630 $ 53.6% 1.1% 1.4% 0.8% 1.0% 1.3% 8.7% 28.8% 43.2% 100.0% 0.1% 0.4% 0.5% 2.1% 23.4% 25.5% 26.0% 74.0% Total Liabilities $102,220 26.0% Net Worth $290,630 74.0% Total Liabilities and Net Worth $392,850 100.0% Victor and Maria are a bit confused about how various financial activities can affect their net worth. a. Assume that their home is now appraised at $200,000 and the value of their automobile has dropped to $8,400. Calcul the effects of these changes on their net worth. Round your answer to the nearest dollar. Net worth would increase by $ 6800 because the value of the real estate rose more than the declined. Calculate the effects of these changes on their asset-to-debt ratio. Round your answers to three decimal places. Old asset-to-debt ratio: 3.94 New asset-to-debt ratio: 4.01 b. If Victor and Maria take out a bank loan for $1,700 and pay off their credit card debts totaling $1,700, what effects wou on their net worth? Taking out a bank loan to pay off the credit card liability would not affect the Hernandezs' net worth. c. If Victor and Maria sell their New York 2038 bond and put the cash into the savings account, what effects would this hav and liquidity ratio? Assume their annual expenses are $80,979. Round your answers to three decimal places. Selling the New York bond would not affect the Hernandezs' net worth. The liquidity ratio would decrease from to Financial planning case 3-2 Victor and Maria Hernandez Victor and Maria, both in their late 30s, have two children: John, age 13 and Joseph, age 15. Victor has had a long sales career with a retail appliance store. Maria works part-time as a medical records assistant. The Hernandezs own two vehicles and their home, on which they have a mortgage. They will face many financial challenges over the next 20 years, as their children drive, go to college, and leave home and go out in the world on their own. Victor and Maria also recognize the need to further prepare for their retirement and the challenges of aging.. Victor and Maria spent some time making up their first balance sheet, which is shown in the table. Balance Sheet for a Couple with Two Children-Victor and Maria Hernandez, January 1, 2018 Dollars Percent ASSETS Monetary Assets Cash on hand 1,200 0.3% Savings account 4,200 1.1% Victor's checking account 2,700 0.7% Maria's checking account 3,300 0.8% Tax refund due 700 0.2% Rent receivable 650 0.2% Total Monetary Assets $12,750 3.2% Tangible Assets Iton Total Tangible Assets. Investment Assets Fidelity mutual funds Scudder mutual fund Ford Motor Company stock New York 2038 bonds Life insurance cash value. IRA accounts Real estate investment Total Investment Assets. Total Assets LIABILITIES Short-Term liabilities Dentist bill Credit card debt Total Short-term Liabilities i Long-Term liabilities Vehicle loan. Home mortgage loan Total long-term liabilities Total Liabilities Net Worth $210,500 4,500 5,500 3,000 4,000 5,300 34,300 113,000 $169,600 $392,850 220 1,700 1,920 8,400 91,900 $100,300 $102,220 $290,630 $ 53.6% 1.1% 1.4% 0.8% 1.0% 1.3% 8.7% 28.8% 43.2% 100.0% 0.1% 0.4% 0.5% 2.1% 23.4% 25.5% 26.0% 74.0% Total Liabilities $102,220 26.0% Net Worth $290,630 74.0% Total Liabilities and Net Worth $392,850 100.0% Victor and Maria are a bit confused about how various financial activities can affect their net worth. a. Assume that their home is now appraised at $200,000 and the value of their automobile has dropped to $8,400. Calcul the effects of these changes on their net worth. Round your answer to the nearest dollar. Net worth would increase by $ 6800 because the value of the real estate rose more than the declined. Calculate the effects of these changes on their asset-to-debt ratio. Round your answers to three decimal places. Old asset-to-debt ratio: 3.94 New asset-to-debt ratio: 4.01 b. If Victor and Maria take out a bank loan for $1,700 and pay off their credit card debts totaling $1,700, what effects wou on their net worth? Taking out a bank loan to pay off the credit card liability would not affect the Hernandezs' net worth. c. If Victor and Maria sell their New York 2038 bond and put the cash into the savings account, what effects would this hav and liquidity ratio? Assume their annual expenses are $80,979. Round your answers to three decimal places. Selling the New York bond would not affect the Hernandezs' net worth. The liquidity ratio would decrease from to