Turner Farms Self Storage in Garner, North Carolina is 98.0% occupied, and its net operating income covers its debt service 2.21 times. Those figures are from the October 2026 servicer report in a CMBS filing. Put through a one-sheet deal screen at its appraised value of $14.8 million, with a new loan at today’s rates, the property raises none of the screen’s four warning flags and returns a levered IRR of 5.4%. The verdict cell reads PASS, which on this sheet means decline: at that price and on these inputs, the screen does not send the deal to a full underwrite.
You are on the acquisitions team of an institutional real estate investor, and more broker teasers arrive than you can underwrite. We asked Compound to build the screen that decides which teasers earn a full model, and to test it on a real property that it picked from CMBS filings. It ran on November 15, 2026 and returned one Excel workbook with three sheets: Screen, Assumptions and Sources.
One caution before the numbers. The price is an assumption set by our request: the latest appraised value in the filing, which is dated May 18, 2021. No one has offered the property at that price. The 5.4% is the output of a screening exercise on public figures and stated assumptions. It does not forecast what the property will return, and nothing here is advice to buy or sell it.
What the workbook shows:
- No flag is raised, and the deal still misses the hurdle. Levered IRR is 5.4% over a ten-year hold against a 10% hurdle, with an equity multiple of 1.53x.
- The debt lowers the return. Unlevered IRR is 6.3%. The going-in cap rate of 7.10% is above the 6.90% loan rate by 20 basis points, so the negative-leverage flag reads OK.
- Net operating income barely moves in ten years. It is $1,050,249 today and $1,067,638 in year 10. Rent grows 1.70% a year, expenses grow 3.74%, and occupancy trends from 98.0% to 91.8%.
- The existing loan and the new loan are far apart. The loan in the filing carries a 3.35% fixed rate and $475,971 of annual debt service. A new $8.88 million loan at 6.90% costs $701,804 a year once it amortizes.
- The price per square foot is close to REIT cost. The asking price is $135.16 a square foot, 3.6% below the $140.26 at which four public REITs carry their North Carolina facilities.
- No cell of the sensitivity grid reaches the hurdle. The best of 25 cases returns 9.6%.
Each input names its source. The subject property and its loan come from CMBS loan-level filings on SEC EDGAR. Rent, occupancy and growth benchmarks come from the fiscal 2025 10-Ks of four self-storage REITs and from three earnings calls held in October 2026. Carrying values come from Schedule III of each REIT’s 10-K. Expense growth is the CPI from the Bureau of Labor Statistics, and the loan rate starts from the Daily Treasury Par Yield Curve.
“I get more broker teasers than I can underwrite and want a real estate deal screener that tells me in one pass whether a deal earns a full model, tested on a real property. From the CMBS loan-level filings, pick one U.S. self-storage property outside the ten largest metros whose latest report gives net rentable area, occupancy, revenue, operating expenses, net operating income, DSCR, appraised value and the loan terms. Use it as the subject, its latest appraised value as the asking price and its reported net operating income as current NOI. Set the market rent estimate and a rent growth rate from what public self-storage REITs report for same-store realized rent per occupied square foot, occupancy and rent growth in their latest 10-K and earnings call, and compare the price per square foot with what those REITs carry facilities at in the same state (Schedule III). Take expense growth from the BLS CPI. Price a new loan at 60% loan-to-value off today's 10-year Treasury yield plus a spread, with a 30-year amortization and two years of interest only, and show it next to the loan the property has now. Build the screen itself as a one-sheet model: an inputs block of ten inputs (price, square feet, current NOI, market rent, capital budget, loan-to-value, rate, amortization, exit cap rate as the going-in rate plus a spread, and a 5- or 10-year hold switch); an annual projection; a results panel with going-in cap rate, year-1 cash-on-cash, levered IRR, equity multiple and DSCR; a flags panel; and a 5-by-5 sensitivity grid of levered IRR to exit cap rate and year-1 NOI. Flag negative leverage (a going-in cap rate below the loan rate), a DSCR below 1.25x, an exit cap rate tighter than the going-in rate, and rent growth above what the REITs report. End the sheet with a one-line verdict: pass, or move to a full underwrite. Use the stored public data wherever it has the figure, and web search only for what it lacks. Put every input on an Assumptions sheet with one column that says where it came from: a cited source, or "analyst assumption" for a figure I would set myself, with the reason for the value you chose. Every output must be a live formula that traces back to the Assumptions sheet. Add a Sources sheet listing each data source, what it gave and its date. Deliver one Excel workbook and a short summary of the result, the flags, and what I would need from the seller to firm it up. Cite every sourced figure.”
That is the request as we sent it, without its closing line, which asks that no name or email be put in the workbook.
Deal screener inputs: ten cells and where each one came from
A screener is useful when its inputs can be filled from a teaser in minutes and each one says where it came from. Compound put the ten inputs on the Assumptions sheet with a source column, and every cell on the Screen sheet reads them by formula.
| B | C | D | E | |
|---|---|---|---|---|
| 5 | Input | Value | Unit | Source / basis |
| 86 | SCREEN INPUTS (THE TEN ON THE SCREEN SHEET) | |||
| 87 | Asking price | $14,800,000 | $ | Request: latest appraised value (row 16) |
| 88 | Net rentable area | 109,500 | SF | CMBS report (row 9) |
| 89 | Current NOI | $1,050,248.72 | $ | Request: reported NOI from the CMBS report (row 13) |
| 90 | Market rent (per occupied SF per year) | $15.71 | $/SF/yr | Analyst assumption: set to NSA same-store rent (row 45). NSA's secondary-market, Sun Belt-heavy portfolio (34 NC stores) is the closest match to a 110k SF suburban Raleigh facility; PSA, EXR and CUBE rents ($19.91 to $22.73) reflect coastal and urban mixes |
| 91 | Capital budget (funded at close) | $250,000 | $ | Analyst assumption: about $2.30/SF for roofs, paving, gate and access systems and rebranding on a 1999-built facility renovated in 2018; replace with a property condition report |
| 92 | Loan-to-value | 60% | % | Request |
| 93 | Loan spread over 10-year Treasury | 1.75% | % | Analyst assumption: 175 bps, a typical spread for a 60% LTV fixed-rate loan on a stabilized self-storage asset; confirm with lender quotes |
| 94 | Loan rate | 6.90% | % | Computed: 10-year Treasury (row 81) plus spread (row 93), per Request |
| 95 | Amortization | 30 | years | Request |
| 96 | Interest-only period | 2 | years | Request |
| 97 | Exit cap spread over going-in cap rate | 0.25% | % | Analyst assumption: 25 bps of cap rate expansion for a 10-year older asset and a 2036 exit |
| 98 | Exit cap rate | 7.35% | % | Computed: going-in cap rate (row 89 / row 87) plus spread (row 97), per Request |
| 99 | Hold period switch (5 or 10) | 10 | years | Analyst assumption: 10 years, matching the 10-year loan term so no refinancing is assumed; Request allows 5 or 10 |
| 101 | OPERATING AND TRANSACTION ASSUMPTIONS | |||
| 102 | Rent growth | 1.70% | %/yr | Set from REIT benchmark (row 57) per Request |
| 103 | Expense growth | 3.74% | %/yr | BLS CPI-U 12-month change (row 84) per Request |
| 104 | Stabilized occupancy | 91.8% | % | Analyst assumption: REIT same-store average (row 59); the subject's 98.0% is above every REIT and Sun Belt supply is still being absorbed, so the screen trends it down |
| 105 | Years to converge to market rent and stabilized occupancy | 3 | years | Analyst assumption: about one full customer churn cycle |
| 112 | DSCR threshold | 1.25x | x | Request |
| 113 | Levered IRR hurdle for a full underwrite | 10% | % | Analyst assumption: 10% levered target for a stabilized self-storage acquisition |
The source column sorts the ten inputs into three kinds.
Four are set by the request and labeled Request: the asking price (the latest appraised value), current NOI (the figure in the CMBS report), the 60% loan-to-value and the 30-year amortization. Net rentable area is read from the CMBS report.
Three are labeled analyst assumption, each with a reason. Market rent is $15.71 per occupied square foot a year, the same-store figure of the REIT whose portfolio Compound judged closest to a suburban Raleigh facility. The capital budget is $250,000, which the sheet says to replace with a property condition report. The hold is ten years, matching the loan term so that no refinancing is assumed.
Two are computed, each from a sourced figure plus an analyst assumption. The 6.90% loan rate is the 10-year Treasury yield plus a spread of 175 basis points, to be confirmed with lender quotes. The 7.35% exit cap rate is the going-in rate plus 25 basis points.
Below the ten sit the operating assumptions that the projection needs. Rent growth is tied to the REIT benchmark and expense growth to the CPI, as the request asked. Stabilized occupancy, the three years it takes to get there and the 10% IRR hurdle are analyst assumptions. The hurdle is the one that decides the verdict, so it is the first cell we would set to our own number.
The test property: 98.0% occupied, with a 3.35% loan due in 2031
The filing describes a full property with wide coverage: 109,500 square feet, 98.0% occupied, with net operating income of 2.21 times debt service. The new loan that the request specified costs $225,834 a year more than the existing one once it amortizes (our arithmetic).
Compound chose Turner Farms Self Storage in Garner, North Carolina, in the Raleigh area. The property secures loan 52 in the Benchmark 2021-B28 Mortgage Trust, and the figures are from the trust’s Form ABS-EE asset data file for the report period ended October 13, 2026. That filing reports:
- Net rentable area of 109,500 square feet, built in 1999 and last renovated in 2018.
- Revenue of $1,605,565, operating expenses of $555,316 and net operating income of $1,050,249, for the period ended June 30, 2026. Compound’s answer notes that these are annualized from six months.
- An appraised value of $14,800,000 dated May 18, 2021, which the sheet identifies as the securitization appraisal.
- A loan of $9,000,000 originated on July 19, 2021 at a fixed 3.35%, amortizing over 360 months with no interest-only period, with a balance of $8,040,793 and a maturity date of August 6, 2031.
| F | I | J | |
|---|---|---|---|
| 5 | DEBT: EXISTING VS NEW | ||
| 6 | Existing | New | |
| 7 | Loan amount | $9,000,000 | $8,880,000 |
| 8 | Balance today / at close | $8,040,793 | $8,880,000 |
| 9 | LTV on asking price | 54.3% | 60.0% |
| 10 | Interest rate | 3.35% | 6.90% |
| 11 | Amortization (months) | 360 | 360 |
| 12 | Interest-only (months) | 0 | 24 |
| 13 | Term (months) | 120 | 120 |
| 14 | Debt service, amortizing | $475,971 | $701,804 |
| 15 | Debt service, interest-only years | n/a | $612,720 |
| 16 | DSCR on current NOI (amortizing) | 2.21x | 1.50x |
| 17 | Debt yield on current NOI | 13.1% | 11.8% |
| 18 | Maturity | 08-06-31 | Close + 10 yrs |
| 19 | Prepayment lockout end | 05-05-31 | Open at exit |
The right-hand block puts the two loans side by side. The new loan is 60% of the asking price, or $8,880,000. Its rate is the 5.15% 10-year Treasury par yield at the November 13, 2026 close plus the 175 basis point spread. Debt service is $612,720 in the two interest-only years and $701,804 after that.
On today’s NOI the existing loan is covered 2.21 times and the new loan 1.50 times on an amortizing basis. Debt yield falls from 13.1% on the existing balance to 11.8% on the new loan. The existing balance is 54.3% of the asking price.
The filing also shows why a buyer cannot simply keep the old loan and its rate. Prepayment is locked out until May 5, 2031, and defeasance has been allowed since September 6, 2023. Whether the loan can be assumed, and at what cost, is a question for the seller and the servicer.
Market rent and rent growth from self-storage REIT filings
Four public self-storage REITs reported same-store rent of $15.71 to $22.73 per occupied square foot for 2025, and three of them reported same-store revenue growth of 0.50% to 2.70% for the third quarter of 2026. Compound set market rent at the low end of that range and rent growth at the 1.70% average.
| B | C | D | E | |
|---|---|---|---|---|
| 5 | Input | Value | Unit | Source / basis |
| 35 | REIT SAME-STORE BENCHMARKS | |||
| 36 | PSA realized annual rent per occupied SF, 2025 | $22.54 | $/SF/yr | Public Storage 10-K FY2025, same store facilities |
| 38 | PSA same-store weighted average occupancy, 2025 | 92.0% | % | Public Storage 10-K FY2025 |
| 39 | EXR average annual rent per occupied SF, 2025 | $19.91 | $/SF/yr | Extra Space Storage 10-K FY2025, same-store (net of discounts and bad debt) |
| 41 | EXR same-store average occupancy, 2025 | 93.7% | % | Extra Space Storage 10-K FY2025 |
| 42 | CUBE realized annual rent per occupied SF, 2025 | $22.73 | $/SF/yr | CubeSmart 10-K FY2025, same-store |
| 44 | CUBE same-store period average occupancy, 2025 | 89.7% | % | CubeSmart 10-K FY2025 |
| 45 | NSA same-store rental revenue per occupied SF, 2025 | $15.71 | $/SF/yr | National Storage Affiliates 10-K FY2025 (NSA since acquired by Public Storage) |
| 47 | NSA same-store average occupancy, 2025 | 84.3% | % | National Storage Affiliates 10-K FY2025 |
| 48 | PSA same-store revenue growth, Q3 2026 | 0.50% | % | Public Storage Q3 2026 earnings call, 10/27/2026 |
| 49 | EXR same-store revenue growth, Q3 2026 | 2.70% | % | Extra Space Storage Q3 2026 earnings call, 10/28/2026 |
| 50 | CUBE same-store revenue growth, Q3 2026 | 1.90% | % | CubeSmart Q3 2026 earnings call, 10/30/2026 |
| 51 | CUBE realized rent growth, Q3 2026 | 0.50% | % | CubeSmart Q3 2026 earnings call, 10/30/2026 |
| 52 | PSA FY2026 same-store revenue growth guidance, midpoint | 0.25% | % | Public Storage Q3 2026 earnings call, 10/27/2026 |
| 57 | REIT benchmark rent growth (average Q3 2026 same-store revenue growth, PSA/EXR/CUBE) | 1.70% | % | Computed from the three Q3 2026 calls above; the latest run-rate the REITs report |
| 58 | Highest REIT-reported growth (any measure above) | 2.70% | % | Computed: maximum of rows 48 to 56; ceiling for the rent growth flag |
| 59 | REIT average same-store occupancy (PSA/EXR/CUBE, 2025) | 91.8% | % | Computed from rows 38, 41 and 44 |
Public Storage, Extra Space Storage and CubeSmart report rent of $19.91 to $22.73 per occupied square foot. National Storage Affiliates reported $15.71. Compound used the last figure and wrote its reason in the source column: that REIT’s secondary-market portfolio, with 34 North Carolina stores, is the closest match to a suburban Raleigh facility, while the other three reflect coastal and urban mixes.
Annual rent per occupied square foot: the subject against four REITs
Dollars per occupied square foot a year. REIT figures are same-store, fiscal 2025. The subject's figure is total revenue, fees included
Compound's Assumptions tab, rows 36, 39, 42, 45 and 106: each REIT's fiscal 2025 Form 10-K, and SEC Form ABS-EE asset data for the subject.
The subject earns $14.96 of revenue per occupied square foot, computed on the sheet as revenue over occupied area. The projection moves that to the $15.71 market rent over three years and then grows it at 1.70%.
Rent growth was the harder input. In 2025 the four REITs’ rent per occupied square foot changed by between a 0.40% fall and a 0.49% rise. The October 2026 calls were better: same-store revenue grew 0.50% at Public Storage, 2.70% at Extra Space and 1.90% at CubeSmart. Compound took the average of those three, 1.70%, as the latest run-rate, and used the highest reported figure, 2.70%, as the ceiling for the rent growth flag.
Occupancy is where the subject and the REITs differ most. The property is 98.0% occupied. Public Storage, Extra Space and CubeSmart averaged 91.8% in 2025, and Compound trends the subject down to that level over three years. Its reason is on the sheet: 98.0% is above every REIT, and Sun Belt supply is still being absorbed. Extra Space said on its call, “So if you take Phoenix all the way across the South to the Carolinas, that’s where the supply has hurt the most, and the most supply added.”
A seller would argue the other side, that a property holding 98.0% through that supply has shown it can keep its tenants. The filing cannot settle it, because physical occupancy says nothing about the rents and discounts used to hold it.
The three benchmarks do not come from one set of REITs. Market rent is the National Storage Affiliates figure alone. Stabilized occupancy is the average of the other three and leaves out National Storage Affiliates, which reported 84.3%. Rent growth is same-store revenue growth at those three, a measure that already includes any change in their occupancy, and the projection also lowers the subject’s occupancy from 98.0% to 91.8%. The projection may therefore count falling occupancy twice. We would set rent, occupancy and growth from one comparable set before relying on the result.
Price per square foot against REIT Schedule III carrying values
At $135.16 a square foot, the asking price is 3.6% below the $140.26 at which four REITs carry their North Carolina facilities. Carrying value is historical cost, so the comparison is a sanity check on the price and does not measure market value.
| REIT and area | Facilities | Net rentable square feet | Gross carrying amount ($ thousands) | Carrying value per square foot |
|---|---|---|---|---|
| Public Storage, Raleigh market | 41 | 2,988 thousand | 401,427 | $134.35 |
| Extra Space Storage, North Carolina | 55 | 4,058,524 | 699,492 | $172.35 |
| CubeSmart, North Carolina | 9 | 612,023 | 58,859 | $96.17 |
| National Storage Affiliates, North Carolina | 34 | 2,072,412 | 205,051 | $98.94 |
| Four REITs, weighted by square feet | $140.26 | |||
| Turner Farms Self Storage at the asking price | 109,500 | $135.16 |
Price per square foot: the asking price against REIT carrying values
Dollars per net rentable square foot. REIT figures are gross carrying amount from Schedule III, fiscal 2025
Compound's Screen tab, cells C52 and C53, and Assumptions tab, rows 62 to 78: Schedule III of each REIT's fiscal 2025 Form 10-K.
Public Storage reports Schedule III by market, and its Raleigh line is the closest comparison by location: 41 facilities carried at $134.35 a square foot. The other three report by state. Extra Space carries its North Carolina stores at $172.35 a square foot and CubeSmart at $96.17, so the range is wide and the weighted figure depends on which REIT owns the most space.
We read this check narrowly. A price far above every REIT’s cost would be a reason to stop. A price inside the range says only that the appraisal is not out of line with what large owners have spent in the state.
The annual projection: why NOI stays near $1.05 million
Over ten years revenue rises $263,578 and operating expenses rise $246,188, so net operating income rises $17,390 (our arithmetic on rows 25 to 27 of the Screen sheet). Rent grows 1.70% a year, expenses grow 3.74%, and occupancy trends from 98.0% to 91.8% in the first three years.
| B | C | D | E | F | G | H | M | |
|---|---|---|---|---|---|---|---|---|
| 21 | Year | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 10 |
| 23 | Occupancy | 98.0% | 95.9% | 93.9% | 91.8% | 91.8% | 91.8% | 91.8% |
| 24 | Revenue per occupied SF | $14.96 | $15.47 | $15.99 | $16.52 | $16.81 | $17.09 | $18.59 |
| 25 | Revenue | 1,605,565 | 1,625,065 | 1,643,596 | 1,661,100 | 1,689,339 | 1,718,058 | 1,869,143 |
| 26 | Operating expenses | (555,316) | (576,072) | (597,604) | (619,941) | (643,112) | (667,150) | (801,505) |
| 27 | Net operating income ($) | 1,050,249 | 1,048,992 | 1,045,992 | 1,041,160 | 1,046,227 | 1,050,908 | 1,067,638 |
| 28 | NOI growth | (0.1%) | (0.3%) | (0.5%) | 0.5% | 0.4% | 0.2% | |
| 29 | Capital budget and reserves | (250,000) | (10,965) | (11,375) | (11,800) | (12,241) | (12,699) | (15,256) |
| 30 | Cash flow before debt service ($) | (250,000) | 1,038,027 | 1,034,617 | 1,029,360 | 1,033,986 | 1,038,210 | 1,052,382 |
| 31 | Debt service | (612,720) | (612,720) | (701,804) | (701,804) | (701,804) | (701,804) | |
| 32 | Loan balance, end of year | 8,880,000 | 8,880,000 | 8,880,000 | 8,788,044 | 8,689,538 | 8,584,016 | 7,932,376 |
| 33 | Cash flow after debt service ($) | 425,307 | 421,897 | 327,555 | 332,182 | 336,405 | 350,578 | |
| 34 | DSCR | 1.71x | 1.71x | 1.48x | 1.49x | 1.50x | 1.52x | |
| 36 | Gross sale price (on next-year NOI) | - | - | - | - | - | 14,557,801 | |
| 37 | Selling costs | - | - | - | - | - | (291,156) | |
| 38 | Loan repayment | - | - | - | - | - | (7,932,376) | |
| 39 | Net sale proceeds ($) | - | - | - | - | - | 6,334,269 | |
| 40 | Levered equity cash flow ($) | (6,480,800) | 425,307 | 421,897 | 327,555 | 332,182 | 336,405 | 6,684,847 |
| 41 | Unlevered cash flow ($) | (15,272,000) | 1,038,027 | 1,034,617 | 1,029,360 | 1,033,986 | 1,038,210 | 15,319,027 |
The projection is deliberately short. Occupancy moves in a straight line to the stabilized level over three years. Revenue per occupied square foot moves to market rent over the same three years and grows at 1.70% throughout. Operating expenses start at the filing’s $555,316 and compound at 3.74%, the change in the CPI from September 2025 to September 2026. The capital reserve is $0.10 a square foot, taken from the gap between net operating income and net cash flow in the CMBS report.
The result is three years of falling NOI, from $1,050,249 to $1,041,160, followed by growth of 0.5% a year or less.
Net operating income against annual debt service
Dollars a year. NOI from the projection; debt service on the existing loan and on the new 6.90% loan
Compound's Screen tab, row 27 and cells I14, J14 and J15. Existing loan terms: SEC Form ABS-EE asset data, Benchmark 2021-B28 Mortgage Trust.
Coverage is never the problem. DSCR is 1.71x in the interest-only years, drops to 1.48x in year 3 when amortization starts, and reaches 1.52x by year 10.
The sale is where flat income shows. The sheet values the property at the end of the hold on the next year’s NOI and the 7.35% exit cap rate, which gives a gross sale price of $14,557,801. That is $242,199 less than the purchase price (our arithmetic). After 2.0% selling costs and repayment of the $7,932,376 loan balance, net proceeds are $6,334,269, against $6,480,800 of equity invested.
The hold switch changes the answer in the wrong direction. Compound’s answer reports that the five-year setting gives a 2.8% levered IRR. Closing costs and the loan fee are fixed, and they weigh more on a shorter hold.
The assumption we would test first is expense growth. One year of CPI at 3.74%, held for ten years against 1.70% rent growth, guarantees a margin squeeze. The request asked for CPI and the sheet uses it. A buyer with the property’s actual tax, insurance and payroll lines would grow each on its own basis.
Results and flags: a 7.10% cap rate against a 6.90% loan
The results panel shows a going-in cap rate of 7.10%, year-1 cash-on-cash of 6.6%, a levered IRR of 5.4%, an equity multiple of 1.53x and a minimum DSCR of 1.48x. All four flags read OK, and the verdict cell reads PASS, meaning decline, because the IRR is below the 10% hurdle.
| B | C | F | I | J | K | |
|---|---|---|---|---|---|---|
| 43 | RESULTS | FLAGS | ||||
| 44 | Going-in cap rate | 7.10% | Test | Value | Threshold | Status |
| 45 | Year-1 NOI | $1,048,992 | Negative leverage (cap < loan rate) | 7.10% | 6.90% | OK |
| 46 | Year-1 cash-on-cash | 6.6% | DSCR below threshold (hold minimum) | 1.48x | 1.25x | OK |
| 47 | Levered IRR | 5.4% | Exit cap tighter than going-in cap | 7.35% | 7.10% | OK |
| 48 | Equity multiple | 1.53x | Rent growth above REIT-reported max | 1.70% | 2.70% | OK |
| 49 | DSCR, Year 1 (interest-only) | 1.71x | Flags raised | 0 | ||
| 50 | DSCR, minimum over hold | 1.48x | Levered IRR vs hurdle | 5.4% | 10.0% | BELOW |
| 51 | Unlevered IRR | 6.3% | ||||
| 52 | Price per SF | $135.16 | SOURCES AND USES | |||
| 53 | REIT NC carrying value per SF (Schedule III) | $140.26 | Purchase price | $14,800,000 | ||
| 54 | Price premium / (discount) to REIT carrying value | (3.6%) | Closing costs | $222,000 | ||
| 55 | Going-in cap less loan rate | 0.20% | Capital budget | $250,000 | ||
| 56 | Check: grid center less levered IRR | - | Loan origination fee | $88,800 | ||
| 57 | Check: 12 x monthly P&I less reported debt service | - | Total uses ($) | $15,360,800 | ||
| 89 | Rule: move to a full underwrite only when no flag is raised and levered IRR meets the hurdle (Assumptions row 113). | |||||
| 90 | VERDICT | PASS: 0 flag(s) raised; levered IRR of 5.4% is below the 10% hurdle |
The rule is written above the verdict cell: move to a full underwrite only when no flag is raised and the levered IRR meets the hurdle. Here the flags are clean and the return fails.
- Negative leverage. The cap rate of 7.10% is above the 6.90% loan rate, so the flag reads OK. The margin is 20 basis points. Compound’s answer notes that a loan spread above 195 basis points, or a 10-year Treasury above 5.35%, would trip it.
- DSCR below 1.25x. The lowest year is 1.48x.
- Exit cap rate tighter than going-in. The exit rate is 7.35%, the going-in rate plus 25 basis points.
- Rent growth above what the REITs report. The model uses 1.70% against a highest reported figure of 2.70%.
The screen's returns against the loan rate and the hurdle
Base case, ten-year hold. The best grid case is a 6.85% exit cap rate with NOI 10% higher
Compound's Screen tab, cells C44, C12, C46, C51, C47 and H65, and Assumptions tab, cell C113.
The first flag deserves a second look, because the unlevered IRR of 6.3% is higher than the levered IRR of 5.4%. Borrowing lowers the return even though the flag is clear. Three things explain it.
First, the flag compares NOI with the purchase price alone. The buyer also pays closing costs and the capital budget, for a cost of $15,272,000 before the loan fee. Year-1 NOI is 6.87% of that cost (our arithmetic), just under the loan rate.
Second, the loan amortizes after year 2. Annual debt service of $701,804 is 7.90% of the loan amount (our arithmetic), which is above the cap rate.
Third, NOI does not grow, so the 20 basis points never widen.
The request defined negative leverage as a going-in cap rate below the loan rate, and the sheet tests exactly that. A cap rate within 25 basis points of the loan rate is close enough that we would also compare the two IRRs, which the results panel already shows.
Sources and uses are on the same sheet. Total uses are $15,360,800: the price, $222,000 of closing costs, the $250,000 capital budget and an $88,800 loan fee. The loan funds $8,880,000 and equity funds $6,480,800.
The 5-by-5 sensitivity grid: levered IRR by exit cap rate and NOI
None of the 25 cases reaches the 10% hurdle. The best case, a 6.85% exit cap rate with NOI 10% higher, returns 9.6%, and the worst returns 0.2%.
| B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|
| 62 | SENSITIVITY: LEVERED IRR BY EXIT CAP RATE (ROWS) AND YEAR-1 NOI (COLUMNS) | ||||||
| 63 | Year-1 NOI change | (10%) | (5%) | 0% | +5% | +10% | |
| 64 | Year-1 NOI | $944,093 | $996,543 | $1,048,992 | $1,101,442 | $1,153,891 | |
| 65 | Exit cap rate | 6.85% | 3.1% | 4.9% | 6.6% | 8.2% | 9.6% |
| 66 | 7.10% | 2.4% | 4.3% | 6.0% | 7.6% | 9.1% | |
| 67 | 7.35% | 1.6% | 3.6% | 5.4% | 7.0% | 8.5% | |
| 68 | 7.60% | 0.9% | 3.0% | 4.8% | 6.5% | 8.0% | |
| 69 | 7.85% | 0.2% | 2.3% | 4.2% | 5.9% | 7.5% |
The grid is built without an Excel data table. To the right of it, in columns K to Y, the sheet reruns the levered equity cash flow for each of the 25 cases and takes the IRR of each row. Each grid cell reads one of those IRRs. A check cell on the results panel subtracts the base-case IRR from the center of the grid and shows zero.
The NOI change scales net operating income in every year of the hold and in the sale, so the +10% column describes a property that earns 10% more throughout.
Read across the base row, at a 7.35% exit cap rate, the IRR runs from 1.6% to 8.5%. Read down the center column, it runs from 6.6% to 4.2%. Across these ranges income moves the result by 6.9 percentage points and the exit cap rate moves it by 2.4 (our arithmetic). That tells you where diligence time belongs: on the rent roll and the expense lines before the exit assumption.
What public data cannot tell you about this property
The screen runs on one servicer report, four 10-Ks, three earnings calls and two government series. Each has a limit that the seller’s files would remove, and Compound listed what to ask for in its answer.
- Price. The filing’s latest appraisal is from May 18, 2021 and was made for the securitization. It is the asking price only because the request said to use it. The seller’s price guidance replaces it.
- Income. The CMBS report gives one revenue figure, annualized from the six months to June 30, 2026. From the seller you would get the trailing twelve months and three years of operating statements, and a unit-mix rent roll showing street rates against in-place rates, economic occupancy, concessions, and fee and insurance income.
- Expenses. The report gives one operating expense figure. The seller’s breakdown would show property tax, the management fee, insurance and payroll, and the buyer would add the Wake County reassessment on sale.
- Market rent. REIT same-store figures are averages across national and regional portfolios. The subject’s revenue per occupied square foot includes fees, and the REIT rent figures may not. Street rates at competing facilities within 3 to 5 miles are the real comparison.
- Carrying values. Schedule III is historical cost, and three of the four REITs report it by state.
- Capital. The $250,000 budget is a placeholder for a 1999 facility renovated in 2018. A property condition report replaces it.
- Debt. The 175 basis point spread is an assumption until a lender quotes. The cost to assume or defease the existing loan is unknown from the filing, and Compound’s answer says plainly that a 3.35% loan assumed at 54% loan-to-value would change the result.
- Dates. The National Storage Affiliates figures are from its fiscal 2025 10-K, and the sheet notes that the company has since been acquired by Public Storage. The Bureau of Labor Statistics did not publish an October 2025 CPI index, so the 12-month change runs from September to September.
Our view: what the screen returns at $14.8 million, and what would change it
On the inputs it was given, the sheet’s result follows. At the 2021 appraised value and a 6.90% loan, the screen’s projected income does not grow enough to pay for today’s cost of debt, and no reasonable move in the exit cap rate fixes that.
That is a statement about a price and a set of assumptions. The filed figures describe a property that is 98.0% occupied with coverage of 2.21 times on a loan that runs to 2031, and the screen’s result follows from asking what a new buyer with a new loan would earn at that price.
The other side has three arguments, and each is a cell on the Assumptions sheet. Expenses may not grow at 3.74% for a decade. Occupancy may hold nearer 98.0% than 91.8%. Market rent may be above the lowest of the four REIT figures. The grid shows what they are worth together: with NOI 10% higher and the same exit cap rate, the levered IRR is 8.5%, still under the hurdle.
Three things would change the result. A price below the appraised value raises the cap rate and widens the margin over the loan rate. An assumable 3.35% loan changes the debt service for the years to 2031. A rent roll showing in-place rents below street rates would support faster growth than the REIT average.
If you have a stack of teasers, the next step is to run the same gates across all of them, as in real estate deal pipeline screening. A deal that survives the screen moves to a full real estate pro forma with monthly cash flows, built from the seller’s rent roll and checked against the documents in due diligence.
Self-storage deal screen (Excel)Compound’s workbook from this run: the one-sheet Screen with ten inputs, the annual projection, results, flags, sources and uses, the 5-by-5 levered IRR grid and the verdict; the Assumptions sheet with a source for every input; and the Sources sheet.Download · FreeFAQ
What inputs does a real estate deal screener need?
Ten are enough for a first pass: price, square feet, current NOI, market rent, a capital budget, loan-to-value, loan rate, amortization, an exit cap rate and a hold period. This screen adds rent growth, expense growth and a stabilized occupancy on a separate Assumptions sheet, each with its source.
How is a deal screener different from a full underwriting model?
A screener is one sheet with an annual projection and one loan, built to decide whether a deal deserves more work. A full pro forma models monthly cash flows, unit or lease detail, line-item expenses and a refinancing. The screen above returned a 5.4% levered IRR against a 10% hurdle before any of that work was done.
What is negative leverage, and how does a screener flag it?
Negative leverage means the debt costs more than the property yields, so borrowing lowers the equity return. The common test is a going-in cap rate below the loan rate. In this screen the cap rate is 7.10% and the loan rate 6.90%, so the flag is clear, yet the levered IRR of 5.4% is below the unlevered 6.3%. Compare the two IRRs as well as the two rates.
Should the exit cap rate be higher than the going-in cap rate?
Most screens assume it is, because the building is older at sale and the buyer should not count on the market paying more for each dollar of income. This screen adds 25 basis points to the going-in rate, for an exit cap rate of 7.35%, and flags any case where the exit rate is the lower of the two.
What DSCR should a deal screener test?
Test the lowest year of the hold against the lender’s minimum, and test the amortizing payment as well as the interest-only one. The request set 1.25x. On this screen coverage is 1.71x in the interest-only years and 1.48x in the first amortizing year, so the lowest year is the one after interest-only ends.
How do you screen many deals at once?
Put one deal on each row and apply the same assumptions, gates and hurdle to all of them, then rank the survivors. The one-sheet screen on this page judges a single teaser in depth. The table version is shown in real estate deal pipeline screening.





