Real Estate Financial Modeling Tools

Professional Version: Core/Core-Plus Real Estate Private Equity Fund Pro-Forma Template



SKU: SKU-737 Category:

An Excel-based quarterly financial projection model for the analysis of a core or core-plus real estate private equity fund, for up to 10 total property acquisition investments and up to an 11-year fund life. The model is a 100% unlocked Excel file with fully transparent formulas that  can be further tailored to suit the particulars of your fund structure and transactions.

Real Estate Private Equity Fund Modeling Self-Study module, a $599.00 value, included

Also included with purchase is a 1-hour screenshare orientation to the model

User-Friendly Features

  • Compatible with both PC and Mac
  • Includes instructions for use, with detailed annotations tied to select cells
  • Two-page assumptions input and reporting screen optimized for dashboard-style viewing
  • Persistent calculation checks and data validation protections to prevent faulty inputs
  • Hyperlink navigation enables fast, intuitive access to all tabs
  • Institutional-quality print-ready reporting tabs that are brandable to your fund
  • No circular references impacting the calculation of the Fund Manager Promote

Model Mechanics – Fund-Level

  • Limited Partnership legal structure assumed with General Partner (GP), Fund Manager (GP entity) and Limited Partner entities
  • Up to 10 individual property acquisition transactions

The GP-LP Joint Venture structure

  • Capital is invested parri passu (pro-rata, simultaneously) at a proportion specified by the user
  • A Preferred Return is earned by the Capital
  • Upon positive cash flows being generated by the fund:
    • General Partner receives its pro-rata share of cashflow based on its share of cash investment (returns Capital)
    • Simultaneously, Preferred Return is paid to LPs (includes return of Capital)
    • Last, Profits beyond the Preferred Return are paid at a user-specified share up until the GP acting as both GP and Fund Manager has taken a combined total user-specified share of fund-level profits (e.g., an 80% to LP/20% to Fund Manager split up until the GP and Fund Manager together have earned 20% of the fund-level profits)

Model Mechanics – Individual Property Transaction Level

  • Each property includes the option of an equity partner to the fund as well as an acquisition loan
  • Each property comes with a 3-tier (or fewer) waterfall return structure

The Fund-Equity Partner Joint Venture structure

  • Capital is invested parri passu (pro-rata, simultaneously)
  • A Preferred Return is earned by the Capital
  • Upon positive cash flows being generated by the transaction:
    • First, Preferred Return is paid to both parties parri passu
    • Then, Capital is returned parri passu (payment is not visually distinguishable from payment of Preferred Return in periods where both are paid out)
    • Last, Profits beyond Preferred Return are paid in the proportions specified through the inputs, simultaneously

Model Tabs

  • Model Overview & Instructions
  • Fund-Level Cash Flow & Returns
  • Fund-Level Returns Summary
  • 10 sets of the following:
    • Transaction Analysis
    • Loan Amortization Schedule
    • Partnership Waterfall
    • Partnership Returns Summary Report

Model Timeline

11 years (expandable)


Brandable, print-ready reports are included in the model. See the Sample Reports link on the top right.

License Type And Multiple-User Pricing

  • Licenses are sold on a per-user basis
  • Multi-user pricing quotes are available here

Included With Purchase

  • 1 year of online ticket-based support

SPECIAL BONUS ($179 value)

Equity Joint Venture Partnership and Waterfall Modeling Bootcamp Video Tutorial included with purchase

Includes the following items, which never expire:

 Online access to an easily navigated 80-minute Video Tutorial, playable on any device including PC, Mac, phones and tablets

 PDF of the 60-slide presentation

 Accompanying fully-unlocked, annotated Excel file, compatible with both PC and Mac, with the following tabs:

  1. Preferred Return Non-Compounded Annual
  2. Preferred Return Non-Compounded Annual Solution
  3. Preferred Return Compounded Monthly
  4. Preferred Return Compounded Monthly Solution
  5. 3-Tier Annual Waterfall with Look-Back
  6. Double-Promote Profit Sharing
  7. Double-Promote Monthly Waterfall # 1 with Look-Back
  8. Exercise – Rebuild Tier #3
  9. Double-Promote Monthly Waterfall #2 with Look-Back
  10. Double Promote Returns Summary Exhibit
  11. Alternate Compounding Periods
  12. Sample Partnership Structure 1
  13. Sample Partnership Structure 2
  14. Sample Partnership Structure 3
  15. Claw-Back.
Registration is open for April Excel Bootcamp Webinars Register Now
left to take 50% off with coupon code: yearend50