01
02
03
04
05
CAGR
—
Think from the portfolio's point of view. Money flowing in to the portfolio (investments, deposits) are inflows. Money flowing out (withdrawals, final value) are outflows. XIRR finds the annualised rate that balances them.
01
02
Deposit = cash coming into the portfolio — inflow (+).
Withdraw = cash going out of the portfolio — outflow (−).
The final portfolio value is the last outflow — the portfolio pays you back.
03
What the portfolio is worth on the closing date — as if it pays everything back to you. This is the final outflow.
01
Each row = one cash flow, from the portfolio's point of view. Positive = inflow (investment, deposit into portfolio). Negative = outflow (withdrawal or the final portfolio value on end date).
COLUMN MAPPING
Pick which columns hold the date and amount. Positive = inflows into portfolio (investments). Negative = outflows (withdrawals, final value).
XIRR
—