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 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 i 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. Downs Percent 1,200 4,200 2,700 3,300 700 650 $ 12.750 0.3% 1.1% 0.7% 0.8% 0.2% 0.2% 3.2% 192,000 9.000 9,500 $210,500 48.6% 2.3% 2.4% 53.3% ASSETS Monetary Assets Cash on hand Savings account Victor's checking account Maria's checking account Tax refund due Rent receivable Total Monetary Assets Tangible Assets Home Personal property Automobiles 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 bir Credit card debt Total Short-term Liabilities Long-Term liabilities Vehicle loan Home mortgage loan Total long-term liabilities Total Liabilities Net Worth Total abilities and Net Worth 5,000 5,000 2,800 4,000 5,600 34,100 115,000 $171,500 $394 750 1.3% 1.3% 0.7% 1.0% 1.496 8.6% 29.1% 43.4% 100.0% 220 0.1% 1.500 1.720 $ 9.200 92,000 $100,200 3101.920 5292,830 $394,750 2.190 23.39 25.490 25.890 74.26 100.00 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,700. 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 $85,933. Round your answers to three decimal places. the Hernandezs net worth. Selling the New York bond would not affect The liquidity ratio would increase from to
