---
# System prepended metadata

title: XIRR - Endgame
tags: [excel]

---

---
tags: excel
title: XIRR - Endgame
description: We take a look at how XIRR is measured, and reported, in the real world across various financial tools / instruments / platforms
---

# Intro

We've seen what XIRR is, both intuitively and formally. We've also seen how CAGR and XIRR are related, in a special case.

Now it's time to apply our understanding of XIRR, in evaluating XIRR of common financial instruments we deal with as investors.

# Mutual Fund Portfolios

It's typical of most Indian investors to end up with a mutual fund portfolio, sometimes even unknowingly.

Plenty of platforms and portfolio management apps offered by

- AMCs (**A**sset **M**anagement **C**ompany),
- RTAs (**R**egistrar or **T**ransfer **A**gent, e.g. MyCAMS, KFinTech etc.), 
- RIAs (**R**egistered **I**nvestment **A**dvisor, e.g. ETMoney, Groww, INDMoney, Kuvera, PayTM Money etc.),
- AMFI distributors (Scripbox, FundsIndia, Wealthy.etc.)
- Data aggregator portals (Moneycontrol, Morningstar, Valueresearchonline, CRED etc.)

have XIRR result in-built within their portfolio display sections.

Most of the time one won't have to compute it themselves, given a typical mutual fund portfolio.

However, it doesn't hurt to just be able to do it on your own. In fact, it's quite trivial.

We'd take the same set of CSV transactions that we'd used in one of our previous chapters. But ideally, you should use your own portfolio's CSV export



