Real Estate AIF Model: Waterfall, Fees and Returns by Viren MakwanaReal Estate AIF Model: Waterfall, Fees and Returns by Viren Makwana

Real Estate AIF Model: Waterfall, Fees and Returns

Portfolio project
Viren Makwana

Real Estate AIF Model

An original, fully linked Excel model for a ₹250 Cr Category II real estate fund, built to show how fund terms translate into investor outcomes. All deals and figures are illustrative.
What the model does
Five-deal pipeline with investment, income and exit cash flows by year
Capital calls covering investments, management fees, fund expenses and set-up costs
European waterfall: return of capital, 10% compounded hurdle, 100% GP catch-up, 80/20 carry split
Gross and net IRR, MOIC, TVPI, fee drag and the LP J-curve
Downside, base and upside scenario switch, with built-in checks that every rupee is allocated
Base case results: 15.5% gross IRR (1.81x) and 10.3% net LP IRR (1.46x), with carry equal to exactly 20% of fund profit.
Useful for fund managers, family offices and developers planning an AIF, or LPs testing a term sheet.

0 likes · 0 views · Nov 6, 2026

Linked Excel model for a ₹250 Cr Category II fund: deal cash flows, hurdle, catch-up and carry, gross 15.5% and net 10.3% IRR.

Tags