The Storage Facility Development model projects annual future cash flows from a storage facility from the purchase of the land and rental of storage units to the sale of the property. This covers development costs, financing, levered free cash flow, and a cash waterfall for investors.
The tabs included are:
• Project Inputs
• Annual Cash Flows through the purchase of the land, construction, and sale of property
The model starts with the Project Input tab is used to enter most of the assumptions that will drive the model. Here assumptions such as the construction schedule, development costs, finance terms, property mix, and operating cost are entered and flow into the Annual Cash Flows tab.
The model is built to allow for a refinance of the property; the refinance period, cap rate, and loan-to-value can be adjusted. The holding period can be adjusted as well from a drop-down menu on cell K49 with an associated cap rate.
The Annual Cash Flows include a three-statement model with a projected rent roll from construction to the sale of the property. This includes important aspects such as development costs, financing, levered free cash flow, and a cash flow waterfall for investors. Occupancy for each period can be adjusted in row 12 to allow for variances in occupancy rate from period to period.
In the Cash Flow Waterfall section, equity invested, cash flow distribution, and IRR can be adjusted for GP/LP. In this section, IRR and NPV are calculated for GP/LPs and the project as a whole. Other metrics include Equity multiple and Unlevered/Levered Cash on Cash multiples.
All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.
Similar Products
Other customers were also interested in...
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 Financial Model Bundle
This is a collection of financial model templates that provides the financial projections and valuat... Read more
Real Estate Financial Model Templates Package
This is a collection of ready-made Excel financial model templates for real estate businesses and it... Read more
Real Estate Investment Fund – Development Pr...
This model projects monthly future cash flows from development properties in a Real Estate Investmen... Read more
Multi-Family Housing Rental Renovation Model
The Multi-Family Housing Rental Renovation model projects monthly future cash flows from the renovat... 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
Apartment Building / Self-Storage / Multi-Family A...
This real estate model works great for acquisitions of apartment buildings, multi-family properties,... 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
Warehouse Development Financial Model
This is a detailed, well-structured and transparent cash flow model for the development of... Read more
You must log in to submit a review.