Real Estate Private Equity Financial Model Template

A real estate private equity fund model built in Excel for fund managers, analysts, investors and students who need institutional-quality numbers without starting from a blank sheet. It covers the full life of a closed-ended real estate fund: fundraising, deal pipeline, property underwriting, debt, fees, the distribution waterfall, NAV and LP/GP returns. Everything sits in one linked workbook with a 10-year quarterly forecast and 8 optional extension quarters, giving a 12-year maximum horizon.

Financial Model for a Real Estate Private Equity (REPE) Fund

The model follows the order a real estate fund actually works in. Data and assumptions feed a quarterly fund timeline, which drives the investment pipeline, sources and uses, property underwriting, property cash flows and debt schedules. Each asset then rolls up into portfolio asset management, fund cash flow, fees and expenses, a European distribution waterfall, the NAV balance sheet and investor returns. You get gross and net IRR, MOIC, DPI, TVPI and RVPI in one place.

Every figure is driven by formulas. Change the start date and every date, year header and growth calculation across all 18 tabs updates automatically. Inputs are blue cells on a yellow fill, formulas are black and cross-tab links are green, so you always know which cells are safe to edit. Built-in integrity checks confirm that sources equal uses, debt schedules roll forward, the balance sheet balances and the waterfall allocates every dollar. That makes the model ready for investment committees, lender packs and LP reporting.

What’s Inside: Tab-by-Tab Guide

01. Cover Dashboard

The executive dashboard shows the fund’s key performance indicators on one page: NAV, AUM, gross and net IRR, MOIC, DPI, TVPI, RVPI, leverage, deployment and asset exits. It gives investment committees and LPs an instant view of fund performance.

Side-by-side KPIs for the reporting quarter and the life of the fund
Annual summary of capital calls, distributions, NAV, GAV, debt and NOI
Deployment and exit table by asset, with levered IRR and MOIC
Three built-in charts: capital calls vs distributions, NAV/GAV/debt, and the LP J-curve
Live “All Checks Pass” status banner

02. Assumptions

One central assumptions tab controls the whole real estate fund model. It holds the start date, fund term, extensions, fees, taxes, waterfall hurdles, SOFR curve, scenario settings, and deal-level growth, exit cap rates and financing terms in one place.

A single Model Start Date re-dates the entire workbook
Scenario selector: Base, Upside or Downside
Extension quarters from 0 to 8, plus a reporting as-of quarter
Management fee, acquisition fee, disposition fee and fund expense inputs
Deal-level loan terms: LTV, spread, fixed/floating, floor, cap, interest-only period, amortization and refinancing

Real Estate Private Equity Funding Pipeline

03. Data Actuals

The data actuals tab stores historical and reported data alongside the forecast. It captures three years of seller operating history, quarterly actual NOI, occupancy, lender debt balances and closing data, so you can track budget vs actual and underwriting variances.

Three years of pre-acquisition revenue, OpEx, NOI and occupancy for each deal
Trailing-12-month (T-12) figures compared with the underwritten Year-1 NOI
Quarterly input grids for actual NOI, occupancy and debt balances
Closing price and loan variances vs underwriting

04. Fund Timeline

The quarterly fund timeline is the calendar every tab runs on. It generates 48 periods from one start date, labels fund and calendar years, and flags the investment period, harvest period, base term and optional extensions for the whole model.

40 base quarters plus 8 optional extension quarters
Flags for the investment, harvest, extension and active fund periods
Final asset exit quarter detected automatically
Quarterly base-rate curve including the scenario adjustment

05. Fundraising

The fundraising tab tracks LP and GP commitments, capital calls, distributions and investor allocations. It numbers and dates each capital call, splits it by use, shows unfunded commitments, and reports DPI, TVPI and RVPI on paid-in capital over time.

Fund overview: target size, hard cap, vintage, final close and investment period
LP/GP commitments, management company commitment and hard-cap check
Capital call number, date and notice date, split into investments, fees, expenses and reserves
Distributions split into sale, operating, refinancing, return of capital and profit

06. Investment Pipeline

The investment pipeline manages every acquisition opportunity from screening to closing. It records the deal ID, property type, market, strategy, status, closing probability, purchase price, capital structure, underwriting and returns. Probability-weighted metrics and fund allocation limits keep deployment disciplined and on strategy.

Eight deal slots, each with an “Include in Model” switch
Probability-weighted purchase price, equity, IRR and MOIC
Tracking of IC, due diligence, financing, legal, environmental and appraisal status
Allocation-limit, investment-period and fund-life breach flags

07. Sources & Uses

The sources and uses tab builds each acquisition’s capital stack. Uses cover price, fees, legal, diligence, title, transfer taxes, financing costs, CapEx and reserves. Sources cover senior debt, mezzanine, preferred and common equity, with fund equity balancing.

More than 20 itemised use lines, with rate-based and fixed costs
Senior, mezzanine, preferred, seller, assumed and other debt sources
LTV, loan-to-cost, debt and equity percentage checks
Sources = Uses PASS/REVIEW check for every deal
Refinancing summary linked from the debt schedule

08. Property Underwriting

The property underwriting tab is a full Year-1 operating model for each asset: rent, loss-to-lease, vacancy, concessions, bad debt, other income, recoveries, 15 expense lines, NOI, CapEx, leasing and valuation. It suits every major commercial and residential property type.

Rent set per unit or per square foot to suit any property type
In-place and stabilized NOI with a value-add rent premium
Value-add CapEx budget, TI/LC and leasing economics
Value creation split into business plan, NOI growth and cap rate movement

Real Estate Private Equity Fund Cash Flow

09. Property Cash Flows

The property cash flow tab projects quarterly cash flows for every asset, modelling lease-up, rent and expense growth, CapEx, debt service, refinancing and sale proceeds. It then calculates each property’s levered and unlevered IRR, MOIC, cash yield and DPI.

Quarterly NOI build with a lease-up curve and a phased-in renovation premium
Acquisition, disposition and net equity sale proceeds
Operating distributions, refinancing proceeds and equity contributions
Fair value, cost basis and restricted cash to feed the NAV
Equity cash flow tie-out check for every asset

10. Debt Schedule

The debt schedule models each property loan quarter by quarter: fixed or floating rates, SOFR floors and caps, interest-only periods, amortization, refinancing, prepayment penalties, exit fees and sale payoffs. It also tracks DSCR, debt yield, LTV and interest coverage.

Floating rate = base rate (with floor and cap) + spread, or a fixed coupon
Refinancing sized off current fair value at a target LTV
Mezzanine debt and preferred equity tracked as separate tranches
Debt covenant metrics: DSCR, ICR, debt yield and LTV
Roll-forward check and maturity-before-exit flag

11. Acquisition Disposition

The acquisition and disposition tab summarises each deal’s entry basis and exit economics: purchase price, transaction costs, entry cap rate, exit NOI, exit cap rate, sale price, selling costs, gain on sale, tax basis, taxable gain, IRR and MOIC.

Total acquisition basis and uses tied back to Sources & Uses
Exit valuation with brokerage, transfer tax, legal and disposition fees
Book gain and taxable gain, including tax depreciation
Helper data that drives the exit cap rate sensitivity tables

12. Portfolio Asset Management

The portfolio asset management tab consolidates every property into quarterly portfolio reporting: NOI, occupancy, GAV, debt, weighted cap rates, LTV, DSCR, value creation and deployment. An asset management table tracks each asset’s status, lease-up, CapEx progress and exit readiness.

Weighted average acquisition and exit cap rates, LTV and hold period
Portfolio NOI margin, year-on-year NOI growth and NOI per unit / per SF
Physical and economic occupancy, and occupied units
Portfolio unlevered and levered IRR and MOIC
Budget vs actual and NOI vs underwriting for each asset

13. Fund Cash Flow

The fund cash flow tab is the fund’s cash engine. It calls capital only when needed, capped at unfunded commitments, pays fees and expenses, holds a cash reserve and sends surplus cash through the waterfall, tracking DPI, TVPI and gross IRR.

Capital calls split between LPs and GP pro rata to commitments
Gross view of debt proceeds, refinancing, sale proceeds and operating distributions
Funding shortfall and negative-cash safeguards
Reconciliation back to the property equity cash flows

14. Fees & Expenses

The fees and expenses tab calculates manager income and fund costs. Management fees run on commitments during the investment period, then on net invested equity. It also covers acquisition and disposition fees, organizational costs, inflating fund expenses and GP economics.

Management fee basis switches automatically at the end of the investment period
Fund admin, legal, audit, tax, insurance and other expenses, with annual inflation
Cumulative fees as a percentage of commitments
GP economics: fees plus carried interest

Real Estate Private Equity Fund Balancing

15. Waterfall

The European distribution waterfall runs every quarter. It returns capital, pays an 8% compounding preferred return, a GP catch-up, an 80/20 split to a 12% IRR hurdle, then 70/30, allocating every distribution dollar between LPs and the GP.

Hurdle rates, catch-up and carry tiers set on the Assumptions tab
Pref and hurdle accounts compound quarterly
LP and GP split of return of capital, profit and carried interest
Allocation check that LP + GP equals cash available for distribution

16. NAV Balance Sheet

The NAV balance sheet produces a quarterly fair-value fund balance sheet covering cash, reserves, real estate at cost and fair value, debt and partners’ capital. A full NAV bridge explains each quarter’s movement, and three checks confirm everything balances.

Assets, liabilities and LP/GP partners’ capital
Net income, realized gains and unrealized gains
NAV per $1 committed and per $1 invested; Debt/GAV, Debt/NAV and LTV
NAV bridge from beginning NAV to ending NAV
Balance, roll-forward and cash-to-NAV checks

17. LP GP Returns

The LP GP returns tab reports investor performance: net LP IRR and MOIC, GP IRR, the gross-to-net IRR spread, DPI, TVPI and RVPI over time, carried interest by tier and the LP J-curve. As-of returns include NAV for quarterly reporting.

LP and GP cash flows, with GP commitment and carry shown separately
Gross (property-level) vs net (LP) IRR and the fee-and-carry drag
Returns for the life of the fund and as of the reporting quarter
Carried interest by tier and maximum LP J-curve exposure

18. Sensitivity Scenario Checks

The sensitivity and checks tab stress-tests returns and verifies the model. It includes a scenario manager, exit cap rate vs exit NOI grids, a full cash-flow IRR sensitivity, and more than 25 automated checks with a single PASS/REVIEW status.

Base, Upside and Downside scenario definitions and live results
Levered MOIC, equity profit and approximate net LP MOIC grids
Gross IRR sensitivity to exit cap rate from -75 to +75 basis points
Model integrity checks plus a PASS/REVIEW flag for every quarter

Why Buy This Model

Building a real estate private equity fund model from scratch can take weeks. It also leaves room for broken links, hard-coded numbers and a waterfall no one fully trusts. This model gives you a complete, formula-driven, 18-tab fund model that runs from fundraising to final distribution. It follows lender- and investor-ready formatting and includes built-in integrity checks. Change one start date and the whole workbook re-dates. Toggle a scenario and every return updates. You can see exactly how each IRR, MOIC and carried interest figure is calculated. Whether you’re raising a first-time fund, presenting to an investment committee, preparing LP reports or learning real estate fund modeling, this model saves time, reduces errors and gives your numbers the credibility investors expect.

Real Estate Private Equity Frequently Asked Questions (Faq)

What software do I need to use this model?

You need Microsoft Excel. The model uses standard Excel functions only, with no macros, no VBA and no add-ins, so it opens without security warnings. It’s built and tested for desktop Excel. Other spreadsheet applications may handle some functions or charts differently.

Can I change the start date of the fund?

Yes. Enter a new date in the Model Start Date cell on the 02. Assumptions tab. Every date, fiscal-year header, period flag and growth calculation across all 18 tabs updates automatically. For clean fiscal-year columns, use the first day of a calendar quarter, ideally 1 January.

How long is the forecast period?

The model has a 10-year base term (40 quarters) plus 8 optional extension quarters, for a 12-year maximum horizon. You choose how many extension quarters to use (0 to 8). Each tab also has annual summary columns alongside the quarterly detail. If you require a different forecast period, talk to us for model adjustments (No charge).

Which property types does it support?

Any income-producing property type. Rent can be entered per unit per month (multifamily, student housing, build-to-rent, self-storage) or per square foot per year (industrial, office, medical office, retail). The sample deals cover all of these.

How many deals can I model?

The pipeline holds eight deals, each with its own underwriting, sources and uses, cash flow and debt schedule. You can switch any deal in or out of the fund with the “Include in Model” setting. You can also use the pipeline for probability-weighted planning. If you require a different amount of deals, talk to us for model adjustments (No charge).

What kind of waterfall does it use?

A European (whole-of-fund) waterfall: return of capital, an 8% compounding preferred return, a 100% GP catch-up, an 80/20 split up to a 12% investor IRR, then 70/30. You can change the pref, catch-up rate, both carry rates and the second hurdle on the Assumptions tab.

Does it calculate both gross and net returns?

Yes. Gross returns are measured at the property equity level, before fund fees and carry. Net returns are measured on the LP cash flows, after management fees, fund expenses and carried interest. The model also shows the gross-to-net spread, GP IRR, DPI, TVPI and RVPI, and as-of returns that include NAV.

Can I model refinancing, mezzanine debt and preferred equity?

Yes. Each asset can have a refinancing quarter sized at a target LTV on current value, with refinancing costs, exit fees and prepayment penalties. Mezzanine debt, seller financing, assumed debt and preferred equity are entered in Sources & Uses and tracked as separate interest-only tranches.

How are management fees calculated?

During the investment period, the management fee is charged on committed capital. After it ends, the fee switches to net invested equity (the cost of assets not yet sold). Acquisition fees, disposition fees, organizational expenses and inflating fund operating expenses are modeled separately.

How do I know the model is accurate?

The 18. Sensitivity Scenario Checks tab runs more than 25 automated integrity checks. They include sources = uses, debt roll-forwards, the NAV balance and roll-forward, waterfall allocation, fund-to-property reconciliation, funding shortfalls and covenant flags. There’s also a PASS/REVIEW flag for every quarter. The overall status appears on the Cover Dashboard.

Can I run scenarios and sensitivities?

Yes. Switch between Base, Upside and Downside on the Assumptions tab; each scenario adjusts rent growth, exit cap rates, base rates, occupancy and CapEx. The sensitivity tab has exit cap rate vs exit NOI grids for MOIC, profit and LP MOIC, plus a gross IRR sensitivity that re-runs the full cash flows.

Is the sample data real?

No. The fund name, deals, seller financials and interest-rate curve are illustrative placeholders that show how the model works. Replace them with your own deal data, term sheets and market forward curve before using the outputs for investment decisions.

Can I enter actual results as the fund progresses?

Yes. The 03. Data Actuals tab has quarterly input grids for actual NOI, occupancy and debt balances, plus actual closing data. The Portfolio Asset Management tab then compares actuals with underwriting to show budget vs actual and NOI variance.

Is the model easy to follow if I didn’t build it?

Yes. Every tab has a title band summarising its contents, a descriptive subtitle, consistent column layouts and colour-coded cells: blue inputs, black formulas and green links. Tabs are numbered in the order data flows through the model and colour-coded by function.

Can I use the model for investor presentations and lender packs?

Yes. The Cover Dashboard, NAV Balance Sheet, LP GP Returns and Debt Schedule tabs are formatted to the standard investment committees, lenders and limited partners expect, with clearly labelled units, totals and checks.

Does the model include a NAV and balance sheet?

Yes. The NAV Balance Sheet tab produces a quarterly fair-value balance sheet, partners’ capital by LP and GP, net income, realized and unrealized gains, and a full NAV bridge. Three balance checks confirm that everything reconciles.

Final Notes on the Financial Model

This 20 Year Real Estate Private Equity Fund Financial Projection Model focuses on balancing capital expenditures with steady returns. By optimizing expenditure costs, and efficiency, and maximizing high-margin services, the models ensure sustainable profitability and cash flow stability.

Further Reading

Merger & Acquisitions Model: Download a professional M&A financial model. Dynamic valuation, accretion/dilution analysis, synergies, and debt schedules.
Real Estate Asset Management Financial Model: Boost your financial planning with this downloadable Real Estate Asset financial model. Perfect for budgeting, forecasting, valuation, and business decision-making.
Click here to download a professional CMBS & ABS template: Master complex structured finance deals with the ultimate CMBS & ABS Financial Model. Engineered for institutional analysts and debt funds, this robust template features dynamic waterfall structures, credit enhancement mechanics, and macro stress-testing scenarios. Don’t waste weeks building an un-audited sheet from scratch—underwrite with absolute confidence, forecast tranche cash flows instantly, and impress your investment committee.