Review the Case 2 PDF and attach a one-page written executive summary as if you were a professional adviser writing to the client. Research all the issues/needs/questions the clients have and summarize the pertinent assumptions, case facts, and findings. This executive summary should include specific and actionable recommendations.
FINANCE 6080 Case #2 Ned and Nelly Normal Ned is a pilot and Nelly a school teacher. They have 3 children—all daughters. Kris is 23 and single, graduated from college and working. Olivia is 20 and half way through college, studying engineering. Ellie is 13, an 8th grader. Ned will be required to retire at 65 and Nelly plans to work through 65, as well. Both are currently 50 years old. They would like to maintain their same lifestyle in retirement. They have the following assets: His Checking $11,000 Her Checking $13,500 His Savings $10,700 Her Savings $18,000 Employee Stock Purchase Plan $38,600 401(k) at D Airlines $828,932 Rental Property $400,000 Primary Residence $675,000 Whole Life Policy $500,000 Death Benefit They have the following debts: Chase Visa—generally about $11,000 and paid in full each month Residential Mortgage $270,755—pay $1,575 per month at 3.5% for 30 years. Rental Mortgage–original loan was July 2017 for $336,000. Rate is 4.85%, 30 year loan, they pay $2,225 per month. New Windows–$16,960 original loan amount was $23,104 with a 66 month amortization at 5.99%, pmt is about 411.75 per month. Solar and Roof HELOC –$38,000 for 240 months at 10.5%, payments start next month, but they have forgotten how much it was exactly Car Loan–$27,911 balance, originally $35,150 for 72 months at 3.49% with a payment of $541.00 Income includes: His Salary $295,000 Her Salary $65,000 Military Pension $4,000 per month starting in 5 years Rental Income $24,000 They spend pretty much what they make, but have been able to save about $3,000 per month over the past year in conjunction with Nelly re-entering the work force. His union has negotiated that his employer contributes 15% of his wage into his 401(k) up to the IRS limit each year. He also contributes $4,000 a year into the Employee Stock Purchase Plan. The Normal’s have the following issues/needs/questions:
1. Will Ned and Nelly be able to retire at age 65 and maintain their current lifestyle with no change in their spending or savings plan?
2. What adjustments could be made to their financial plan to make retirement at 65 even better and increase their probability of success?