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
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:
- Preferred Return Non-Compounded Annual
- Preferred Return Non-Compounded Annual Solution
- Preferred Return Compounded Monthly
- Preferred Return Compounded Monthly Solution
- 3-Tier Annual Waterfall with Look-Back
- Double-Promote Profit Sharing
- Double-Promote Monthly Waterfall # 1 with Look-Back
- Exercise – Rebuild Tier #3
- Double-Promote Monthly Waterfall #2 with Look-Back
- Double Promote Returns Summary Exhibit
- Alternate Compounding Periods
- Sample Partnership Structure 1
- Sample Partnership Structure 2
- Sample Partnership Structure 3
- Claw-Back.