571 Case 16 The Maria and Sancho Ruiz Case COMPREHENSIVE FINANCIAL PLANNING CASE Maria and Sancho anticipate living until Sancho is ninety-five years Maria Ruiz recently turned age fifty. She heard about your firm from a neighbor who recommended your services as a comprehensive financial planner. The neighbor, who you helped with retirement and education funding questions, was particularly pleased with the manner in which you incorporated cognitive, emotional, behavioral, relational, and economic concepts into your recommendations. She told Maria that bo you do an excellent job of getting to the root of the quantitative aspects of financial details as well as delving into each client's emotional relationship with money and financial issues. on Based on this recommendation, Maria called your office for an appointment. Your receptionist indicated that you would be delighted to meet with her if both she and her husband (Sancho) would come in for a meeting. This caught Maria off guard because she was not sure if she could convince her husband to come to the meeting. However, you heard back from Maria a few weeks later. She had persuaded her husband to meet yeud with you. Prior to the meeting, you sent Maria and Sancho a data gathering form and asked them to bring important financial documentation to the first meeting. You met for the first time in your conference room. You and your paraplanner (Emily) were able to arbres determine the following from these data and the meeting: rigoroval er i. Maria has a relatively low level of risk tolerance Sancho is a real risk taker. to retire when Maria turns age sixty-five, Their shared primary goal tudoton Maria and Sancho need to earn the equivalent of $495,000 before taxes per year-today's dollars--at that time. . disiplov ito alta assuming the following: of age. Maria and Sancho except inflation to average 3.0 percent annually into the future, which is also the anticipated growth rate of savings and salaries. 572 Case Approach to Financial Planning Maria and Sancho have simple will leaving assets to the surviving spouse, Neither Maria nor Sancho have any other estate planning documents of trusts in place siu Additionally. Maria has several questions she would like answered . First, is she adequately protected in case Sancho were to pass away? This is a concern for Maria because she has split her time between being a stay-at-home mom and working in the family's rental real estate business and in Sancho's consulting firm for most of her adult life Second, she would like for you to investigate the family's financial situation because she cannot figure out why she and Sancho have been having a challenging time balancing their budget month-to-month. o Maria thinks that she and Sancho make a reasonably good income, but she is not able to see where all the money is going particularly the family's investment earnings. Third, she is interested in other advice and counsel that can be used to benefit her and the family's financial situation. Information about Sancho During the meeting, you learned a few things about Sancho. He is a very busy person He currently works for a high-tech firm. He is the senior vice president of cyber security As a senior executive with the firm, his position is very secure. In addition, Sancho runs a business consulting firm. His firm provides executive leadership consulting to Fortune 500 company clients. Sancho's consulting firm has been very successful even though it is run primarily as a small business. You did learn that Sancho runs the consulting practice as an LLC, but he has no full-time employees, although he does pay Maria a nominal wage so that she can fund her individual retirement account (TRA) and maintain a wage base for Social Security purposes." An interesting element of Sancho's business is that he needs to travel quite a bit. This is the reason he has established offices in Las Vegas, Nevada and St. Petersburg, Florida. He leases a car in each location so that one is available when he uses the office. Sancho chose these locations for two reasons: The first is that he and Maria already own a personal condominium in each city. Being familiar with each location made the decision easier. Second, Sancho thought having a base of operations on the east and west coasts would be an innovative idea in terms of client contact and entertaining Maria also liked the idea of establishing offices in each location because her family lives in Tampa and vacations in Las Vegas frequently. loving From Strategies to Plan Development 573 Given the dynamic real estate markets in Las Vega and St. Petersburg and economic estate, Maria took the role of property manager. She devotes between fifteen and twenty hours per week working in the business managing the day-to-day real estate operations. Maria is responsible for screening potential new tenants, scheduling Petersburg, he has also asserted that he allocates approximately 500 hours per year to investments in each city." Maria was involved in the purchase decisions but did not signs of price appreciation Sancho and Marin purchased condominiums as rental choose the initial for current) tenants. Once the properties were rented, Sancho and managers. In order to avoid passive activity rules associated with owning rental real repairs, paying expenses and homeowner's association bills, and ensuring that rent is collected on a timely basis. Given that Sancho frequently travels to Las Vegas and St the real estate business. Essentially, he is the one that checks on each property's state of repair and condition. As the initial meeting with Maria and Sancho ended, Sancho made the following comments: . o O He noted that he was not interested in working with you. There was nothing personal in the comment. He stated that he already has an attorney and accountant on retainer, and as such, he did not think it was necessary to get involved with another financial adviser at this time. However, he made it quite clear that he felt it would be useful for Maria to have her own financial planner, and that if she wanted to move forward working with you he would support the idea. He did note that Maria would need to fund the service fees charged od s by your firm. In an effort to jumpstart your professional relationship with Maria, Sancho agreed to provide as much information as needed to get a financial plan in place that will (1) show if Maria and Sancho are on track, as a couple, to reach their retirement goal, and if not, how they can achieve the goal; (2) address Maria's concerns about premature his death issues; and (3) provide Maria peace of mind related to the household's financial situation. Sancho noted that he would be pleased to receive any information about ways to increase the household's combined overall level of financial well- being. Forsi nancial Notes . Personal Background . Sancho is fifty-two years old. . Maria is fifty years old. 574 Case Approach to Financial Planning Manuel (son) is twenty-seven years old All family members are in good health. Business Notes Approximately two years ago, Sancho purchased a plane timeshare for 5417,500. Monthly expenses are $5,035, plus $1,275 per hour of use. The timeshare includes fifty hours of guaranteed airtime he must pay for the time used) As noted above, Maria works part-time for Sancho's consulting company, in addition to running the rental real estate LLC. Because the consulting practice is based on Sancho's expertise, he feels the company will have no value once he retires or dies. Asset Summary Principal Residence o Purchased for $875,000 (loan amount) with a thirty-year 4.5 percent mortgage o Last payment: 81 . St. Petersburg Condo Purchased for $385,000 (loan amount) with a twenty-year 5.8 percent mortgage o Last payment:24 Las Vegas Condo Purchased for $280,000 (loan amount) with a thirty-year 5.0 percent mortgage o Last payment: 60 Las Vegas Condo (rental). o Purchased for $380,000 (loan amount) with a twenty-year 6.0 percent mortgage Last payment: 36 . Florida Condo (rental). . Purchased for $495,000 (loan amount) with a twenty-year 6.9 percent mortgage Last payment: 36 2018 Lexus two years old; five-year loan with 0.0 percent loan. 2017 Land Rover one year old; five-year loan with 1.0 percent loan. 201X BMW three years old; five-year loan with 2.5 percent loan. Universal Life Insurance Policy (Owner/Insured: Sancho; Beneficiary: Maria) . . o $1 million face value issued seven years ago . Term Life Insurance Policy (Owner/Insured: Sancho; Beneficiary: Maria). o $1 million thirty-year face value policy issued five years ago Group Term Life Insurance Policy (Owner/Insured: Sancho; Beneficiary: Maria). o $3 million face value policy. Liability Summary . valot Credit Cards. blor to do o Visa: several cards with an average APR of 14.50 percent. MasterCard: several cards with an average APR of 13.90 percent. Discover: one card with an APR of 18.00 percent. Call | o Store Cards: several cards with an average APR of 23.90 percent. O Furniture Loan: APR 19.00 percent. Student Loan. Parent Plus and bank loans to pay for son's college expenses. . o Amount borrowed: $240,000. Average interest rate: 6.9 percent. o Original loan term: ten years. Last payment: 24th 576 Case Approach to Financial Planning . Home Equity Loan. Amount borrowed: $145,000. O APY: 7.35 percent. Last payment: 24" (original ten-year loan). Expense Summary and Notes Gifts and donations are primarily charitable in nature (e.g, church, civic organizations, museums, etc.). Unreimbursed medical expenses include occasional chiropractic care, elective surgery, and insurance deductibles. Information about Sancho's Consulting Business Sancho runs his consulting business as an LLC. He regularly transfers $100,000 from net earnings to his ABC brokerage account. The account is in Sancho's name only. All remaining net earnings from the business are transferred to the household budget. The following balance sheet represents Maria's best attempt to summarize the household asset and liability situation. Emily-your paraplanner--needs your advice on completing the form: q Chapter 14 -- Moving From Strategies to Plan Development 577 Figure XVI.1. Balance Sheet Assets Value Ownership $7,426,328.81 Monetary Assets $57,700.00 $6,700.00 - Checking Account Checking Account Savings Account $14,000.00 H $37,000.00 - Investment Assets $3,627,128.81 MNO Brokerage Account $350,000.00 401(k) Account $1,400,000.00 H IRA Account $169,000.00 W ABC Brokerage Account $905,628.81 H XYZ Brokerage Account $720,000.00 H Life Insurance Cash Value $82,500.00 H Assets Used in Sancho's Business 5486,000.00 Golf Club Membership $75,000.00 H Plane Timeshare $400,000.00 H Savings, Cash, & Checking Accounts $11,000.00 H Real Estate LLC Las Vegas Condo Florida Condo $295,000.00 $500,000.00 LLC LLC $795,000.00 $1,985,000.00 Housing Assets $1,300,000.00 Primary Residence J 578 Case Approach to Financial Planning St. Petersburg Condo $385,000.00 5300,000.00 Las Vegas Condo $164,500.00 Vehicle Assets 201X Lexus $45,000.00 ) - 201X Land Rover $60,000.00 201X BMW $43,000.00 H 201X Harley Davidson Motorcycle $16,500.00 SI Personal Property & Use Assets $811,000.00 Artwork $79,000.00 J Jewelry $135,000.00 W Coins and Stamps $19,000.00 H Furniture and Household Goods $200,000.00 J Jet Skis $30,000.00 37 Foot Sailboat 583,000.00 H Golf Equipment $15,000.00 H Other $250,000.00 LIABILITIES DEBT OWNERSHIP Personal Liabilities $3,256,517.14 $120,000.00 Current Bills S. Short-Term Debt $ Credit Cards Visa $40,000.00 Chapter 14 - Moving From Strategies to Plan Development 579 MasterCard $30,000.00 Discover $20,000.00 H Store Cards $30,000.00 Mortgages 222 Primary Residence ??? St. Petersburg Condo ??? - Las Vegas Condo ??? HEW Home Equity Loan ??? Vehicle Debt $124,549.00 201X Lexus $35,540.00 201X Land Rover $65,899.00 2017 BMW $23, 110.00 201X Harley Davidson Motorcycle H Other Liabilities $273,000.00 Furniture Loan $60,000.00 College Loans $213,000.00 Bank Loan S. Liabilities Assoc. with Sancho's Business 272 Leases Las Vegas Offices $192,000.00 Florida Offices $ 190,800.00 Las Vegas Car (Mercedes) $21,600.00 580 Case Approach to Financial Planning $19,800.00 Florida Car (Acura) Real Estate LLC Las Vegas Condo (mortgage) Florida Condo (mortgage) 172 LLC 272 LLC $??? ASSETS S??? LIABILITIES $722 NET WORTH Sancho is the primary household earner. The following is a summary of his W-2 income from his cyber security position. Please note that Sancho was unable to obtain an exact figure for other compensation. He hopes that you can calculate that. Figure XVI.2. Sancho's Non-Business Income Situation $871,416 Wages Other Taxable Compensation $ ??? Taxable income $ ??? Federal Income Tax Withheld $ 193,503 Social Security Wages $ 128,400 Social Security Tax Withheld $ 7,961 Medicare Wage and Tips $ 894,308 Medicare Tax Withheld $ 19,216 Qualified Plan Contributions $ 8,034 Medical Insurance Contributions $ 7,800 Disability Insurance Contributions $ 2,750 State and Local Taxes Withheld $ 42,150 *Pre-tax contributions/payments ter 14 Moving from Strategies to Plan Development 581 The following income and expense statements represent the cash flow situation for the real estate LLC and Sancho's consulting business Figure XVI.3. Real Estate LLC Income Las Vegas Rental Income $24,000 Florida Rental Income $19,200 Expenses Las Vegas Mortgage Insurance Tax Condo Fees $32,669 $450 $6,300 $6,000 Florida Mortgage Insurance Tax Condo Fees $45,697 $700 $6,700 $3,600 Figure XVI.4. Sancho's Consulting Business Income Business Income and Expenses Yearly Income Dollars Business Income $ 702,000 $0 bris Other Income Total Income $ 702,000 Expenses & Payments Travel $ 24,000 Meals with Clients $ 19,100 Professional Services Dar $ 28,000 Office Expenses $ 15,000 $ 10,765 Employee Expenses 582 Case Approach to Financial Planning $ 48,000 Las Vegas Office Lease $ 63,600 Florida Office Lease $ 7,200 Las Vegas Car Lease $ 6,600 Florida Car Lease Insurance Expenses $ 4,350 Plane Timeshare $ 124,170 Misc. Tax-Deductible Business Expenses $ 33,000 Total Expenses $ 374,235 Income S 327,765 FICA $ 13,413 $ 12,732 $ 108,000 $ 193,638 Employer Element of FICA Federal Tax Withholdings Income After Expenses State Income Tax Withholdings Earnings Contributed to Business Brokerage Account Transfer to Household Account Note: Expenses are paid using American Express $ 25,000 S00,000 $ 68,638 The following represents the Ruizs' cash flow position. Please note that Maria and Sancho were unable to complete the form. Figure XVI.5 Household Cash Flow Statement CASH FLOW WORKSHEET Yearly Income Current Year H Income $871,416 W Income $ 10,765 H Business Income $??? ving From Strategies to Plan Development 583 H Business Interest & Dividends H Interest & Dividends W Interest & Dividends $??? See portfolio data $??? See portfolio data S??? See portfolio data Group Benefit Income S??? $??? $??? Total Income Expenses & Payments Principal Residence P&I St. Petersburg Condo P&I Las Vegas Condo P&l Home Equity Loan $ 32,568 $ 18,037 S ??? 201X Lexus $ 12,730 201X Land Rover $ 17,101 201X BMW $ 14,630 Mortgages and Vehicle Total $??? Universal Life Premiums $ 22,000 Term Life Premiums $ 3,500 Homeowner's Insurance $ 1,300 Principal Residence St. Petersburg Condo $ 600 $750 Las Vegas Condo 55,500 Automobile Insurance $??? Group Benefit Insurance $0 Other Misc. Ins. Premiums $ 42,942 Insurance Total $ 301,503 Federal Income Taxes Paid $ 67,150 State Income Taxes Paid $ 54,127 FICA Paid $??? Payroll Tax Total Homeowner's Tax $ 8,000 $ 4,100 Principal Residence St. Petersburg Condo Las Vegas Condo $7,000 $2,300 Personal Property Taxes Quarterly Federal Tax Withholdings SO Tax Total $ 34,400 Brokerage Account (1) $ 3,493 401(k) Account (H) $ 8,034 IRA Account (W) $6,500 Brokerage Account (H) $ 36,000 Regular/Allocated Savings $0 Reinvested Interest & Dividends $ 47,998 Reinvested Interest & Dividends $ 26,036 Other Tax Advantaged Retirement Savings $0 Savings Total $ 128,062 Utilities $ 7,200.00 Telephone $3,600.00 Utility Total $ 10,800 Condo Fees $ 9,000 Home Maintenance & Repair $4,800 Strategies to Plan Development 585 Home Expense Total Food at Home $ 23400 Food Eating Out $ 10,500 Clothing $ 19.000 Automobile Repairs $ 20.000 Daily Living Expense Total $3,200 Entertainment & Vacation $ 53,000 Gifts & Donations $ 48,000 Personal Liabilities $ 95,000 Short-Term Debt SO Student Loan Debt $ 34,013 abril Credit Cards Visa $ 6,000 MasterCard DO $ 6,000 Discover $ 6,000 Store Cards $6,000 bb Ongoing Expenses $ 201,013 roll $6,000 Unreimbursed Medical Expenses Miscellaneous Expenses $ 7,200 $ 13,200 Miscellaneous Expense Total Discretionary Cash Flow $??? Total Income $??? Total Fixed Expenses S??? Total Variable Expenses $??? Discretionary Cash Flow Figure XVI.6. Portfolio Data Account 5 Account 2 Account 3 Account 4 Account Account MNO Sancho 401K Maria IRA ABC Brokerage XYZ Brokerage Name Brokerage H w H H Title Joint $1,400,000 $169,000 $905,629 $720,000 $350,000 Value 15 22 10 26 15 Years Invested Annual Contribution $8,034 $6,500 $100,000 $3,493 S 36,000 Allocation Stocks 20% 50% 75% 80% 25% 15% 30% Municipal Bonds 0% 50% 60% 5% 25% 10% T-Bills 0% 20% 5% 20% Hard Assets 0% 0% 10% Taxable Yield/ Return 0.260% na. 1.040% 0.5200 Qualified Dividend Yld 1.065% 0.000% 3.550% 4.260% 2.130% Notes: Joint joint ownership; H owned by husband (Sancho); W - owned by wife (Maria) . Historical Portfolio Rate of Return Assumptions (past and forward looking) Stocks: 10.32 percent (Standard Deviation: 19.70 percent). Municipal Bonds: 7.10 percent (Standard Deviation: 9.75 percent). T-Bills: 5.20 percent (Standard Deviation: 5.00 percent). Hard Assets and Real Estate: 7.78 percent (Standard Deviation: 21.00 per- cent). . Chapter 14 -- Moving from Strategies to Plan Development 587 . Thirty-Year Mortgage APR: 6.00 percent. Twenty-Year Mortgage APR: 5.00 percent Fifteen-Year Mortgage APR: 4.80 percent Home Equity APR: 6.25 percent (Based on ten-Year Loan). Financial Planning Assumptions The following assumptions and data should be used in addition to the information already provided in the case narrative: Taxes . Emily, your paraplanner, estimates Social Security and Medicare taxes to be approximately 547,310; however, this number is based on the case assumptions and the case marginal tax rates. She recommends that you confirm this figure using your own calculation. All dividends and capital gains are reinvested. Maria and Sancho are in the 35.0 percent federal marginal tax bracket. Maria and Sancho pay a 6.0 percent state marginal tax o The state deduction amount is $8,000 . 0 The state exemption amount is $2,500 per person. Woow orb The family is not eligible for a state tax credit. Retirement Sancho's monthly Social Security retirement benefit (PIA) in today's dol- lars: $3,400 (Maria is eligible to receive 50 percent of Sancho's benefit). Sancho and Maria hope to replace the equivalent of $495,000 before taxes per year in today's dollars in retirement, which is a replacement ratio of ed approximately 56.1 percent of earned household income For insurance planning purposes, assume that the Ruiz family is in the 35.0 percent federal marginal tax bracket and the 6.0 percent state tax bracket pre- and post-retirement. Maria and Sancho plan to retire when Sancho turns age sixty-seven (his full normal Social Security retirement age). Sancho would like to invest aggressively prior to retirement. Maria would prefer to take less risk. Sancho and Maria are willing to compromise by assuming a simple return calculated as: (Sancho's 401k RoR+Maria's IRA RoR)/2 588 Case Approach to Financial Planning . Sancho and Maria plan to invest in a diversified portfolio of stocks, mu. nicipal bonds, T-B.is, and hard assets/real estate during retirement. For initial planning purposes, assume an equal weighting in each of these as set classes to determine the expected RoR. Retirement savings contributions (pre-or post-tax) are assumed to grow at the rate of salary inflation (3.0 percent). Sancho and Maria are willing to allocate $500,000 from Sancho's personal investment account for retirement if needed. Maria and Sancho plan to sell the rental properties at retirement to help offset retirement needs. Sancho stated that he believes these assets will increase in value, on average, by a 7.60 percent rate of return until retire- . . ment. Insurance In the case of death: Expenses at death: o Final expenses: $40,000 each. Estate administration: $12,000 each. Miscellaneous final needs: $20,000 each. Transitional funding need: $10,000 each. For life insurance planning purposes only, Maria and Sancho would like to ensure that the surviving spouse will receive $625,000 in income per year until retirement Sancho and Maria hope to replace the equivalent of $495,000 before taxes per year in today's dollars in retirement. . . Maria will earn $10,765 per year until retirement; Sancho is expected to eam $871,416 until retirement." Maria and Sancho feel a 80 percent capital retention replacement ratio is appropriate when planning for life insurance needs. For insurance planning purposes, assume that the Ruiz family is in the 35.0 percent federal marginal tax bracket and the 6.0 percent state tax bracket pre and post-retirement Sancho and Maria plan to invest any life insurance proceeds and other assets in the case of death in a diversified portfolio of stocks, municipal bonds, T-Bills, and hard assets/real estate. For initial planning purposes, assume an equal weighting in each of these asset classes to determine the expected RoR. . Maria and Sancho are agreed that they would like to pay off all short- term, mortgage, vehicle, business, and other debts at the death of the first percent marginal tax bracket and the 6.0 percent state tax bracket. Moving From Strategies to Plan Development 589 Inflation pre- and post-retirement is assumed to be 3.0 percent. . spouse. Maria's Social Security retirement benefit, should Sancho die, is $20,400 per year in today's dollars; she will receive the benefit starting at age sixty. No survivor Social Security benefit is expected if Maria dies first. Sancho's monthly Social Security retirement benefit in today's dollars: $3,400 (Maria is eligible to receive 50 percent of Sancho's benefit). Maria and Sancho are willing to sell the rental properties and second olentoonste homes at the death of the first spouse to offset life insurance needs. Other assets to be used in the event of death: All brokerage accounts and retirement plan assets. In the case of disability: Sancho has a long-term disability policy with a $60,000 annual benefit The plan is employer provided at no cost to Sancho Benefits last until age sixty-seven. . . logo o The plan has a 180-day elimination period. Maria has no disability coverage. Maria and Sancho would like to replace 60 percent of household current income, Ident The couple is willing to self-insure the risk that Maria may become disabled. Assume a life expectancy of life expectancy of age ninety-five for Sancho and age ninety-three for Maria. Sancho has earmarked $974,000 of investment and monetary assets to cover short-term and elimination period disability needs. Maria and Sancho are willing to allocate $1,255,628 to help fund other . disability needs For insurance planning purposes, assume the Ruiz family is in the 35.0 590 Case Approach to Financial Planning Sancho and Maria plan to reallocate investment assets, in the event of disability, into a diversified portfolio of stocks, municipal bonds, T-Bills, and hard assets/real estate. For initial planning purposes, assume an equal weighting in each of these asset classes to determine the expected RoR Maria and Sancho will use earnings from the MNO and XYZ brokerage accounts to help offset yearly long-term disability income needs. Neither Maria nor Sancho expect Social Security benefits if either becomes disabled . In the case of a long-term care need: Maria and Sancho are comfortable using all brokerage account assets to fund any LTC needs. Assume an LTC inflation rate of 4.0 percent. . Assume $12,000 annual prescription costs per person if long-term care services are needed (in addition to long-term care costs). The average long-term care cost in their area is $85,000 per year. Assume age seventy-five for LTC needs for Maria and age seventy-seven for Sancho. . . Maria and Sancho are comfortable assuming a four-year long-term care need Sancho and Maria plan to reallocate investment assets, in the event of a LTC need, into a diversified portfolio of stocks, municipal bonds, T-Bills, and hard assets/real estate. For initial planning purposes, assume an equal weighting in each of these asset classes to determine the expected ROR. Property Insurance The couple's principal residence is currently insured based on a replace ment value of $1 million. allado The St. Petersburg condominium is insured for a replacement value of $347,000. The Las Vegas condominium is insured for a replacement value of $285,000 . The Las Vegas rental is insured for a replacement value of $295,000. The Florida rental is insured for a replacement value of $500,000 . . orld Use these data and assumptions to craft a comprehensive financial plan for your clince, investment, retirement, estate, and special needs' analyses. Be sure to address Maria's questions through cash flowet worth, tax, insurance, Discussion Points and Questions Chapter 14 - Moving From Strategies to Plan Development 591 Each vehicle is covered by a 100/300/100 split-limit coverage policy. A $1 million excess liability policy is in place the premium is $150 per account value based on contributions, time invested, and rate of return assumptions. 1 6. Estimate the Ruizs' current net worth situation. a. b. Briefly summarize the relevant facts of the case. 2. Estimate the amount of income earned from non-business source. Be sure to account for federal state, and FICA taxes withheld at the household level 3. Estimate the net taxable income from Sancho's consulting business. Be sure to account for FICA taxes, federal tax withholdings, and state tax withholdings. Also determine how much of the net income from the business flows to Sancho's brokerage account versus the household budget. Estimate net income from the rental real estate LLC. 5. Estimate the Ruizs' current discretionary cash flow position. a. Identify strengths and weakness associated with their cash flow situation. dalbe. Use financial ratios to evaluate areas for improvement. utero si enel secolo in Draft a list of potential recommendations that can be used to improve or enhance the situation Identify strengths and weakness associated with their net worth situationen b. Use financial ratios to evaluate areas for improvement Draft a list of potential recommendations that can be used to improve or enhance the situation. 7. Determine the weighted average rate of return for each portfolio, based on the current asset allocation. Estimate the amount of qualified dividends from the MNO, ABC, and XYZ portfolios Estimate the amount of interest earned from the MNO, ABC, and XYZ portfolios 592 Case Approach to Financial Planning & Develop an estimate of this year's tax situation for the Ruiz family? Can Maria and Sancho expect a federal income tax refund? Identify strengths and weakness associated with their federal tax situation b. Draft a list of potential recommendations that can be used to improve or enhance the situation 9. Do Maria and Sancho need long-term insurance coverage at this time? If yes, how much? 10. Does Sancho need additional short-term disability coverage? Does Sancho need additional long. term disability coverage? If the answer is yes to either question, how much? Provide an estimate of the cost of coverage? 11. Do Maria and Sancho need additional life insurance coverage? Answer the question based on: 1. A full needs analysis. II. The human life value approach. III. The capital retention approach. IV. The income retention approach How much additional life insurance, if any, does Maria need? b. How much additional life insurance, if any, does Sancho need? c. If either has a need, what type of insurance policy would be most appropriate? How much might such a policy cost? a d. Draft a list of other potential recommendations that can be used to improve or enhance the situation 12. Are Maria and Sancho on track to meet their retirement goal(s) based on the current case assumptions? a. Identify strengths and weakness associated with their retirement situation. b. Draft a list of potential recommendations that can be used to improve or enhance the situation. 13. Do Maria and Sancho need to worry about paying federal estate taxes should either die prematurely this year? a. Identify strengths and weakness associated with their estate planning situation. b. Draft a list of potential recommendations that can be used to improve or enhance the situation 14. Identify other issues Maria should be aware of as she evaluates the information provided in the context of a comprehensive financial plan. 571 Case 16 The Maria and Sancho Ruiz Case COMPREHENSIVE FINANCIAL PLANNING CASE Maria and Sancho anticipate living until Sancho is ninety-five years Maria Ruiz recently turned age fifty. She heard about your firm from a neighbor who recommended your services as a comprehensive financial planner. The neighbor, who you helped with retirement and education funding questions, was particularly pleased with the manner in which you incorporated cognitive, emotional, behavioral, relational, and economic concepts into your recommendations. She told Maria that bo you do an excellent job of getting to the root of the quantitative aspects of financial details as well as delving into each client's emotional relationship with money and financial issues. on Based on this recommendation, Maria called your office for an appointment. Your receptionist indicated that you would be delighted to meet with her if both she and her husband (Sancho) would come in for a meeting. This caught Maria off guard because she was not sure if she could convince her husband to come to the meeting. However, you heard back from Maria a few weeks later. She had persuaded her husband to meet yeud with you. Prior to the meeting, you sent Maria and Sancho a data gathering form and asked them to bring important financial documentation to the first meeting. You met for the first time in your conference room. You and your paraplanner (Emily) were able to arbres determine the following from these data and the meeting: rigoroval er i. Maria has a relatively low level of risk tolerance Sancho is a real risk taker. to retire when Maria turns age sixty-five, Their shared primary goal tudoton Maria and Sancho need to earn the equivalent of $495,000 before taxes per year-today's dollars--at that time. . disiplov ito alta assuming the following: of age. Maria and Sancho except inflation to average 3.0 percent annually into the future, which is also the anticipated growth rate of savings and salaries. 572 Case Approach to Financial Planning Maria and Sancho have simple will leaving assets to the surviving spouse, Neither Maria nor Sancho have any other estate planning documents of trusts in place siu Additionally. Maria has several questions she would like answered . First, is she adequately protected in case Sancho were to pass away? This is a concern for Maria because she has split her time between being a stay-at-home mom and working in the family's rental real estate business and in Sancho's consulting firm for most of her adult life Second, she would like for you to investigate the family's financial situation because she cannot figure out why she and Sancho have been having a challenging time balancing their budget month-to-month. o Maria thinks that she and Sancho make a reasonably good income, but she is not able to see where all the money is going particularly the family's investment earnings. Third, she is interested in other advice and counsel that can be used to benefit her and the family's financial situation. Information about Sancho During the meeting, you learned a few things about Sancho. He is a very busy person He currently works for a high-tech firm. He is the senior vice president of cyber security As a senior executive with the firm, his position is very secure. In addition, Sancho runs a business consulting firm. His firm provides executive leadership consulting to Fortune 500 company clients. Sancho's consulting firm has been very successful even though it is run primarily as a small business. You did learn that Sancho runs the consulting practice as an LLC, but he has no full-time employees, although he does pay Maria a nominal wage so that she can fund her individual retirement account (TRA) and maintain a wage base for Social Security purposes." An interesting element of Sancho's business is that he needs to travel quite a bit. This is the reason he has established offices in Las Vegas, Nevada and St. Petersburg, Florida. He leases a car in each location so that one is available when he uses the office. Sancho chose these locations for two reasons: The first is that he and Maria already own a personal condominium in each city. Being familiar with each location made the decision easier. Second, Sancho thought having a base of operations on the east and west coasts would be an innovative idea in terms of client contact and entertaining Maria also liked the idea of establishing offices in each location because her family lives in Tampa and vacations in Las Vegas frequently. loving From Strategies to Plan Development 573 Given the dynamic real estate markets in Las Vega and St. Petersburg and economic estate, Maria took the role of property manager. She devotes between fifteen and twenty hours per week working in the business managing the day-to-day real estate operations. Maria is responsible for screening potential new tenants, scheduling Petersburg, he has also asserted that he allocates approximately 500 hours per year to investments in each city." Maria was involved in the purchase decisions but did not signs of price appreciation Sancho and Marin purchased condominiums as rental choose the initial for current) tenants. Once the properties were rented, Sancho and managers. In order to avoid passive activity rules associated with owning rental real repairs, paying expenses and homeowner's association bills, and ensuring that rent is collected on a timely basis. Given that Sancho frequently travels to Las Vegas and St the real estate business. Essentially, he is the one that checks on each property's state of repair and condition. As the initial meeting with Maria and Sancho ended, Sancho made the following comments: . o O He noted that he was not interested in working with you. There was nothing personal in the comment. He stated that he already has an attorney and accountant on retainer, and as such, he did not think it was necessary to get involved with another financial adviser at this time. However, he made it quite clear that he felt it would be useful for Maria to have her own financial planner, and that if she wanted to move forward working with you he would support the idea. He did note that Maria would need to fund the service fees charged od s by your firm. In an effort to jumpstart your professional relationship with Maria, Sancho agreed to provide as much information as needed to get a financial plan in place that will (1) show if Maria and Sancho are on track, as a couple, to reach their retirement goal, and if not, how they can achieve the goal; (2) address Maria's concerns about premature his death issues; and (3) provide Maria peace of mind related to the household's financial situation. Sancho noted that he would be pleased to receive any information about ways to increase the household's combined overall level of financial well- being. Forsi nancial Notes . Personal Background . Sancho is fifty-two years old. . Maria is fifty years old. 574 Case Approach to Financial Planning Manuel (son) is twenty-seven years old All family members are in good health. Business Notes Approximately two years ago, Sancho purchased a plane timeshare for 5417,500. Monthly expenses are $5,035, plus $1,275 per hour of use. The timeshare includes fifty hours of guaranteed airtime he must pay for the time used) As noted above, Maria works part-time for Sancho's consulting company, in addition to running the rental real estate LLC. Because the consulting practice is based on Sancho's expertise, he feels the company will have no value once he retires or dies. Asset Summary Principal Residence o Purchased for $875,000 (loan amount) with a thirty-year 4.5 percent mortgage o Last payment: 81 . St. Petersburg Condo Purchased for $385,000 (loan amount) with a twenty-year 5.8 percent mortgage o Last payment:24 Las Vegas Condo Purchased for $280,000 (loan amount) with a thirty-year 5.0 percent mortgage o Last payment: 60 Las Vegas Condo (rental). o Purchased for $380,000 (loan amount) with a twenty-year 6.0 percent mortgage Last payment: 36 . Florida Condo (rental). . Purchased for $495,000 (loan amount) with a twenty-year 6.9 percent mortgage Last payment: 36 2018 Lexus two years old; five-year loan with 0.0 percent loan. 2017 Land Rover one year old; five-year loan with 1.0 percent loan. 201X BMW three years old; five-year loan with 2.5 percent loan. Universal Life Insurance Policy (Owner/Insured: Sancho; Beneficiary: Maria) . . o $1 million face value issued seven years ago . Term Life Insurance Policy (Owner/Insured: Sancho; Beneficiary: Maria). o $1 million thirty-year face value policy issued five years ago Group Term Life Insurance Policy (Owner/Insured: Sancho; Beneficiary: Maria). o $3 million face value policy. Liability Summary . valot Credit Cards. blor to do o Visa: several cards with an average APR of 14.50 percent. MasterCard: several cards with an average APR of 13.90 percent. Discover: one card with an APR of 18.00 percent. Call | o Store Cards: several cards with an average APR of 23.90 percent. O Furniture Loan: APR 19.00 percent. Student Loan. Parent Plus and bank loans to pay for son's college expenses. . o Amount borrowed: $240,000. Average interest rate: 6.9 percent. o Original loan term: ten years. Last payment: 24th 576 Case Approach to Financial Planning . Home Equity Loan. Amount borrowed: $145,000. O APY: 7.35 percent. Last payment: 24" (original ten-year loan). Expense Summary and Notes Gifts and donations are primarily charitable in nature (e.g, church, civic organizations, museums, etc.). Unreimbursed medical expenses include occasional chiropractic care, elective surgery, and insurance deductibles. Information about Sancho's Consulting Business Sancho runs his consulting business as an LLC. He regularly transfers $100,000 from net earnings to his ABC brokerage account. The account is in Sancho's name only. All remaining net earnings from the business are transferred to the household budget. The following balance sheet represents Maria's best attempt to summarize the household asset and liability situation. Emily-your paraplanner--needs your advice on completing the form: q Chapter 14 -- Moving From Strategies to Plan Development 577 Figure XVI.1. Balance Sheet Assets Value Ownership $7,426,328.81 Monetary Assets $57,700.00 $6,700.00 - Checking Account Checking Account Savings Account $14,000.00 H $37,000.00 - Investment Assets $3,627,128.81 MNO Brokerage Account $350,000.00 401(k) Account $1,400,000.00 H IRA Account $169,000.00 W ABC Brokerage Account $905,628.81 H XYZ Brokerage Account $720,000.00 H Life Insurance Cash Value $82,500.00 H Assets Used in Sancho's Business 5486,000.00 Golf Club Membership $75,000.00 H Plane Timeshare $400,000.00 H Savings, Cash, & Checking Accounts $11,000.00 H Real Estate LLC Las Vegas Condo Florida Condo $295,000.00 $500,000.00 LLC LLC $795,000.00 $1,985,000.00 Housing Assets $1,300,000.00 Primary Residence J 578 Case Approach to Financial Planning St. Petersburg Condo $385,000.00 5300,000.00 Las Vegas Condo $164,500.00 Vehicle Assets 201X Lexus $45,000.00 ) - 201X Land Rover $60,000.00 201X BMW $43,000.00 H 201X Harley Davidson Motorcycle $16,500.00 SI Personal Property & Use Assets $811,000.00 Artwork $79,000.00 J Jewelry $135,000.00 W Coins and Stamps $19,000.00 H Furniture and Household Goods $200,000.00 J Jet Skis $30,000.00 37 Foot Sailboat 583,000.00 H Golf Equipment $15,000.00 H Other $250,000.00 LIABILITIES DEBT OWNERSHIP Personal Liabilities $3,256,517.14 $120,000.00 Current Bills S. Short-Term Debt $ Credit Cards Visa $40,000.00 Chapter 14 - Moving From Strategies to Plan Development 579 MasterCard $30,000.00 Discover $20,000.00 H Store Cards $30,000.00 Mortgages 222 Primary Residence ??? St. Petersburg Condo ??? - Las Vegas Condo ??? HEW Home Equity Loan ??? Vehicle Debt $124,549.00 201X Lexus $35,540.00 201X Land Rover $65,899.00 2017 BMW $23, 110.00 201X Harley Davidson Motorcycle H Other Liabilities $273,000.00 Furniture Loan $60,000.00 College Loans $213,000.00 Bank Loan S. Liabilities Assoc. with Sancho's Business 272 Leases Las Vegas Offices $192,000.00 Florida Offices $ 190,800.00 Las Vegas Car (Mercedes) $21,600.00 580 Case Approach to Financial Planning $19,800.00 Florida Car (Acura) Real Estate LLC Las Vegas Condo (mortgage) Florida Condo (mortgage) 172 LLC 272 LLC $??? ASSETS S??? LIABILITIES $722 NET WORTH Sancho is the primary household earner. The following is a summary of his W-2 income from his cyber security position. Please note that Sancho was unable to obtain an exact figure for other compensation. He hopes that you can calculate that. Figure XVI.2. Sancho's Non-Business Income Situation $871,416 Wages Other Taxable Compensation $ ??? Taxable income $ ??? Federal Income Tax Withheld $ 193,503 Social Security Wages $ 128,400 Social Security Tax Withheld $ 7,961 Medicare Wage and Tips $ 894,308 Medicare Tax Withheld $ 19,216 Qualified Plan Contributions $ 8,034 Medical Insurance Contributions $ 7,800 Disability Insurance Contributions $ 2,750 State and Local Taxes Withheld $ 42,150 *Pre-tax contributions/payments ter 14 Moving from Strategies to Plan Development 581 The following income and expense statements represent the cash flow situation for the real estate LLC and Sancho's consulting business Figure XVI.3. Real Estate LLC Income Las Vegas Rental Income $24,000 Florida Rental Income $19,200 Expenses Las Vegas Mortgage Insurance Tax Condo Fees $32,669 $450 $6,300 $6,000 Florida Mortgage Insurance Tax Condo Fees $45,697 $700 $6,700 $3,600 Figure XVI.4. Sancho's Consulting Business Income Business Income and Expenses Yearly Income Dollars Business Income $ 702,000 $0 bris Other Income Total Income $ 702,000 Expenses & Payments Travel $ 24,000 Meals with Clients $ 19,100 Professional Services Dar $ 28,000 Office Expenses $ 15,000 $ 10,765 Employee Expenses 582 Case Approach to Financial Planning $ 48,000 Las Vegas Office Lease $ 63,600 Florida Office Lease $ 7,200 Las Vegas Car Lease $ 6,600 Florida Car Lease Insurance Expenses $ 4,350 Plane Timeshare $ 124,170 Misc. Tax-Deductible Business Expenses $ 33,000 Total Expenses $ 374,235 Income S 327,765 FICA $ 13,413 $ 12,732 $ 108,000 $ 193,638 Employer Element of FICA Federal Tax Withholdings Income After Expenses State Income Tax Withholdings Earnings Contributed to Business Brokerage Account Transfer to Household Account Note: Expenses are paid using American Express $ 25,000 S00,000 $ 68,638 The following represents the Ruizs' cash flow position. Please note that Maria and Sancho were unable to complete the form. Figure XVI.5 Household Cash Flow Statement CASH FLOW WORKSHEET Yearly Income Current Year H Income $871,416 W Income $ 10,765 H Business Income $??? ving From Strategies to Plan Development 583 H Business Interest & Dividends H Interest & Dividends W Interest & Dividends $??? See portfolio data $??? See portfolio data S??? See portfolio data Group Benefit Income S??? $??? $??? Total Income Expenses & Payments Principal Residence P&I St. Petersburg Condo P&I Las Vegas Condo P&l Home Equity Loan $ 32,568 $ 18,037 S ??? 201X Lexus $ 12,730 201X Land Rover $ 17,101 201X BMW $ 14,630 Mortgages and Vehicle Total $??? Universal Life Premiums $ 22,000 Term Life Premiums $ 3,500 Homeowner's Insurance $ 1,300 Principal Residence St. Petersburg Condo $ 600 $750 Las Vegas Condo 55,500 Automobile Insurance $??? Group Benefit Insurance $0 Other Misc. Ins. Premiums $ 42,942 Insurance Total $ 301,503 Federal Income Taxes Paid $ 67,150 State Income Taxes Paid $ 54,127 FICA Paid $??? Payroll Tax Total Homeowner's Tax $ 8,000 $ 4,100 Principal Residence St. Petersburg Condo Las Vegas Condo $7,000 $2,300 Personal Property Taxes Quarterly Federal Tax Withholdings SO Tax Total $ 34,400 Brokerage Account (1) $ 3,493 401(k) Account (H) $ 8,034 IRA Account (W) $6,500 Brokerage Account (H) $ 36,000 Regular/Allocated Savings $0 Reinvested Interest & Dividends $ 47,998 Reinvested Interest & Dividends $ 26,036 Other Tax Advantaged Retirement Savings $0 Savings Total $ 128,062 Utilities $ 7,200.00 Telephone $3,600.00 Utility Total $ 10,800 Condo Fees $ 9,000 Home Maintenance & Repair $4,800 Strategies to Plan Development 585 Home Expense Total Food at Home $ 23400 Food Eating Out $ 10,500 Clothing $ 19.000 Automobile Repairs $ 20.000 Daily Living Expense Total $3,200 Entertainment & Vacation $ 53,000 Gifts & Donations $ 48,000 Personal Liabilities $ 95,000 Short-Term Debt SO Student Loan Debt $ 34,013 abril Credit Cards Visa $ 6,000 MasterCard DO $ 6,000 Discover $ 6,000 Store Cards $6,000 bb Ongoing Expenses $ 201,013 roll $6,000 Unreimbursed Medical Expenses Miscellaneous Expenses $ 7,200 $ 13,200 Miscellaneous Expense Total Discretionary Cash Flow $??? Total Income $??? Total Fixed Expenses S??? Total Variable Expenses $??? Discretionary Cash Flow Figure XVI.6. Portfolio Data Account 5 Account 2 Account 3 Account 4 Account Account MNO Sancho 401K Maria IRA ABC Brokerage XYZ Brokerage Name Brokerage H w H H Title Joint $1,400,000 $169,000 $905,629 $720,000 $350,000 Value 15 22 10 26 15 Years Invested Annual Contribution $8,034 $6,500 $100,000 $3,493 S 36,000 Allocation Stocks 20% 50% 75% 80% 25% 15% 30% Municipal Bonds 0% 50% 60% 5% 25% 10% T-Bills 0% 20% 5% 20% Hard Assets 0% 0% 10% Taxable Yield/ Return 0.260% na. 1.040% 0.5200 Qualified Dividend Yld 1.065% 0.000% 3.550% 4.260% 2.130% Notes: Joint joint ownership; H owned by husband (Sancho); W - owned by wife (Maria) . Historical Portfolio Rate of Return Assumptions (past and forward looking) Stocks: 10.32 percent (Standard Deviation: 19.70 percent). Municipal Bonds: 7.10 percent (Standard Deviation: 9.75 percent). T-Bills: 5.20 percent (Standard Deviation: 5.00 percent). Hard Assets and Real Estate: 7.78 percent (Standard Deviation: 21.00 per- cent). . Chapter 14 -- Moving from Strategies to Plan Development 587 . Thirty-Year Mortgage APR: 6.00 percent. Twenty-Year Mortgage APR: 5.00 percent Fifteen-Year Mortgage APR: 4.80 percent Home Equity APR: 6.25 percent (Based on ten-Year Loan). Financial Planning Assumptions The following assumptions and data should be used in addition to the information already provided in the case narrative: Taxes . Emily, your paraplanner, estimates Social Security and Medicare taxes to be approximately 547,310; however, this number is based on the case assumptions and the case marginal tax rates. She recommends that you confirm this figure using your own calculation. All dividends and capital gains are reinvested. Maria and Sancho are in the 35.0 percent federal marginal tax bracket. Maria and Sancho pay a 6.0 percent state marginal tax o The state deduction amount is $8,000 . 0 The state exemption amount is $2,500 per person. Woow orb The family is not eligible for a state tax credit. Retirement Sancho's monthly Social Security retirement benefit (PIA) in today's dol- lars: $3,400 (Maria is eligible to receive 50 percent of Sancho's benefit). Sancho and Maria hope to replace the equivalent of $495,000 before taxes per year in today's dollars in retirement, which is a replacement ratio of ed approximately 56.1 percent of earned household income For insurance planning purposes, assume that the Ruiz family is in the 35.0 percent federal marginal tax bracket and the 6.0 percent state tax bracket pre- and post-retirement. Maria and Sancho plan to retire when Sancho turns age sixty-seven (his full normal Social Security retirement age). Sancho would like to invest aggressively prior to retirement. Maria would prefer to take less risk. Sancho and Maria are willing to compromise by assuming a simple return calculated as: (Sancho's 401k RoR+Maria's IRA RoR)/2 588 Case Approach to Financial Planning . Sancho and Maria plan to invest in a diversified portfolio of stocks, mu. nicipal bonds, T-B.is, and hard assets/real estate during retirement. For initial planning purposes, assume an equal weighting in each of these as set classes to determine the expected RoR. Retirement savings contributions (pre-or post-tax) are assumed to grow at the rate of salary inflation (3.0 percent). Sancho and Maria are willing to allocate $500,000 from Sancho's personal investment account for retirement if needed. Maria and Sancho plan to sell the rental properties at retirement to help offset retirement needs. Sancho stated that he believes these assets will increase in value, on average, by a 7.60 percent rate of return until retire- . . ment. Insurance In the case of death: Expenses at death: o Final expenses: $40,000 each. Estate administration: $12,000 each. Miscellaneous final needs: $20,000 each. Transitional funding need: $10,000 each. For life insurance planning purposes only, Maria and Sancho would like to ensure that the surviving spouse will receive $625,000 in income per year until retirement Sancho and Maria hope to replace the equivalent of $495,000 before taxes per year in today's dollars in retirement. . . Maria will earn $10,765 per year until retirement; Sancho is expected to eam $871,416 until retirement." Maria and Sancho feel a 80 percent capital retention replacement ratio is appropriate when planning for life insurance needs. For insurance planning purposes, assume that the Ruiz family is in the 35.0 percent federal marginal tax bracket and the 6.0 percent state tax bracket pre and post-retirement Sancho and Maria plan to invest any life insurance proceeds and other assets in the case of death in a diversified portfolio of stocks, municipal bonds, T-Bills, and hard assets/real estate. For initial planning purposes, assume an equal weighting in each of these asset classes to determine the expected RoR. . Maria and Sancho are agreed that they would like to pay off all short- term, mortgage, vehicle, business, and other debts at the death of the first percent marginal tax bracket and the 6.0 percent state tax bracket. Moving From Strategies to Plan Development 589 Inflation pre- and post-retirement is assumed to be 3.0 percent. . spouse. Maria's Social Security retirement benefit, should Sancho die, is $20,400 per year in today's dollars; she will receive the benefit starting at age sixty. No survivor Social Security benefit is expected if Maria dies first. Sancho's monthly Social Security retirement benefit in today's dollars: $3,400 (Maria is eligible to receive 50 percent of Sancho's benefit). Maria and Sancho are willing to sell the rental properties and second olentoonste homes at the death of the first spouse to offset life insurance needs. Other assets to be used in the event of death: All brokerage accounts and retirement plan assets. In the case of disability: Sancho has a long-term disability policy with a $60,000 annual benefit The plan is employer provided at no cost to Sancho Benefits last until age sixty-seven. . . logo o The plan has a 180-day elimination period. Maria has no disability coverage. Maria and Sancho would like to replace 60 percent of household current income, Ident The couple is willing to self-insure the risk that Maria may become disabled. Assume a life expectancy of life expectancy of age ninety-five for Sancho and age ninety-three for Maria. Sancho has earmarked $974,000 of investment and monetary assets to cover short-term and elimination period disability needs. Maria and Sancho are willing to allocate $1,255,628 to help fund other . disability needs For insurance planning purposes, assume the Ruiz family is in the 35.0 590 Case Approach to Financial Planning Sancho and Maria plan to reallocate investment assets, in the event of disability, into a diversified portfolio of stocks, municipal bonds, T-Bills, and hard assets/real estate. For initial planning purposes, assume an equal weighting in each of these asset classes to determine the expected RoR Maria and Sancho will use earnings from the MNO and XYZ brokerage accounts to help offset yearly long-term disability income needs. Neither Maria nor Sancho expect Social Security benefits if either becomes disabled . In the case of a long-term care need: Maria and Sancho are comfortable using all brokerage account assets to fund any LTC needs. Assume an LTC inflation rate of 4.0 percent. . Assume $12,000 annual prescription costs per person if long-term care services are needed (in addition to long-term care costs). The average long-term care cost in their area is $85,000 per year. Assume age seventy-five for LTC needs for Maria and age seventy-seven for Sancho. . . Maria and Sancho are comfortable assuming a four-year long-term care need Sancho and Maria plan to reallocate investment assets, in the event of a LTC need, into a diversified portfolio of stocks, municipal bonds, T-Bills, and hard assets/real estate. For initial planning purposes, assume an equal weighting in each of these asset classes to determine the expected ROR. Property Insurance The couple's principal residence is currently insured based on a replace ment value of $1 million. allado The St. Petersburg condominium is insured for a replacement value of $347,000. The Las Vegas condominium is insured for a replacement value of $285,000 . The Las Vegas rental is insured for a replacement value of $295,000. The Florida rental is insured for a replacement value of $500,000 . . orld Use these data and assumptions to craft a comprehensive financial plan for your clince, investment, retirement, estate, and special needs' analyses. Be sure to address Maria's questions through cash flowet worth, tax, insurance, Discussion Points and Questions Chapter 14 - Moving From Strategies to Plan Development 591 Each vehicle is covered by a 100/300/100 split-limit coverage policy. A $1 million excess liability policy is in place the premium is $150 per account value based on contributions, time invested, and rate of return assumptions. 1 6. Estimate the Ruizs' current net worth situation. a. b. Briefly summarize the relevant facts of the case. 2. Estimate the amount of income earned from non-business source. Be sure to account for federal state, and FICA taxes withheld at the household level 3. Estimate the net taxable income from Sancho's consulting business. Be sure to account for FICA taxes, federal tax withholdings, and state tax withholdings. Also determine how much of the net income from the business flows to Sancho's brokerage account versus the household budget. Estimate net income from the rental real estate LLC. 5. Estimate the Ruizs' current discretionary cash flow position. a. Identify strengths and weakness associated with their cash flow situation. dalbe. Use financial ratios to evaluate areas for improvement. utero si enel secolo in Draft a list of potential recommendations that can be used to improve or enhance the situation Identify strengths and weakness associated with their net worth situationen b. Use financial ratios to evaluate areas for improvement Draft a list of potential recommendations that can be used to improve or enhance the situation. 7. Determine the weighted average rate of return for each portfolio, based on the current asset allocation. Estimate the amount of qualified dividends from the MNO, ABC, and XYZ portfolios Estimate the amount of interest earned from the MNO, ABC, and XYZ portfolios 592 Case Approach to Financial Planning & Develop an estimate of this year's tax situation for the Ruiz family? Can Maria and Sancho expect a federal income tax refund? Identify strengths and weakness associated with their federal tax situation b. Draft a list of potential recommendations that can be used to improve or enhance the situation 9. Do Maria and Sancho need long-term insurance coverage at this time? If yes, how much? 10. Does Sancho need additional short-term disability coverage? Does Sancho need additional long. term disability coverage? If the answer is yes to either question, how much? Provide an estimate of the cost of coverage? 11. Do Maria and Sancho need additional life insurance coverage? Answer the question based on: 1. A full needs analysis. II. The human life value approach. III. The capital retention approach. IV. The income retention approach How much additional life insurance, if any, does Maria need? b. How much additional life insurance, if any, does Sancho need? c. If either has a need, what type of insurance policy would be most appropriate? How much might such a policy cost? a d. Draft a list of other potential recommendations that can be used to improve or enhance the situation 12. Are Maria and Sancho on track to meet their retirement goal(s) based on the current case assumptions? a. Identify strengths and weakness associated with their retirement situation. b. Draft a list of potential recommendations that can be used to improve or enhance the situation. 13. Do Maria and Sancho need to worry about paying federal estate taxes should either die prematurely this year? a. Identify strengths and weakness associated with their estate planning situation. b. Draft a list of potential recommendations that can be used to improve or enhance the situation 14. Identify other issues Maria should be aware of as she evaluates the information provided in the context of a comprehensive financial plan