How to Calculate Portfolio Returns: XIRR, CAGR, and Real Examples

Why portfolio return calculation is harder than it looks

Checking today's portfolio value against total money invested feels intuitive — but that number mixes timing, cash flows, and market luck into one misleading figure. If you invested ₹5 lakh in January and ₹5 lakh in December before a year-end rally, a simple gain percentage credits the entire book for returns only the later tranche enjoyed.

Professional investors separate cash flow timing from market performance using annualized metrics. For personal portfolios with irregular SIPs, bonuses, redemptions, and dividend reinvestments, XIRR (Extended Internal Rate of Return) is the standard answer.

Understanding how to calculate portfolio returns correctly helps you compare funds, evaluate advisors, and judge whether your strategy works — independent of how much you contributed each month.

Four return metrics investors should know

Absolute return: terminal value minus total invested. If you invested ₹8 lakh and hold ₹10 lakh, absolute gain is ₹2 lakh (25% on capital deployed — but undated). Useful for quick snapshots, insufficient for comparing periods.

CAGR (Compound Annual Growth Rate): measures smooth annual growth between two points assuming a single starting investment. Formula: CAGR = (Ending Value / Beginning Value)^(1/years) − 1. Works for lump sums with no intermediate flows.

XIRR: annualized return accounting for dated cash flows — investments and withdrawals. Essential for SIPs, staggered bonuses, and partial exits. Excel's XIRR function and portfolio platforms compute this iteratively.

Time-weighted return (TWR): strips out cash flow timing to judge manager skill. More relevant for mutual fund factsheets than personal books unless you want to isolate your decision quality from deposit timing luck.

When to use XIRR vs CAGR

Use CAGR when you made one investment and held without additions or withdrawals — a fixed deposit style lump sum in a single stock or fund for exactly three years, for example.

Use XIRR when reality intrudes: monthly SIPs, occasional top-ups, SWP withdrawals, or selling half a position to fund an expense. That describes most Capitallytics users.

Misapplying CAGR to SIP books systematically misstates performance — usually flattering late bull markets and punishing early bear entries. XIRR aligns annualized return with when money actually entered the market.

How XIRR works (without heavy math)

XIRR finds the discount rate that makes net present value of all cash flows equal zero. You do not need to solve this by hand — tools handle iteration. Conceptually: it answers, "What fixed annual return would replicate my deposits, withdrawals, and ending value?"

Inputs required: every cash flow amount and date. Investments are negative flows (money leaving you), withdrawals and current market value are positive flows. Missing a ₹25,000 bonus investment date can shift XIRR by full percentage points.

Capitallytics tracks holdings and market values centrally, reducing manual cash-flow reconstruction. For forensic accuracy after irregular trades, export trade history from brokers and verify dates quarterly.

Step-by-step: calculate XIRR in a spreadsheet

Step 1 — List every cash flow with exact dates. Example: 01-Apr-2024: −₹1,00,000 investment; 01-Oct-2024: −₹50,000; 01-Apr-2025: +₹1,80,000 current value (treated as final inflow if you liquidated today).

Step 2 — Use =XIRR(values, dates) in Excel or Google Sheets. Ensure dates are valid and at least one negative and one positive flow exist.

Step 3 — Interpret as annualized return. An XIRR of 11.4% means your timed contributions compounded equivalent to 11.4% per year to reach today's value.

Step 4 — Sanity check against absolute gain. Large absolute profit with modest XIRR suggests money was invested late. Small absolute profit with high XIRR may mean early success on little capital.

Worked example: SIP portfolio in INR

Imagine ₹10,000 monthly SIP into an equity fund for 12 months — ₹1,20,000 total — with current value ₹1,35,000 after one year. Simple return = 12.5% absolute, but XIRR accounts for each installment's time in market and will typically differ from dividing profit by total invested.

If the market rallied in month 11, later installments contributed less growth; XIRR captures that. If you also withdrew ₹20,000 in month 8 for an emergency, XIRR incorporates the partial exit — simple gain math would not.

Run the same scenario in Capitallytics calculators for SIP projections, then compare live portfolio XIRR once holdings are linked. Gap between plan and reality teaches more than any textbook.

Common calculation mistakes

Mistake 1 — Dividing total profit by total invested without annualizing or dating flows.

Mistake 2 — Ignoring withdrawals, dividends taken as cash, or internal transfers between brokers.

Mistake 3 — Mixing currencies without conversion dates. US stock gains must use INR values at flow dates for Indian investors measuring local purchasing power.

Mistake 4 — Using purchase price after corporate actions without adjusting for splits, bonuses, or mergers.

Mistake 5 — Comparing XIRR on a 9-month portfolio to a fund's advertised 5-year CAGR. Match time horizons and methods.

Portfolio return metrics comparison table

Metric | Best for | Limitation — Absolute gain: quick P&L check | ignores timing and annualization. CAGR: single lump-sum multi-year hold | invalid with SIPs/withdrawals. XIRR: personal portfolios with irregular flows | needs accurate dates; sensitive to short periods. TWR: comparing fund managers | complex for DIY multi-broker books.

Practical rule: track XIRR for your total portfolio quarterly, CAGR for individual lump-sum legacy holdings, and absolute gain for goal progress (e.g., ₹50 lakh target by 2030).

Calculating returns across multiple brokers

Zerodha equity, Groww mutual funds, and a US broker account each report returns differently. Consolidated portfolio XIRR requires merging all cash flows into one timeline — another reason scattered apps mislead.

Import CSV or PDF statements into Capitallytics, unify holdings, and let live marks feed total portfolio value. Manual sheets fail here because investors forget old accounts or stale rows.

External references: Microsoft Excel XIRR documentation, CFA Institute materials on performance measurement, and AMFI factsheet definitions for fund CAGR — useful cross-checks for methodology.

Period returns: 1M, YTD, 1Y, since inception

Beyond annualized figures, period returns show recent momentum. A healthy 5-year XIRR can coexist with a negative 3-month return — both are true, serving different decisions.

Define periods consistently. YTD should use Jan 1 market value (or first available mark) through today. Since-inception XIRR needs first deposit date, not account opening date if funding lagged.

Capitallytics investment performance views help monitor period P&L without rebuilding pivot tables weekly.

Using returns data to improve decisions

Return metrics diagnose process; they do not predict next quarter. High XIRR on a concentrated crypto bet signals risk taken as much as skill demonstrated.

Compare returns against a relevant benchmark: Nifty 50 for large-cap India exposure, MSCI World for global equity sleeves, or a blended benchmark matching your policy allocation.

When underperformance persists for multiple years versus benchmark after fees, revisit fund selection or allocation — not just contribution amounts.

Automating return tracking

Manual XIRR quarterly is educational once; tedious forever. Portfolio trackers should compute performance whenever prices refresh. Capitallytics updates valuations from market data providers and surfaces period analytics on dashboard load.

Pair automated tracking with annual manual verification: reconcile broker statements, confirm corporate actions, and archive year-end snapshots for tax planning.

Automation fails if imports are incomplete. Schedule a quarterly "account sweep" to add new folios or brokers before trusting consolidated returns.

Actionable tips for accurate performance measurement

Maintain one consolidated tracker — treat Capitallytics as source of truth for total book performance.

Record every withdrawal and lump sum with dates, not just purchases.

Compare XIRR to appropriate benchmarks, not random headline indices.

Use at least 12 months of data before drawing strong conclusions from annualized figures.

Separate goal tracking (absolute ₹ targets) from efficiency tracking (XIRR).

Conclusion

Learning how to calculate portfolio returns with XIRR transforms vague "I think I did okay" into evidence. The method respects when you invested, how much you withdrew, and what you hold today — the only fair standard for real-world portfolios.

Capitallytics combines SIP calculators, live portfolio tracking, and performance analytics so you spend less time in spreadsheets and more time improving allocation decisions. Start free, import your holdings, and review your true annualized return this month.

Try Capitallytics' free portfolio tracker and investment analytics platform — built for investors who want clarity across Indian and global markets.