Self Storage Facility 5-Year Financial Model Excel | Occupancy, Cash Flow, Break-Even, Scenarios & Investor Deck

📊 SELF STORAGE FACILITY – 5-YEAR FINANCIAL MODEL & INVESTMENT FORECAST

Plan facility revenue, occupancy, rental rates, operating expenses, staffing, CapEx, debt, liquidity, and funding requirements with an integrated financial model built specifically for self storage facilities.

This professional package combines a 24-worksheet Excel Financial Model, a 15-slide Investor / Management PowerPoint Deck, and a detailed 24-page How-to-Use PDF Guide.

The model connects the main operating drivers of a self storage facility with a complete 2029–2033 Three-Statement Forecast, allowing operators, buyers, investors, developers, consultants, and management teams to evaluate facility performance within one structured framework.

🏠 UNIT MIX & FACILITY CAPACITY

Build a flexible facility configuration covering:

✅ Small Units ✅ Medium Units ✅ Large Units ✅ Climate-Controlled Units ✅ Parking ✅ Vehicle Storage ✅ User-defined custom unit types

For each unit type, users can configure unit count, monthly rental rate, starting occupancy, annual rate growth, climate-control status, and parking / vehicle classification.

📈 PHYSICAL & ECONOMIC OCCUPANCY

The occupancy model links unit inventory with:

✅ Starting Occupancy ✅ Annual Occupancy Ramp ✅ Target Occupancy ✅ Scenario Adjustments ✅ Occupied Units ✅ Physical Occupancy

Economic Occupancy is calculated separately by comparing net rental revenue with potential gross rental revenue, providing an additional view of facility performance.

💰 RENTAL & ANCILLARY REVENUE

Rental revenue is modeled by unit type using monthly rental rates, occupancy, rate growth, and concessions / bad-debt assumptions.

Optional ancillary revenue streams include:

✅ Late Fees ✅ Insurance / Protection Plans ✅ Locks / Merchandise ✅ Administrative Fees ✅ Other Ancillary Revenue ✅ Custom Revenue Lines

This provides a transparent separation between core rental revenue and additional facility income.

💼 OPERATING EXPENSES & STAFFING

Plan facility operating costs including:

✅ Property Tax ✅ Insurance ✅ Utilities ✅ Repairs ✅ Security ✅ Software ✅ Marketing ✅ Management ✅ Maintenance ✅ Licenses & Permits ✅ Professional Fees ✅ Office & Administration ✅ Variable Operating Costs

Staffing logic includes headcount, compensation, payroll burden, benefits, and wage growth across facility management, customer service, maintenance, security, support, and additional customizable roles.

🏗️ CAPEX, DEPRECIATION & DEBT

Build a structured capital plan covering areas such as:

✅ Construction / Fit-Out ✅ Security Systems ✅ Gates ✅ Cameras ✅ Office Equipment ✅ Renovation ✅ Replacement CapEx ✅ Signage ✅ Paving / Exterior ✅ IT / Access Control

CapEx feeds into depreciation, while the Debt Schedule calculates new borrowing, principal repayments, interest expense, total debt service, ending debt, and Debt Service Coverage Ratio.

🧾 FULL THREE-STATEMENT FINANCIAL MODEL

The workbook integrates:

✅ Income Statement ✅ Balance Sheet ✅ Cash Flow Statement

Operating performance, CapEx, depreciation, financing, working capital, and funding requirements are connected throughout the model.

📅 MONTHLY + FIVE-YEAR FORECAST

The system includes:

✅ Detailed Monthly Forecast — Year 1 ✅ Annual Forecast — Years 1–5 ✅ Illustrative forecast period 2029–2033

The five-year view consolidates Revenue, EBITDA, EBITDA Margin, Net Income, Operating Cash Flow, CapEx, Debt Service, Funding Required, Ending Cash, Physical Occupancy, Average Monthly Rent, and Revenue per Available Unit.

📊 EXECUTIVE DASHBOARD

The management dashboard provides an immediate overview of:

✨ Total Units ✨ Physical Occupancy ✨ Economic Occupancy ✨ Average Rent per Unit ✨ Monthly Revenue ✨ Revenue per Available Unit ✨ EBITDA ✨ EBITDA Margin ✨ Ending Cash ✨ Break-Even Occupancy ✨ Debt Service ✨ Funding Required

Four integrated charts visualize:

📈 Revenue & EBITDA 🏠 Physical Occupancy 💵 Ending Cash & Funding 💰 Rental vs Ancillary Revenue

🎯 BREAK-EVEN ANALYSIS

Evaluate both operating and liquidity requirements through:

✅ EBITDA Break-Even Occupied Units ✅ EBITDA Break-Even Occupancy ✅ Cash Break-Even Occupancy ✅ Fixed Cost Base ✅ Contribution per Occupied Unit ✅ Debt Service ✅ CapEx

This helps users understand the occupancy level required under their own rent, cost, payroll, debt, and capital assumptions.

🔄 BEAR • BASE • BULL SCENARIOS

Compare three transparent planning cases:

🔴 Bear 🔵 Base 🟢 Bull

Scenario multipliers can flex:

✅ Occupancy ✅ Rental Rates ✅ Operating Expenses ✅ CapEx ✅ Financing

The selected scenario flows through the connected model and updates Revenue, EBITDA, Ending Cash, Occupancy, and Funding Required.

🔥 OCCUPANCY × RENT SENSITIVITY

The integrated sensitivity analysis evaluates how different combinations of:

Occupancy × Average Monthly Rent

may affect:

✅ EBITDA ✅ Ending Cash

This provides a focused view of two of the most important economic drivers of a self storage facility while holding other assumptions constant.

🏦 FUNDING REQUIREMENT

The model evaluates:

✅ Minimum Cash Balance ✅ Beginning Cash ✅ Operating Cash Flow ✅ CapEx ✅ Debt Draws ✅ Principal Repayment ✅ Pre-Funding Ending Cash ✅ Equity Funding Required ✅ Post-Funding Ending Cash

Year 1 funding logic also considers monthly cash timing before flowing into the annual forecast.

🎤 15-SLIDE INVESTOR / MANAGEMENT POWERPOINT

The included professional presentation summarizes the model through sections covering:

🏢 Executive Snapshot & Facility Overview 🏠 Unit Mix 📈 Occupancy 💰 Revenue Build 💼 Operating Expenses 👥 Staffing & CapEx 📊 5-Year Forecast 💵 Cash & Funding Requirement 🏦 Debt Schedule 🎯 Break-Even Analysis 🔄 Scenario Analysis 🔥 Sensitivity Analysis ⚠️ Risks & Use Notes

It is designed for structured management reviews, facility planning, consulting work, financing preparation, and investor discussions.

📘 24-PAGE HOW-TO-USE GUIDE

The detailed guide explains the complete workflow, including:

✅ Quick Start ✅ Navigation & Color Legend ✅ Settings & Scenario Selection ✅ Assumptions ✅ Unit Mix ✅ Occupancy ✅ Rental Revenue ✅ Ancillary Revenue ✅ Operating Expenses ✅ Staffing ✅ CapEx & Depreciation ✅ Debt Schedule ✅ Three Statements ✅ Monthly Forecast Year 1 ✅ Annual Forecast & KPI Analysis ✅ Break-Even Analysis ✅ Scenario Analysis ✅ Sensitivity Analysis ✅ Funding Requirement ✅ Executive Dashboard ✅ Google Sheets Workflow & Troubleshooting

💻 TECHNICAL COMPATIBILITY

✅ Microsoft Excel (.xlsx) ✅ Microsoft PowerPoint (.pptx) ✅ PDF Guide ✅ Google Sheets import possible ✅ No macros or VBA ✅ No APIs ✅ No live market data ✅ No external Excel data connections

📌 Microsoft Excel remains the reference environment. When imported into Google Sheets, formatting or chart appearance may vary, although the core workbook structure and calculation logic remain usable.

⚖️ IMPORTANT DISCLAIMER

This product is an editable financial planning and modeling template intended for informational, organizational, and decision-support purposes only. It does not constitute real estate, investment, valuation, financing, tax, legal, accounting, or other professional advice. No market values, investment returns, cap rates, funding approvals, or future operating results are guaranteed or represented.

All included sample data and assumptions are illustrative and should be replaced with facility-specific information before real-world use.

📊 This complete planning system brings facility operations, occupancy, rental economics, financial forecasting, break-even analysis, debt, liquidity, and funding requirements into one connected framework. It is designed to help operators, investors, developers, consultants, and finance professionals evaluate assumptions more clearly, compare alternative scenarios, and prepare more structured management and financing discussions.