VALUE THE HOLDING AT THE DESK'S PRICEDesk connected · key sabya · marketapi.streetgains.in ·
Pick a stock and enter the shares held: the value today becomes shares × the desk's price.
List every cash flow with its date: money you put in as negative, money you took out as positive, and the value of what you still hold on the as-of date as a final positive flow. The XIRR is the one annual rate that discounts them all to zero.
A purchase is a negative amount, a sale or dividend positive
DateAmount (₹, − in, + out)
₹
₹1.75 LResults
XIRR+11.21%annualised, money-weighted
Total put in₹1,50,000
Total taken out + held₹1,95,000
Net gain₹45,000+30.0% absolute
Span2 yrs 10 mo2024-01-15 → 2026-11-10
Compare with a fund's or index's XIRR over the same dates for a like-for-like reading; a CAGR ignores the timing of the money.
Cash flows discounted at the XIRR
the present values sum to zero by construction| Date | Amount | Present value |
|---|---|---|
| 15 Jan 2024 | −₹1,00,000 | −₹1,00,000 |
| 15 Jul 2024 | −₹50,000 | −₹47,421 |
| 1 Mar 2025 | ₹20,000 | ₹17,745 |
| 10 Nov 2026 | ₹1,75,000 | ₹1,29,675 |
Assumptions & formula
Σ CFi ÷ (1 + XIRR)(di − d0) ÷ 365 = 0solved by Newton's method (bisection as the fallback), the spreadsheet convention of a 365-day year.- Dates are calendar days; the first flow is day zero.
- An XIRR over a few weeks extrapolates a short period and reads large — judge it with the span shown.
Calculators are for information and planning. Outputs depend on the inputs and assumptions you enter and are not a recommendation to buy, sell or hold any security or product. Streetgains Technologies Private Limited is a SEBI Registered Research Analyst (INH000017082); it is not a loan provider, tax adviser or mutual fund distributor.