Question

In: Finance

Uma turned 25 today, that she plans to retire on her 65 th birthday , and...

Uma turned 25 today, that she plans to retire on her 65 th birthday , and that s he expects to live until her 8 0 th birthday . On her 65th birthday, she wants $ 90,000 and wants that amount to increase by 2 % every year until h er 80th birthday. In other words, she wants to make a withdrawal from her 65th birthday until her 80 th ( including her 80th birthday ). So far, she has managed to save $ 40,000 (until today ) and that money is earning an interest rate of 7% compounded annually . She wants to put additional equal amount of deposit from h er 26th birthday until her 64th birthday in the same account. Given this , how much must she should deposit every year to meet her retirement goal?

A) $2,381.99

B) $3,233.53

C) $2,171.88

D) $2,548.73

E) $1,823.34

Solutions

Expert Solution

First of all we calculate the required PV of the annuity :

Birthday Time line from 64th Bday Cashflow req PV @ 7% from 64th Bday PV
65 1 90000 0.934579439 84112.15
66 2 91800 0.873438728 80181.68
67 3 93636 0.816297877 76434.87
68 4 95508.72 0.762895212 72863.15
69 5 97418.8944 0.712986179 69458.33
70 6 99367.2723 0.666342224 66212.61
71 7 101354.618 0.622749742 63118.56
72 8 103381.71 0.582009105 60169.1
73 9 105449.344 0.543933743 57357.46
74 10 107558.331 0.508349292 54677.2
75 11 109709.498 0.475092796 52122.19
76 12 111903.688 0.444011959 49686.58
77 13 114141.762 0.414964448 47364.77
78 14 116424.597 0.387817241 45151.47
79 15 118753.089 0.36244602 43041.58
80 16 121128.15 0.338734598 41030.3
PV at 64th Bday 962982
PV at 25th Bday (962982/1.07^39) 68809.88
Money Already saved 40000
PV of Annuity 28809.88

Now the PV of the annuity is $28809.88. Interest Rate is 7% and the annuity is for 39 payments. (Starting 26th Bday till 64th Bday).

So as on 25th Bday we can say that,

$2880988 = X/1.07 + X/1.07^2 +X/1.07/3 ............X/1.07^38 + X/1.07^39.

Solving the equation, (We can use a financial cal as well with pv = $28809.88, irr = 7%, n = 39, cpt - PMT),

We get , X = $2171.88 (Ans)

Ans: The deposit every year to meet the retirement goal is $2171.88


Related Solutions

Cathy Kung, 25, plans to retire at the age of 65. She estimates that she will...
Cathy Kung, 25, plans to retire at the age of 65. She estimates that she will need $50,000 in the first year of her retirement, and this post-retirement expenditure will increase at the rate of inflation of 2% per year. Based on her family history, she does not expect to live beyond the age of 90. After retirement, she will invest her money in bank deposits with an expected rate of return of 4% per year. Her post-retirement marginal tax...
Cathy Kung, 25, plans to retire at the age of 65. She estimates that she will...
Cathy Kung, 25, plans to retire at the age of 65. She estimates that she will need $50,000 in the first year of her retirement, and this post-retirement expenditure will increase at the rate of inflation of 2% per year. Based on her family history, she does not expect to live beyond the age of 90. After retirement, she will invest her money in bank deposits with an expected rate of return of 4% per year. Her post-retirement marginal tax...
Today is Sofia’s 35th birthday. She plans to retire in 32 years at the age of...
Today is Sofia’s 35th birthday. She plans to retire in 32 years at the age of 67, with expected life expectancy of 30 years after that. To maintain her life style, she thinks she will have to withdraw $8,000 from retirement account at the beginning of each month during retirement. Meanwhile, she plans to donate $100 to charity starting on her 70th birthday, and the monthly payment will continue till she passes away. In addition, she would like to establish...
Ms. Smith plans to retire in 25 years (she will be 65). The IRS longevity table...
Ms. Smith plans to retire in 25 years (she will be 65). The IRS longevity table forecasts that Ms. Smith will live to be 85 years old. Ms. Smith is expected to have 20 years in retirement. Ms. Smith needs to be able to withdraw $60,000 annually (end of each year) from her retirement investment account before the balance is fully used. This plus her $35,000 annually in social security benefits will serve her needs (she believes). During her 20...
Suppose that you just turned 25, plan to retire at 65, and estimate that you will...
Suppose that you just turned 25, plan to retire at 65, and estimate that you will need $10,141 per month at the end of each month upon retirement for the next 30 years. How much do you need to contribute at the end of each month until you reach age 60? Assume your estimated return is 8.5% EAR, that you have $10,000 already invested, and the funds will continue to earn interest to age 65, even though you will not...
Suppose that you just turned 25, plan to retire at 65, and estimate that you will...
Suppose that you just turned 25, plan to retire at 65, and estimate that you will need $9,471 per month at the end of each month upon retirement for the next 30 years. How much do you need to contribute at the end of each month until you reach age 50? Assume your estimated return is 6.2% EAR, that you have $10,000 already invested, and the funds will continue to earn interest to age 65, even though you will not...
Your friend Ellen is celebrating her 25th birthday (i.e., she is 25 today) and wants to...
Your friend Ellen is celebrating her 25th birthday (i.e., she is 25 today) and wants to start saving for her anticipated retirement at age 55. She wants to be able to withdraw $10,000 from her savings account on each birthday for 10 years following her retirement (the first withdrawal will be on her 56th birthday). Ellen intends to invest her money in the local saving bank, which offers 8% (EAR) interest per year. Suppose Ellen wants to make 24 deposits...
Today is Janet’s 23rd birthday. Starting today, Janet plans to begin saving for her retirement. Her...
Today is Janet’s 23rd birthday. Starting today, Janet plans to begin saving for her retirement. Her plan is to contribute $1,000 to a brokerage account each year on her birthday. Her first contribution will take place today. Her 42nd and final contribution will take place on her 64th birthday. Her aunt has decided to help Janet with her savings, which is why she gave Janet $10,000 today as a birthday present to help get her account started. Assume that the...
GIVEN: Francis Frugal has just turned 65 and is about to retire. She has $1,500,000 in...
GIVEN: Francis Frugal has just turned 65 and is about to retire. She has $1,500,000 in her bank account and plans to live on $76,500 per year. Please show the equations. Not on Excel. A.    If she lives to age 95, what is the minimum rate of return she needs to earn during retirement? B.   Oh no! Her three bachelor sons all suddenly lost their jobs and have to move back in with her. Poor Francis will have to spend...
Katie and Ryan would both like to retire at age 60. a) Katie turned 25 today....
Katie and Ryan would both like to retire at age 60. a) Katie turned 25 today. She would like to retire at age 60. If she starts investing $5,000 annually starting one year from now, with her last investment made on her 60th birthday, how much will she have at age 60 if she earns 5% compounded annually on her money? Show/explain your work. b) Ryan turned 30 today. He would like to retire at age 60. If he starts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT