New Version Updates:• The model supports now up to 50 properties
• Updated Acquisition, Financing and Operations Assumptions and Output Reports
• New Investors Distribution Waterfall & Fund Summary
Model 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 Monthly & Annual Cash Flow per Property, Portfolio Annual Cash Flows & Returns, Fund Annual Cash Flows & Returns, Partnerships Cash Flow and a professional Executive Summary presenting Fund’s overall performance.
The structure of the template follows Financial Modeling Best Practices principles and is fully customizable.
Inputs:
• Fund Level Assumptions (incl. Investments Assumptions, Set up costs & Fund Level Expenses, Investors Contributions & Distributions Assumptions)
• Properties Acquisition & Disposition Assumptions (incl. Purchase date, Purchase Price, Hold Period, Sale Price, Transactions Fees, etc.)
• Debt Financing Assumptions (incl. Loan to Value, Interest Rates, I/O Period, Loan Term)
• Debt Refinancing Assumptions (incl. Refinancing Option, Refinancing Timing, Loan to Value, Interest Rates, I/O Period, Loan Term )
• Properties Revenue Assumptions (incl. Rental Rates, Vacancy %, Rent Deposits)
• Properties OpEx & CapEx Assumptions (incl. Mgmt Fees, Property Taxes, Leasing Commissions, G&A, TIs & Reserves CapEx, etc.)
Outputs:
• Monthly Cash Flow Analysis per Property (incl. EGR, NOI, Property Disposition, Net CF before and after Debt, Unlevered and Levered Cash Flows)
• Monthly Cash Flow Sumary per Year
• Annual Cash Flow per Property including Unlevered and Levered Cash Flows & Return Metrics (IRR, MOIC)
• Portfolio Cash Flow including Equity & Debt Financing, Unlevered and Levered Cash Flows & Return Metrics (IRR, MOIC)
• Fund Level Annual Cash Flow (including Portfolio Cash Flows, Fund Level Expenses and Fund Return Metrics)
• Partnership Returns Waterfall analyzing the distribution between LPs and GPs, including calculation of GP Catch up (Before or After Principal) and Carried Interest.
• Executive Summary presenting overall REPE performance
Detailed instructions on the use of the model are included in the Excel file.
Help & Support
Committed to high quality and customer satisfaction, all our templates follow best practice financial modeling principles and are thoughtfully and carefully designed, keeping the user’s needs and comfort in mind.
No matter if you have no experience or you are well versed in finance, accounting, and the use of Microsoft Excel, our professional financial models are the right tools to boost your business operations!
If you however experience any difficulty while using this template and you are not able to find the appropriate guidance in the provided instructions, please feel free to contact us for assistance.
If you need a template customized for your business requirements, please e-mail us and provide a brief explanation of your specific needs.
Similar Products
Other customers were also interested in...
Single Family Residential Property Investment Mode...
Financial model presenting an investment scenario (buy, hold, sell) for a Single Family Residential ... Read more
Real Estate Acquisition Financial Model (Commercia...
Simple Real Estate Acquisition Financial Model suitable for Commercial, Industrial and Residential P... Read more
Land Development Financial Model – Dynamic 1...
A Financial model presenting a development scenario for raw Land. Suitable for residential land d... Read more
Condominium Development – Dynamic 10 Year Fi...
A condominium (or condo for short) is a building structure divided into several units that are each ... Read more
Single Tenant Net Lease (NNN) – Investment &...
Single-tenant property is a property that is fully occupied by a single user. Single-tenant properti... Read more
Prefabricated Buildings Manufacturer – Dynam...
Financial model presenting a development scenario for a Prefabricated Buildings Factory including co... Read more
Mixed-Use Real Estate Model: Leverage / JV Options
A general real estate model to plan all assumptions for up to 7 'uses' for a given property. Include... Read more
Real Estate Portfolio Template – Excel Spreadshe...
The Real Estate Portfolio Template forecasts the financial performance when building a real estate p... Read more
Real Estate Acquisition-Rent-Sell Comprehensive An...
An integrated, dynamic and ready-to-use Real Estate Acquisition-Rent-Sell Comprehensive Analysis Mod... Read more
Construction / Development Financial Model
Development & Construction Model presents the case where a property with multiple residential un... Read more
You must log in to submit a review.