logo

Products

Logo

Dhan App

Stock Market App built for Super Traders & Long Term Investors.

Logo

Dhan Web

Web Trading Platform for those who love to trade from the big screen.

Logo

Options Trader App

Option Trading App built especially for India's F&O Traders.

Logo

Options Trader Web

Option Trading Platform to build, analyze, & execute F&O trades.

Logo

Trade from tv.dhan.co

Trade with TradingView Chart features for FREE on tv.dhan.co.

Logo

Connect to TradingView

Connect Dhan to TradingView - Place orders from tradingview.com

Logo

DhanHQ Trading APIs

Trade with Algo, Connect Apps, Build Services using APIs for FREE.

Logo

smallcases on Dhan

Build wealth with smallcase investment for FREE on Dhan.

Logo

Margin Trading Facility

Get 4X Leverage on 1700+ stocks. Trade Now, Pay Later.

Logo

ScanX Stock Screener

50+ Readymade Screeners, Live Market Insights & Instant Trade Execution.

Logo

Rent Stocks via SLBM

Earn up to 35% p.a. over & above your portfolio holdings!

PricingOpen Demat Account at ₹0 AMCBecome a PartnerCustomer ServiceDhan SupportDhan Blog
fuzz
Logo
MadeForTrade CommunityIndicator by Dhan

Download the App Now!

raise
raise
Home
CalculatorsXIRR Calculator

XIRR Calculator

The XIRR calculator is a simple tool for investors to calculate the annualised rate of return for investments that have irregular cash flows ..Read More

Calculate your XIRR:

Start Date
Maturity Date
Recurring Investment Amount (₹)
₹ 100
₹ 5,00,000

Total Maturity Amount (₹)
₹ 10,000
₹ 10,00,00,000

Investment Amount
₹ 0
Returns
₹ 4,50,000
📊

What is XIRR?

XIRR, or Extended Internal Rate of Return, is a financial metric that is used to calculate the annualised rate of return of an investment that involves multiple cash flows at irregular intervals. ​Unlike traditional methods, which assume consistent investments, XIRR takes into account the exact timing and quantity of each cash flow (whether an investment or withdrawal). ​It helps in assessing the performance of Systematic Investment Plans (SIPs) and other investments where investments and withdrawals are not uniform.

This makes it a highly accurate tool to evaluate investments where contributions may not be of the same amount and frequency. ​It offers a single rate of return that, when applied to all transactions, gives the current value of the investment, which is a realistic measure of the investment performance.

For investors, understanding XIRR is important to compare various investment options and make informed decisions while investing in mutual funds or directly investing in stocks through SIPs.

Also it is advised to estimate your monthly SIP's according to your goals using an Online SIP Calculator.

How does the XIRR calculator work?

An XIRR calculator simplifies the complex process of finding the Extended Internal Rate of Return for investments with irregular cash flows. ​Instead of having to solve iterative calculations manually, which can be time-consuming and prone to errors, the online XIRR calculator automates this process.

Investors enter the dates of the cash flows (both investments and withdrawals), as well as their amounts. ​Investments are entered as negative values (cash outflows), and withdrawals or current valuations are entered as positive values (cash inflows).

The calculator then makes use of an underlying formula that seeks the discount rate at which the Net Present Value (NPV) of all these cash flows are zero. ​This discount rate is the XIRR and is expressed as an annualised percentage. ​The timing of each cash flow is critical, as XIRR considers the exact dates in order to give a true picture of the time value of money rather than simpler return calculations.

By instantaneously calculating this rate, the online XIRR calculator gives investors a comprehensive and accurate picture of their investment’s performance, allowing them to make informed decisions without having to understand the complex mathematical computations involved.

XIRR vs IRR vs CAGR: What’s the difference?

XIRR, IRR and CAGR are all metrics used to assess investment returns, but they differ in their application and the type of cash flows they take into consideration. ​Understanding the differences between XIRR, IRR and CAGR is crucial to accurately evaluate investment returns.

ParameterCAGRIRRXIRR
Cash Flow PatternSingle investment, single redemptionMultiple cash flows at regular intervalsMultiple cash flows at irregular intervals
Date SensitivityOnly start and end datesAssumes equal periods between flowsUses exact calendar dates
Calculation MethodDirect formulaIterative algorithmIterative algorithm (more complex)
Accuracy for SIPsInaccurateAccurate if dates are uniformMost accurate
Accuracy for Multiple TransactionsCannot handleLimited (only uniform periods)Fully accurate
Best for Indian InvestorsLump sum trackingTheoretical/planned SIPsReal-world investing
Excel/Sheets FunctionNo built-in (manual formula)=IRR(values)XIRR(values, dates)
Use CaseFD, PPF, one-time mutual fundProject evaluationMutual fund SIPs, stocks
Handles Irregular AmountsNoYes, but assumes regular timingYes, with exact dates

Features of the online XIRR calculator

For Indian investors, there are several features that are accessible through the online XIRR calculator. Here’s what it offers:
  1. Precise return calculations: It calculates the exact return on investment by considering the time and amount of each investment or cash inflow.
  2. Handles irregular cash flows: It stands out in cases of investments whose contributions or withdrawals are irregular.
  3. Versatility about investment type: This method is not just restricted to irregular SIPs; you may use it for mutual funds, stocks, bonds, etc.
  4. Annualised return for easy comparison: By using the XIRR calculator, you can easily compare the returns on your various investments.
  5. User-friendly interface: The online XIRR calculator tool has a user-friendly interface, which means you can use it without the need for financial knowledge.
  6. Comparison tool: Investors can use the calculated XIRR to compare the performance of multiple investment options to determine which ones are generating better returns.
  7. Supports financial planning: By offering a clear picture of investment growth, XIRR can help investors set financial goals that are realistic and track progress towards those goals.

How to use the XIRR calculator?

Using an online XIRR calculator is a simple process. It helps investors calculate the actual annualised return on their investments. The steps involved in the process are as follows:
Enter dates and cash flows
Start by entering the date of all financial transactions. ​For each date, indicate how much money you invested (cash outflow) or withdrew (cash inflow). ​In the XIRR calculator, the investments are entered as negative values, and the redemptions or the current portfolio value are entered as a positive value.
Submit data
Once all the relevant transaction dates and amounts are entered, click on the calculate button. ​The XIRR calculator will then process the data, applying the XIRR formula based on the timing and amount of the individual cash flows.
Interpret the results
These results will be shown on the calculator as a percentage, which will be the annualised rate of return for the investment. ​A higher XIRR means a higher performance. ​This percentage gives a complete understanding of how the investment has been performing, taking into account all the irregularities in making or withdrawing the investment transactions.
Use for decision-making
The XIRR calculation can be used by investors to make investment choices in the future. ​For example, when investors are comparing the XIRR of various investments, they can assess which investments are performing the best and adjust their strategy accordingly.

XIRR formula explained (With a simple example)

The XIRR formula assists in determining the rate r that will satisfy the following equation:

NPV = Σ [CFᵢ / (1 + r)^(dᵢ/365)] = 0

Where:
CFi = Cash Flow in transaction i (Negative for investments, positive for redemptions/current value)
r = XIRR
dᵢ = Number of days between the first cash flow date and transaction i
365 = Number of days in a year (for annualisation)

This formula cannot be solved algebraically and requires the use of iterative numerical methods. Let's understand this with the help of practical examples. Consider an investor who makes the investments on the following dates:
  • 01-Jan-2025 (Investment): -₹10,000
  • 01-July-2025 (Investment): -₹5,000
  • 01-Jan-2025 (Investment): -₹7,000
  • Redemption date/Current Value: 12-Feb-2026:- +₹25,000
  • Total Investment: ₹22,000
  • Current Value: ₹25,000
  • Absolute Gain: ₹3,000 (13.63% simple return)

However, this 13.63% return is misleading because it doesn't take into consideration the duration of the investment. The first amount of Rs. 10,000 was invested for about 12 months, while the last amount was invested for 1 month only.

Through iterative calculation, the XIRR is about 19.99%. This 19.99% XIRR is much more meaningful than the 13.63% simple return because it:
  • Accounts for the time when each transaction was made
  • Annualises the return so that it is easy to compare with other investments
  • Gives a true picture of how the investment has performed over time

When should you use XIRR?

XIRR is an indispensable tool for investors who deal with investment portfolios involving multiple irregular transactions over a period of time. It gives them the most accurate picture of the true annualised return of their investments, which is often not the case with traditional CAGR or IRR.
You should use XIRR for the following purposes primarily:
  • Systematic investment plans (SIPs): If you make regular investments of a fixed or variable amount into mutual funds or stocks at different intervals, XIRR is the best metric to calculate the overall portfolio return.
  • Systematic withdrawal plans (SWPs): For retirees or individuals who are withdrawing their income from their investments at different times, XIRR is a suitable indicator for calculating exact returns by taking into account these periodic outflows.
    You can also use a SWP calculator to calculate the withdrawal amount while keeping investments intact.
  • Lump sum investments with partial withdrawals: If you have made a large initial investment and then withdraw some of it at different dates, XIRR will compute the effective rate of return on the remaining capital and the period it was invested.
  • Multiple lump sum investments: When you make multiple lump sum investments into the same fund or stock at different points in time, XIRR combines all these investments into one so that you can have an accurate return figure.
  • Portfolio performance evaluation: For a diversified portfolio in which you may be rebalancing or adding funds or selling off assets at irregular times, XIRR gives you a holistic measure of your overall portfolio's performance.
  • Comparing irregular investments: When comparing two different investment options, both of which have irregular cash flows, XIRR makes it possible to have an apples-to-apples comparison of their actual annualised returns, making it easier to identify which is a better performer.
  • Long-term investment analysis: For long-term investors, XIRR takes into account every fluctuation in the market and what you do over the years, giving you a real measure of your investment's efficiency

In essence, whenever the timing and amounts of your cash flows are not perfectly regular, XIRR is the most reliable metric to gauge your investment's real-world performance.

How to calculate XIRR in Excel or Google Sheets

Calculating XIRR in Excel or Google Sheets is a common way among investors and is an effective method without evolving complexities. ​Both applications contain an inbuilt XIRR function, making this process relatively simple without having to do the calculations manually. Here's a step-by-step approach to calculating XIRR in Excel or Google Sheets:
  • Add the data in two columns, one for Dates and one for Cash flows.
  • In the Dates column, enter all of the dates of the transactions in chronological order.
  • In the Cash Flows column, put in the respective amounts.
  • Remember to indicate investments as negative numbers and redemptions/current value as positive numbers.
  • Include the current value of your investment as a positive cash flow on today's date (or the date you wish to calculate the XIRR up to).
Data Setup
DateCash Flow
01-Jan-2025-₹10,000
01-July-2025-₹5,000
01-Jan-2026-₹7,000
12-Feb-2026+₹25,000
  • Apply the XIRR function: Choose an empty cell in which you want to calculate the result of the XIRR.
  • The syntax is: =XIRR(values, dates,)
  • values: This refers to the range of cells with your cash flows (e.g. B2:B5).
  • dates: This is your range of cells that have your corresponding dates (e.g. A2:A5)
  • Then the formula would be =XIRR(B2:B5, A2:A5)
  • After entering the details, press Enter, then the XIRR is calculated and shown as a decimal value (e.g. 0.1999) by Excel.
  • Format the decimal value as a percentage by multiplying it by 100. The XIRR will be 19.99%

banner

Common XIRR mistakes

While XIRR is a powerful tool, there are some common mistakes to watch out for that could result in inaccurate results or misinterpretations. Some of these mistakes are:
Incorrect sign convention
The most common mistake is to assign the wrong positive or negative signs to the cash flows. All money that has been invested or paid out (e.g. SIP instalments, lump sum deposits) should be entered as negative numbers. All money received (i.e. withdrawals, redemptions, and current portfolio value) must be positive. Reversing these signs yields a completely incorrect XIRR.
Missing the current value
For ongoing investments, many users forget to include the current market value of their investment as a positive cash flow with today's date (or the date up to which the calculation is desired). Without this last cash flow, the calculator assumes the investment is over with zero value, resulting in a distorted, often negative, XIRR.
Incorrect dates
XIRR's accuracy depends on accurate dates. Using approximate dates or not entering the dates in chronological order can skew the result. Make sure to add each cash flow along with its exact date of the transaction.
Confusing XIRR with CAGR for irregular investments
It is a big mistake to use CAGR for investments that have multiple, irregular cash flows. CAGR can be used only for a single initial investment and a single final value, without considering all the transactions in between. XIRR is the right measure for SIPs and other dynamic investments with irregular transactions at various intervals.
Short-Term XIRR misinterpretation
Although XIRR gives an annualised rate, interpreting it over very short periods (e.g., a few months) can be misleading. Annualised returns are more meaningful and stable for longer investment horizons, because short-term fluctuations in the markets can cause significant changes in the initial XIRR calculations.

By avoiding these common pitfalls, investors can take advantage of the full power of the XIRR calculator to gain a true understanding of their investment performance.




Invest & Trade with a Trading
Platform That's #MadeForTrade

Open your Dhan Account in minutes!
Start Now
border
logo

Join our Community

community logo

Follow us on

twitter
telegram
Linkedin
youtube
instagram
facebook

built with love
for Indians who love to invest & trade

raise

We are part of Raise Financial Services

raise
raise

Explore  |  Sitemap


*All securities mentioned on this website are exemplary and not recommendatory.

*Current prices on the website are delayed by 15 mins, login to check live prices.

We are bullish on India, we are bullish on India's prospects to be one of the largest economies in the world. We believe that the stock market provides a unique opportunity for all of India's traders and investors to participate in the growth story of the country.

Yet, most investing & trading platforms in India have remained more or less the same over the past decade. Times have changed and retail traders and investors have become smarter about managing their trades and money. Modern traders & investors require an online trading platform that helps them keep up with the technological advancements of our time.

That's why we're building Dhan - to help you trade, to help you invest, and to help you participate in India's growth stock via the stock market with awesome features and an incredible experience.

We are doing so by giving you access to not just one but 6 products within the Dhan ecosystem:


This means that with Dhan, you'll be able to start:


Lakhs of users already trust Dhan for their online stock trading and investing needs. Dhan is growing rapidly because of the love we receive from SuperTraders and Long-Term Investors who acknowledge that the platform is innovating for them, building super useful features that help them do everything from investing in stock market to trading F&O like a pro on the Tradingview charts and much more.

While we are growing, we will always remember why we started building in the first place - you. Our user-first approach will always be at the heart of our philosophy. Come join us on this incredible journey!

Try it out, you can close your account at anytime using this link.

©2021-2026 Raise Securities Private Limited (formerly Moneylicious Securities Private Limited). All rights reserved. CIN: U74999MH2012PTC433549 Raise Securities is part of Raise Financial Services.

SEBI Stock Broker Registration No: INZ000006031 | Depository Participant (CDSL) ID: IN-DP-289-2016 | SEBI Research Analyst Registration No: INH000023357
Exchange Membership No. : NSE: 90133 | BSE: 6593 | MCX: 56320
Registered & Corporate Office: Unit No. 2201, 22nd Floor, Gold Medal Avenue, S.V. Road, Beside Patel Petrol Pump, Piramal Nagar, Goregaon West, Mumbai – 400104, Customer Care: 9987761000.

Details of client bank account

For any query / feedback / clarifications, email at help@dhan.co.

In case of grievances for any of the services rendered by Raise Securities Private Limited, please write to grievance@dhan.co (for NSE, BSE and MCX) or grievancedp@dhan.co (for Depository Participant). Please ensure that you carefully read the Risk Disclosure Document as prescribed by SEBI, our Terms of Use and Privacy Policy. Compliance Officer: Mr. Manish Garg and Mobile: 8655740961 Email: complianceofficer@dhan.co To lodge your complaints using SEBI SCORES, click here.


Disclaimer: All communications with the client via chat, phone, or email are for support purposes only. Any commitments or statements made by the agent (human or virtual) shall not be binding on the company.


DHAN is a brand owned by Raise Securities Private Limited. All DHAN clients are registered under Raise Securities Private Limited. Clients are advised to refer to our company as Raise Securities Private Limited when communicating with regulatory authorities.


Procedure to file a complaint on SEBI SCORES: Register on SCORES portal. Mandatory details for filing complaints on SCORES: Name, PAN, Address, Mobile Number, E-mail ID. Benefits: Effective Communication, Speedy redressal of the grievances. You may refer the website https://scores.sebi.gov.in/ for more information. You may also download the SEBI Scores app to log a complaint Android: https://play.google.com store apps sebiscores iOS: https://apps.apple.com app sebiscores.


Disclaimer: Investment in the securities market are subject to market risks, read all the related documents carefully before investing. Brokerage will not exceed the SEBI prescribed limit


Attention investors:

  1. Stock brokers can accept securities as margins from clients only by way of pledge in the depository system w.e.f September 01, 2020.
  2. Update your e-mail and phone number with your stock broker / depository participant and receive OTP directly from depository on your e-mail and/or mobile number to create pledge.
  3. Check your securities / MF / bonds in the consolidated account statement issued by NSDL/CDSL every month.

Note: As a policy we do not give stock tips or recommendations and have not authorized anyone to give this on behalf of us. If you know anyone claiming to be a part of Dhan / / Raise or our associate companies or partners and offering such services, please report us on help@dhan.co. Important Information for Investors: To prevent unauthorized transactions in your trading / demat account, do not share your account details, credentials or any personal details with anyone. Keep your mobile number updated with your Stock Broker, Depository Participant and ensure that the same is registered with Stock Exchanges, Depository and KRAs. You will receive alerts and information on your registered mobile number / email for debit and other important transactions in your demat account directly from CDSL / Exchange on the same day. KYC is one time exercise while dealing in securities markets - once KYC is done through a SEBI registered intermediary (Stock Broker, DP, Mutual Fund, etc.), you need not undergo the same process again when you approach another intermediary. No need to issue cheques by investors while subscribing to IPO. Just write the bank account number and sign in the application form to authorise your bank to make payment in case of allotment. No worries for refund as the money remains in investor's account. This is issued in the interest of investors.


Investors should be cautious on unsolicited emails and SMS advising to buy, sell or hold securities and trade only on the basis of informed decision. Investors are advised to invest after conducting appropriate analysis of respective companies and not to blindly follow unfounded rumours, tips etc. Further, you are also requested to share your knowledge or evidence of systemic wrongdoing, potential frauds or unethical behaviour through the anonymous portal facility provided on BSE & NSE website. Issued in the interest of the investors.


Raise Securities Private Limited also known as Dhan is only an order collection platform that collects orders on behalf of clients and places them on BSE StarMF for execution. Client expressly agrees that Dhan is not liable or responsible and does not represent or warrant any damages regarding non- execution of orders or any incorrect execution of orders with regard to the funds chosen by the client or due to, but not being limited to, any link/system failure, delay in transfer of the funds on account of any unforeseen circumstances/issues in the banking system/payment aggregators or any other problems that may result in a delay in crediting the funds into the BSE Star MF's bank account. Raise Securities Private Limited (Dhan) does not engage in proprietary trading on its own account.


Mutual fund investments are subject to market risks, read all scheme related documents carefully before investing. Dhan is not a distributor or agent of any mutual fund. Mutual Funds are not exchange-traded products. Any related disputes will not have access to the Exchange-investor redressal forum or arbitration mechanism. For other disclaimers please refer https://dhan.co/advertisement-disclaimer/


Download client registration documents (Rights & Obligations, Risk Disclosure Document, Do's & Don'ts) in vernacular language: BSE | NSE | MCX


Kindly, read the Advisory Guidelines of BSE | NSE | MCX for investors as prescribed by the exchange with reference to their circular dated 27th August, 2021 regarding investor awareness and safeguarding client's assets


Important Links: SEBI | BSE | NSE | MCX | CDSL | SCORES | ODR Portal | Investor Charter for Stock Brokers | Investor Charter for DP | Investor Charter for Research Analyst | UCC Advisory | e-Voting for Shareholders | NCL Client Collateral details |
MCXCCL Client Collateral details

Important Information: Terms of Usage | Disclaimers | Privacy Policy | Grievances | Grievances RA | Risk Management Policy | Risk Disclosure | Advertisement Disclaimer | Referral Terms & Conditions | Saarthi 2.0 Mobile App for Investors