Question

Assume that you plan to retire in 45 years and that you estimate you will need...

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

Homework Answers

Answer #1

Based on the given data, pls find below workings:

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
Assume that you plan to retire in 40 years and that you estimate you will need...
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...
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?
You plan to retire in 28 years. At the point of retirement, you want to be...
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...
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...
Assume you are now 30 years old. You plan to retire when you are 60 years...
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 that you will retire in 30 years. You plan to be retired for a total...
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 are 30 years old today. You want to retire at the age of 60. You...
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...
You are planning to work for the next 35 years (years 1 – 35) and expect...
You are planning to work for the next 35 years (years 1 – 35) and expect to live in retirement for 40 years after you retire (years 36-75). You believe that you will need $300,000 per year during your retirement. How much will you need to save each year for the 35 years you are working to meet this goal? Assume that the interest rate is 6%.  
Assume you are 40 years old and wish to retire at age 65. You expect to...
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...
Assume your goal is to retire at age 65 and you estimate you will live until...
Assume your goal is to retire at age 65 and you estimate you will live until age 90. Your income at age 30 is $50,000 and you expect this to increase at a rate of 8% per year. The nominal rate of return on your investment portfolio is 6% and you plan to save 15% of your income per year. The expected rate of inflation is 3%. How much will your fund pay per year during your retirement?