Free Templates · Real Estate Syndication

Real Estate Syndication Fee & GP/LP Waterfall Excel Calculator

A 4-tab, 100% formula-driven Excel workbook modeling multifamily sponsor fees (acquisition, construction, asset management, disposition), an 8% compounded preferred return, a 70/30 promote split, and a +100 bps exit cap stress test.

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

TabScope & Formulas
Inputs_and_SummaryEditable 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_Flows5-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_WaterfallFull 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.
Controls9 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 →