Commercial Real Estate Properties, Development, Financial Model, Mini Storage, Real Estate

Accounts Payable, Cap Rate (Capitalization Rate), Cash on Cash Yield, Cash-on-Cash Multiple, Excel, Financial Debt, Private Equity Waterfall Distribution Models, Property Valuation, Real Estate Valuation, Rental Income, Revenue Projections, Scenario Analysis, Valuation

This is a fully functional, institutional quality, and dynamic real estate Development Financial Model. It was set up with the guidance of a real estate expert. It’s a powerful model, yet, user-friendly, that will provide to the user a detailed Excel spreadsheet in which, the viability of an investment in a Self Storage property can be assessed with accuracy.

The template is monthly in nature, and it is a 100% unlocked Excel file with fully transparent formulas that can be further tailored to suit your particular needs.

Model Options:

• Dynamic Monthly & Annual Cash Flow: In order to calculate the key investments metrics needed to determine the feasibility of the project, and the value of a potential selling, the cash flow is calculated in a monthly base;

• Because this is a developing project model, the lease-up forecast takes into account the fact that during the construction phase there is no or limited revenue, and the construction loan interests are capitalized accordingly with the parameters defined in the executive summary sheet

• Dynamic construction budget: the construction expenses are modeled following an s-curve (normal distribution), meaning that construction expenses are projected in a way that you have few expenses in the beginning, and then they quickly ramp up to your full project costs;

• Dynamic equity financing: unlike an existing property acquisition where you only need to take your purchase price and multiply by a certain percentage and get the loan/equity amount required, this model, trough complex formulae and macros, works backward to get the required amount and timing for equity/loan funding.

• Construction Loan: The model assumes that first the construction expenses are funded through equity, and once we’ve used all available equity; we can, then, start drawing construction loan tranches to pay for the remaining costs of the project.

• Permanent Finance: the model also covers permanent financing, so once we actually have built out the property and the project has been stabilized, we’re likely going to refinance the project if we don’t decide to sell.
• The key drivers of the financial model and return metrics are shown on the summary tab. The summary tab also includes dynamic charts, which update automatically accordingly with the hold period. The Summary tab is meant to be printed, and as such the view mode is set to Print Preview by default.

• Equity Waterfall Model: the template provides a 3 tier equity waterfall model, so the user will be able to determine how much capital the limited partner and General partner will get, and their respective rates of return;
• Scenarios: The scenarios modeling sheets provide four possible scenarios based on the Rent, Vacancy, construction costs and exit, Cap rate variance, etc. The base scenario is defined by default with the inputs set on the Investment Summary and the Assumptions sheets.
Instructions
• The user only needs to input information into the dark blue font cells in the Investment Summary and Assumption sheets. If the contents of a cell are colored black, it means that is a formula.
• The template is provided with information from a hypothetical property, for demonstration purposes that must be erased for a real property valuation;
• The investment summary sheet provides an overview of the property based on several key metrics and assumptions.
• In the Assumptions sheet the user can define the remaining drivers;
• To assess the sale value of the property, this model is designed to capitalize on the NOI of the 12 months subsequent to the disposition divided by the defined exit cap rate;
• The maximum horizon for this model is ten (10) years;
• For revenue the user must provide the current rents, the type, quantity and square foot of the different units, taking into account the rentable area
• For Construction Budget, the user needs to set the budget and timing for different expense categories.