Question

- You have just turned 40 years old and are trying to decide who much money to put into your retirement plan. The plan works as follows: Every dollar in the plan earns 7% per year. You cannot make withdrawals until you retire on your sixty-fifth birthday. After that point, you can make withdrawals as you see fit. You decide that you will plan to live to 95 and work until your turn 65. You estimate that to live comfortably in retirement, you will need $250,000 per year starting at the end of the first year of retirement and ending on your 95th birthday. You already have $200,000 in the retirement plan. You will contribute the same amount to the plan at the end of every year that you work, starting next year. How much do you need to contribute each year to fund your retirement?

Answer #1

First we have find the amount needed to withdraw $250,000 for 30 years (65 to 95) at 7% interest rate. for that use PV function in EXCEL

=PV(rate,nper,pmt,fv,type)

rate=7%

nper=30

pmt=250000

fv=0

type=0

=PV(7%,30,250000,0,0)

PV=$3,102,260.30

In the question, it mentioned that they have already 200,000 in the retirement account. This recevies 7% interest for 25 years (40-65 years)

=200000*((1+7%)^25)=1,085,486.53

So, he has to accumulate 2,016,773.77 (3,102,260.30-1,085,486.53) in 25 years. use PMT function in EXCEL

=PMT(rate,nper,pv,fv,type)

rate=7%

nper=25

pv=0

fv=2016773.77

type=0

=PMT(7%,25,0,2016773.77)

PMT=31,886.24

The annual contributions to fund the retirement account=31,886.24

You have just turned 40 years old and are trying to decide who
much money to put into your retirement plan. The plan works as
follows: Every dollar in the plan earns 7% per year. You cannot
make withdrawals until you retire on your sixty-fifth birthday.
After that point, you can make withdrawals as you see fit. You
decide that you will plan to live to 95 and work until your turn
65. You estimate that to live comfortably in...

You have just turned 40 years old and are trying to decide who
much money to put into your retirement plan. The plan works as
follows: Every dollar in the plan earns 7% per year. You cannot
make withdrawals until you retire on your sixty-fifth birthday.
After that point, you can make withdrawals as you see fit. You
decide that you will plan to live to 95 and work until your turn
65. You estimate that to live comfortably in...

You have just turned 30 years? old, have just received your?
MBA, and have accepted your first job. Now you must decide how much
money to put into your retirement plan. The plan works as? follows:
Every dollar in the plan earns 9% per year. You cannot make
withdrawals until you retire on your 70th birthday. After that?
point, you can make withdrawals as you see fit. You decide that you
will plan to live to 100 and work until...

You have just turned 30 years old, have just received your
MBA, and have accepted your first job. Now you must decide how much
money to put into your retirement plan. The plan works as follows:
Every dollar in the plan earns 8% per year. You cannot make
withdrawals until you retire on your 60th birthday. After that
point, you can make withdrawals as you see fit. You decide that you
will plan to live to 100 and work until...

Your second cousin has just turned 30 years old, has just
received her master’s degree in
neurofinance and has accepted her first job. Now she must
decide how much money to put into
her retirement plan. The plan works as follows: Every dollar
in the plan is expected to earn 8%
per annum. She cannot make withdrawals until she retires on
her sixty-fifth birthday. After that
point, she can make withdrawals as she sees fit. She plans on
living to...

You just turned 20 years old and want to retire when you turn
65. You expect to live for 25 years after retirement and want to
withdraw $100,000 per year in retirement, starting on your 65th
birthday. You expect to earn a return of 6% on your investments
every year. What is the present value (as of your 65th
birthday) of the withdrawals you expect to make?
How much money should you save each year if you make the first...

You just turned 25 years old and want to retire when you turn
65. You expect to withdraw $90,000 per year for 25 years during
retirement, starting first withdrawal one year after your 65th
birthday. You expect to earn a return of 8% on your investments
every year. part 1 How much retirement saving do you need to have
by 65th birthday to support the withdrawals in the next 25 years?
Or the same question can be asked differently, what...

Intro
You just turned 23 years old and want to retire when you turn
65. You expect to live for 25 years after retirement and want to
withdraw $80,000 per year in retirement, starting on your
65th birthday. You expect to earn a return of 5% on your
investments every year.
Pt 1. What is the present value (as of your
65th birthday) of the withdrawals you expect to make in
retirement?
Attempted answer: 1127515.56 (WRONG)
80000* [ 1 -...

You are trying to calculate how much money you should have at
retirement. On your 57 th birthday you will retire and immediately
make your first withdrawal of ?$4166.67. You plan to make 24 such
withdrawals each year. You plan to continue withdrawing at that
level and frequency until you are 72 years old. ? (Assume beginning
of period withdrawals with the first withdrawal on your retirement
date and no withdrawal on your final? birthday.) During retirement
your savings will...

You are trying to decide how much to save for retirement. Assume
you plan to save $ 5,500 per year with the first investment made
one year from now. You think you can earn 12.0% per year on your
investments and you plan to retire in 38 years, immediately after
making your last 5,500 investment.
a. How much will you have in your retirement account on the day
you retire?
b. If, instead of investing $5,500 per year, you wanted...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 10 minutes ago

asked 10 minutes ago

asked 25 minutes ago

asked 34 minutes ago

asked 36 minutes ago

asked 43 minutes ago

asked 44 minutes ago

asked 47 minutes ago

asked 55 minutes ago

asked 58 minutes ago

asked 59 minutes ago

asked 1 hour ago