Short reads on waterfall math, spreadsheet problems, and distribution operations for real estate GPs.
The five most common Excel errors that cause waterfall miscalculations, and how to catch them before your auditor does.
At some point, an LP will ask how their distribution was calculated. The problem isn't the question. It's how long it takes you to answer.
Excel waterfalls work fine for 3 investors. At 10 or more, rounding errors compound and allocations stop tying out.
Fund auditors don't want your spreadsheet. They want locked records, clear allocation logic, and a reconstructable trail.
Manual waterfall calculations cost more than time. They cost confidence, LP trust, and the risk that a past distribution was wrong.
Simple vs compound preferred return changes LP payouts. Here's the math with real numbers so you can check your own model.
GP catch-up is one of the most misunderstood waterfall mechanics. See how it works with two common structures and real numbers.
Clawback provisions let LPs reclaim GP distributions when final fund returns fall short. Here's how they work and why tracking matters.
New LPs joining mid-fund change pref accrual timing, capital account basis, and tier thresholds for everyone.
IRR and XIRR can return different results on the same cash flows. When your waterfall has IRR hurdles, the formula matters.
Side letters create LP-specific waterfall terms that override the standard LPA. Here's how they affect allocation calculations.
Year-end true-ups reconcile quarterly estimates against actual performance. Here's what the process looks like for controllers.