Question

Assume that you plan to retire in 45 years and that you estimate you will need an income of $200,000 on the day you retire and an equivalent amount, adjusted for inflation, at the beginning of each year for a total of 35 years. You will take a world-wide cruise 10 years after you retire and estimate the cost to be $100,000.

Assume that you will earn 12.00 percent during your working years and 6.00 percent after you retire. You anticipate that your salary will grow at an average rate of 4% each year. The expected rate of inflation after you retire is estimated to be 3.5%.

You will make annual contributions to your retirement fund at the end of each year while working. How much must you save in the first year so that you will meet these goals?

Can you please answer using Excel

Answer #1

Based on the given data, pls find below workings:

Assume that you plan to retire in 40 years and that you estimate
you will need an income of $60,000 at the beginning of each year
for 30 years, following your retirement.
Assume that you will earn 10.00 percent during your working
years and 5.50 percent after you retire.
How much must you save every month so that you will meet these
goals?

Ben plans to retire in 42 years and has determined that he will
be comfortable if he can receive $75,000 at the beginning of each
year after retirement. He will live for 25 years after retiring and
will earn 6.00% on his fund after retirement. Ben will earn 12.00%
on his fund will working and saving. How much must Ben save every
month to meet his retirement goal?

Assume that you will retire in 30 years. You plan to be retired
for a total of 30 years. You wish to withdraw the equivalent of
$50,000 per year (in TODAY'S dollars) from your retirement fund
each year that you are retired (ASSUME that there will NOT be any
adjustments for inflation DURING your retirement. You will withdraw
the same dollar amount every year that you are retired). The
expected inflation rate for the next 30 years is 3%. You...

You plan to retire in 28 years. At the point of retirement, you
want to be able to withdraw 25,682 at the end of each year forever.
Assume that you earn a 7.1% rate of return prior to retirement and
an 5.69% rate of return after retirement. If you do not want to
make any further contributions to your retirement fund, how much do
you need today? Round answer to the nearest dollar.

1a) You estimate that by the time you retire in 35 years, you
will have accumulated savings of $2 million. If the interest rate
is 3.5% and you live 20 years after retirement, what annual level
of expenditure will those savings support? Unfortunately, inflation
will eat into the value of your retirement income. Assume a 1.5%
inflation rate and work out a spending program for your retirement
that will allow you to increase your expenditure in line with
inflation
Group...

1. You plan to retire in 33 years and
can invest to earn 18%. You estimate that you will need Rs
1,000,000 at the end of each year for an estimated 18 years after
retirement, and you expect to earn 5% during those retirement
years. How much do you need to set aside at the end of each year to
accumulate the money needed for your retirement?

You are 30 years old today. You want to retire at the age of 60.
You expect to live until age 85. You would like to have a monthly
income of $13,000 per month in retirement. How much do you have to
save per month during your working years in order to achieve your
retirement goal? Assume end of period payments. Assume an annual
interest rate of 3.5% in retirement and 5% during your working
life. How much do you...

Assume you are now 30 years old. You plan to retire when you are
60 years old. You think you will live until you are 85 years old.
a. If the rate of return during your working years (a.k.a. the
"savings period") is 10% and you plan to save $1,000 per year, how
much will you have saved up by retirement age? b. If the rate of
return during your retirement is 7%, how much will you receive as
an...

Assume you are 40 years old and wish to retire at age 65. You
expect to be able to average a 6% annual rate of interest on your
savings over your lifetime (both prior to and after retirement).
You would like to save enough money to provide $8,000 per year
beginning at age 66 in retirement income to supplement other
sources (Social Security, pension plans, etc.) Suppose you decide
to that the extra income needs to be provided for only...

You plan to retire in fifteen years. Since you’ll be retiring
relatively young you plan to live in retirement for 25 years. You
haven’t been able to save much so far and you’ve only accumulated
$5,000 towards retirement. You think you will need $100,000/year to
live in retirement. If you can invest at 6% annually, how much will
you have to invest between now and then to achieve your goals?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 1 minute ago

asked 2 minutes ago

asked 5 minutes ago

asked 17 minutes ago

asked 42 minutes ago

asked 48 minutes ago

asked 54 minutes ago

asked 59 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago