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. 0.3 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 Savings account 4,200 Victor's checking account 2,700 Maria's checking account 3,300 Tax refund due 700 Rent receivable 650 Total Monetary Assets $ 12,750 Tangible Assets Home 192,000 Personal property 9,000 Automobiles 9,500 3.3 $210,500 53.7 5,000 4,500 1.1 2,500 0.6 4,000 5,300 34,500 113,000 $168,800 $392,050 o 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 Long-Term liabilities Vehicle loan Home mortgage loan Total long-term liabilities Total Liabilities Net Worth Total Liabilities and Net Worth 220 1,500 $ 1,720 7,400 92,100 $ 99,500 $101,220 $290,830 $392,050 25.8 74.2 100.0 BU $392,050 Total Liabilities and Net Worth 1000 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,300. Calculate and characterize the effects of these changes on their net worth. Round your answer to the nearest dollar. Net worth would increase by $ because the value of the real estate rose more than the value of the car 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: New asset-to-debt ratio: b. If Victor and Maria take out a bank loan for $1,500 and pay off their credit card debts totaling $1,500, what effects would these changes have 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 have on their net worth and liquidity ratio? Assume their annual expenses are $81459. Round your answers to three decimal places Selling the New York bond would not affect The liquidity ratio would screase from the Hernandezs' net worth 310 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. 0.3 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 Savings account 4,200 Victor's checking account 2,700 Maria's checking account 3,300 Tax refund due 700 Rent receivable 650 Total Monetary Assets $ 12,750 Tangible Assets Home 192,000 Personal property 9,000 Automobiles 9,500 3.3 $210,500 53.7 5,000 4,500 1.1 2,500 0.6 4,000 5,300 34,500 113,000 $168,800 $392,050 o 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 Long-Term liabilities Vehicle loan Home mortgage loan Total long-term liabilities Total Liabilities Net Worth Total Liabilities and Net Worth 220 1,500 $ 1,720 7,400 92,100 $ 99,500 $101,220 $290,830 $392,050 25.8 74.2 100.0 BU $392,050 Total Liabilities and Net Worth 1000 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,300. Calculate and characterize the effects of these changes on their net worth. Round your answer to the nearest dollar. Net worth would increase by $ because the value of the real estate rose more than the value of the car 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: New asset-to-debt ratio: b. If Victor and Maria take out a bank loan for $1,500 and pay off their credit card debts totaling $1,500, what effects would these changes have 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 have on their net worth and liquidity ratio? Assume their annual expenses are $81459. Round your answers to three decimal places Selling the New York bond would not affect The liquidity ratio would screase from the Hernandezs' net worth 310