Safe Withdrawal Amount
Calculate how much you can withdraw from a portfolio each year and each month using the 4% rule in Google Sheets.
=portfolio_value * 0.04 How It Works
The safe withdrawal amount converts your portfolio into spendable income. The classic approach multiplies your portfolio by 4% (the “4% rule”) to get a year-one withdrawal amount. That amount then increases with inflation each subsequent year.
Syntax
Annual withdrawal:
=portfolio_value * withdrawal_rateMonthly withdrawal:
=portfolio_value * withdrawal_rate / 12Example
Portfolio: $800,000
Annual withdrawal (4%):
=$800,000 * 0.04 = $32,000Monthly withdrawal:
=$32,000 / 12 = $2,667Withdrawal Amounts by Portfolio Size
| Portfolio | 3% Rate | 3.5% Rate | 4% Rate | 4.5% Rate |
|---|---|---|---|---|
| $300,000 | $9,000 | $10,500 | $12,000 | $13,500 |
| $500,000 | $15,000 | $17,500 | $20,000 | $22,500 |
| $750,000 | $22,500 | $26,250 | $30,000 | $33,750 |
| $1,000,000 | $30,000 | $35,000 | $40,000 | $45,000 |
| $1,500,000 | $45,000 | $52,500 | $60,000 | $67,500 |
| $2,000,000 | $60,000 | $70,000 | $80,000 | $90,000 |
Variations
Inflation-Adjusted Withdrawal (Year 2+)
After the first year, adjust for inflation rather than recalculating from portfolio value:
=previous_year_withdrawal * (1 + inflation_rate)Example - Year 1 through 5 at 3% inflation:
| Year | Annual Withdrawal | Monthly |
|---|---|---|
| 1 | $32,000 | $2,667 |
| 2 | $32,960 | $2,747 |
| 3 | $33,949 | $2,829 |
| 4 | $34,967 | $2,914 |
| 5 | $36,016 | $3,001 |
Variable Percentage Method
Withdraw a fixed percentage of current portfolio each year (income fluctuates):
=current_portfolio_value * withdrawal_rateThis naturally adjusts - less in down years, more in up years.
Including Other Income Sources
=desired_annual_spending - social_security - pension - other_incomeThe result is how much you actually need from your portfolio.
Example:
- Want: $55,000/year
- Social Security: $22,000
- Need from portfolio: $33,000
- Portfolio needed at 4%: =33000/0.04 = $825,000
Setting Up a Withdrawal Calculator
| A | B |
|---|---|
| Portfolio Value | $800,000 |
| Withdrawal Rate | 4% |
| Inflation Rate | 3% |
| Social Security | $20,000 |
| Pension | $0 |
| Annual from Portfolio | =B1*B2 |
| Total Annual Income | =B6+B4+B5 |
| Monthly Income | =B7/12 |
| Year 2 Withdrawal | =B6*(1+B3) |
| Year 5 Withdrawal | =B6*(1+B3)^4 |
Pro Tips
-
A 3.5% rate provides more margin for retirements longer than 30 years
-
Tracking essential vs discretionary spending helps identify flexibility
-
Some retirees hold 1-2 years of expenses in cash to avoid selling during downturns
-
Recalculate after big market moves - worth reviewing your withdrawal amount if your portfolio changes significantly
-
Factor in taxes - a $40,000 withdrawal from a traditional 401(k) is less than $40,000 after taxes
Common Errors
- Applying 4% every year to current balance - the classic rule applies 4% once (year one) then adjusts for inflation
- Forgetting taxes - gross withdrawal and net spending are different amounts
- Ignoring other income - Social Security, pensions, and part-time work reduce what you need from the portfolio
- Using the wrong rate for early retirement - 3-3.5% is often more appropriate for retirements starting before age 55