# Real Estate Fund Investment Model Model a real estate fund deployment, hold, and exit cycle with property-level IRRs, fee drag, and LP net returns. Supports fund marketing, secondaries analysis, and quarterly performance reporting without manually threading disposition timing. - Canonical: https://finamodel.com/templates/real-estate-fund-model - Excel download: https://finamodel.com/templates/real-estate-fund.xlsx - Category: Real Estate - Model type: Fund / Waterfall - Difficulty: Intermediate - Audiences: Fund managers, Investors & analysts, LP investors, Secondaries buyers, Institutional allocators - Tags: fund-level, real-estate-investments, lp-returns, distributions, carry ## Overview Track a multi-property real estate fund's deployment, hold, and exit cycle with property-level underwriting and LP net returns. This template deploys committed capital across multiple properties over a defined investment period, models property-level operating cash flow and value creation via rent growth and operating margin expansion, calculates exit proceeds from property sales, and distributes cash through a waterfall prioritizing LP capital return and preferred return before GP carry. The workbook includes a capital call schedule, a portfolio sheet tracking each property's deployment date, hold period, operating IRR, and exit proceeds, loan financing and debt repayment by property, fee mechanics (management fees stepping down from committed capital to invested capital net of exits), and a waterfall sheet. The model calculates LP net IRR accounting for all capital calls, annual management fees, carried interest earned by the GP, and realized distributions. It handles the J-curve: negative cash in years 1–3 (capital calls and fees), positive from Year 4+ as exits commence. Target users are institutional LPs evaluating real estate fund commitments, real estate GPs managing fundraising, secondary buyers assessing fund-to-fund opportunities, and advisors on real estate fund selection in the $200M to $5B fund size range. ## What's included - Committed capital and capital call schedule - Investment deployment across property types and geographies - Property-level operating cash flow and value creation - Exit proceeds and distribution waterfall - Management fees, GP carry, and LP net IRR - Loan financing and debt repayment schedules ## How the Real Estate Fund Model Turns Property Exits into LP Net Returns This real estate fund model illustrates a closed-end, 10-year value-add strategy: deploying $500M across a blended eight-to-twelve-asset rollup, collecting asset yield, exiting at an assumed multiple, and running a European whole-fund waterfall. It connects property-level cash flows to fund-level LP and GP net returns. Best for analysts testing fee, carry, and exit-timing assumptions. ### What Drives Cash Flow Across the Fund Life The model blends eight to twelve assets into a single portfolio, so cash flow is driven by aggregate deployment and exit timing rather than per-property detail. Capital is invested over four years—15%, 30%, 35%, then 20%—reaching full deployment at $500M. - Assets are assumed held about six years, so exits begin in Year 6. Two revenue streams feed the fund: annual yield on the cost basis of assets still held, and gross proceeds when assets are sold. - Yield is applied only to held assets, meaning it naturally declines as exits occur. Exit proceeds depend on the cost basis of exiting assets multiplied by a blended exit multiple, with the exit schedule governed by three assumption cells that must sum to no more than 100%. ### How the Calculation Flow Connects Sheets The model links nine sheets in a deliberate sequence. Assumptions feed an asset rollup that tracks deployment, cost basis, yield, and exits by year. - That rollup supplies the fund cash flow statement, which combines yield, new deployments, exit proceeds, management fees, operating expenses, and subscription-line activity before calculating capital calls. The subscription line sits alongside, rolling forward drawdowns and repayments sourced only from exit proceeds. - Positive net cash flow after calls flows into the European whole-fund waterfall, which pays return of capital, then a compounded preferred return, then a catch-up, then an 80/20 split. Fund NAV is built separately as a balance—cost basis of held assets plus unrealised gain—and feeds the returns sheet alongside the waterfall distributions. ### Outputs: Returns, NAV, and Covenant Checks The returns sheet produces LP net IRR, GP net IRR, TVPI, DPI, RVPI, and LP net MOIC. Because the waterfall is whole-fund, LP net IRR derives from LP capital calls as negative cash flows and LP distributions as positive ones after fees and carry. - NAV is a balance recalculated each year, not a running flow, so unrealised gain does not linger after assets are sold; by Year 10, cost basis and unrealised gain both reach zero and TVPI equals DPI. - A checks sheet validates ten relationships, including cumulative exit percentage never exceeding 100%, sub-line balance never going negative and repaying to roughly zero at wind-up, capital calls staying within fund size, and gross IRR exceeding LP net IRR after fee and carry deductions. ### Practical Use for Fund Evaluation This template is designed for GP fundraising decks, LP due diligence, and fee or carry negotiations. It lets a reader test how management fee step-down from committed capital to NAV affects net outcomes, how subscription-line usage defers LP calls and compresses early IRR, and how exit concentration in Years 6 through 8 shapes the J-curve and DPI trajectory. - The model also shows the fund-level cost stack: a 1.5% investment-period fee, a 1.0% post-investment fee on held NAV, operating expenses, and sub-line interest and unused fees. The public download is a values-only preview, not a live model, so it illustrates the relationships and assumptions rather than recalculating automatically. - It does not segment individual properties or model asset-level debt. ## Property-level investment tracking Organise individual property investments to show acquisition cost, hold period performance, and each asset contribution to fund-level return. ## Fee and carry mechanics Model management fees, acquisition fees, disposition fees, and GP carry to show the full fee drag and net LP returns after all charges. ## Distribution waterfall and LP reporting Calculate LP distributions based on capital returned and allocations, accounting for vintage tracking, catch-up mechanics, and hurdle rates. ## Property-level investment tracking Organise individual property investments to show acquisition cost, hold period performance, and each asset contribution to fund-level return. ## Fee and carry mechanics Model management fees, acquisition fees, disposition fees, and GP carry to show the full fee drag and net LP returns after all charges. ## Distribution waterfall and LP reporting Calculate LP distributions based on capital returned and allocations, accounting for vintage tracking, catch-up mechanics, and hurdle rates. ## Features - **Property-level investment tracking:** Organizes individual property investments to show acquisition cost, hold performance, and exit return contribution. - **Fee and carry mechanics:** Models management fees, acquisition fees, disposition fees, and GP carry to show net LP returns after all charges. - **Distribution waterfall and timing:** Calculates distributions to LPs based on capital returned and allocations, accounting for vintage tracking and catch-up mechanics. ## Use cases - **Fund marketing and investor pitching:** Model target fund returns, property sourcing strategy, and net LP IRR to support fundraising. - **Secondaries and continuation fund analysis:** Evaluate remaining portfolio value and projected distributions to support secondary sale or rollover decisions. - **Performance reporting and LP communications:** Track realized and unrealized gains by property to report quarterly performance and justify management fees. ## Frequently asked questions ### What is a real estate fund model? A fund-level model that aggregates property investments, capital calls, management fees, GP carry, and exit proceeds to show committed LP capital deployment and net IRR. ### What is the typical hold period for real estate funds? Real estate funds typically target five to ten year holds. Value-add strategies may exit earlier and core funds hold longer depending on the investment mandate. ### How is GP carry calculated? GP carry is typically 20% of profits above the hurdle rate, commonly set at 8%, and is paid when total distributions to LPs exceed the return threshold including preferred return. ### Can I model different property types and strategies? Yes. The model supports core, core-plus, value-add, and opportunistic strategies with varying hold periods, leverage assumptions, and return expectations. ### How do I use this model for a secondaries or continuation fund analysis? Evaluate remaining portfolio value and projected future distributions to support a secondary sale price or rollover decision for an existing fund. ## Related templates - [Leveraged Buyout Model](https://finamodel.com/templates/lbo-model) - [Private Equity Fund Model](https://finamodel.com/templates/pe-fund-model) - [Exit Waterfall Model](https://finamodel.com/templates/exit-waterfall-model)