Question

PROBLEM 7 – Time-Value-of-Money and Retirement Planning

Ellen is 30 years old and plans to start saving $10,000 annually, toward her retirement. She will put the $10,000 into an investment account at the end of each year. She will put this savings into a mutual fund. She intends to retire in 35 years. Upon her retirement, she will move her savings, (i.e. her “nest egg”) into a relatively low-risk account that earns 4.0% annually. Her first withdrawal will be made one year after her retirement and she expects to withdraw $100,000 from the account at the end of each year for 25 years thereafter (i.e. she wants to have enough annual income to last at least until she reaches age 90).

What return (i.e. interest rate) must Ellen earn on her investment account during the next 35 years, while she is saving for her retirement? In other words, what rate of return must the account provide Ellen while she is building up her “nest egg?”

Answer #1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

*Hope this will help, please do comment if you need any
further explanation. Your feedback would be appreciated.*

Your friend Ellen is celebrating her 25th birthday (i.e., she is
25 today) and wants to start saving for her anticipated retirement
at age 55. She wants to be able to withdraw $10,000 from her
savings account on each birthday for 10 years following her
retirement (the first withdrawal will be on her 56th birthday).
Ellen intends to invest her money in the local saving bank, which
offers 8% (EAR) interest per year.
Suppose Ellen wants to make 24 deposits...

Terry Austin is 30 years old and is saving for her
retirement. She is planning
on making 35 contributions to her retirement account at the
beginning of
each of the next 35 years. The first contribution
will be made today
(t = 0) and the final contribution will be made 34 years from
today (t = 34).
The retirement account will earn a return of 8.2 percent a
year. If each
contribution she makes is $5,493.00 how much will be in the
retirement...

This is a classic retirement problem. A friend is celebrating
her birthday and wants to start saving for her anticipated
retirement. She has the following years to retirement and
retirement spending goals: - Years until retirement: 30 - Amount to
withdraw each year: $90,000 - Years to withdraw in retirement: 30 -
Interest rate: 8% Because your friend is planning ahead, the first
withdrawal will not take place until one year after she retires.
She wants to make equal annual...

Doreen is celebrating her 35th birthday and decides she needs to
start saving for retirement beginning at age 65. She wants to be
able to withdraw 90,000 annually for 15 years starting on her 66th
birthday. She intends to invest at 8% over the life of the account.
Her employer will contribute 1500 per year until she retires.
Additionally, she expects a 25,000 distribution from a family trust
on her 55th birthday which will be deposited into the retirement
account....

Your friend is celebrating her 35th birthday today wants to
start saving for her anticipated retirement at age 65. She wants to
be able to withdraw $105,000 from her savings account on each
birthday for 20 years following her retirement; the first
withdrawal will be on her 66th birthday. Your friend intends to
invest her money in the local credit union, which offer 7 percent
interest per year. She wants to make equal annual payments on each
birthday into the...

Jason plans to retire in 35 years and live 30 years after his
retirement.
He will save $10,000 every year, starting from next year until
his retirement (i.e. 35 years from today).
After retirement, Jason wants to make 30 annual withdrawals.
The withdrawals are the same over years. The first
withdrawal will be made in the first year after his
retirement.
The annual interest rate is 5%, which applies the whole
time to his retirement account.
How much can Jason...

10. Nicky Darling is currently 30 years old and decides to start
saving for her retirement. Her current (annual) income is €30,000
and will grow at a constant rate of 2% annually until her
retirement. She would like to save one quarter of her net income
every year from next year onwards until she turns 65 (including
that year). She agrees with the bank on annual interest rate
compounding at an annualized interest rate of 4%. The final value
of...

Ashley turned 30 today, and she is planning to save $3,000 per year
for retirement, with the first deposit to be made one year from
today. She will invest in a mutual fund, which she expects to
provide a return of 8.20% per year throughout her lifetime. She
plans to retire 35 years from today, when she turns 65, and she
expects to live for 30 years after retirement, to age 95. Under
these assumptions, how much can she spend...

This is a classic retirement problem. Your friend, Mary Jones,
is celebrating her 30th birthday and wants to start
saving for her anticipated retirement. She has the following years
to retirement and retirement spending goals, which are as
follows:
Years until
retirement:
30
Amount to withdraw each year upon
retirement:
$90,000
Years to withdraw in
retirement:
20
Interest
rate:
5%
Mary is planning to make equal annual deposits into her
retirement account, while her first withdrawal will take place one...

2. Gary Luff is trying to plan for retirement in 10 years, and
currently he has $150,000 in a savings account and $250,000 in
shares. In addition, he plans on adding to his savings by
depositing $8,000 per year in his savings account at the end of
each of the next five years and then $10,000 per year at the end of
each year for the final five years until retirement. Required:
(a) Assuming Gary’s savings account returns 8% compounded...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 14 minutes ago

asked 28 minutes ago

asked 28 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago

asked 3 hours ago

asked 3 hours ago