You plan on retiring in exactly 38 years and you would like to have a retirement fund balance of exactly $1,000,000 at that time. You are convinced

You plan on retiring in exactly 38 years and you would like to have a retirement fund balance of exactly $1,000,000 at that time. You are convinced that you can earn an APR (based on monthly compounding) of 6.54%. If you are making end-of-the-month payments into the account, how much does each one of the payments need to be in order to reach your target? To nearest $0.01

Solutions

Expert Solution

Each monthly payment is calculated using the PMT function:

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

= PMT(6.54%/12,38*12,,-1000000)

= $498.96

Where, rate is periodic rate ,n per is number of periods, fv is future value.

Each one of the payments need to be in order to reach your target will be $498.96.

Junaid answered 1 year ago

Next > < Previous

Related Solutions

You plan to retire in 34 years and would like to have saved $1,000,000 in your...

You plan to retire in 34 years and would like to have saved $1,000,000 in your tax-deferred retirement account. Currently, your balance in your account is zero. As a first pass analysis, assume that you make an annual contribution at the end of each year, starting with the current year. Also, assume that the dollar amount of each contribution is the same. Your investment options are such that you forecast a rate of return of 8% per year over the...

You plan on working for the next 35 years before retiring and you would like to...

You plan on working for the next 35 years before retiring and you would like to accumulate $2 million when you stop working. If you start today, how much will you deposit each month to reach $2 million in retirement? Assume you will average a 7% annual rate of return in deposits will be made at the end of each month.

You plan on retiring in 30 years and want to have $3,000,000 saved in your retirement...

You plan on retiring in 30 years and want to have $3,000,000 saved in your retirement account. You will earn an average rate of return of 6% on your investments. How much will you need to invest each month in order to get to your goal.

Joey plans on retiring in 40 years and would like to have a nest egg of...

Joey plans on retiring in 40 years and would like to have a nest egg of $5,000,000 saved by then. How much do you need to save each month if you can earn a 15% annual return? How much do you need to save each month if you can only earn a 5% annual return? Still working with the 5% annual return, how much do you need to save each month if you wait ten years to start (30 years...

You plan to retire in exactly 20 years. Your goal is to create a fund that...

You plan to retire in exactly 20 years. Your goal is to create a fund that will allow you to receive $20,000 at the end of each year for the next 30 years between retirement and death (a psychic told you that you’d die exactly 30 years after you retire). You know that you will be able to earn 11% per year during the 30-year retirement period. Required: d. Now assume that you will earn 10% from now through the...

You are planning on retiring the moment that you accumulate $1,000,000 in your mutual fund. Currently,...

You are planning on retiring the moment that you accumulate $1,000,000 in your mutual fund. Currently, you have $226,619 in the account, and you pay 1,000 into it monthly. If your account earns 8%, how many years until you can retire? A. 14 B.15 C. 16 D. 17 Eight years ago, you took out a loan for 100,000 at an interest rate of 12% compounded monthly. The loan was for 20 years, and you make monthly payments of $1,101.09 each...

You plan to buy your dream home in 10 years. At that time, you would like...

You plan to buy your dream home in 10 years. At that time, you would like to be able to afford a $400,000 home and put 20% down (pay 20% of the purchase price with your own money), and take out a 30 year mortgage for the rest. You can invest at 9% per year compounded monthly. Assume this will also be the interest rate on the mortgage. a. How much money do you need to save each month for...

John is 37 years old and would like to establish a retirement plan. Develop a spreadsheet...

John is 37 years old and would like to establish a retirement plan. Develop a spreadsheet model that could be used to assist John with retirement planning. Your model should include the following input parameters: John’s current age = 37 years, Johns current total retirement savings = $259,000, Annual rate of return on retirement savings = 4 percent, Johns current annual salary = $145,000, Johns expected annual percentage increase in salary = 2 percent, Johns percentage of annual salary contributed...

I plan to retire in 40 years and live 30 years after retiring.•After retirement I...

I plan to retire in 40 years and live 30 years after retiring. •After retirement I want to be able to withdraw $30,000 each year. •The annual interest rate is 8%.•How much do I need to save each year in the next 40 years? How would you do this on a BAII Plus Calculator?

You would like to have $75,000 in 15 years. To accumulate this amount, you plan to...

You would like to have $75,000 in 15 years. To accumulate this amount, you plan to deposit an equal sum in the bank each year that will earn 8 percent interest compounded annually. Your first payment will be made at the end of the year. a. How much must you deposit annually to accumulate this amount? b. If you decide to make a large lump-sum deposit today instead of the annual deposits, how large should the lump-sum deposit be? ...

Subjects