calculate investment growth with withdrawals

The Withdrawal Equation: How to Calculate Investment Growth While Taking Income

Introduction

Building an investment portfolio requires discipline and a long-term vision. The final test of that portfolio, however, often comes not during the accumulation phase, but during the distribution phase. This is when you begin to withdraw money, turning abstract numbers into tangible income. Whether you are funding retirement, a sabbatical, or a series of large purchases, understanding how to calculate investment growth with withdrawals is a critical financial skill.

This process moves beyond simple compound interest formulas. It introduces a dynamic and often tension-filled variable: the regular removal of capital. Each withdrawal reduces the principal amount left to compound, creating a complex interplay between growth, time, and cash flow. A miscalculation can lead to a premature depletion of funds, while a sound strategy can ensure financial stability for decades.

We will explore this topic from the perspective of an individual investor managing their portfolio. We will break down the mathematical concepts, provide practical examples, and discuss the strategic implications of different withdrawal patterns. The goal is to equip you with the knowledge to project your portfolio’s longevity under various conditions.

The Foundation: Compound Interest Without Withdrawals

To understand the impact of withdrawals, we must first recall the formula for compound growth without them. The future value (FV) of a single lump-sum investment is calculated as:

\text{FV} = \text{PV} \times (1 + r)^n

Where:

  • PV is the present value or initial principal.
  • r is the periodic interest rate (e.g., annual rate divided by compounding periods).
  • n is the total number of compounding periods.

For regular contributions, the formula expands to the future value of an annuity:

\text{FV} = P \times \frac{(1 + r)^n - 1}{r}

Where P is the periodic contribution.

These formulas assume no capital is removed. Introducing withdrawals changes the calculus entirely.

Calculating Growth with Periodic Withdrawals

When you start taking periodic withdrawals, you are effectively reversing the contribution process. Each withdrawal diminishes the principal base that generates future returns. The order of operations—whether growth happens before or after the withdrawal—matters significantly in the short term.

There are two primary methods for modeling this:

Method 1: Withdrawal at the End of the Period (Most Common)
This method assumes the investment grows throughout the period, and then a withdrawal is taken at the end. The formula to find the remaining balance after n periods is:

\text{Remaining Balance} = \text{PV} \times (1 + r)^n - W \times \frac{(1 + r)^n - 1}{r}

Where W is the withdrawal amount per period.

Example:
Imagine you retire with a portfolio of $1,000,000. You assume an average annual return of 6%. You plan to withdraw $60,000 at the end of each year. What is the portfolio balance after 5 years?

\text{Balance}_5 = \text{\$1,000,000} \times (1 + 0.06)^5 - \text{\$60,000} \times \frac{(1 + 0.06)^5 - 1}{0.06}

First, calculate the growth component:

\text{\$1,000,000} \times (1.3382255776) = \text{\$1,338,225.58}

Second, calculate the withdrawal component:

\text{\$60,000} \times \frac{(1.3382255776 - 1)}{0.06} = \text{\$60,000} \times \frac{0.3382255776}{0.06} = \text{\$60,000} \times 5.63709296 = \text{\$338,225.58}

Finally, subtract the withdrawal component from the growth component:

\text{\$1,338,225.58} - \text{\$338,225.58} = \text{\$1,000,000.00}

This result makes sense. A 6% return on $1 million is $60,000. By withdrawing exactly the annual gain, the principal remains intact. This is a simple but powerful illustration of a sustainable withdrawal rate, at least in a perfectly stable market.

Method 2: Withdrawal at the Beginning of the Period
This method assumes you take the withdrawal first, and then the remaining balance grows. This is more realistic for income planning, as people often need funds at the start of a month or quarter. The formula adjusts to:

\text{Remaining Balance} = (\text{PV} - W) \times (1 + r)^n - W \times \frac{(1 + r)^n - (1 + r)}{r} + W \times (1 + r)

A more intuitive approach is to calculate period-by-period.

Example:
Using the same $1,000,000 portfolio and a $60,000 annual withdrawal, but now taken at the beginning of each year. Let’s calculate the balance after the first year manually.

  1. Start of Year 1: Withdraw $60,000. Balance = $940,000.
  2. End of Year 1: $940,000 grows by 6%. Balance = \text{\$940,000} \times 1.06 = \text{\$996,400}.

The balance is $3,600 lower than the end-of-period withdrawal example. This is because you lost the opportunity for that $60,000 to grow by 6% over the year (\text{\$60,000} \times 0.06 = \text{\$3,600}).

The Critical Concept: Sequence of Returns Risk

The formulas above assume a constant rate of return. Reality is never so kind. The order in which market returns occur—a phenomenon known as the sequence of returns risk—is perhaps the single greatest determinant of portfolio survival during the withdrawal phase.

Two investors with the same average annual return can have vastly different outcomes based on the sequence of those returns.

Illustration:
Two retirees, Alex and Blake, each start with a $1,000,000 portfolio and withdraw $50,000 at the beginning of each year. Both experience the same seven annual returns: -5%, -5%, -5%, 5%, 10%, 10%, 10%. The average return is 3.0% for both. The sequence is different.

Alex’s Returns (Bad Sequence First): -5%, -5%, -5%, 5%, 10%, 10%, 10%
Blake’s Returns (Good Sequence First): 10%, 10%, 10%, 5%, -5%, -5%, -5%

Let’s calculate the outcome for Alex.

YearStarting BalanceWithdrawalBalance After WithdrawalReturnEnding Balance
1$1,000,000$50,000$950,000-5%$902,500
2$902,500$50,000$852,500-5%$809,875
3$809,875$50,000$759,875-5%$721,881
4$721,881$50,000$671,8815%$705,475
5$705,475$50,000$655,47510%$721,023
6$721,023$50,000$671,02310%$738,125
7$738,125$50,000$688,12510%$756,938

Now, let’s calculate the outcome for Blake.

YearStarting BalanceWithdrawalBalance After WithdrawalReturnEnding Balance
1$1,000,000$50,000$950,00010%$1,045,000
2$1,045,000$50,000$995,00010%$1,094,500
3$1,094,500$50,000$1,044,50010%$1,148,950
4$1,148,950$50,000$1,098,9505%$1,153,898
5$1,153,898$50,000$1,103,898-5%$1,048,703
6$1,048,703$50,000$998,703-5%$948,768
7$948,768$50,000$898,768-5%$853,830

Result: Despite identical average returns, Alex’s portfolio finishes at $756,938 while Blake’s finishes at $853,830—a difference of nearly $100,000. The early negative returns crippled Alex’s portfolio because each withdrawal was taken from a shrinking principal, locking in losses and leaving less capital to participate in the subsequent recovery. Blake’s early positive returns provided a buffer that protected him from the later downturns.

This risk is the primary reason financial advisors caution against overly aggressive withdrawal rates, especially in the early years of retirement.

The 4% Rule and Sustainable Withdrawal Rates

The most famous attempt to solve the withdrawal equation is the 4% Rule, born from the 1994 “Trinity Study.” The rule states that a retiree can withdraw 4% of their initial portfolio value in the first year of retirement, and then adjust that dollar amount for inflation each subsequent year, with a high probability of the portfolio lasting 30 years.

Calculation:

\text{First Year Withdrawal} = \text{Initial Portfolio Value} \times 0.04

For a $1,000,000 portfolio, the first-year withdrawal is \text{\$1,000,000} \times 0.04 = \text{\$40,000}.

If inflation is 3% in year one, the second-year withdrawal becomes \text{\$40,000} \times 1.03 = \text{\$41,200}.

The 4% rule is a useful starting point, but it is not a universal law. Its success depends heavily on the asset allocation (stocks vs. bonds) and the market sequence in the first decade of retirement. In today’s environment of lower expected returns and higher valuations, some analysts suggest a 3% or 3.5% initial withdrawal rate is more prudent.

Calculating the Time to Depletion (The “n” Factor)

Sometimes the critical question is not the final balance, but the time until the balance reaches zero. This requires solving for the number of periods n in the withdrawal formula. This calculation is complex and often requires iterative methods or a financial calculator, but we can approximate it.

The formula for the present value of an annuity with withdrawals is:

\text{PV} = W \times \frac{1 - (1 + r)^{-n}}{r}

This formula calculates the initial principal needed to support n withdrawals of amount W at a rate r. We can rearrange this to solve for n, the number of periods until depletion.

n = \frac{-\left(1 - \frac{\text{PV} \times r}{W}\right)}{(1 + r)}

Example:
How long will a $500,000 portfolio last if you need $30,000 per year and expect a 5% annual return?

First, check if the withdrawal amount is feasible: \text{\$500,000} \times 0.05 = \text{\$25,000}. Since $30,000 > $25,000, the portfolio will eventually deplete because you are withdrawing more than the annual growth.

Plug into the formula:

n = \frac{-\left(1 - \frac{\text{\$500,000} \times 0.05}{\text{\$30,000}}\right)}{(1.05)} = \frac{-\left(1 - \frac{\text{\$25,000}}{\text{\$30,000}}\right)}{(1.05)} = \frac{-\left(1 - 0.8333\right)}{(1.05)} = \frac{-(0.1667)}{(1.05)} (0.1667) \approx -1.7918 (1.05) \approx 0.04879

Therefore:

n = \frac{-(-1.7918)}{0.04879} \approx \frac{1.7918}{0.04879} \approx 36.72 \text{ years}

This portfolio would last just over 36 years under these constant assumptions.

Advanced Strategy: Dynamic Withdrawals

The rigid structure of the 4% rule ignores reality. A more robust approach is a dynamic withdrawal strategy that adjusts to market performance. Common methods include:

  1. The Flooring Approach: Establish a base level of essential income covered by reliable sources (Social Security, annuities, bond ladders). The portfolio then only funds discretionary expenses, allowing for flexibility in withdrawal amounts during market downturns.
  2. Percentage of Portfolio: Withdraw a fixed percentage of the portfolio’s value each year. The dollar amount will fluctuate with the market. For example, taking 4% of a $1,000,000 portfolio gives $40,000. If the market drops 20%, the portfolio is worth $800,000, and the withdrawal becomes $32,000. This method ensures the portfolio can never be fully depleted, but income is volatile.
  3. Guardrail Rules: Set upper and lower bounds for withdrawals. If the portfolio performance exceeds expectations, you can give yourself a raise (e.g., a 10% increase in withdrawal amount). If it underperforms, you must take a pay cut (e.g., a 10% decrease). This strategy balances income stability with portfolio sustainability.

Conclusion

Calculating investment growth with withdrawals is not a one-time exercise solved by a single formula. It is an ongoing process of monitoring, adjustment, and risk management. The math provides the framework—the undeniable logic of compounding and its erosion by distributions. However, the uncontrollable variable of market sequence injects a profound element of uncertainty.

The most successful withdrawal strategies are those that embrace flexibility. They acknowledge that the future is unpredictable and that adhering to a rigid spending plan, especially during a bear market, can be a recipe for disaster. By understanding the underlying calculations, the devastating impact of poor early returns, and the spectrum of available strategies, you can move from a state of uncertainty to one of empowered control. You can craft a plan that allows your hard-earned capital to support you for as long as you need it.

Scroll to Top