Question

Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...

Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 70.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 70.0 when he fully retires, he will begin to make annual withdrawals of $182,480.00 from his retirement account until he turns 92.00. He he will make contributions to his retirement account from his 26th birthday to his 65th birthday. To reach his goal, what must the contributions be? Assume a 8.00% interest rate.

Homework Answers

Answer #1

Calculation of Amount at the age of 70:

Rate = 8%

Nper = 92 - 70 = 22

PMT = 182480

FV = 0

Amount at the age of 70 can be calcculated by using the following excel formula:
=PV(rate,nper,pmt,fv)
=PV(8%,22,-182480,0)
= $1,861,431.70

Calculation of amount at the age of 65:

Rate = 8%

Nper = 70 - 65 = 5

FV = 1861431.70

PMT = 0

Amount at the age of 65 can be calcculated by using the following excel formula:
=PV(rate,nper,pmt,fv)
=PV(8%,5,0,-1861431.70)
= $1,266,859.14


Calculation of annual contribution:

Rate = 8%

Nper = 40

FV = 1266859.14

PV = 0

Annual contribution can be calculated by using the following excel formula:
=PMT(rate,nper,pv,fv)
=PMT(8%,40,0,-1266859.14)
= $4,890.28

Contribution = $4,890.28

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 74.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 74.0 when he fully retires, he will begin to make annual withdrawals of $176,595.00 from his retirement account until he turns 92.00. He he will make contributions to his retirement account from his 26th birthday...
27. Derek plans to retire on his 65th birthday. However, he plans to work part-time until...
27. Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 70.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 70.0 when he fully retires, he will begin to make annual withdrawals of $189,025.00 from his retirement account until he turns 89.00. He he will make contributions to his retirement account from his 26th...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 70.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 70.0 when he fully retires, he will wants to have $3,142,214.00 in his retirement account. He he will make contributions to his retirement account from his 26th birthday to his 65th birthday. To reach his...
9)#1 Derek plans to retire on his 65th birthday. However, he plans to work part-time until...
9)#1 Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 70.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 70.0 when he fully retires, he will begin to make annual withdrawals of $101,516.00 from his retirement account until he turns 90.00. He he will make contributions to his retirement account from his 26th...
A) Derek plans to retire on his 65th birthday. However, he plans to work part-time until...
A) Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 72.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 72.0 when he fully retires, he will begin to make annual withdrawals of $120,165.00 from his retirement account until he turns 94.00. He he will make contributions to his retirement account from his 26th...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 74.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 74.0 when he fully retires, he will begin to make annual withdrawals of $143,996.00 from his retirement account until he turns 92.00. He he will make contributions to his retirement account from his 26th birthday...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 74.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 74.0 when he fully retires, he will begin to make annual withdrawals of $130,692.00 from his retirement account until he turns 88.00. After this final withdrawal, he wants $1.38 million remaining in his account. He...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 71.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 71.0 when he fully retires, he will begin to make annual withdrawals of $167,806.00 from his retirement account until he turns 87.00. After this final withdrawal, he wants $1.30 million remaining in his account. He...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 72.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 72.0 when he fully retires, he will begin to make annual withdrawals of $170,683.00 from his retirement account until he turns 92.00. After this final withdrawal, he wants $1.84 million remaining in his account. He...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
Derek plans to retire on his 65th birthday. However, he plans to work part-time until he turns 75.00. During these years of part-time work, he will neither make deposits to nor take withdrawals from his retirement account. Exactly one year after the day he turns 75.0 when he fully retires, he will begin to make annual withdrawals of $108,596.00 from his retirement account until he turns 88.00. He he will make contributions to his retirement account from his 26th birthday...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT