The 5 Metrics Every LP Should Track (But Doesn't)

If you invest in real estate syndications, you're probably tracking your portfolio in a spreadsheet. You log your initial investment, you log the distributions when they hit your bank account, and you use the `=XIRR()` function to see how you're doing.

But here's the problem: your spreadsheet IRR is probably wrong.

When you rely solely on the metrics provided in sponsor portals, or when you use basic spreadsheet formulas without accounting for the nuances of private equity, you get a distorted view of your portfolio's health.

After investing in multiple deals and seeing the administrative chaos firsthand, I realized that most Limited Partners (LPs) are tracking the wrong numbers. Here are the 5 metrics you actually need to track to understand your portfolio's true performance.

1. True Portfolio XIRR (Not Just Deal IRR)

Sponsors love to report the IRR of their specific deal. But as an LP, you don't care about the deal's IRR in a vacuum—you care about your Portfolio XIRR.

Why it matters:

If Deal A returns 20% IRR on $50k, and Deal B returns 8% IRR on $150k, your overall return isn't the average of the two. Furthermore, the timing of capital calls and distributions across different deals drastically impacts your actual annualized return.

The mistake LPs make:

Averaging the IRRs reported by sponsors, or failing to account for the "cash drag" of committed but uncalled capital.

How to track it:

You need a system that calculates XIRR across all cash flows (in and out) across all deals simultaneously, using the exact dates the money left or entered your bank account—not the dates the sponsor reported the distribution.

2. DPI (Distributions to Paid-In Capital)

IRR is a time-weighted metric. It's heavily influenced by when money moves. DPI, on the other hand, is a cold, hard cash metric.

Why it matters:

DPI answers the most fundamental question: "For every dollar I put in, how many dollars have I gotten back?" A DPI of 0.50 means you've received half your money back. A DPI of 1.20 means you've gotten all your money back, plus a 20% profit.

The mistake LPs make:

Focusing entirely on IRR while ignoring DPI. A deal can have a fantastic 25% IRR on paper because of a quick early distribution, but a DPI of only 0.10, meaning 90% of your capital is still locked up and at risk.

3. MOIC (Multiple on Invested Capital)

Also known as the Equity Multiple, MOIC measures the total value of your investment relative to what you put in.

Why it matters:

While DPI measures realized cash, MOIC measures total value (realized cash + unrealized equity). If you invest $100k, receive $30k in distributions, and the remaining equity is valued at $120k, your MOIC is 1.50x.

The mistake LPs make:

Confusing MOIC with IRR. A 2.0x MOIC over 3 years is incredible (approx. 26% IRR). A 2.0x MOIC over 10 years is mediocre (approx. 7% IRR). You must track MOIC alongside IRR to understand both the magnitude and the velocity of your returns.

4. Uncalled Capital Commitments

This isn't a performance metric, but it's the most critical risk metric in your portfolio.

Why it matters:

In many syndications (especially development or value-add funds), you commit a certain amount but the sponsor only "calls" the capital as needed. If you commit $100k but have only funded $40k, you have $60k in uncalled capital.

The mistake LPs make:

Failing to track uncalled capital across multiple deals. If three different sponsors issue capital calls in the same month and you haven't maintained the liquidity to cover them, you face severe penalty interest or dilution.

How to track it:

You need a real-time dashboard showing your total committed capital minus your total funded capital, giving you your exact liquidity requirement at any given moment.

5. Proforma Variance

Every syndication comes with a proforma—the sponsor's projection of how the deal will perform.

Why it matters:

You need to know if the deal is actually hitting the numbers the sponsor promised in the Private Placement Memorandum (PPM).

The mistake LPs make:

Filing the PPM away and never looking at it again. When a distribution arrives, they're just happy to get a check, without realizing the distribution is 30% lower than projected.

How to track it:

Log the projected distributions from the PPM when you enter the deal. Every time a distribution hits, compare the actual amount to the projected amount. This variance is the ultimate scorecard for a sponsor's reliability.

---

The Solution: Stop Using Spreadsheets

Tracking these 5 metrics across 10+ deals in a spreadsheet is a part-time job. Formulas break, data entry is tedious, and pulling numbers from half a dozen sponsor portals is a nightmare.

That's exactly why I built SyndTrack.

SyndTrack is a purpose-built portfolio tracker for LP investors. It automatically calculates your true Portfolio XIRR, DPI, and MOIC. It tracks your uncalled capital, and it organizes all your K-1s for tax season.

If you're ready to graduate from spreadsheets and get a true picture of your portfolio's performance, create a free SyndTrack account today.