BUY WITH CONFIDENCE
BENEFITS OF DOCUMENT
DESCRIPTION
Real estate private equity (REPE) firms raise capital from outside investors, called Limited Partners (LPs), and then use this capital to acquire and develop properties, operate and improve them, and then sell them to realize a return on their investment. REPE firms usually focus on commercial real estate – offices, industrial, retail, multifamily, and specialized properties like hotels.
This financial model presents a business scenario of a REPE firm and analyzes property acquisitions costs, debt financing, property operating income, property level cash flows and returns, fund level cash flows and partnership cash flows and return metrics.
Outputs of the model include Acquisitions and Debt Schedules, Property Monthly Operations Analysis, Property Monthly and Annual Cash Flow, Fund Annual Cash Flow, Partnerships Cash Flow and a professional Executive Summary presenting firm's results.
The structure of the template follows Financial Modeling Best Practices principles and is fully customizable.
Inputs:
• General Business Info & Reporting Metrics
• Fund Level Assumptions (Ownership share between General and Limited Partner, Set up costs & Fund Level Expenses)
• Properties Portfolio (10 different properties, Acquisition, Hold and Disposition Timing)
• Properties Acquisition & Disposition Assumptions (Purchase Price, Acquisition & Closing Fees, Sale Price, Cap Rates, Selling Costs)
• Properties Revenue & Costs Assumptions
• Debt Assumptions (Loan to Value, Interest Rates, Loan Term)
Outputs:
• Total Acquisition Costs (All-in-basis) and Loan (Loan Amount, Monthly Payment) calculations
• Debt Schedule per Property
• Properties Operations Analysis (Revenue, Opex, CapEx, Net Cash Flow)
• Properties Monthly and Annual Cash Flow including Unlevered and Levered Cash Flows, Return Metrics (IRR, MOIC) and Partners Cash Flow distribution
• Fund Level Annual Cash Flow (including Investment Cash Flow of each property and Fund Level Expenses)
• Partnership Cash Flows (a standard 4-tier
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Integrated Financial Model, Real Estate, Private Equity Excel: Real Estate Private Equity (REPE) Financial Model Excel (XLSX) Spreadsheet, Profit Vision
OVERVIEW
(XLSX)
ABOUT THE AUTHOR
Profit Vision provides Consulting & Outsourced Financial Services as well as Financial Planning & Performance analysis to small and mid-size businesses by implementing efficient and effective tools to assist them with start-up business plans or improve their ongoing operations. [read more]
Ask the Author a Question
Real Estate Integrated Financial Model Private Equity Deal Structuring Valuation Model Example Fundraising Strategic Planning Business Plan Example Mining Industry Value Chain Analysis
![]() |
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more. |