Retiring at age 60, how much money would I need to have at retirement if I wanted a yearly withdrawal of $60,000 for the next 30 years to travel the world and live comfortably. The anticipated interest rate is 7% and the current value is $100k. Additionally, what would be the monthly payment to achieve that goal for retirement in 32 years?
Calculation of amount of money you need to have at retirement:
Rate = 7%
Nper = 30
PMT = 60000
FV = 0
The amount of money you need to have at retirement can be
calculated by using the following excel formula:
=PV(rate,nper.pmt,fv)
=PV(7%,30,-60000,0)
= $744,542.47
The amount of money you need to have at retirement = $744,542.47
Calculation of monthly payment:
Rate = 7% / 12
Nper = 32 * 12 = 384
FV = $744,542.47
PV = $100,000
Monthly payment can be calculated by using the following excel
formula:
=PMT(rate,nper,pv,fv)
=PMT(7%/12,384,100000,-744542.47)
= $1,174.58
Get Answers For Free
Most questions answered within 1 hours.