Question

Anna wants to plan for retirement. She stimates that she would need $24,000 when she retires at age 67 to live the first year after retirement (year 68). She estimates that the amount that she will need for living will have to grow by 3.5% every year to keep up with inflation. Her retirement account earns 4.5% every year. How much should she start saving on her 36th birthday to comfortably live till she is 85 years old, if she is ready to increase the amount that she saves every year with the rate of inflation?

Please show work and explain how and which Excel functions were used

Answer #1

Vera wants to buy an antique car for $75,000 on her 36th
birthday. She would like to begin with a yearly amount deposited in
her money market account earning 6.5% on her 26th birthday, and
increase the amount each year by the inflation rate of 4.5%. What
amount should she plan on depositing on her 26th birthday?
$2,346
$3,521
$3,986
$5,456

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 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 are saving for retirement. To live comfortably, you decide
you will need to save $2 million by the time you are 65. Today is
your 30th birthday, and you decide, starting today and continuing
on every birthday up to and including your 65th birthday, that you
will put the same amount into a savings account. If the interest
rate is 5%, how much must you set aside each year to make sure that
you will have $2 million in...

you are saving for retirement. To live comfortably, you decide
you will need to save
$2,000,000
by the time you are
65.
Today is your
33rd
birthday, and you decide, starting today and continuing on
every birthday up to and including your
65th
birthday, that you will put the same amount into a savings
account. If the interest rate is
6%,
how much must you set aside each year to make sure that you will
have
$2,000,000
in the account...

You are saving for retirement. To live comfortably, you decide
you will need to save $2 million by the time you are 65. Today is
your 30th birthday, and you decide, starting today and continuing
on every birthday up to and including your 65th birthday, that you
will put the same amount into a savings account. If the interest
rate is 8 %, how much must you set aside each year to make sure
that you will have $2 million...

You are saving for retirement. To live comfortably, you decide
you will need to save $ 4 million by the time you are 65. Today is
your 33 rd birthday, and you decide, starting today and
continuing on every birthday up to and including your 65 th
birthday, that you will put the same amount into a savings
account. If the interest rate is 9 %, how much must you set aside
each year to make sure that you will...

You are saving for retirement. To live comfortably, you decide
you will need to save $3 million by the time you are 65 . Today is
your 30 th birthday, and you decide, starting today and
continuing on every birthday up to and including your 65 th
birthday, that you will put the same amount into a savings
account. If the interest rate is 8 % , how much must you set aside
each year to make sure that you...

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...

Your client is 21 years old. She wants to begin saving for
retirement, with the first payment to come one year from now. She
can save $8,000 per year, and you advise her to invest it in the
stock market, which you expect to provide an average return of 11%
in the future.
a. If she follows your advice, how much money will she have at
65? Round your answer to the nearest cent.
$
b. How much will she...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 41 minutes ago

asked 43 minutes ago

asked 59 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 2 hours ago

asked 2 hours ago

asked 2 hours ago