Stock XIRR Calculator
The Stock XIRR Calculator helps investors calculate the annualized return on a stock investment when money is invested or withdrawn on different dates. Unlike a simple return percentage, XIRR considers the exact timing of each cash flow, making it useful for investments involving multiple purchases, sales, dividends, or partial withdrawals.
How to Use the Stock XIRR Calculator
Enter each stock cash flow with its transaction date and amount. Treat money invested in the stock as a negative cash flow and money received from selling shares, dividends, or the final portfolio value as a positive cash flow. Add all relevant transactions, then calculate XIRR to get the annualized return.
Stock XIRR Formula
XIRR is calculated by finding the annual rate of return that makes the net present value of all dated cash flows equal to zero.
0 = Σ [Cash Flowᵢ / (1 + r)^((Dateᵢ − Date₀) / 365)]
Here, r is the XIRR, Cash Flowᵢ is the amount of each investment or withdrawal, Dateᵢ is the date of that cash flow, and Date₀ is the date of the first cash flow. The calculator uses an iterative numerical method to find the rate r.
Example
Suppose an investor buys shares for ₹1,00,000 on 1 January 2025 and receives ₹1,20,000 from the investment on 1 January 2026. The cash flows are -₹1,00,000 on 1 January 2025 and +₹1,20,000 on 1 January 2026. Because the period is one year, the XIRR is approximately 20%.
If the same ₹1,20,000 is received after a shorter or longer period, the annualized XIRR will be different because XIRR considers the exact dates of the cash flows.
Why Use XIRR for Stocks?
XIRR is useful when stock investments contain multiple transactions on different dates. A simple return calculation may not accurately represent the annualized performance when investments are made at different times. XIRR accounts for the timing of each cash flow and provides an annualized rate that can be used to compare investment performance across different time periods.
FAQs about Stock XIRR Calculator
What is a Stock XIRR Calculator?
A Stock XIRR Calculator calculates the annualized return of a stock investment when cash flows occur on different dates.
What does XIRR mean?
XIRR stands for Extended Internal Rate of Return. It calculates an annualized return for a series of cash flows that are not necessarily equally spaced in time.
Should investment amounts be entered as negative values?
Yes. Money paid to purchase stocks should normally be entered as negative cash flows, while money received from selling shares, dividends, or the final investment value should be entered as positive cash flows.
Can XIRR handle multiple stock purchases?
Yes. XIRR is particularly useful for multiple purchases because each purchase can be entered with its own date and cash flow amount.
Is XIRR the same as CAGR?
No. CAGR generally assumes a single beginning value and a single ending value over a defined period. XIRR can handle multiple cash flows occurring on different dates.
Can I use XIRR for dividends?
Yes. Dividends can be included as positive cash flows on their actual payment dates. This can help measure the annualized return of an investment including cash distributions.
Is XIRR guaranteed to be positive?
No. XIRR can be negative when the investment has lost value. The result depends on the amount and timing of all cash flows.
Related Calculators
Explore more free financial calculators to plan your investments, savings, and loans: