At 5.4% you'll run out of money about age 88.
PV = $177,000
Current age = 54
Age payment start = 65
Monthly benefit = $2,000
Annual rate of return = 5.4%
$177,000 will grow to $315,660 in 11 years at 5.4%.... $177,000*(1+5.4%)^11 = $315,660
$315,660 will support $2,000/month payments for ~23 years.... = nper(5.4%/12,2000,-315660) ~ 276 months = 23 years, + 65 = 88.
__________________
If something cannot endure laughter.... it cannot endure.
Patience is the art of concealing your impatience.
Slow and steady wins the race.
Retired Jan 2012 at age 56
|