Question

In: Finance

Jack and Jill are 41 years old and plan on retiring at age 65 and expect...

Jack and Jill are 41 years old and plan on retiring at age 65 and expect to live until age 95. Theycurrently earn $200,000 and expect to need $100,000 in retirement. They also expect that SocialSecurity will provide $24,000 of benefits in today’s dollars at age 65. They are saving $20,000 each intheir 401(k) plans and IRAs. Their son, Parker, is expected to go to college in 10 years. They want tosave for Parker’s college education, which they expect will cost $25,000 in today’s dollars and they arewilling to fund 4 years of college. They were told that college costs are increasing at 6% per year, whilegeneral inflation is 3%. They currently have $500,000 saved in total and they are averaging an 8% rateof return and expect to continue to earn the same return over time. Based on this information, whatshould they do?

Solutions

Expert Solution

Basesd on the information provided above, let us try to determine whether have they saved enough for their retirement and parker's education or not, and do they need to still invest or can stop further investments.

DAta Provided:

Earnings Rate : 8%

Current Age: 41 yrs

Retirement age: 65 yrs

Inflation rate: 3%

Life Expentancy: 95 yrs

Let us first determine the total amount which is to be funded:

They are expected to get retired at the age of 65

They need $100,000

Less: Social security which is to be provided at the age of 65 is $24,000

So total funds needed is $76,000

They are now 41 yrs of age, expected to retire at 65 yrs

Total number of years lefft to retire = 65 - 41 = 24 yrs

So the Future Value of $76,000 after 24 yrs at the age of retirement would be = 76,000 * (1+0.03)24 = $154,492.35

The present Value of the Retirement Annuity can be calculated with the following formula:(at the age of 65)

PV = PMT ((1-(1/(1+r)n))/r)

n heree would be the difference beetween the life expentancy and retirement age = 95 - 65 = 30 yrs

PV of Retirement Annuity = $154,492.35((1-(1/1.048544)30))/0.048544 = $2,532,092.39

Let us find the present value of the lumpsum of retirement annuity in todays value by discounting it with 8% interest for 24 years.

PV = $2,532,092.39/(1+0.08)24 = $399,309.29

Now Let us find the Total o[f education Costs in today's Value:

Let us try to get the total of education cost in 10 yrs

Todays cost is $25,000

n = 10 yrs

interest rate = 6%

Value at the end of 10 years = 25000 * (1.06)10 = $44,771.19

$44,771.19 would be the fees for four years.

Total of education cost at the beginning of the year = PMT*((1-(1/(1+r)n))/r)

n = 4

r = 1.89

PMT = $44,771.19

PV = $44,771.19 ((1-1/(1+0.0189)4))/0.0189) = $174,171.32

Let us try to discount it to present value of todays time(that is disounting it for 10 years at current market interst rate)

PV = $174,171.32/(1.08)10  = $80,675.02

Now let us make the judgement:

PV of retirment = $2,532,092.39

PV of Education = $80,675.02

Total = $479,984.31

Less Investment Assets = $500,000

They still have surplus of $20,015.69

Therefore they need not specifically save for the meeting the future requirements. They already have saved enough of savings for their retirement and Parker's Education Cost. They can stop saving if they wish.


Related Solutions

Mike is currently 35 years old and plans on retiring at the age of 65. Ideally,...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally, Mike would like to retire with $1,000,000.00. (Input all answers as positive values, no commas, with no symbols ex. no $ or %. Input all % answers as whole numbers without symbols ex. 10.03 for .1003. Input all final answers two decimal places out.) How much would Mike have to deposit on an annual basis to reach his goal if he can get a...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally,...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally, Mike would like to retire with $1,000,000.00. (Input all answers as positive values, no commas, with no symbols ex. no $ or %. Input all % answers as whole numbers without symbols ex. 10.03 for .1003. Input all final answers two decimal places out.) How much would Mike have to deposit on a monthly basis to reach his goal if he can get a...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally,...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally, Mike would like to retire with $1,000,000.00. (Input all answers as positive values, no commas, with no symbols ex. no $ or %. Input all % answers as whole numbers without symbols ex. 10.03 for .1003. Input all final answers two decimal places out.) If Mike can only find an annual return of 8% compounded on a monthly basis and can only deposit $400...
Mike is currently 35 years old and plans on retiring at the age of 65 ideally...
Mike is currently 35 years old and plans on retiring at the age of 65 ideally Mike would like to retire with one million dollars. a. How much would Mike have to deposit on an annual basis to reach his goal if he can get return of 12% compounded annually.? b. How much would mike deposit on a monthly basis to reach his goal if he can get a return of 10% compounded monthly? c. If mike can find an...
Suppose that you are age 25 today and plan on retiring at age 65. You determined...
Suppose that you are age 25 today and plan on retiring at age 65. You determined that you need to have saved $659,754 in real dollars by the time you retire. How much must you contribute (in real dollars) each year to your retirement account to achieve your goal? Assume the following: you make annual contributions; each contribution is the same amount in real dollars; the first contribution will be one year from today; your last contribution will be at...
You plan on retiring in 40 years at age 65.  You currently have $20,000 (graduation present) that...
You plan on retiring in 40 years at age 65.  You currently have $20,000 (graduation present) that you are going to deposit today in a bond that will yield 10% a year for the entire 40 years (traditional IRA).  At age 40 you will receive an inheritance from your parents of approximately $20,000 which you will invest in mutual funds that will yield 9% a year for 25 years (Traditional IRA).  The current discount rate is 5.5%, the risk-free rate is 3% and...
Personal Financial Plan for “Jack and Jill” Jack and Jill are married and a middle-aged couple....
Personal Financial Plan for “Jack and Jill” Jack and Jill are married and a middle-aged couple. In order to achieve their goals, they hope to retire and must, therefore, ensure they have enough savings to cater for their needs in their golden days. As a married couple, they have made several investments and are not sure whether their insurance coverage is adequate. They are not sure whether they have enough financial resources to last them for the rest of their...
You are 40 years old today and want to plan for retirement at age 65. You...
You are 40 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 95 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $70,000 has today. You plan on withdrawing the money starting the day you retire. You have $15,000 saved for retirement today. Inflation...
You are 47 years old today and want to plan for retirement at age 65. You...
You are 47 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 87 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $73,868 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement....
Suppose you are 40 years old and plan on retiring in 25 years, and then living...
Suppose you are 40 years old and plan on retiring in 25 years, and then living for another 15 years after retirement.  Your current income is $70,000 per year.  If you pay $3,000 in Social Security taxes each year, how much do you need to save per year in order to have enough to replace 75% of your preretirement income at retirement when combined with Social Security
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT