Storage Facility Development Model

Storage Facility Development Model

The Storage Facility Development model projects annual future cash flows from a storage facility from the purchase of the land, 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
• Construction Loan worksheet

The model starts with the Construction Loan worksheets where you can break down certain costs that make up the construction loan. Next, 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. Holding period can be adjusted as well from a drop-down menu on cell K49 with an associated cap rate.

The Annual Cash Flows includes a three statement model with projected rent roll from construction to the sale of the property. This also 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 is 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.