XIRR for Syndication Investors: Formula and Excel Steps
On this page
XIRR is the spreadsheet function that turns your actual syndication cash flows into an annualized return. You list what you paid in and what you received, each with its date, and the function returns the yearly rate that makes those flows net to zero. In Excel or Google Sheets the formula is =XIRR(values, dates). It is the right tool for a syndication because the money moves on irregular dates: one investment, quarterly distributions, then a sale. Plain IRR assumes equal gaps between payments and can give a different answer. DoorRaise shows investors their commitments and distributions on the deal page, and you can use the steps below to check any sponsor's reported return.
This post is part of our guide to real estate syndication. It complements equity multiple, IRR and cash on cash. Information is as of October 2026.
How do you calculate XIRR in Excel step by step?
- In column A, list each cash flow. Your investment is negative (for example, -100000). Every distribution or sale payment you received is positive.
- In column B, enter the date of each cash flow. Use real dates, not text.
- In a blank cell, type =XIRR(A2:A14, B2:B14), adjusting the ranges.
- Format the result as a percentage.
In Google Sheets, the formula is the same. In a Spanish-language Excel the function is called TIR.NO.PER. The first date should be the earliest, the list must contain at least one negative and one positive amount, and every date must be on or after the first.
A worked example (made-up numbers)
An investor puts in $100,000 on January 15, 2026. The deal pays 12 quarterly distributions of $1,750, the first on April 15, 2026, and the last on January 15, 2029. On that last date the investor also receives $110,000 from the sale.
| Date | Amount |
|---|---|
| Jan 15, 2026 | -$100,000 |
| Apr 15, 2026 to Oct 15, 2028 | $1,750 each (11 payments) |
| Jan 15, 2029 | $1,750 + $110,000 = $111,750 |
Total received: 12 x $1,750 + $110,000 = $131,000. Equity multiple: 1.31x. XIRR: about 10.3% a year. These numbers are made up to show the method. They are not a projection or typical results for any deal, and a loss case would show a negative XIRR.
What is the difference between XIRR and IRR?
| Topic | IRR | XIRR |
|---|---|---|
| Dates | Assumes equal gaps (every period the same length) | Uses each real date |
| Inputs | Amounts only | Amounts and dates |
| Fit for a syndication | Only if every payment is on a regular schedule | Better for real deals with a sale on any date |
| Result | Per-period rate | Annualized rate |
If you use IRR on quarterly flows you get a quarterly rate, which you then have to annualize. If the sale is not exactly at a quarter-end, IRR is slightly off. XIRR avoids both issues. See our guide to the preferred return in Excel for related spreadsheet work.
Why does XIRR give an error or a strange number?
- #NUM! There is no negative amount, no positive amount, or the first date is not the earliest. Also check that dates are real dates, not text.
- #VALUE! A cell has text in it, or dates are mismatched in length from amounts.
- A very large or very small rate. If a deal has a loss or a very short hold, XIRR can show extreme numbers. Read it next to the equity multiple.
- A different answer from the sponsor. The sponsor may use a projected sale date, include fees differently or use a different start date. Ask how they calculate it.
- Missing cash flows. Include every payment received and any capital call you paid. See what is a capital call.
What does XIRR leave out?
- Taxes. Distributions can be partly a return of capital or taxed differently from profit. See syndication taxes for beginners.
- Risk. A stronger number does not mean a safer deal. See apartment syndication risks.
- Dollars. A 20% rate on a three-month hold produces fewer dollars than 8% on five years. Check the multiple.
- Projections. If the sale has not happened, the number depends on a sale price someone guessed. Treat it as an estimate, not a result.
How DoorRaise fits in
DoorRaise is a technology platform, not a law firm, broker-dealer, investment adviser or funding portal, and it does not hold investor money. Investors on a DoorRaise deal see their commitment, wire status and distributions in their portfolio, which are the dated figures you would enter in the sheet above. DoorRaise does not recommend an investment or predict returns, and a return you calculate is only a measure of what the cash flows were. Fees for sponsors are $1,500 to set up (non-refundable), then $5,000 a year from closing (only if the deal closes). See how it works.
Raise your apartment deal from the people who already follow you.
DoorRaise is built for apartment buildings with 5 or more units: one link for the deal, escrow until closing and a standard fee card.
FAQ
What is XIRR in real estate?
It is the annualized return on a series of cash flows that happen on specific dates. For a syndication, it uses your investment, each distribution and the sale proceeds with their dates.
Is XIRR the same as IRR?
No. IRR assumes the payments are evenly spaced. XIRR uses the actual dates, so it is better for real estate where payments and the sale fall on irregular dates.
What is a good XIRR for a syndication?
There is no standard. Targets are not guaranteed and actual results can be lower, including losses. Compare the XIRR with the equity multiple, the hold period and the risk of the deal, not with a single benchmark.
Can I use XIRR before the deal has sold?
Yes, with an assumed sale value and date. The result is an estimate and changes with the sale price. Label it clearly as a projection.
Does XIRR include fees?
It includes whatever cash flows you enter. If you enter what you actually paid in and received, fees are already in those amounts. If you use the sponsor's gross figures, fees may not be.
Sources
- Investor.gov: Investor bulletin on private placements
- IRS: Instructions for Schedule K-1 (Form 1065)
- IRS: Instructions for Form 1065
This post is general information as of October 2026, not legal, tax or investment advice. Talk to your own advisers. The examples are simplified illustrations with made-up numbers, not a projection or an offer. DoorRaise is not a law firm, broker-dealer, investment adviser or funding portal.