Question

In: Finance

Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65.

Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first 10 years, she contributes $3,000 per year. She increases the contribution rate to $5,000 per year in years 11 through 20. This is followed by increases to $10,000 per year in years 21 through 30 and to $15,000 per year for the last ten years. This money earns a 9 percent return.

First compute the value of the retirement plan when she turns age 65. (Do not round intermediate calculations and round your final answer to 2 decimal places.)


Solutions

Expert Solution

CASE 1

CALCULATE FOR FIRST TEN YEARS = FV =(RATE,NPER,PMT,[PV],TYPE)

RATE= 9% , NPER = 10, 3000, PV=0,TYPE=0 , SUBSTITUTING THIS IN EXCEL FORMULA,

FV=(.09,10,-3000,0,0) = $45,578.79 , THIS AMOUNT WILL ATTRACT 9% FOR REST OF 30 YEARS = FV=PV(1+R)^T , FV = VALUE AT 10TH YEAR = $45,578.79 , R = 0.09, T= 30YEARS

FV=45578.79(1.09)^30 = $604724.73

2ND CASE : AT THE AGE OF 35, FOR NEXT 10 YEARS ,CONTRIBUTES $5000,

PUTTING IN FV FORMULA, FV =(RATE,NPER,PMT,[PV],TYPE) , WE LL GET = FV(0.09,10,-5000,0,0) = 75964.65

AND FV FOR NEXT 20 YEARS = FV=PV(1+R)^T , HERE PV = 75964.65, T = 20 , R = 0.09

FV= 75964.65*(1.09)^20 = $425737.1024

3RD CASE, AT THE AGE OF 45, FOR NEXT 10 YEARS ,CONTRIBUTES $10000,

PUTTING IN FV FORMULA, FV =(RATE,NPER,PMT,[PV],TYPE),WE LL GET = FV(0.09,10,-10000,0,0) =$151929.30

AND FV FOR NEXT 10 YEARS = FV=PV(1+R)^T , HERE PV =151929.30 , T = 10 , R = 0.09

FV =151929.30*(1.09)^10 = $359671.90

4TH CASE AT THE AGE OF 55, FOR NEXT 10 YEARS ,CONTRIBUTES $15000,

PUTTING IN FV FORMULA, FV =(RATE,NPER,PMT,[PV],TYPE),WE LL GET = FV(0.09,10,-15000,0,0)

= $227893.95

SO, TOTAL VALUE AT THE AGE OF 65 = CASE1 + CASE 2 + CASE 3 + CASE 4

= $604724.73 + $425737.1024 + $359671.90+ $227893.95

FINAL VALUE AT AGE OF 65 = $1618027.68


Related Solutions

Consider a person who begins contributing to a retirement plan at age 25 and contributes for...
Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first ten years, she contributes $3,000 per year. She increases the contribution rate to $5,000 per year in years 11 through 20. This is followed by increases to $10,000 per year in years 21 through 30 and to $15,000 per year for the last ten years. This money earns a 9 percent return. Compute the...
Consider a person who begins contributing to a retirement plan at age 25 and contributes for...
Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first ten years, she contributes $3,700 per year. She increases the contribution rate to $5,700 per year in years 11 through 20. This is followed by increases to $10,700 per year in years 21 through 30 and to $15,700 per year for the last ten years. This money earns a return of 10 percent. First...
Problem 5-57 Spreadsheet Problem (LG2, LG9) Consider a person who begins contributing to a retirement plan...
Problem 5-57 Spreadsheet Problem (LG2, LG9) Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first ten years, she contributes $2,300 per year. She increases the contribution rate to $4,300 per year in years 11 through 20. This is followed by increases to $9,300 per year in years 21 through 30 and to $14,300 per year for the last ten years. This money earns...
You are 40 years old today and want to plan for retirement at age 65. You...
You are 40 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 95 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $70,000 has today. You plan on withdrawing the money starting the day you retire. You have $15,000 saved for retirement today. Inflation...
You are 47 years old today and want to plan for retirement at age 65. You...
You are 47 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 87 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $73,868 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement....
If you start contributing to your retirement account at the age of 18 with $25 a...
If you start contributing to your retirement account at the age of 18 with $25 a month and you increase your contributions by $5 each year, how much will you be contributing a month at the age of 40?
You plan on retiring in 40 years at age 65.  You currently have $20,000 (graduation present) that...
You plan on retiring in 40 years at age 65.  You currently have $20,000 (graduation present) that you are going to deposit today in a bond that will yield 10% a year for the entire 40 years (traditional IRA).  At age 40 you will receive an inheritance from your parents of approximately $20,000 which you will invest in mutual funds that will yield 9% a year for 25 years (Traditional IRA).  The current discount rate is 5.5%, the risk-free rate is 3% and...
Suppose that you are age 25 today and plan on retiring at age 65. You determined...
Suppose that you are age 25 today and plan on retiring at age 65. You determined that you need to have saved $659,754 in real dollars by the time you retire. How much must you contribute (in real dollars) each year to your retirement account to achieve your goal? Assume the following: you make annual contributions; each contribution is the same amount in real dollars; the first contribution will be one year from today; your last contribution will be at...
Steven is contributing to his 401(k) retirement plan. He contributes $3100 per year. His employer matches...
Steven is contributing to his 401(k) retirement plan. He contributes $3100 per year. His employer matches 50% of his contribution. If Steven can earn a 6% rate of return, how much (approximately) will he have in his account after 6 years?(Round your answer). $18433. $32435. $30806. $28572.
1. The 25 year old invests $2,000 a year until the age of 65 The 35...
1. The 25 year old invests $2,000 a year until the age of 65 The 35 year old invests $2,000 a year until the age of 65 We’ll assume they both get the same rate of return on their dollar, in this example we’ll use 8%. Where will each of them be when they reach the age of 65? What is the difference in the two investment choice? Place the difference between the two $ amounts as your final answer....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT