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 period of time until you retire.

What is your required annual contribution (before taxes), based on these forecasts?

Round your answer to the nearest dollar.

Solutions

Expert Solution

Solution :

Following points need to be kept in mind while calculating :-

1. Nper is the total number of payment periods in an annuity.

2. Pmt is the payment made each period and cannot change over the life of the annuity.

3. Pv is the present value that the future payment is worth now. Pv must be entered as a negative amount.

4. Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0

5. Type is the number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0 which represents at the end of the period. If payments are due at the beginning of the period, type should be 1.

Keeping the above points in mind refer below attached image in excel for calculation.

Given below is the year wise schedule with figures rounded off.

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

You plan to retire in 28 years. You would like to maintain your current level of...

You plan to retire in 28 years. You would like to maintain your current level of consumption which is $57,316 per year. You will need to have 25 years of consumption during your retirement. You can earn 4.01% per year (nominal terms) on your investments. In addition, you expect inflation to be 2.96% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 6 years, in nominal terms...

You plan to retire in 24 years. You would like to maintain your current level of...

You plan to retire in 24 years. You would like to maintain your current level of consumption which is $30,471 per year. You will need to have 24 years of consumption during your retirement. You can earn 6.67% per year (nominal terms) on your investments. In addition, you expect inflation to be 4.33% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 8 years, in real terms...

You plan to retire in 23 years. You would like to maintain your current level of...

You plan to retire in 23 years. You would like to maintain your current level of consumption which is $51,594 per year. You will need to have 29 years of consumption during your retirement. You can earn 5.27% per year (nominal terms) on your investments. In addition, you expect inflation to be 2.06% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 10 years, in nominal terms...

You plan to retire in 29 years. You would like to maintain your current level of...

You plan to retire in 29 years. You would like to maintain your current level of consumption which is $50,301 per year. You will need to have 23 years of consumption during your retirement. You can earn 5.16% per year (nominal terms) on your investments. In addition, you expect inflation to be 2.83% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 15 years, in nominal terms...

You plan to retire in 22 years. You would like to maintain your current level of...

You plan to retire in 22 years. You would like to maintain your current level of consumption which is $52,558 per year. You will need to have 34 years of consumption during your retirement. You can earn 4.4% per year (nominal terms) on your investments. In addition, you expect inflation to be 2.09% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 12 years, in nominal terms...

You plan to retire in 20 years. You would like to maintain your current level of...

You plan to retire in 20 years. You would like to maintain your current level of consumption which is $48,795 per year. You will need to have 23 years of consumption during your retirement. You can earn 5.97% per year (nominal terms) on your investments. In addition, you expect inflation to be 3.64% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 7 years, in real terms...

You plan to retire in 27 years. You would like to maintain your current level of...

You plan to retire in 27 years. You would like to maintain your current level of consumption which is $55,465 per year. You will need to have 25 years of consumption during your retirement. You can earn 4.89% per year (nominal terms) on your investments. In addition, you expect inflation to be 2.28% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 17 years, in nominal terms...

You plan to retire in 24 years. You would like to maintain your current level of...

You plan to retire in 24 years. You would like to maintain your current level of consumption which is $34,386 per year. You will need to have 25 years of consumption during your retirement. You can earn 6.33% per year (nominal terms) on your investments. In addition, you expect inflation to be 4.84% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 8 years, in real terms...

You plan to retire in 22 years. You would like to maintain your current level of...

You plan to retire in 22 years. You would like to maintain your current level of consumption which is $57,156 per year. You will need to have 33 years of consumption during your retirement. You can earn 4.79% per year (nominal terms) on your investments. In addition, you expect inflation to be 2.82% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 8 years, in nominal terms...

You plan to retire in 22 years. You would like to maintain your current level of...

You plan to retire in 22 years. You would like to maintain your current level of consumption which is $41,709 per year. You will need to have 24 years of consumption during your retirement. You can earn 6.57% per year (nominal terms) on your investments. In addition, you expect inflation to be 4.98% inflation per year, from now and through your retirement. How much do you have to invest each year, starting next year, for 10 years, in real terms...

Subjects