Free calculator
SWP calculator
Systematic Withdrawal Plans (SWP) take a fixed amount from an invested corpus on a regular schedule—often discussed with mutual funds and retirement income. Enter a starting corpus, your monthly or quarterly withdrawal, an expected annual return you choose, and a horizon in years plus months. We show ending balance, total withdrawn, and net change with end-of-month timing on the balance path—illustration math for Sheets and Excel, not a quote or tax tool.
When to use this calculator
A focused withdrawal story with transparent assumptions—fast checks before you build a fuller workbook.
- See whether a steady withdrawal rate lasts your horizon with one long-run return assumption.
- Compare monthly vs quarterly withdrawal timing on the same headline return (see methodology for quarter-end rules).
- Copy a month-by-month column layout into Sheets or Excel after you align rate, N, and cash-flow signs with the section below.
We keep one growth path on the balance: monthly compounding using the same monthly growth factor family as the SIP and compound interest calculators. Withdrawals are post‑growth within each month.
Monthly SWP
Each month applies (1 + r/12) on the balance, then subtracts up to the monthly withdrawal amount (never below zero—if the balance cannot fund the full withdrawal, only the available post‑growth amount is taken).
Quarterly SWP
Same monthly growth steps on the balance; a quarterly withdrawal posts only at the end of months 3, 6, 9, … after that month’s factor, mirroring quarterly SIP installment timing.
What we do not model
Step‑up or inflation‑linked withdrawals, tax on redemptions (including India LTCG/STCG), loads, NAV cut‑off timing, weekly/yearly cadence, XIRR, or live fund data—use a full workbook or official tools when you need those layers.
Past performance does not guarantee future results. For arbitrary compounding picks and contribution charts, use the compound interest calculator. For regular investing instead of withdrawals, use the SIP calculator. To layer an expense ratio on the same corpus story, use the mutual fund calculator. For ages and retirement contributions, use the retirement savings calculator.
Google Sheets & Excel
There is no single FV cell for net withdrawals each month while the balance also grows—match this page by building month columns: starting balance → multiply by (1 + annualRate/12) for that month’s growth → subtract the scheduled withdrawal (capped so the balance never goes negative in the sheet). Repeat for each month through your horizon.
In German Excel, use ; separators and localized function names—Formulas → Insert function for your language pack.
Frequently asked questions
What is an SWP calculator?
It estimates how a starting corpus evolves when you take regular withdrawals (monthly or quarterly) while the remainder stays invested at an expected annual return you type in. SWP is widely used for mutual fund income plans in some markets; the math here is a generic periodic withdrawal illustration.
How is SWP different from SIP?
SIP adds money on a schedule; SWP removes it. This site uses the same monthly growth factor on the balance for both tools, with end-of-month cash flows—compare the methodologies side by side.
How does quarterly SWP timing work on this page?
We still grow the balance with the same monthly factor as the monthly SWP path. Your quarterly amount is taken only at the end of every third month (months 3, 6, 9, …) after that month’s growth.
How is this different from the compound interest calculator?
The compound interest tool is the general engine with contribution knobs and charts. This page is an SWP‑shaped shortcut: withdrawals instead of deposits, monthly compounding on the balance, and copy geared to systematic withdrawal wording.
When should I use the mutual fund calculator instead?
Use the mutual fund page when you want the same balance story plus an annual expense ratio field to illustrate ongoing fee drag. This SWP page keeps fees out of v1—lower the return line if you want a quick net approximation.
Do you model Indian capital gains tax or TDS on SWP?
No. This is a currency‑agnostic illustration—not LTCG/STCG rules, not TDS, and not NAV cut‑off timing. Use local tax tools when those details matter.
Do withdrawals increase with inflation?
Not in v1. For a constant percent story on purchasing power, see the inflation calculator as a separate illustration—do not assume this page escalates your withdrawals automatically.
How do I match this in Google Sheets or Excel?
Model one row per month: grow the prior ending balance by (1+annualRate/12), subtract the withdrawal (or 0 when your story skips a month), carry the new balance forward. FV alone is easy to misapply when both growth and changing net flows apply each month.
Is this investment advice?
No. It is a free educational tool—not a recommendation to start, stop, or change any withdrawal plan, and not a substitute for qualified professionals when stakes are high.