Question

You just decided to begin saving for retirement. You will make deposits of $1,000 per month...

You just decided to begin saving for retirement. You will make deposits of $1,000 per month into a retirement account that earns 8.00% p.a. The first deposit is made today and the last deposit will be made when you retire exactly 30 years from today. The day you retire you will buy an RV for $240,000. You will begin to make withdrawals from the account the first month after you retire. If you plan to live an addition 25 years, you will be able to withdraw $_____. (Note: you make 300 total monthly withdrawals from your retirement account.)

Homework Answers

Answer #1

First we have to find future value using FV function in EXCEL

=FV(rate,nper,pmt,pv,type)

These deposits are monthly

rate=8%/12=0.667%

nper=number of periods=12*30=360

pmt=1000

pv=0

type=1 (deposits are made at the begining of the year, hence type=1)

=FV(0.667%,360,-1000,0,1)

FV=$1,500,295

The accumulated value=$1,500,295

At the time, you retire, buys an RV of $240,000. the value becomes=$1260295 (1500295-240000)

==> Now how much withdrawls we make, use PMT function

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

rate=0.667%

nper=12*25=300

pv=1260295

fv=0

type=0 (because first withdrawl happens after a month, means end of the month,hence type=0)

=PMT(0.667%,300,-1260295,0,0)

PMT=9727.16

The monthly withdrawl=$9727.16

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You just decided to begin saving for retirement. You will make deposits of $1,000 per month...
You just decided to begin saving for retirement. You will make deposits of $1,000 per month into a retirement account that earns 8.00% p.a. The first deposit is made today and the last deposit will be made when you retire exactly 30 years from today. (Note: you make 361 total monthly deposits into your retirement account.) You will begin to make withdrawals from the account the first month after you retire. If you plan to live an addition 25 years...
A year from now, you plan to begin saving for your retirement by depositing $20,000 into...
A year from now, you plan to begin saving for your retirement by depositing $20,000 into a new savings account that has an expected return of 5.75% compounded monthly. You plan to continue depositing the same amount each year until you retire in 35 years. You expect to make withdrawals from your savings account every month for 40 years after you retire. Assume you were asked to find the amount you will be able to withdraw each month from your...
You decide to open a retirement account at your local bank that pays 9%/year/month (9% per...
You decide to open a retirement account at your local bank that pays 9%/year/month (9% per year compounded monthly). For the next 20 years, you will deposit $600 per month into the account, with all deposits and withdrawals occurring at month’s end. On the day of the last deposit, you will retire. Your expenses during the first year of retirement will be covered by your company’s retirement plan. As such, your first withdrawal from your retirement account will occur on...
A week from now, you plan to begin saving for your retirement by depositing $200 into...
A week from now, you plan to begin saving for your retirement by depositing $200 into a new savings account that has an expected return of 7.75% compounded monthly. You plan to continue depositing the same amount each week until you retire in 40 years. You expect to make withdrawals from your savings account every year for 35 years after you retire. Assume you were asked to find the amount you will be able to withdraw each year from your...
A year from now, you plan to begin saving for your retirement by making a deposit...
A year from now, you plan to begin saving for your retirement by making a deposit into a new savings account that has an expected return of 7.5% compounded monthly. You plan to continue depositing the same amount each year until you retire in 30 years. You expect to make withdrawals in the amount of $200 from your savings account every week for 45 years after you retire. Assume you were asked to find the amount you will need to...
Question 1 You decide to open a retirement account at your local bank that pays 7%/year/month...
Question 1 You decide to open a retirement account at your local bank that pays 7%/year/month (7% per year compounded monthly). For the next 20 years, you will deposit $400 per month into the account, with all deposits and withdrawals occurring at month’s end. On the day of the last deposit, you will retire. Your expenses during the first year of retirement will be covered by your company’s retirement plan. As such, your first withdrawal from your retirement account will...
You begin saving for retirement at age 25, and you plan to retire at age 70....
You begin saving for retirement at age 25, and you plan to retire at age 70. You want to deposit a certain amount each month into an account that pays an APR of 3% compounded monthly. Make a table that shows the amount you must deposit each month in terms of the nest egg you desire to have when you retire. (Round your answers to the nearest cent.)
Sof ́ıa saves money for retirement. She deposits $150 on the first day of every month...
Sof ́ıa saves money for retirement. She deposits $150 on the first day of every month (starting today) for 30 years in a saving account. Altogether, 360 investments. She plans to retire after 30 years and from that time on she does not invest money anymore, and rather she plans to withdraw a fixed amount of money $Q every month (starting on the first day of the 361st month) for 40 years. Altogether, 480 withdrawals. Assume that the annual interest...
You are planning to make monthly deposits of $190 into a retirement account that pays 7...
You are planning to make monthly deposits of $190 into a retirement account that pays 7 percent interest compounded monthly. If your first deposit will be made one month from now, how large will your retirement account be in 20 years?
You just turned 28 and are now seriously planning for your retirement. You wish to retire...
You just turned 28 and are now seriously planning for your retirement. You wish to retire two years earlier than the mandatory retirement age of 65. You hope to be able to make end-of-month withdrawals from your retirement account of P25,000 per month for a 30-year period after that. Your plan is to fund your retirement by making monthly deposits between now and when you retire. The initial monthly deposit will be made at the end of the coming month....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT