What Is XIRR?
XIRR solves the same problem as IRR — what annualized return did this investment actually produce? — but it uses the exact dates of every cash inflow and outflow instead of assuming they happen at neat annual or monthly intervals. This matters in real estate because your cash flows are inherently irregular: you close on a property mid-month, collect rents on the first, pay for a $15,000 roof in August, pull out $60,000 in a refinance in March, and sell three years and seven months later. Standard IRR cannot handle that timing accurately. XIRR can.
XIRR is a return metric that calculates your annualized rate of return using the actual dates of each cash flow, rather than assuming equal time intervals like standard IRR.
At a Glance
- Calculates annualized return using actual cash flow dates, not equal intervals
- Excel/Sheets formula: =XIRR(cash_flow_range, date_range)
- More accurate than IRR for real estate because rents, repairs, refinances, and sales happen on irregular dates
- Standard metric for syndication sponsor performance reporting
- Shares IRR's weakness: assumes interim cash flows are reinvested at the same rate
0 = Σ [Cash Flow_i / (1 + XIRR)^((Date_i - Date_0) / 365)]
How It Works
Standard IRR divides your investment timeline into equal periods — usually months or years — and assumes each cash flow lands at the boundary of those periods. That works for bonds with fixed coupon dates but falls apart for real estate. You close on March 15, not January 1. Your refinance proceeds hit on October 22. You sell 4 years and 3 months later, not exactly 5 years.
XIRR takes each cash flow paired with its actual date and solves for the annualized discount rate that makes the net present value of all cash flows equal zero. The formula weights each dollar by the exact number of days between that cash flow and the investment start date.
In practice, you build a spreadsheet with two columns: dates and cash flows. The initial investment goes in as a negative number on the purchase date. Each month's net rental income (after expenses) goes in on the date received. Any large capital events — refinance proceeds, capital expenditures, insurance payouts — go on their actual dates. The final sale proceeds go on the closing date. Then =XIRR(values, dates) gives you the annualized return.
The difference between XIRR and IRR can be significant when cash flows are lumpy. A large refinance early in the hold period boosts XIRR more than IRR would reflect, because XIRR captures the time value of getting that money back sooner. Conversely, a large capital call midway through the hold penalizes XIRR more heavily because the formula accounts for exactly when you had to put more money in.
Real-World Example
Rachel invests $80,000 as a limited partner in a value-add apartment syndication on June 15, 2023. Her cash flows:
- June 15, 2023: -$80,000 (initial investment)
- Dec 31, 2023: +$2,000 (Q3-Q4 preferred return, partial year)
- Mar 31, 2024: +$1,600 (Q1 distribution)
- Jun 30, 2024: +$1,600 (Q2 distribution)
- Sep 30, 2024: +$1,600 (Q3 distribution)
- Dec 31, 2024: +$1,600 (Q4 distribution)
- Mar 31, 2025: +$1,600 (Q1 distribution)
- Jun 30, 2025: +$1,600 (Q2 distribution)
- Oct 15, 2025: +$112,000 (sale proceeds — return of capital plus profit share)
Plugging these into =XIRR(values, dates) returns 21.6%. If she used simple IRR with annual periods, the result would be approximately 19.8% — understating the actual return because the early partial-year distributions and the sale closing in October (not December) shift timing in her favor. The 1.5% difference matters when comparing multiple syndication opportunities.
Pros & Cons
- Handles the irregular timing of real estate cash flows accurately — rents, refinances, and sales rarely fall on neat intervals
- Industry standard for syndication reporting — lets you compare sponsors and deals on a level playing field
- Available in Excel, Google Sheets, and most financial calculators — no custom math required
- More precise than IRR for partial-year holds, mid-month closings, and lumpy distributions
- Produces a single annualized percentage that accounts for both the size and timing of every dollar
- Same reinvestment assumption as IRR — assumes interim cash flows are reinvested at the XIRR rate, which may overstate returns if you park cash at 4-5%
- Sensitive to cash flow timing — small changes in dates can shift the result, making it easy to manipulate
- Requires accurate record-keeping — missing or misattributed cash flows produce misleading results
- Not intuitive — most beginning investors find cash-on-cash return or simple ROI easier to understand and act on
- Can produce misleading results on very short holds — a quick flip with high profit shows an astronomical annualized XIRR that is not repeatable
Watch Out
Do not confuse XIRR with simple annualized return. XIRR accounts for the time value of money, which means getting $10,000 back in month 6 is worth more than getting it in month 36. This is powerful but can mislead: a quick flip that returns your capital in 4 months might show a 90% XIRR, but that does not mean you can sustain 90% returns annually.
When evaluating syndication sponsors, always ask whether they report XIRR or IRR and how they handle the timing of distributions. Some sponsors report "projected IRR" using annual periods, which can differ from the actual XIRR by 1-3 percentage points. The existing IRR term in our glossary notes: "IRR assumes you reinvest interim cash flows at the same rate. In practice, you might park money at 4%. That can overstate returns." XIRR inherits this exact limitation.
For your own deal analysis, XIRR is the gold standard — but only if your cash flow data is clean. A misattributed date or missing distribution will skew results. Track every dollar with its exact date from day one.