Lump sum now | PV | $155000 | |
Payment starting now | Pmt_now | 0 | $/payment |
Interest rate | i | 5.50% | /yr |
number of years until annuity begins | n | 19 | yr |
number of payments/year | freq | 20 | /yr |
When payments are made for each n | type | 0 | 0 = at end, 1 = at start |
Future Value | FV | $440095 | |
|
Interest generated by Future Value | FV(i,n,P) * i | 1210 | $/payment |
Longevity of future annuity | L | 25 | yr |
Constant withdrawal of FV over time L | Pmt_future | 1621 | $/payment |
|
Spending growth rate (e.g., CPI) | g | 2.0% | /yr |
First year (of 25) Trinity-style withdrawal | W(FV,L,i,g) | 26446 | $/yr |
| | 1322 | $/payment |
See rows 70-90 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.