Direct download (free, no registration required)
Includes editable blue inputs, side-by-side Base Case (6.50% exit cap: 10.82% LP IRR, $1.75M GP fees, $1.22M promote) vs. Downside Stress (+100 bps: 5.82% LP IRR, $1.69M GP fees, $0 promote), and 9 live mathematical identity checks in the Controls tab. Recalculates cleanly in Excel, LibreOffice, and Google Sheets with zero macros.
Download Excel Workbook (.xlsx) Explore The Real Estate Syndicator →What the Workbook Computes Dynamically
| Tab | Scope & Formulas |
|---|---|
| Inputs_and_Summary | Editable blue inputs for acquisition price ($35.00M), LTV (70%), GP/LP equity split (5%/95%), all four sponsor fee rates, 8% pref, 70/30 promote, and +100 bps exit stress, plus Sources & Uses and live Base vs. Downside GP/LP summary. |
| Annual_Cash_Flows | 5-year (2027-2031) operating statement plus 2032 forward exit NOI, value-add renovation premiums, 2.0% annual asset management fee on EGI, IO bridge debt service, and Base vs. Downside net exit proceeds. |
| GP_LP_Waterfall | Full 5-year compounded preferred return accrual, Tier 1 pref, Tier 2 return of capital, Tier 3 70/30 promote split, LP IRR, LP equity multiple, and GP fee vs. promote breakdown for both Base and Downside cases. |
| Controls | 9 live mathematical identity checks (0 hardcoded constants) verifying Sources = Uses, waterfall tier conservation, partner conservation, fee tie-outs, and zero promote before return of capital. |
Read the full walkthrough and stress-test math
See every number explained step by step in Real Estate Syndication Fees and GP/LP Splits, or get the complete 9-sheet Tarrowmere model and Regulation D desk checklists in The Real Estate Syndicator.
Read the Full Guide → Book & Companion Files →