DATED CASH FLOWS
Asset Return Calculator (XIRR)
Find the yearly return on property, land, or any asset where money went in and out at different times.
Use XIRR instead of CAGR when there are rents, repairs, EMIs, top-ups, partial withdrawals, or other dated cash flows.
Simple XIRR
Use this for a buy/sell investment, with optional fees or extra dated cash flows.
Money paid or invested is a negative cash flow. Money received from rent, sale, dividend, or withdrawal is a positive cash flow.
Enter what you invested, what it's worth now, and the dates. Optionally add fees or extra cash flows.
Current market value or sale proceeds
XIRR — Annualised Return
12.5% p.a.
Total invested
₹10.00 Lakh
Current value
₹18.00 Lakh
Net gain / loss
₹8.00 Lakh
Gross CAGR
12.5% p.a.
What this means
Your XIRR of 12.5% p.a. is the single annualised rate that accounts for the exact timing of every cash flow. It equals the CAGR of 12.5% p.a. because there are only two cash flows.
XIRR does not adjust for inflation, taxes, or the return you may have earned elsewhere.
Costs and assumptions
This estimate is based only on the information entered here.
What to calculate next
Example property cash-flow check
A property XIRR estimate can include the purchase amount, stamp duty, registration, brokerage, loan payments, rent received, maintenance, repairs, vacancy costs, and final sale proceeds.
Money paid is entered as a negative cash flow and money received as a positive cash flow. Missing costs can make the annualized return look better than the actual result.
Educational estimate only. This calculator uses simplified assumptions based on your inputs. Actual outcomes may differ because of market returns, taxes, fees, inflation, product rules, exit penalties, lender charges, and personal circumstances. This is not financial, investment, tax, or legal advice. Stamp duty, registration, brokerage, maintenance, vacancy, property tax, capital gains tax, loan charges, and sale costs can materially change actual returns.
Frequently asked questions
What is XIRR?
When should I use XIRR instead of CAGR?
How do I enter money paid and received?
Can I use this for property?
Does this include stamp duty, tax, or maintenance?
Why can missing cash flows change XIRR?
What this means
Your asset returned 12.5% annually — outperforming typical equity mutual fund benchmarks.
How this estimate is calculated
This shows the simplified method used for the estimate. It is meant for transparency, not as a full financial model.
Formula
Scroll sideways if the formula is wider than the screen.
Assumption: The calculator searches for the yearly rate that balances all entered dated cash flows. Property modes generate monthly rent or EMI cash flows from the dates and assumptions entered. EMI mode uses a reducing-balance loan schedule.
Requires at least one negative and one positive cash flow. Some unusual cash-flow patterns may not have a valid annualised-return solution. Rent / EMI amounts are assumed constant; real-world rent revisions, taxes, repairs, vacancy, sale costs, and loan prepayments are not modelled unless entered.