Calculation guide
For people exploring investment contributions, withdrawals or returns.
Returns are effective annual assumptions. Monthly growth uses (1+r)^(1/12), multiplied by the annual fee factor's monthly equivalent when a separate fee is entered. Start/end timing determines whether the contribution precedes growth. Annual contribution increases apply after each 12 payments. Inflation changes purchasing power, not the nominal account balance. No return is guaranteed. Negative cash flows represent money paid out; positive flows represent money received. Include the final valuation as a positive flow if relevant. IRR uses equal periods; XIRR discounts actual calendar-day differences using ACT/365F. Nonconventional sign-change patterns are reported as potentially ambiguous instead of silently choosing one root. NPV uses the entered discount rate.
Inputs
Date
Date on which this payment or receipt occurs, entered as YYYY-MM-DD.
Amount
Amount for this calculation or dated cash flow. Where negative amounts are allowed, negative means paid out and positive means received.
Worked example
Cash flows
| Date | Amount |
|---|---|
| 2026-01-01 | -100,000 |
| 2027-01-01 | 110,000 |
Formula:
Σ CF_t/(1+r)^((date_t−date₀)/365) = 0
Annualized return = 9.99999999999424%
| Result | Value |
|---|---|
| Annualized return | 10% |
| Net cash flow | 10,000 |
Interpreting the result
Equivalent full-year return after compounding. It differs from a nominal annual rate.
Sum of signed receipts and payments without discounting.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Date (row 1) | 2026-01-01 | 2026-01-02 | Annualized return | 10% | 10.028806% |
| Amount (row 1) | -100,000 | -90,000 | Annualized return | 10% | 22.222222% |
