Lump sum now | PV | $32000 | |
Payment starting now | Pmt_now | 0 | $/payment |
Interest rate | i | 5.0% | /yr |
number of years until annuity begins | n | 15 | yr |
number of payments/year | freq | 12 | /yr |
When payments are made for each n | type | 0 | 0 = at end, 1 = at start |
Future Value | FV | $67639 | |
|
Interest generated by Future Value | FV(i,n,P) * i | 282 | $/payment |
Longevity of future annuity | L | 25 | yr |
Constant withdrawal of FV over time L | Pmt_future | 395 | $/payment |
|
Spending growth rate (e.g., CPI) | g | 2.0% | /yr |
First year (of 25) Trinity-style withdrawal | W(FV,L,i,g) | 3853 | $/yr |
| | 321 | $/payment |
See rows 73-94 of the 'Misc. calcs' tab in the case study spreadsheet (http://forum.mrmoneymustache.com/forum-information-faqs/case-study-spreadsheet-updates/) to enter your numbers.