A conservative model does not assume the facility will fail. It shows whether the investment can meet its obligations when lease-up is slower, costs rise or the local market becomes less forgiving.
A self-storage opportunity can look compelling when the model begins with the seller’s projected rents, fast occupancy growth and a clean expense estimate. Those inputs may describe what could happen. They do not establish what is likely or what the owner can safely carry.
A useful model begins with supportable evidence. It includes the full cost of buying or building, operating the facility, serving the debt, funding lease-up and replacing major components. It then tests the assumptions most likely to change.
The purpose is to understand how much of the deal’s performance comes from current facts and how much depends on future execution.
The revenue model should be grounded in the local market study, independent feasibility work and the facility’s actual operating record when one exists.
For each unit type, document:
Number of rentable units and rentable square feet
Climate-controlled, drive-up, interior or vehicle-storage designation
Current street rate
Average in-place rate for occupied units
Promotions and free-rent periods
Physical occupancy
Economic or collected occupancy
Delinquency and write-offs
Modeled rent and occupancy
Source and date for each assumption
Avoid applying one average rate to the entire property when unit size, access and climate control create different economics. A blended rate can be a useful summary, but the model should be built from the underlying unit mix.
A competitor’s advertised price is one data point. Promotions, administrative fees, rent guarantees, delinquency, refunds and customer churn determine what the property collects.
For an acquisition, compare:
Street rates offered to new customers
Scheduled in-place rents
Cash collected after discounts and losses
Recent rate increases and tenant response
Move-ins and move-outs by month
Complimentary, owner-used or unrentable units
Accounts labeled occupied despite severe delinquency
For a development, model the promotional period and collected rent during lease-up. A facility can fill units quickly through discounts while producing less cash than the occupancy percentage suggests.
If the plan relies on rents above nearby competitors or immediate increases for existing tenants, show the timing, evidence and likely customer response instead of treating the increase as automatic.
Keep an assumption log that records the input, source, date, rationale and scenario in which it changes. Label amounts as historical, quoted, contractual or estimated.
Examples of current evidence include:
Signed purchase agreement or land contract
Current rent roll and bank deposits
Contractor bids
Tax bills and local tax estimates
Buyer-specific insurance quote
Loan proposal or term sheet
Vendor contracts
Property-condition capital schedule
Examples of future assumptions include rent growth, lease-up pace, concessions, payroll savings, repair timing and the arrival of new competitors. Making the distinction visible helps reviewers challenge the right numbers.
Include the negotiated purchase price for an existing facility or the complete land cost for a development. Show deposits, credits and any seller financing separately so the model reflects both total cost and cash timing.
For a new facility or expansion, include buildings and the work that makes the site usable: grading, foundations, utilities, stormwater, paving, landscaping, fencing, gates, lighting, signage, fire protection and required off-site improvements.
Use detailed bids and identify allowances, alternates and exclusions. A building quote may omit site work, utility upgrades or municipal requirements that materially affect the project.
Professional fees and permits
Architecture and engineering
Survey and geotechnical work
Environmental and feasibility studies
Legal and accounting
Appraisal and lender reports
Zoning and entitlement applications
Building permits and inspections
Impact, tap and utility fees
Construction administration
Separate amounts already paid from costs still due. Include a contingency for work that is reasonably expected but not fully scoped.
Build a sources-and-uses schedule
Every project dollar should appear as a use and be matched with a committed source.
Common sources include:
Buyer equity
Senior debt
Seller financing
Partner equity
Construction draws
Approved working-capital proceeds
Other committed financing
Common uses include:
Purchase or land cost
Construction and site development
Professional fees and permits
Loan fees and interest
Immediate repairs
Equipment and technology
Pre-opening costs
Lease-up losses
Working capital
Required reserves
Contingency
Sources must equal uses. A source should also be available when the use must be paid. Reimbursement-based construction draws can create a temporary cash need even when the expense is eligible for financing.
Use the actual proposed loan structure when available.
Record:
Loan amount
Interest rate
Fixed or variable structure
Index, spread and floor
Amortization period
Maturity date
Interest-only period
Construction-draw mechanics
Payment frequency
Fees
Required reserves
Prepayment terms
For a variable-rate loan, show payments at the starting rate and at higher rates. For construction, calculate interest on projected draws and extend the carry when the downside case delays completion or lease-up.
Do not use an annual interest estimate when payment timing matters. A monthly schedule shows when debt begins, when principal amortization starts and how the payment interacts with the lease-up cash balance.
The seller’s current tax bill may not reflect the buyer’s future cost. Taxes can change after a sale, reassessment, construction completion, expansion, change of use or expiration of an incentive.
Ask a qualified local professional about:
Likely assessed value
Applicable tax rates and districts
Reassessment timing
Treatment of new construction
Exemptions or abatements
Appeal process
Supplemental or delayed bills
Whether personal property is taxed separately
Model the expected post-transaction amount and the month in which the increase is likely to affect cash. Stress-test a higher assessment rather than extending the historical bill by a generic percentage.
Insurance cost depends on the buyer, property, location, construction, loss history, coverage and deductibles. Obtain a quote or informed indication for the intended transaction.
Review:
Property and general liability
Business interruption
Flood
Wind or named-storm coverage
Equipment breakdown
Crime and cyber
Workers’ compensation
Vehicle exposure where applicable
Replacement-cost assumptions
Deductibles and exclusions
Place annual or semiannual premiums in the month they are paid unless financing or escrow changes the cash timing. Include a downside case for premium and deductible increases.
The staffing model should reflect how the facility will actually be operated.
On-site manager compensation
Payroll taxes and benefits
Relief coverage and overtime
Remote management staff
Call-center support
Bookkeeping and administration
Third-party management fees
Training and hiring costs
Owner-provided labor
If the owner plans to perform management work, include owner compensation or a replacement-labor cost. Otherwise, the model can make investment returns look stronger by treating work as free.
Electricity for climate control, lighting, gates and security
Water and sewer
Gas or other heating fuel
Internet and communications
Trash service
Seasonal demand
Utility deposits and connection charges
Rate increases
For an acquisition, compare monthly bills with weather and occupancy. For a development, use engineering information and comparable facilities rather than a generic cost per square foot when climate control is material.
Recurring maintenance belongs in the operating budget. Known replacements and major capital work should appear on a separate schedule. A replacement reserve is a planning allowance for future work, not a substitute for identifying the expected projects.
Model:
Routine door, gate and lighting repairs
Preventive HVAC and fire-system service
Pest control, landscaping and snow removal
Roof, paving and drainage maintenance
Immediate repairs from the property-condition assessment
Major replacements during the holding period
Operational disruption and lost rentals
Contingency for concealed conditions
Tie the reserve and capital schedule to the remaining useful life of the roofs, paving, doors, HVAC, elevators, gates and security equipment.
Property-management software
Online rental and electronic-signature tools
Website and hosting
Call center and phone routing
Gate and access-control integration
Camera or cloud-storage subscriptions
Payment-processing fees
Chargebacks and bank fees
Identity-verification or fraud tools
Data backups and cybersecurity services
Confirm minimums, per-unit charges, transaction fees, implementation costs and annual increases. For an acquisition, verify whether current contracts and accounts transfer to the buyer.
Marketing cost should reflect the facility’s occupancy stage and competitive position. A development and a struggling acquisition may need more support than a stabilized property.
Search advertising
Directory or marketplace listings
Website work and local search
Signage and opening campaigns
Referral relationships
Promotions and free rent
Call tracking
Creative and agency fees
Reputation management
Cost per completed move-in
Track marketing spend and concessions separately so the model shows the full cost of acquiring a tenant. In the downside case, slower lease-up may require higher marketing while producing less revenue.
Gate and operator service
Keypads and controllers
Camera maintenance and storage
Alarm monitoring
Lighting repair and electricity
Fence and perimeter repair
Network and remote-access support
Locks and overlocks
After-hours response
Replacement parts and equipment reserves
Security is both a recurring operating cost and a capital need. Avoid placing the full burden in only one category.
Full units do not guarantee full collections. Include delinquency, write-offs, refunds and the direct cost of enforcing lien rights and disposing of abandoned property.
Uncollected rent and fees
Chargebacks and returned payments
Required notices and mailing
Auction platform or advertising costs
Lock cutting and inventory labor
Cleaning and disposal
Legal or compliance support
Periods when delinquent units cannot be rerented
Proceeds retained or returned as required
Use the facility’s historical collection reports and current operating policy where available. State law and rental-agreement requirements affect timing and cost.
A development or expansion can operate at a loss while occupancy builds. An annual model can hide the lowest cash point.
The monthly lease-up schedule should include:
Units available by month
Move-ins and move-outs
Net absorption
Street rates and promotions
Collected revenue
Operating expenses that begin before opening
Payroll and marketing
Interest and loan payments
Property taxes and insurance
Working-capital balance
Model phased openings when relevant. Construction completion is not the same as stabilization, and a certificate of occupancy does not immediately create enough revenue to cover the property.
Working capital carries the business through timing differences, operating deficits and ordinary surprises.
Build a rolling monthly cash balance:
Beginning cash
Cash collected from customers
Loan draws or other funding
Operating expenses
Debt payments
Capital expenditures
Required reserve deposits
Ending cash
Identify the lowest projected balance, the month it occurs and the additional cash required to remain above the owner’s minimum reserve. Repeat the calculation for each stress case.
A project can be profitable over several years and still run out of money during construction or lease-up. The model should show when additional cash is needed and who is committed to provide it.
If ownership requires ongoing labor, show a reasonable owner salary, management payment or replacement cost. Keep compensation separate from investment distributions so the reader can see what is earned for work and what is earned on capital.
Income-tax treatment depends on the ownership structure, jurisdiction, depreciation, allocation and individual circumstances. Work with a tax advisor to determine whether and how taxes or tax distributions belong in the owner-level cash model. Avoid presenting a pre-tax return as though it were spendable after-tax cash.
Change related assumptions together. Slower lease-up can reduce revenue, extend interest carry, increase marketing and require more working capital at the same time.
Reduce monthly net absorption and extend the period to stabilization. Carry operating expenses, marketing and debt for the longer period.
Reduce achievable street and collected rents by unit type. Recalculate revenue, coverage and cash needs without assuming occupancy improves enough to offset the difference.
Increase hard costs, site work, professional fees and contingency. Test whether the loan grows with the budget or whether the owner must fund the overrun.
Increase both recurring expenses and any required escrow or reserve funding. Use the timing of the increase in the cash schedule.
Add free rent or discounts and show their effect on collected revenue. Include the marketing cost used to generate the move-in.
Recalculate construction interest, permanent payments and variable-rate debt. Apply the higher rate for a realistic period.
Slow lease-up, lower rents, increase marketing and assume more tenant churn. A competitor affects several operating inputs rather than one line.
Test lower move-ins, more move-outs, greater delinquency, weaker pricing and reduced ancillary income. Consider whether local employers, colleges, military activity or housing demand create additional concentration.
A common debt-service coverage ratio divides a defined net operating income by required principal and interest payments for the period. The result depends on the definitions used.
Debt-service coverage ratio = underwritten net operating income ÷ required debt service.
Calculate coverage using your own supportable case, then reproduce the lender’s underwriting assumptions. Ask how the lender treats:
Potential rent and vacancy
Lease-up and stabilization
Management fees
Property taxes and insurance
Replacement reserves
Ancillary income
Nonrecurring expenses
Capital expenditures
Interest-only periods
Variable-rate or stressed payments
The Office of the Comptroller of the Currency identifies income-generating capacity and debt-service coverage as central parts of commercial real estate analysis. Lenders may apply their own underwriting criteria and adjustments to property cash flow.
Source: Office of the Comptroller of the Currency, Commercial Real Estate Lending
Reconcile the difference between the two calculations line by line. A lender’s lower coverage result may come from lower rents, higher vacancy, a management fee, tax or insurance adjustments, reserves or a different debt payment.
For the base case and each downside case, show:
Stabilized rent and occupancy
Time to stabilization
Total project cost
Peak equity required
Minimum cash balance
Annual debt service
Debt-service coverage
Working-capital shortfall
Largest cost or timing change
Action the owner would take
The summary should identify which scenario the project can carry and which one requires more equity, a lower price, a smaller project, different loan terms or another change to the plan.
The model begins with the seller’s projected rents without market support
Every occupied unit is modeled at the current street rate
Physical occupancy is used as a substitute for collected revenue
Construction costs omit site work, utilities or professional fees
Property taxes extend the seller’s historical bill
Insurance is a rough estimate rather than a buyer-specific quote
Owner labor is treated as free
The capital reserve is not tied to a replacement schedule
Lease-up moves directly from opening to stabilization
Working capital is a round number with no monthly cash calculation
Higher interest rates change the rate but not the payment
A new competitor affects only occupancy
The lender’s DSCR definition has not been reproduced
The downside case still assumes every major operational goal is achieved
The goal is not to make every assumption pessimistic. It is to use evidence, capture the full cash requirement and leave enough room for a result that is less favorable than the sales presentation.
A conservative model should tell the buyer how much cash is required, when it is required and which assumptions determine whether the property can cover its obligations.
Ask one final question: If lease-up takes longer, costs rise and the lender underwrites less income than you do, can you still fund the project and remain comfortable owning it?
First Bank of the Lake helps business owners nationwide find the financing they need to grow, expand and invest in what comes next. Our experience has made us one of the country’s leading SBA lenders. Since 2023, First Bank of the Lake has ranked among the top 1% of SBA 7(a) lenders, placing 15th nationwide by approval amount and have also ranked as the third most active SBA franchise lender by lending volume, according to the U.S. Small Business Administration.
Founded in 1985, we combine national lending capabilities with the personal attention you would expect from a community bank. Our knowledgeable team takes the time to understand your goals, walk you through your options and support you at every step.
If you are considering financing for your business, we would be happy to answer your questions. Call us at (888) 828-5689 or complete the form above to start the conversation. You can also visit our website or connect with us on Facebook and LinkedIn.