Question

In: Finance

Sally Prescott plans on retiring in 15 years, that is, she will work for another 15...

Sally Prescott plans on retiring in 15 years, that is, she will work for another 15 full years. When she retires she plans on spending 3 years in Bulgaria volunteering for the Peace Corps. After which she will spend her time in Boca Raton, Florida at a townhouse she purchased 5 years ago for $250,000. She currently has $100,000 in savings. She estimates that she will need $20,000 a year for living expenses in Bulgaria and then $35,000 a year for approximately 20 years when she retires to Florida. If she earns 4% compounded monthly in her savings account, how much must she deposit each year to meet her financial goals? She will withdraw her annual cash flows at the beginning of each year, that is, her first $20,000 withdrawal will occur at the beginning of year 16, before she travels to Bulgaria. Her annual deposits will begin at the end of this year and continue until she leaves for Bulgaria.

Solutions

Expert Solution

EAR = [(1 +stated rate/no. of compounding periods) ^no. of compounding periods - 1]* 100
? = ((1+4/(12*100))^12-1)*100
Effective Annual Rate% = 4.0742
PVAnnuity Due = c*((1-(1+ i)^(-n))/i)*(1 + i )
C = Cash flow per period
i = interest rate
n = number of payments
PV= 20000*((1-(1+ 4.0742/100)^-3)/(4.0742/100))*(1+4.0742/100)
PV = 57681.83
PVAnnuity Due = c*((1-(1+ i)^(-n))/i)*(1 + i )
C = Cash flow per period
i = interest rate
n = number of payments
PV= 35000*((1-(1+ 4.0742/100)^-20)/(4.0742/100))*(1+4.0742/100)
PV = 491804.07
Future value = present value*(1+ rate)^time
491804.07 = Present value*(1+0.040742)^3
Present value = 436277.56

total amount needed just before retirement = 436277.56+57681.83=493959.39

Future value = present value*(1+ rate)^time
Future value = 100000*(1+0.040742)^15
Future value = 182031.36

Amount to be financed by yearly deposit = 493959.39-182031.36=311928.03

FVOrdinary Annuity = C*(((1 + i )^n -1)/i)
C = Cash flow per period
i = interest rate
n = number of payments
311928.03= Cash Flow*(((1+ 4.0742/100)^15-1)/(4.0742/100))
Cash Flow = 15492.33

Related Solutions

Sally Prescott plans on retiring in 15 years, that is, she will work for another 15...
Sally Prescott plans on retiring in 15 years, that is, she will work for another 15 full years. When she retires she plans on spending 3 years in Bulgaria volunteering for the Peace Corps. After which she will spend her time in Boca Raton, Florida at a townhouse she purchased 5 years ago for $250,000. She currently has $100,000 in savings. She estimates that she will need $20,000 a year for living expenses in Bulgaria and then $35,000 a year...
Sasha just turned 55 years old today and plans on retiring in 20 years on her...
Sasha just turned 55 years old today and plans on retiring in 20 years on her 75th birthday. She would like to withdraw money from her retirement account on her birthday each year until she dies. She would like to withdraw $80,000 on her 75th birthday, and increase her withdrawals 6% each year through her 89th birthday. She expects to die on her 90th birthday, at which time she would like to leave $300,000 to her granddaughter. Sasha currently has...
Joey plans on retiring in 40 years and would like to have a nest egg of...
Joey plans on retiring in 40 years and would like to have a nest egg of $5,000,000 saved by then. How much do you need to save each month if you can earn a 15% annual return? How much do you need to save each month if you can only earn a 5% annual return? Still working with the 5% annual return, how much do you need to save each month if you wait ten years to start (30 years...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally,...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally, Mike would like to retire with $1,000,000.00. (Input all answers as positive values, no commas, with no symbols ex. no $ or %. Input all % answers as whole numbers without symbols ex. 10.03 for .1003. Input all final answers two decimal places out.) How much would Mike have to deposit on an annual basis to reach his goal if he can get a...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally,...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally, Mike would like to retire with $1,000,000.00. (Input all answers as positive values, no commas, with no symbols ex. no $ or %. Input all % answers as whole numbers without symbols ex. 10.03 for .1003. Input all final answers two decimal places out.) How much would Mike have to deposit on a monthly basis to reach his goal if he can get a...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally,...
Mike is currently 35 years old and plans on retiring at the age of 65. Ideally, Mike would like to retire with $1,000,000.00. (Input all answers as positive values, no commas, with no symbols ex. no $ or %. Input all % answers as whole numbers without symbols ex. 10.03 for .1003. Input all final answers two decimal places out.) If Mike can only find an annual return of 8% compounded on a monthly basis and can only deposit $400...
Mike is currently 35 years old and plans on retiring at the age of 65 ideally...
Mike is currently 35 years old and plans on retiring at the age of 65 ideally Mike would like to retire with one million dollars. a. How much would Mike have to deposit on an annual basis to reach his goal if he can get return of 12% compounded annually.? b. How much would mike deposit on a monthly basis to reach his goal if he can get a return of 10% compounded monthly? c. If mike can find an...
Problem: Jonathan and Beth plan on retiring in 15 years. They have made progress on their...
Problem: Jonathan and Beth plan on retiring in 15 years. They have made progress on their retirement portfolio (they currently have $100,000 in their 401ks + IRAs), but need to do more. Recognizing their lack of planning they have come to you for help in determining how much they need to save annually to produce an inflation-adjusted equivalent of $50,000 per year paid at the beginning of each your over 20 years of retirement. Moreover, they would like to leave...
Problem: Jonathan and Beth plan on retiring in 15 years. They have made progress on their...
Problem: Jonathan and Beth plan on retiring in 15 years. They have made progress on their retirement portfolio (they currently have $100,000 in their 401ks + IRAs), but need to do more. Recognizing their lack of planning they have come to you for help in determining how much they need to save annually to produce an inflation-adjusted equivalent of $50,000 per year paid at the beginning of each your over 20 years of retirement. Moreover, they would like to leave...
Sally lives in town with an ongoing pandemic. If she goes to work, theres a probability,...
Sally lives in town with an ongoing pandemic. If she goes to work, theres a probability, p, of getting infected by the virus that is causing the epidemic, where 0 < p < 1. If she stays at home, she can't be infected and will not earn income. Suppose when she goes to work and does not get infected, she will earn $50. If she gets infected he will lose $80 in health care cost, but will still earn an...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT