How it's calculated
B is the balance, r is the annual rate divided by 12 and W is the monthly withdrawal, taken at the end of the month. If B is less than W, the last withdrawal is what is left.
Assumptions
- The balance grows monthly at one-twelfth of the annual rate.
- The withdrawal is the same every month and taken at the end of the month.
- Taxes, charges and inflation are not included.
Worked example
10 lakh rupees growing at 12% a year (1% a month) with 10,000 withdrawn every month stays at 10 lakh: each withdrawal equals that month’s growth.
Questions
Why does the balance sometimes rise?
If the monthly growth is larger than the withdrawal, the balance grows even while you withdraw.
Is the return certain?
No. Market-linked returns vary and can be negative, and a fall early on reduces what is left for later. Try lower rates too.
Does this include tax on withdrawals?
No. Tax depends on your country and product. Enter a lower return or a higher withdrawal to allow for it.