Sheet C-01CalculatorRev.

Self-storage deal analyzer

Enter the rent roll, expenses, loan and exit. See the facility today, at stabilization, and what it returns. Same engine as the Storage Underwriter iPhone app.

01Property & price
Used for price and NOI per SF
02Unit mixMonthly rents
5×10
Size (ft)
Climate
10×10
Size (ft)
Climate
10×15 CC
Size (ft)
Climate
10×20
Size (ft)
Climate

In-place rent is what occupied tenants pay today. Market rent is what you expect to achieve at stabilization.

03Income & expensesAnnual
Grows with occupied units
Held flat through lease-up
Concessions & bad debt, % of revenue
Operating expenses ÷ EGI today
Optional; included in the ratio
Optional reassessed bill
04Financing
05Stabilization & exit
Per year, post-stabilization
Per year
Stabilization adjustments Optional
Annual, e.g. extra staff or marketing; phases in with the lease-up
Annual, e.g. a tenant protection program you'll start
Your investment targets IRR 14% · DSCR 1.25x
Underwriting resultWorth a closer look
NOI today
$210K
81% occupied
Stabilized NOI
$311K
90% at market rent

Stabilized value at 7.00% cap
$4.44M
+$1.16M vs. $3.29M all-in cost

Going-in cap
6.57%
Yield on cost
9.46%Stabilized
Levered IRR
23.3%7-year hold
Equity multiple
3.66x
Stabilized DSCR
1.60x
Cash-on-cash
11.2%Stabilized
Equity required
$1.05M
Break-even occ.
70%Today, incl. debt

This deal meets 3 of your 4 investment targets. Yield on Cost of 9.5% is below your 10.0% target.

Keep this deal. Storage Underwriter for iPhone saves every facility, adds a line-item P&L and expansion modeling, and exports an 8-page investment memo for partners and lenders.

iPhone app · coming soon →

NOI bridge: where the growth comes from

Annual
Current NOI$210K
Occupancy+$38K
Rent to Market+$64K
Other Income+$2.0K
Collection Loss−$3.1K
Stabilized NOI$311K

Occupancy is valued at in-place rents, rent-to-market at target occupancy. Expenses include any reassessed property tax.

Annual projection

$153KY1Y2Y3Y4Y5Y6Y7
YearEGIOpexNOIDebt svcCash flowOcc.DSCR
1$365K$131K$235K$162K$72K85%1.44x
2$416K$135K$281K$194K$87K90%1.45x
3$447K$139K$308K$194K$114K90%1.59x
4$460K$143K$318K$194K$123K90%1.63x
5$474K$147K$327K$194K$133K90%1.68x
6$488K$151K$337K$194K$143K90%1.73x
7$503K$156K$347K$194K$153K90%1.79x
Exit in year 7 at 7.00% on year-8 NOI of $358K: sale $5.11M, less $102K costs and $2.00M loan payoff = $3.00M net.

Levered IRR sensitivity

Exit cap × occupancy
Occ. \ Cap
6.00%
6.50%
7.00%
7.50%
8.00%
80%
20.2%
18.2%
16.3%
14.4%
12.6%
85%
23.7%
21.8%
20.0%
18.3%
16.6%
90%
26.8%
25.0%
23.3%
21.7%
20.1%
95%
29.7%
27.9%
26.3%
24.7%
23.3%
100%
32.3%
30.6%
29.0%
27.5%
26.2%
Meets 14% targetWithin 3 ptsBelowYour assumptions

Sources & uses

Purchase Price$3,200,000
Closing Costs$64,000
Loan Fees$22,400
Total cost$3,286,400
Primary Loan$2,240,000
Equity$1,046,400

Loan: $2,240,000 · $13,533/mo interest-only for 12 mo, then $16,191/mo amortizing.

Against your targets

3 of 4 met
IRR23.3%target 14.0%
Cash-on-Cash11.2%target 8.0%
DSCR1.60xtarget 1.25x
Yield on Cost9.5%target 10.0%
  • Large rent increase requiredStabilization assumes in-place rents rise 18% to market on a weighted basis.
  • Most expenses are estimated100% of operating expenses rely on the 38% placeholder ratio rather than actual figures.

340 units · 37,500 SF in the unit mix · price $9.4K/unit, $84/SF. Calculated in your browser with the same engine as the iOS app; nothing is sent anywhere.

Method

How the analyzer underwrites a facility

Self-storage acquisitions are priced on the gap between how a facility performs today and how it could perform once it is full and rents are at market. The analyzer models that gap explicitly instead of asking you for a single “pro forma NOI.”

1. Today: in-place performance

Scheduled rent is occupied units × in-place rent for every unit size. Ancillary income is added, collection loss is subtracted, and the result is effective gross income (EGI). Operating expenses are your expense ratio × today's EGI. That NOI divided by the purchase price is the going-in cap rate, the yield you are buying on day one.

2. Stabilized: full and at market

At stabilization every unit size reaches your target occupancy at market rent. Expenses are held at today's dollars. They do not scale with the new revenue, because most self-storage costs are fixed. The exception is property tax: if you enter a post-sale tax bill, it replaces the current one from stabilization forward. The cap rate calculator shows that tax effect on its own.

3. The path between them

Each month, occupancy and rent move in a straight line toward stabilization. After stabilization, rent grows at your growth rate, and expenses grow from month one. Months are summed into years. Debt service comes from a monthly amortization schedule that honors interest-only periods. Try the lease-up calculator to see the monthly path by itself.

4. Exit and returns

The sale price is the following year's NOI divided by the exit cap. That is how a buyer would value it. Selling costs and the remaining loan balance come off to give net proceeds. The equity cash flows (equity in, annual cash flow, net proceeds) produce the levered IRR and equity multiple.

What the flags mean

The analyzer checks the same risks the app does: rent increases above 15% on a weighted basis, occupancy gains above 15 points, DSCR below your minimum, year-1 coverage under 1.0x, an exit cap below the going-in cap, leverage above 75% loan-to-value, a large tax reassessment, negative year-1 cash flow, and a unit mix that does not match the stated rentable square feet.

These numbers are only as good as your inputs. Verify rents against the rent roll and bank deposits, and taxes with the county assessor. The due diligence checklist maps each input to the document that proves it.
FAQ

Questions

What does a self-storage deal analyzer calculate?

It turns a facility's rent roll, income, expenses, financing and exit assumptions into current and stabilized NOI, value at a cap rate, cash flow by year, and investor returns: going-in cap rate, yield on cost, levered IRR, equity multiple, cash-on-cash and DSCR. This one also shows where the NOI growth comes from and how returns change with exit cap and occupancy.

How is stabilized NOI calculated?

Each unit size moves from its current occupied count to your target occupancy and from in-place rent to market rent. Tenant protection and fee income grows with occupied units; retail and other income stays flat. Collection loss is taken as a percentage of revenue, and operating expenses come from your expense ratio applied to today's effective gross income, held in today's dollars, plus any reassessed property tax. Stabilized NOI is stabilized effective gross income minus those expenses.

How does the lease-up period affect returns?

Occupancy and rent move in a straight line from today to stabilization over the months you enter, and rent growth starts only after stabilization. A longer lease-up delays the NOI increase, lowers early cash flow and debt coverage, and reduces IRR even if the stabilized NOI is identical.

What exit cap rate should I use?

Many investors set the exit cap at or above the going-in cap rate so the return does not depend on cap rates falling. The sensitivity grid shows IRR at exit caps 0.5 point above and below your assumption (0.25 point below a 6% base), and the analyzer flags an exit cap below the going-in cap.

Is this the same math as the Storage Underwriter iPhone app?

Yes. The calculations are a direct TypeScript port of the app's Swift underwriting engine, and they are tested against outputs generated by the Swift engine itself on 23 scenarios. The app adds saved deals, a line-item P&L, expansion modeling and an 8-page PDF investment memorandum.

Is my deal data saved or sent anywhere?

No. Everything is calculated in your browser. Your latest inputs are kept in this browser's local storage so they are still there when you come back; nothing is uploaded.