Imagine you are 25 years old right now. You would like to retire in 40 years (at age 65). You would like to fund your retirement. You would like to have enough saving to withdraw $50,000 each year in retirement and you want to plan for 20 hears (the last withdrawal is at age 85).
You will earn 7% annually on your saving before you retire. Then once you retire, you will move your nest egg into a safer investment, earning a 3% annual rate of return.
Assume all payments are made at the end of each year (these are all ordinary annuities).
a) How much do you need to have in your nest egg the day you retire (what is the saving goal)?
b) If you wanted to fund your retirement with one lump sum now (at age 25), how much would you have to invest?
c) Instead of investing one large sum today, what would your annual payments have to be for the next 40 years to reach the retirement goal?
a
| PVOrdinary Annuity = C*[(1-(1+i/100)^(-n))/(i/100)] |
| C = Cash flow per period |
| i = interest rate |
| n = number of payments |
| PV= 50000*((1-(1+ 3/100)^-20)/(3/100)) |
| PV = 743873.74 |
b
| Future value = present value*(1+ rate)^time |
| 743873.74 = Present value*(1+0.07)^40 |
| Present value = 49676.17 |
c
| FVOrdinary Annuity = C*(((1 + i )^n -1)/i) |
| C = Cash flow per period |
| i = interest rate |
| n = number of payments |
| 743873.74= Cash Flow*(((1+ 7/100)^40-1)/(7/100)) |
| Cash Flow = 3726.17 |
Imagine you are 25 years old right now. You would like to retire in 40 years...
10. Assume that you are now 25 years old. You would like to retire at age 65 and have a retirement fund of $5,000,000 at the time of your retirement. You have already $50,000 at age 25 in the retirement account. You expect to earn 7% per year. The amount of money you must set aside each month to reach your retirement goal is: A. $4,377.98 B. $1594.18 C. $3500.00 D. $2500.00
You hope to retire in 30 years, when you do, you would like to have the purchasing power of $100,000 today, during each year of retirement. Your cash is needed at the beginning of each year of retirement. Inflation is expected to be 3% per year from now until the end of your retirement. Your retirement will last 25 years, you expect your 401k to earn 5% per year during your retirement years. How much money do you need at...
Suppose you have 25 years until you retire, and that you desire a retirement nest-egg of $2,500,000 on the day you retire. Suppose also that you’ve saved $100,000 toward your retirement so far, and that your investment account earns a nominal rate of 7.5% per year, compounded monthly. In addition, suppose you expect a windfall inheritance of $200,000 five years from now that you will invest in this account. a) What is the effective interest rate, or annual percentage yield,...
Suppose you have 25 years until you retire, and that you desire a retirement nest-egg of $2,500,000 on the day you retire. Suppose also that you’ve saved $100,000 toward your retirement so far, and that your investment account earns a nominal rate of 7.5% per year, compounded monthly. In addition, suppose you expect a windfall inheritance of $200,000 five years from now that you will invest in this account. a) What is the effective interest rate, or annual percentage yield,...
You would like to start saving for retirement and you have 40 years until the planned retirement date. Each year, during your retirement years (assume 30 years), you would like to spend an amount equivalent to the purchasing power of $50,000 today. You estimate that the expected rate of return on some recommended investment portfolio is 8%AER and you plan to select that portfolio during the working (savings) years. Assume 4%AER yield on your investments during retirement years. The annual...
A young couple, both 25 years old, are planning to retire in 40 years at the age of 65. After they retire, they expect to live for an additional 20 years, until age 85. They plan to begin saving for retirement today and based on information from their financial planner, they think they will earn 8% on their investment compounded annually. They think they will earn 5% on their retirement savings after they retire. If they begin at age 25...
It is your 25th birthday (end of 25 years) and you decide that you want to retire on your 65th birthday (end of 65 years - 40 years later). Your salary is $55,000 per year and you expect your salary to increase by 3% each year for the next 40 years. When you retire, you want your retirement fund to provide an annual payment equal to 80% of your salary at age 65 and to increase by 2% a year...
you want a one million dollar nest egg when you retire. At present, you have $30,000 saved and would like to retire in 20 years. to reach your goal, you have arbitrarily chosen to set aside $300 a month towards your goal. if you stay on track with your current plan, assuming an average annual return of 6%, how much will you have saved by retirement?
You plan to work for 40 years and then retire using a 25-year annuity. You want to arrange a retirement income of $4000 per month. You have access to an account that pays an APR of 7.2% compounded monthly. This requires a nest egg of $555,873.10. What monthly deposits are required to achieve the desired monthly yield at retirement? (Round your answer to the nearest cent.) eBook
How to solve this problem in Excel Sheet?
Assume that you are now 35 years old. You would like to retire at age 65 and have a retirement fund of $5,000,000 at the time of your retirement. You have already $100,000 in the retirement account. You expect to earn 6% per year. The amount of money you must set aside each month beginning one month from now to reach your retirement goal is: