Average Return Calculator

How to use the average return calculator

This tool supports two related but distinct methods. The dated cash-flow method estimates the annual rate that makes the present value of all deposits, withdrawals, and ending proceeds balance to zero. It is a money-weighted return, so both the size and timing of cash flows affect the answer. The multiple-period method chains a sequence of holding-period returns and converts the combined result into one annualized geometric rate.

Dated cash-flow inputs

Starting balance is the account value at the beginning of the measurement window and is required. A higher starting balance, with every other input unchanged, generally lowers the calculated return because more initial capital was required to produce the same ending value. Use the market value of the full account, not only the amount originally deposited.

Start date fixes when the starting balance is invested. It must be earlier than every relevant ending date. Even small date changes can move the annualized result when the measurement window is short, because the calculation uses actual calendar-day spacing.

Ending balance is the account value on the ending date and is required. Increasing it raises the return; lowering it reduces the return and can produce a negative result. Do not also enter the ending balance as a withdrawal, because that would double-count the same proceeds.

Ending date must be later than the start date. A longer period typically reduces the annualized rate needed to explain a given total gain, while a shorter period increases it.

Deposits and withdrawals are optional dated activities. A deposit is additional capital added to the account and therefore works against the investment return. A withdrawal is cash received from the account and works in favor of the return. Enter the absolute amount and select the activity type rather than typing a negative number. Each cash-flow date should fall inside the start and ending dates. Common mistakes include omitting a large contribution, reversing a withdrawal and deposit, or using a trade date instead of the date the cash actually entered or left the account.

Multiple return-period inputs

Return is the total percentage gain or loss for one holding period, not an annual rate unless that row covers exactly one year. For example, enter 12% for a period in which value rose from 100 to 112. A return may be negative, but not −100% or lower because the compounded value would be zero or negative.

Years and months describe how long that row’s return took to occur. At least one of them must be positive. Months are converted to twelfths of a year. A longer holding length gives that row more influence on the annualized result because the same gain spread over more time implies a lower yearly pace.

Understanding the results

Annualized return is the headline measure. In dated cash-flow mode it is an XIRR-style money-weighted return. In multiple-period mode it is the constant compounded annual rate that would create the same final growth over the total holding length. Positive values indicate growth; zero means no economic gain after accounting for timing; negative values indicate a loss.

Cumulative return measures total growth across the full period without annualizing it. In cash-flow mode the displayed cumulative figure compares investment gain with net contributed capital. In multiple-period mode it is the exact chained result of all entered returns. Cumulative return is useful for understanding the whole journey, but it is less suitable for comparing investments held for different lengths of time.

Net contributions equal the starting balance plus deposits minus withdrawals. Investment gain equals the ending balance plus withdrawals minus the starting balance and deposits. These two totals provide a practical cross-check: ending wealth and cash taken out should reconcile with the capital put in and the gain earned.

Analysis span reports the elapsed years. In multiple-period mode the table also shows the growth factor after each row. A factor of 1.25 means a hypothetical unit of capital has grown by 25% since the first period.

How the model works

The dated method solves for the rate r that makes the sum of each cash flow divided by (1 + r) raised to its fraction of a year equal zero. Because irregularly timed cash flows do not produce a simple closed-form solution, the calculator uses a bounded numerical root search and rejects cases with no economically valid sign change. This is conceptually aligned with spreadsheet XIRR calculations.

The multiple-period method multiplies each growth factor, such as 1.12 for a 12% return, to obtain a cumulative growth factor. It then raises that factor to the reciprocal of the total years and subtracts one. This geometric method preserves compounding and avoids the distortion caused by a simple arithmetic average.

Reading the chart and table

In dated cash-flow mode, bars show deposits and distributions at their dates while the line tracks cumulative investor capital. In return-period mode, the line shows how a hypothetical $10,000 changes after each entered period. The legend and audit table use the same underlying model values as the headline result and the Excel workbook.

Practical cautions

• Compare annualized returns only when the underlying risk, fees, taxes, and liquidity are reasonably similar.
• Use actual account values after fees when evaluating realized performance.
• Do not interpret a high historical return as a forecast or guarantee.
• Check that every material external cash flow is included exactly once.

For broader background, see the U.S. Securities and Exchange Commission’s explanations of annual return and compound growth, FINRA’s guide to rates of return, and Microsoft’s documentation for the XIRR function. This calculator is educational and does not provide investment, tax, or legal advice.