Time to Exhaust PV
How long a fund lasts with periodic withdrawals.
When to use: Use for monthly withdrawal plans from retirement or investment accounts.
Formula
Variables
| Symbol | Name | Description | Unit |
|---|---|---|---|
| n | Number of Years | How long fund lasts | years |
| PV | Present Value | Fund balance | $ |
| PMT | Payment | Monthly withdrawal | $ |
| k | Interest Rate | Nominal annual rate | % |
| m | Periods/Year | Withdrawals per year | integer |
Real-Life Examples
Example 1: Monthly Retirement Withdrawals
$500,000 fund, withdraw $3,000/month at 5% monthly compounding.
Given
Step-by-Step
Monthly withdrawals of $3,000 will last about 23.77 years.
Example 2: Emergency Fund Depletion
$50,000 fund, withdraw $2,000/month at 3% monthly compounding.
Given
Step-by-Step
The emergency fund lasts about 2.15 years at $2,000/month.
Frequently Asked Questions
Enter your balance as PV, monthly withdrawal as PMT, annual rate as k, and 12 for m. The formula calculates how many years the fund sustains those monthly withdrawals before running out.
Monthly withdrawals deplete savings slightly faster than an equivalent annual withdrawal because money is removed earlier in the year, reducing the balance that earns interest. However, the difference is usually small.
If your monthly withdrawal is less than the monthly interest earned (PV × k/m), the fund will never run out — it actually grows over time. The formula only produces a finite result when withdrawals exceed interest income.