Question

You plan on buying yourself a retirement cabin in the Rocky Mountains 40 years from now. At an interest rate of 5 percent per year, how much must you invest each year (equal annual amounts beginning next year) to have $150,000 in your cabin fund in 40 years?

please solve using excel

Answer #1

Future Value to accumulate in 40 years = $150,000

Calculating the Equal Annual Payments at the end of each year using Excel "PMT" function:-

So, **equal annual payments is $1241.72**

*If you need any clarification, you can ask in
comments. *

**If you like my answer, then please up-vote as it
will be motivating *** *

You plan to retire 34 years from now. You expect that you will
live 22 years after retiring. You want to have enough money upon
reaching retirement age to withdraw $140,000 from the account at
the beginning of each year you expect to live, and yet still have
$2,500,000 left in the account at the time of your expected death
(56 years from now). You plan to accumulate the retirement fund by
making equal annual deposits at the end of...

You plan to retire 37 years from now. You expect that you will
live 25 years after retiring. You want to have enough money upon
reaching retirement age to withdraw $110,000 from the account at
the beginning of each year you expect to live, and yet still have
$2,500,000 left in the account at the time of your expected death
(62 years from now). You plan to accumulate the retirement fund by
making equal annual deposits at the end of...

You want to plan your retirement. Your assumption is that you
will work for 35 years and after that need $300,000 annually for 30
years starting a year after you retire. In order to fund your
retirement plan you want to invest the same amount at the end of
each year (including the year 35) starting one year from now. How
much would you have to invest each year over your working career?
(Assumption with a 4% annual return to...

You want to save $1,000,000 for retirement, which will be 40
years from today. How much would you have to set aside each year to
fund the retirement if you made 40 equal annual deposits beginning
one year from today? Assume interest rates of 6, 8, 10, and 12
percent.

You are planning for retirement 35 years from now. You plan to
invest $5,300 per year for the first 8 years, $6,800 per year for
the next 9 years, and $13,600 per year for the following 18 years
(assume all cash flows occur at the end of each year). If you
believe you will earn an effective annual rate of return of 10.3%,
what will your retirement investment be worth 35 years from
now?

You are planning for retirement 36 years from now. You plan to
invest $3,500 per year for the first 7 years, $7,500 per year for
the next 10 years, and $14,500 per year for the following 19 years
(assume all cash flows occur at the end of each year). If you
believe you will earn an effective annual rate of return of 11.0%,
what will your retirement investment be worth 36 years from
now?

You are planning for retirement 34 years from now. You plan to
invest $3,100 per year for the first 5 years, $8,500 per year for
the next 10 years, and $10,700 per year for the following 19 years
(assume all cash flows occur at the end of each year). If you
believe you will earn an effective annual rate of return of 12.2%,
what will your retirement investment be worth 34 years from
now?
$58,073.60
$51,759.00
$2,310,735.22
$2,592,644.91
$1,163,838.30

You are planning for retirement 30 years from now. You plan to
invest $3,600 per year for the first 6 years, $7,800 per year for
the next 8 years, and $13,800 per year for the following 16 years
(assume all cash flows occur at the end of each year). If you
believe you will earn an effective annual rate of return of 12.1%,
what will your retirement investment be worth 30 years from
now?
Question 25 options:
$53,557.98
$1,648,134.07
$1,470,235.57...

You have $10,000 to invest for the next 40 years for your
retirement. You are offered an investment plan that will pay you 5%
per year for the next 20 years and 10% for the last 20 years. How
much will you end up with in 40 years’ time? Does it matter if the
investment plan pay you 10% for the first 20 years and 5% for the
next 20 years? Why or why not?

You plan on depositing $6,000 at the end of each year
for 40 years into a retirement account that pays 4% interest. How
much could you withdraw annually in equal beginning of year amounts
starting at the time you make your last deposit and continuing for
a total of 20 years, assuming balances continue to earn 4% until
withdrawn?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 18 minutes ago

asked 23 minutes ago

asked 31 minutes ago

asked 34 minutes ago

asked 40 minutes ago

asked 43 minutes ago

asked 47 minutes ago

asked 49 minutes ago

asked 56 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago