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

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)

Reports

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