Hi all,
What's the best option, to cash out your retirement for lump sum, or take the monthly payment for life?
rate | 0.02 |
nyear | 20 |
pmt_mo | 3000 |
Total | =B3*B2*12 |
PV | =PV(B1/12,B2*12,-B3) |
Lump sum | 550000 |
Best? | =IF(B6=B5,"Either",IF(B6>B5,"Lump sum","Monthly")) |