Price 31 Midwest properties at their latest appraised value, finance each with a new 6.90% loan, and 23 of them earn less on the purchase price than the loan costs each year. Eight pass all three gates of the screen. One of those eight returns less than the equity put in.
You are on the acquisitions team of an institutional investor and someone has handed you a pipeline. Before anyone builds a full model, you need every deal on one page, on the same loan terms, with the same tests. We asked Compound to build that page from public filings. It ran on November 15, 2026 and returned one Excel workbook with three sheets.
What the workbook shows:
- 8 of 31 deals pass. The three gates are a year-1 debt service coverage ratio of at least 1.25x, a going-in cap rate at or above the cost of the new loan, and occupancy of at least 80%.
- One gate decides every result. All 23 deals that fail have a going-in cap rate below the 7.90% annual loan constant. The coverage and occupancy gates remove no deal that the leverage gate keeps (our count from the gate columns).
- The top of the shortlist is a warehouse and five apartment properties. Bolingbrook Logistics Center ranks first with a 16.8% levered IRR in the model. No retail property passes.
- A pass is a filter result. The gates do not test return. One office deal passes all three and ranks eighth with a modeled levered IRR of -7.9% and an equity multiple of 0.73x.
- 30 of 31 appraisals are more than three years old. The asking price in this screen is the appraised value, so the age of the appraisal is the age of the price.
- Five deals carry a refinance shortfall flag. In each, a new loan at 65.0% of appraised value is smaller than the existing loan balance.
Every return on this page is the output of a screen at an assumed price. The request set each asking price at the latest appraised value in the loan filing. No seller has quoted these prices, and nothing here is a forecast for any property or a view on whether to buy it.
The property data comes from CMBS loan-level filings, the Form ABS-EE exhibits that each trust files on SEC EDGAR. The loan rate starts from the Daily Treasury Par Yield Curve. Expense growth is the consumer price index from the Bureau of Labor Statistics. Apartment rent growth blends Zillow’s ZORI index with Apartment List rent reports that Compound read on the web. The Sources sheet lists 25 trusts, each with its filing accession number.
“I have been handed a pipeline of deals to triage and want a deal pipeline screening workbook that ranks them in one sitting, built on real properties. From the CMBS loan-level filings, pick 25 to 40 properties in the Midwest (Ohio, Michigan, Indiana, Illinois, Wisconsin, Minnesota and Missouri) whose loans mature within the next 24 months, since those owners must sell or refinance. Mix apartment, industrial, retail and office, and keep only properties whose latest report gives units or net rentable area, occupancy, net operating income, appraised value and the loan balance, rate and maturity date. Give each deal one row with its name, city and state, property type, year built, size, occupancy, reported NOI and an asking price set at the latest appraised value, plus one capital figure per unit or per square foot as an analyst assumption by property type and an optional price override. Set the assumptions once for every deal in a block at the top: loan-to-value, a loan rate built from today's 10-year Treasury yield plus a spread, amortization, exit cap rate spread over the going-in rate, hold period, rent growth by property type (apartments from Zillow ZORI and Apartment List for the Midwest metros, the others as analyst assumptions) and expense growth from the BLS CPI. Build the screen itself as a one-sheet model: the shared assumptions block on top, then one table with one row per deal and the computed columns to the right of the inputs: price per unit or per square foot, going-in cap rate, year-1 DSCR on the new loan, year-1 cash-on-cash, levered IRR, equity multiple, and whether the new loan at the shared terms pays off the existing balance at maturity. Add pass or fail gates (a DSCR of at least 1.25x, no negative leverage, occupancy of at least 80%), a rank by levered IRR among the deals that pass, and a top-ten shortlist block that fills by formula and re-sorts when I change a shared assumption. Flag every deal with negative leverage, every deal where the new loan falls short of the existing balance, and every deal whose appraisal is more than three years old. 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.
The shared assumptions: one loan for every deal
Every deal in the screen gets the same loan: 65.0% of the price at 6.90%, amortizing over 30 years. Those terms produce an annual loan constant of 7.90%, and that one number drives most of the results.
Compound put the shared terms in one block on the Assumptions sheet and pointed the top of the Screen sheet at it. Each row says where its value came from.
| B | C | D | E | |
|---|---|---|---|---|
| 6 | Assumption | Value | Unit | Source / basis |
| 7 | Analysis date | 2026-11-15 | date | Request: the screen date; the maturity window and appraisal age are measured from it. |
| 8 | Loan maturity window | 24 | months | Request: loans maturing within 24 months of the analysis date. |
| 9 | 10-year Treasury par yield, close of Nov 13, 2026 | 5.15 | %, as published | U.S. Treasury daily par yield curve, 10-year, as of 2026-11-13, the latest close before the analysis date (Compound stored rates data). |
| 10 | 10-year Treasury yield | 5.15% | % | Formula: published yield / 100. |
| 11 | Loan spread over 10-year Treasury | 175 | bps | Analyst assumption: 175 bps is a typical fixed-rate CMBS / balance-sheet spread for stabilized Midwest assets at 60-65% LTV. |
| 12 | New loan interest rate | 6.90% | % | Formula: 10-year Treasury + spread. |
| 13 | Loan-to-value | 65.0% | % | Analyst assumption: 65% is a common senior-loan ceiling for stabilized multifamily, industrial, retail and office. |
| 14 | Amortization | 30 | years | Analyst assumption: 30-year amortization, standard for fixed-rate commercial mortgages. |
| 15 | Annual loan constant | 7.90% | % | Formula: annual debt service per $1 of loan at the new rate and amortization. |
| 16 | Closing costs | 2.0% | % of price | Analyst assumption: 2% for transfer taxes, title, legal and financing fees. |
| 17 | Hold period | 5 | years (1 to 10) | Analyst assumption: 5-year hold, a typical value-add / core-plus horizon. |
| 18 | Exit cap rate spread over going-in cap | 50 | bps | Analyst assumption: 50 bps of cap rate expansion over the hold for aging and rate risk. |
| 19 | Sale costs | 2.0% | % of exit value | Analyst assumption: 2% for brokerage and closing costs at sale. |
| 20 | Minimum year-1 DSCR | 1.25x | x | Request: DSCR of at least 1.25x. |
| 21 | Minimum occupancy | 80% | % | Request: occupancy of at least 80%. |
| 22 | Appraisal age flag threshold | 3 | years | Request: flag appraisals more than three years old. |
| 23 | Expense growth (CPI-U, 12 months to Sep 2026) | 3.7% | % | Formula: BLS CPI-U 12-month change from the CPI block below. |
Three kinds of input sit in that block, and the label tells you which is which.
| Kind | Inputs | What to do with it |
|---|---|---|
| Request | Analysis date, 24-month maturity window, 1.25x minimum coverage, 80% minimum occupancy, three-year appraisal age limit | These came from the request. Change them when your mandate differs. |
| Sourced | 10-year Treasury yield of 5.15% at the close of November 13, 2026; expense growth of 3.7% | Refresh on the day you rerun the screen. |
| Analyst assumption | 175 basis point loan spread, 65.0% loan-to-value, 30-year amortization, 2.0% closing costs, 5-year hold, 50 basis point exit cap spread, 2.0% sale costs | Replace with your lender’s quote and your house view. |
The loan rate is the Treasury yield plus the spread: 5.15% plus 175 basis points is 6.90%. The loan constant in cell C15 is the yearly payment on one dollar of that loan, 7.90%. It is higher than the rate because the payment includes principal.
The constant matters more than the rate in this screen. Compound’s test for negative leverage compares each going-in cap rate with the 7.90% constant. A deal bought at a cap rate below the constant pays out more in debt service per dollar borrowed than the property earns per dollar of price, so borrowing lowers the first-year cash return. Some analysts run that test against the interest rate, as the screen on the real estate deal screener page does. The constant is the stricter version.
The pipeline: 31 properties from CMBS filings
Compound kept 31 properties in six states: 9 apartment, 5 industrial, 6 office and 11 retail. Each one’s loan matures between February 2027 and November 2028, and each one’s latest filing reports size, occupancy, net operating income, appraised value and the loan’s balance, rate and maturity.
The request asked for 25 to 40 properties across seven states. Compound said in its answer that no Minnesota loan met every data requirement, and that it kept single-property loans that were current on payments and had 12 months of financials. The inputs come from each trust’s October 2026 filing.
| B | C | D | E | F | G | H | I | J | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25 | ID | Property | City | State | Type | Year built | Size | Unit | Occupancy | Reported NOI | Appraised value (asking) | Appraisal date | Existing loan balance | Loan maturity |
| 26 | D01 | Centennial Highlands | Fort Wayne | IN | Apartment | 2015 | 97 | Units | 96.9% | 1,483,182 | 18,550,000 | Jul 2017 | 11,371,761 | Oct 2027 |
| 27 | D02 | Chatham Glen | Plainfield | IN | Apartment | 2016 | 92 | Units | 95.7% | 1,211,389 | 17,200,000 | May 2018 | 11,428,285 | Jul 2028 |
| 28 | D03 | Colony Bay Apartments | Fort Wayne | IN | Apartment | 1966 | 495 | Units | 96.0% | 2,573,902 | 25,000,000 | Mar 2017 | 13,500,000 | Apr 2027 |
| 29 | D04 | Clearpointe Landing | Midland | MI | Apartment | 2016 | 110 | Units | 95.5% | 1,793,630 | 20,900,000 | Jul 2018 | 13,400,000 | Nov 2028 |
| 30 | D05 | KINGSLEY APARTMENTS | Sterling Heights | MI | Apartment | 1969 | 328 | Units | 95.0% | 2,975,673 | 30,700,000 | May 2018 | 20,217,010 | Jul 2028 |
| 31 | D06 | River Place Apartments | Detroit | MI | Apartment | 1891 | 301 | Units | 88.4% | 1,464,882 | 32,800,000 | May 2018 | 17,000,000 | Jul 2028 |
| 32 | D07 | WOODLAND GARDENS APARTMENTS | Royal Oak | MI | Apartment | 1967 | 337 | Units | 97.0% | 2,931,691 | 34,100,000 | May 2018 | 22,677,633 | Jul 2028 |
| 33 | D08 | DRAKE PLAZA APARTMENTS | St. Louis | MO | Apartment | 1914 | 78 | Units | 84.0% | 380,661 | 5,900,000 | Jan 2018 | 3,197,881 | May 2028 |
| 34 | D09 | 118 FLATS OVAL | Cleveland | OH | Apartment | 2016 | 32 | Units | 75.0% | 400,558 | 8,100,000 | Jan 2017 | 4,904,020 | Mar 2027 |
| 35 | D10 | Bolingbrook Logistics Center | Bolingbrook | IL | Industrial | 2007 | 42,350 | SF | 100.0% | 1,328,863 | 14,100,000 | Apr 2017 | 5,772,802 | Jun 2027 |
| 36 | D11 | GRM Indianapolis | Indianapolis | IN | Industrial | 1940 | 394,570 | SF | 100.0% | 2,165,669 | 30,100,000 | Mar 2023 | 17,000,000 | May 2028 |
| 37 | D12 | Novi Technology Center | Novi | MI | Industrial | 1988 | 105,184 | SF | 84.7% | 907,303 | 12,500,000 | Jan 2017 | 7,805,340 | Apr 2027 |
| 38 | D13 | MAPLE STREET | North Canton | OH | Industrial | 1919 | 788,032 | SF | 79.0% | 2,505,053 | 34,100,000 | Mar 2018 | 20,759,438 | Jul 2028 |
| 39 | D14 | NORTHERN OHIO INDUSTRIAL PARK | Elyria | OH | Industrial | 1946 | 1,056,528 | SF | 88.0% | 2,148,670 | 15,900,000 | Jun 2017 | 9,165,518 | Nov 2027 |
| 40 | D15 | Bingham Office Center | Bingham Farms | MI | Office | 1974 | 524,852 | SF | 72.4% | 3,176,227 | 52,000,000 | Mar 2017 | 26,012,637 | May 2027 |
| 41 | D16 | CONTINENTAL PLAZA | Troy | MI | Office | 1986 | 95,953 | SF | 65.0% | 261,764 | 9,200,000 | Nov 2016 | 5,264,765 | Mar 2027 |
| 42 | D17 | LIBERTY CENTER | Troy | MI | Office | 1988 | 278,443 | SF | 97.0% | 3,666,652 | 33,000,000 | Jan 2017 | 18,495,648 | Feb 2027 |
| 43 | D18 | RAYMOND JAMES FINANCIAL CENTER | Auburn Hills | MI | Office | 1987 | 137,960 | SF | 83.0% | 1,047,546 | 15,000,000 | Apr 2017 | 9,304,132 | Jun 2027 |
| 44 | D19 | Alliance Data Systems | Columbus | OH | Office | 2017 | 241,493 | SF | 100.0% | 3,111,622 | 47,000,000 | Jul 2018 | 26,550,000 | Aug 2028 |
| 45 | D20 | Belcan Headquarters | Blue Ash | OH | Office | 2000 | 135,413 | SF | 100.0% | 1,814,537 | 26,500,000 | Sep 2021 | 15,900,000 | Nov 2028 |
| 46 | D21 | 901 West Madison | Chicago | IL | Retail | 2007 | 16,052 | SF | 77.1% | 449,408 | 7,400,000 | Sep 2025 | 4,924,424 | Aug 2028 |
| 47 | D22 | DEMPSTER PLAZA | Niles | IL | Retail | 1968 | 113,191 | SF | 91.0% | 1,906,603 | 36,150,000 | Aug 2017 | 22,366,703 | Oct 2027 |
| 48 | D23 | JEWEL OSCO FOX RIVER | Fox River Grove | IL | Retail | 1990 | 55,553 | SF | 100.0% | 506,852 | 9,000,000 | Jul 2018 | 5,100,000 | Oct 2028 |
| 49 | D24 | JEWEL-OSCO | Shorewood | IL | Retail | 2002 | 66,437 | SF | 100.0% | 752,382 | 13,200,000 | Jul 2018 | 8,600,000 | Sep 2028 |
| 50 | D25 | WEST CARMEL MARKETPLACE | Carmel | IN | Retail | 2005 | 121,000 | SF | 100.0% | 1,508,621 | 21,400,000 | Sep 2017 | 9,803,138 | Jan 2028 |
| 51 | D26 | 21300 Eureka | Taylor | MI | Retail | 2017 | 23,200 | SF | 100.0% | 571,845 | 7,700,000 | Jul 2018 | 4,553,818 | Oct 2028 |
| 52 | D27 | Romeo Commons | Macomb | MI | Retail | 1986 | 76,636 | SF | 98.0% | 1,060,370 | 14,300,000 | Jan 2017 | 7,861,165 | Mar 2027 |
| 53 | D28 | Gravois Dillon Plaza | High Ridge | MO | Retail | 1996 | 148,110 | SF | 96.0% | 1,098,494 | 20,100,000 | Nov 2017 | 12,901,822 | Jan 2028 |
| 54 | D29 | MARKETPLACE AT FOUR CORNERS PHASE II | Aurora | OH | Retail | 2004 | 116,436 | SF | 84.0% | 700,868 | 16,310,000 | Jan 2018 | 9,819,147 | Mar 2028 |
| 55 | D30 | EAST TOWNE GREEN BAY | Green Bay | WI | Retail | 1983 | 67,471 | SF | 96.0% | 732,237 | 10,420,000 | Feb 2018 | 6,068,326 | Jun 2028 |
| 56 | D31 | PICK N SAVE APPLETON WI | Appleton | WI | Retail | 2004 | 65,313 | SF | 100.0% | 738,151 | 11,500,000 | Oct 2017 | 6,809,505 | Jan 2028 |
The formula in the bar is the purchase price. It takes the price override in column Q if you have typed one, and the appraised value otherwise. That is the one place where you turn a public appraisal into a seller’s actual ask.
Three things in this table are worth a look before any return. First, the size of the pipeline: the appraised values add up to $650.1 million and the existing loan balances to $378.5 million (our arithmetic on columns M and O).
Second, the appraisal dates. 27 of the 31 appraisals are dated 2017 or 2018 (our count). The Assumptions sheet says, deal by deal, whether the value is the most recent reported appraisal or the appraisal at securitization with no later one reported.
Third, the existing loans are cheap by today’s terms. The filings report note rates from 3.87% to 6.26% on the 31 loans, and the screen’s new loan costs 6.90%. Every one of these loans would be replaced by a more expensive one.
One mapping is Compound’s and it is disclosed: the filings code three of the industrial properties as warehouse, and the Assumptions sheet says it mapped that code to Industrial.
Growth by property type: sourced for apartments, assumed for the rest
Apartment rent growth is 3.1%, the average of two public rent measures across five Midwest metros. Industrial, office and retail growth are analyst assumptions of 3.0%, 0.0% and 2.0%, and expenses grow 3.7% for every type.
The request asked for apartment rent growth from Zillow ZORI and Apartment List, and for the other types as analyst assumptions. Compound built the apartment figure in a block you can audit.
| B | C | D | E | F | |
|---|---|---|---|---|---|
| 33 | Metro | ZORI multifamily, Sep 2025 ($/mo) | ZORI multifamily, Sep 2026 ($/mo) | ZORI 12-month change | Apartment List 12-month change |
| 34 | Cleveland, OH Metro Area | 1,201 | 1,249 | 4.0% | (0.7%) |
| 35 | Detroit-Warren-Dearborn, MI Metro Area | 1,346 | 1,395 | 3.7% | 3.8% |
| 36 | Fort Wayne, IN Metro Area | 1,055 | 1,133 | 7.3% | 5.0% |
| 37 | Indianapolis-Carmel-Greenwood, IN Metro Area | 1,353 | 1,387 | 2.5% | 1.5% |
| 38 | St. Louis, MO-IL Metro Area | 1,283 | 1,329 | 3.5% | 0.5% |
| 39 | Average of the five metros | 4.2% | 2.0% | ||
| 41 | Apartment rent growth (blend) | 3.1% | |||
| 44 | Series | Value | Unit | ||
| 45 | CPI-U all items, not seasonally adjusted, Sep 2025 | 324.800 | index 1982-84=100 | ||
| 46 | CPI-U all items, not seasonally adjusted, Sep 2026 | 336.940 | index 1982-84=100 | ||
| 47 | CPI-U 12-month change | 3.7% | % |
The two measures disagree. ZORI averages 4.2% across the five metros and Apartment List averages 2.0%. In Fort Wayne they read 7.3% and 5.0%. In Cleveland ZORI shows 4.0% growth and Apartment List shows a 0.7% decline. Compound averaged the two averages and used 3.1% for every apartment deal. The ZORI figures come from stored data. The Apartment List figures came from its November 2026 rent report on the web, and the source note says four are city-level figures and Indianapolis is metro-wide.
Expense growth is sourced: the consumer price index rose from 324.800 in September 2025 to 336.940 in September 2026, a 3.7% change.
The other inputs by type are labeled analyst assumption, each with a reason.
| Type | Rent growth | Capital at purchase | Basis |
|---|---|---|---|
| Apartment | 3.1% | $5,000 per unit | Sourced blend; capital is an analyst assumption |
| Industrial | 3.0% | $5 per SF | Analyst assumption |
| Office | 0.0% | $25 per SF | Analyst assumption |
| Retail | 2.0% | $10 per SF | Analyst assumption |
Look at what those pairs do. Year-1 net operating income in the screen is revenue grown at the rent rate less expenses grown at 3.7%. For office, revenue is flat and expenses rise, so income falls every year of the hold. The office results below follow from that choice as much as from the filings.
Going-in cap rate against the 7.90% loan constant
23 of the 31 deals have a going-in cap rate below the 7.90% loan constant, and the screen flags each one for negative leverage. All 11 retail deals are flagged, with cap rates from 4.3% to 7.4%.
The going-in cap rate is reported net operating income divided by the purchase price. With the price set at appraised value, it is income as a share of an appraisal, and most of these appraisals are eight or nine years old.
Going-in cap rate at appraised value, 31 deals
Reported NOI divided by appraised value. Dark bar: the 7.90% annual loan constant. Highlighted bars pass all three gates
Compound's Screen sheet, column U and cell D13. NOI and appraised values: CMBS Form ABS-EE filings for the reporting period ending October 2026. Loan constant: 10-year Treasury of 5.15% on November 13, 2026 plus an assumed 175 basis point spread, 30-year amortization.
The eight deals above the dark bar are the eight that pass.
A coverage ratio of 1.25x on a 65.0% loan with a 7.90% constant needs a going-in cap rate of about 6.42% (our arithmetic: 1.25 times 65.0% times 7.90%, before year-1 growth). The leverage gate needs 7.90%. Any deal that clears the leverage gate has already cleared coverage by a wide margin. So the coverage gate fails 10 deals and the occupancy gate fails five, and every one of them also fails the leverage gate (our counts from columns AK, AL and AM). Of the 23 deals that do not pass, thirteen cover their debt at 1.25x or better, and twelve of those miss on leverage alone.
By property type (ranges from column U, pass counts are ours):
| Type | Deals | Going-in cap rate range | Pass all gates |
|---|---|---|---|
| Apartment | 9 | 4.5% to 10.3% | 5 |
| Industrial | 5 | 7.2% to 13.5% | 2 |
| Office | 6 | 2.8% to 11.1% | 1 |
| Retail | 11 | 4.3% to 7.4% | 0 |
Now the question of how strict the test is. 14 of the 23 flagged deals have a cap rate below the 6.90% interest rate, and nine sit between the rate and the constant (our counts). If your shop defines negative leverage against the rate, those nine deals come off the flag list. Compound’s answer makes a related point: cutting the loan spread to 100 basis points lifts the pass count to 10. The gate is one formula in column AL that points at one cell, so either change takes a few seconds.
Read every row of the next table as a hypothetical purchase. Each one assumes a new 65.0% loan at 6.90% and a price equal to an appraisal that is, for 30 of the 31, more than three years old, with one growth rate and one capital figure for the whole property type. A FAIL in the Result column or a negative return describes that set of assumptions. It does not describe how the property or its existing loan is performing.
| C | F | T | U | AA | AB | AF | AG | AH | AN | AO | AP | AQ | AR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25 | Property | Type | Price / unit or SF | Going-in cap rate | Year-1 DSCR | Year-1 cash-on-cash | Levered IRR | Equity multiple | New loan less existing balance | Result | Rank (levered IRR) | Negative leverage | Refi shortfall | Stale appraisal |
| 26 | Centennial Highlands | Apartment | 191,237 | 8.0% | 1.60x | 7.8% | 12.0% | 1.65x | 685,739 | PASS | 5 | STALE APPRAISAL | ||
| 27 | Chatham Glen | Apartment | 186,957 | 7.0% | 1.41x | 5.3% | 8.7% | 1.46x | (248,285) | FAIL | NEG LEVERAGE | REFI SHORTFALL | STALE APPRAISAL | |
| 28 | Colony Bay Apartments | Apartment | 50,505 | 10.3% | 2.06x | 11.6% | 12.8% | 1.65x | 2,750,000 | PASS | 4 | STALE APPRAISAL | ||
| 29 | Clearpointe Landing | Apartment | 190,000 | 8.6% | 1.72x | 9.3% | 13.5% | 1.73x | 185,000 | PASS | 3 | STALE APPRAISAL | ||
| 30 | KINGSLEY APARTMENTS | Apartment | 93,598 | 9.7% | 1.94x | 11.4% | 14.5% | 1.77x | (262,010) | PASS | 2 | REFI SHORTFALL | STALE APPRAISAL | |
| 31 | River Place Apartments | Apartment | 108,970 | 4.5% | 0.88x | (1.5%) | (4.8%) | 0.78x | 4,320,000 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 32 | WOODLAND GARDENS APARTMENTS | Apartment | 101,187 | 8.6% | 1.72x | 8.8% | 11.8% | 1.62x | (512,633) | PASS | 6 | REFI SHORTFALL | STALE APPRAISAL | |
| 33 | DRAKE PLAZA APARTMENTS | Apartment | 75,641 | 6.5% | 1.28x | 3.3% | 3.2% | 1.16x | 637,119 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 34 | 118 FLATS OVAL | Apartment | 253,125 | 4.9% | 0.99x | (0.1%) | 2.8% | 1.15x | 360,980 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 35 | Bolingbrook Logistics Center | Industrial | 333 | 9.4% | 1.89x | 11.8% | 16.8% | 1.93x | 3,392,198 | PASS | 1 | STALE APPRAISAL | ||
| 36 | GRM Indianapolis | Industrial | 76 | 7.2% | 1.44x | 5.2% | 7.7% | 1.40x | 2,565,000 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 37 | Novi Technology Center | Industrial | 119 | 7.3% | 1.45x | 5.6% | 8.2% | 1.43x | 319,660 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 38 | MAPLE STREET | Industrial | 43 | 7.3% | 1.46x | 4.9% | 3.3% | 1.16x | 1,405,562 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 39 | NORTHERN OHIO INDUSTRIAL PARK | Industrial | 15 | 13.5% | 2.69x | 12.4% | 7.8% | 1.35x | 1,169,482 | PASS | 7 | STALE APPRAISAL | ||
| 40 | Bingham Office Center | Office | 99 | 6.1% | 1.14x | 1.1% | (41.9%) | 0.08x | 7,787,363 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 41 | CONTINENTAL PLAZA | Office | 96 | 2.8% | 0.48x | (4.2%) | n/a | -1.07x | 715,235 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 42 | LIBERTY CENTER | Office | 119 | 11.1% | 2.11x | 9.8% | (7.9%) | 0.73x | 2,954,352 | PASS | 8 | STALE APPRAISAL | ||
| 43 | RAYMOND JAMES FINANCIAL CENTER | Office | 109 | 7.0% | 1.30x | 2.6% | (33.3%) | 0.18x | 445,868 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 44 | Alliance Data Systems | Office | 195 | 6.6% | 1.28x | 2.9% | (7.3%) | 0.70x | 4,000,000 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 45 | Belcan Headquarters | Office | 196 | 6.8% | 1.29x | 3.0% | (21.0%) | 0.35x | 1,325,000 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 46 | 901 West Madison | Retail | 461 | 6.1% | 1.20x | 2.6% | 0.9% | 1.04x | (114,424) | FAIL | NEG LEVERAGE | REFI SHORTFALL | ||
| 47 | DEMPSTER PLAZA | Retail | 319 | 5.3% | 1.04x | 0.4% | (3.5%) | 0.84x | 1,130,798 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 48 | JEWEL OSCO FOX RIVER | Retail | 162 | 5.6% | 1.12x | 1.4% | 0.4% | 1.02x | 750,000 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 49 | JEWEL-OSCO | Retail | 199 | 5.7% | 1.13x | 1.6% | 1.2% | 1.06x | (20,000) | FAIL | NEG LEVERAGE | REFI SHORTFALL | STALE APPRAISAL | |
| 50 | WEST CARMEL MARKETPLACE | Retail | 177 | 7.0% | 1.39x | 4.7% | 2.6% | 1.12x | 4,106,862 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 51 | 21300 Eureka | Retail | 332 | 7.4% | 1.47x | 6.0% | 5.8% | 1.28x | 451,182 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 52 | Romeo Commons | Retail | 187 | 7.4% | 1.45x | 5.5% | 1.7% | 1.08x | 1,433,835 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 53 | Gravois Dillon Plaza | Retail | 136 | 5.5% | 1.07x | 0.8% | (5.5%) | 0.76x | 163,178 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 54 | MARKETPLACE AT FOUR CORNERS PHASE II | Retail | 140 | 4.3% | 0.84x | (1.8%) | (9.6%) | 0.59x | 782,353 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 55 | EAST TOWNE GREEN BAY | Retail | 154 | 7.0% | 1.39x | 4.6% | 2.6% | 1.13x | 704,674 | FAIL | NEG LEVERAGE | STALE APPRAISAL | ||
| 56 | PICK N SAVE APPLETON WI | Retail | 176 | 6.4% | 1.27x | 3.3% | 3.1% | 1.15x | 665,495 | FAIL | NEG LEVERAGE | STALE APPRAISAL |
The gates and the rank by levered IRR
The shortlist ranks the passing deals by levered IRR and fills by formula, so it re-sorts when a shared assumption changes. It lists eight deals, from 16.8% down to -7.9%, and leaves ranks nine and ten blank.
Compound wrote the rank in column AO with a count of passing deals that have a higher IRR, and the shortlist looks each rank up with INDEX and MATCH. Change the spread, the hold period or a growth rate and the block reorders.
| B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58 | TOP-TEN SHORTLIST: PASSING DEALS RANKED BY LEVERED IRR | ||||||||||||
| 59 | Rank | Property | City | State | Type | Purchase price | Going-in cap rate | Year-1 DSCR | Year-1 cash-on-cash | Levered IRR | Equity multiple | New loan less existing balance | Flags |
| 60 | 1 | Bolingbrook Logistics Center | Bolingbrook | IL | Industrial | 14,100,000 | 9.4% | 1.89x | 11.8% | 16.8% | 1.93x | 3,392,198 | STALE APPRAISAL |
| 61 | 2 | KINGSLEY APARTMENTS | Sterling Heights | MI | Apartment | 30,700,000 | 9.7% | 1.94x | 11.4% | 14.5% | 1.77x | (262,010) | REFI SHORTFALL STALE APPRAISAL |
| 62 | 3 | Clearpointe Landing | Midland | MI | Apartment | 20,900,000 | 8.6% | 1.72x | 9.3% | 13.5% | 1.73x | 185,000 | STALE APPRAISAL |
| 63 | 4 | Colony Bay Apartments | Fort Wayne | IN | Apartment | 25,000,000 | 10.3% | 2.06x | 11.6% | 12.8% | 1.65x | 2,750,000 | STALE APPRAISAL |
| 64 | 5 | Centennial Highlands | Fort Wayne | IN | Apartment | 18,550,000 | 8.0% | 1.60x | 7.8% | 12.0% | 1.65x | 685,739 | STALE APPRAISAL |
| 65 | 6 | WOODLAND GARDENS APARTMENTS | Royal Oak | MI | Apartment | 34,100,000 | 8.6% | 1.72x | 8.8% | 11.8% | 1.62x | (512,633) | REFI SHORTFALL STALE APPRAISAL |
| 66 | 7 | NORTHERN OHIO INDUSTRIAL PARK | Elyria | OH | Industrial | 15,900,000 | 13.5% | 2.69x | 12.4% | 7.8% | 1.35x | 1,169,482 | STALE APPRAISAL |
| 67 | 8 | LIBERTY CENTER | Troy | MI | Office | 33,000,000 | 11.1% | 2.11x | 9.8% | (7.9%) | 0.73x | 2,954,352 | STALE APPRAISAL |
| 68 | 9 | ||||||||||||
| 69 | 10 |
Levered IRR of the eight passing deals
5-year hold, 65.0% loan at 6.90%, price at appraised value. Model output, in shortlist order
Compound's Screen sheet, shortlist block, column K. Inputs: CMBS Form ABS-EE filings, Treasury par yield curve, BLS CPI, Zillow ZORI, Apartment List; growth by type, capital, spread, hold and exit cap spread are analyst assumptions.
Three rows deserve a second look, because a rank is a sort order and tells you nothing about why.
Bolingbrook Logistics Center ranks first. The filing reports 42,350 square feet at 100.0% occupancy. At the appraised value of $14,100,000 the price is $333 per square foot and the going-in cap rate is 9.4%. The appraisal is dated April 2017. The first question for the seller is what the property would appraise at today, because a 9.4% yield on a nine-year-old value says little about the yield on a current one. The second is the size. The filed revenue and net operating income come to $39.88 and $31.38 per square foot (our arithmetic on columns K, L and H), which is high for warehouse space. Check the square footage in the filing against the seller’s rent roll before trusting the rank.
Northern Ohio Industrial Park has the highest cap rate and ranks seventh. Its going-in cap rate is 13.5% and its coverage is 2.69x, the highest of the 31. Its IRR is 7.8%. The reason is the capital assumption. At $5 per square foot on 1,056,528 square feet, capital at purchase is $5,282,640, about 33% of the $15,900,000 price (our arithmetic). A flat capital figure per square foot is heavy on a property priced at $15 per square foot. Only a property condition report can say whether that fits this building.
The eighth-ranked deal passes every gate with a negative modeled return. It is an office building in Michigan. The filing reports 97.0% occupancy and the cap rate at appraised value is 11.1%, so it clears coverage at 2.11x. Its modeled IRR is -7.9%. The screen’s office assumptions produce that: 0.0% rent growth against 3.7% expense growth, and $25 per square foot of capital, which comes to $6,961,075 (our arithmetic). The gates test coverage, leverage and occupancy and never look at return, so a deal can pass all three with a negative IRR. Compound said in its answer that it would not carry this row forward on the pass alone.
| C | Z | AF | AG | AT | AU | AV | AW | AX | AY | |
|---|---|---|---|---|---|---|---|---|---|---|
| 25 | Property | Total equity | Levered IRR | Equity multiple | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| 35 | Bolingbrook Logistics Center | 5,428,750 | 16.8% | 1.93x | (5,428,750) | 641,744 | 679,971 | 719,241 | 759,583 | 7,665,577 |
| 39 | NORTHERN OHIO INDUSTRIAL PARK | 11,165,640 | 7.8% | 1.35x | (11,165,640) | 1,383,346 | 1,435,877 | 1,489,480 | 1,544,169 | 9,180,616 |
| 42 | LIBERTY CENTER | 19,171,075 | (7.9%) | 0.73x | (19,171,075) | 1,878,148 | 1,781,395 | 1,681,026 | 1,576,905 | 7,059,626 |
| 40 | Bingham Office Center | 32,361,300 | (41.9%) | 0.08x | (32,361,300) | 371,482 | 233,030 | 89,403 | (59,592) | 2,065,423 |
| 41 | CONTINENTAL PLAZA | 5,802,825 | n/a | -1.07x | (5,802,825) | (245,375) | (281,193) | (318,350) | (356,896) | (5,016,596) |
The cash flow columns show how each IRR is built. Year 0 is the equity: price plus 2.0% closing costs plus capital, less the loan. Years 1 to 4 are income less debt service. Year 5 adds the sale, valued at the grown income divided by an exit cap rate 50 basis points above the deal’s own going-in rate, less 2.0% sale costs and the loan balance.
For the eighth-ranked office deal the annual cash flow falls from 1,878,148 in Year 1 to 1,576,905 in Year 4 as flat revenue meets rising expenses, and Year 5 brings 7,059,626 against 19,171,075 of equity. The two office rows below it do not pass the gates. The first, with 72.4% reported occupancy, shows a 0.08x equity multiple in the model after $13,121,300 of assumed capital (our arithmetic). The second, at 65.0% reported occupancy and a 2.8% cap rate at appraised value, has negative modeled cash flow in every year. Excel cannot solve an IRR for it, so the cell shows n/a and the equity multiple is negative.
All three office results rest on the same blanket inputs: an appraisal dated 2016 or 2017 used as the price, a new 6.90% loan, 0.0% rent growth, 3.7% expense growth and $25 per square foot of capital. Change any of them for a given building and its row changes. The figures are what the screen returns on those inputs and say nothing about how each building is doing under its existing loan.
The gates also exclude deals with better returns than some that pass. One apartment deal has a modeled IRR of 8.7%, above two deals on the shortlist, and is left off because its 7.0% cap rate at appraised value is below the 7.90% constant. Whether that is the right call depends on whether you buy for first-year yield or for total return. The screen applies the rule the request gave it.
Refinance shortfall and appraisal age flags
Five deals show a refinance shortfall: a new loan at 65.0% of appraised value would not pay off the existing balance. 30 of the 31 carry the stale appraisal flag, and the one exception is 901 West Madison, appraised in September 2025.
The refinance test asks a narrow question: at the shared terms, does the new loan cover the old one? Column AH is the new loan less the existing balance from the filing.
New loan less existing loan balance: the eight smallest of 31
New loan at 65.0% of appraised value, less the balance in the latest filing. Negative bars carry the refinance shortfall flag
Compound's Screen sheet, column AH. Appraised values and loan balances: CMBS Form ABS-EE filings for the reporting period ending October 2026.
The five gaps are small next to the loans. The largest is $0.51 million against a balance of $22.68 million. The next two are $0.26 million against $20.22 million and $0.25 million against $11.43 million, and the last two are $0.11 million and $0.02 million. Of the five, two are apartment deals on the shortlist, at ranks two and six.
A shortfall here means the existing balance is more than 65.0% of an appraisal that is, in four of the five cases, more than three years old. It is a result of the screen’s assumed loan-to-value and says nothing about whether the existing loan will be repaid. Compound noted in its answer that the test uses the latest reported balance as a stand-in for the balance at maturity. An amortizing loan will be somewhat smaller by then, so the test leans conservative.
The appraisal age flag fires on anything older than three years at the analysis date. The ages in column AJ run from 1.2 years to 10.0 years. GRM Indianapolis, appraised in March 2023, is flagged at 3.6 years. With 30 of 31 flagged, the flag does not help you rank. It tells you that the price column of this screen is a placeholder for nearly every deal.
What the public data cannot tell you
The filings give you size, occupancy, income, an appraisal and the loan. They do not give you a price, a rent roll or the condition of the building, and those are what turn a screen into an offer.
Compound ended its answer with the list of what you would need from the seller. We agree with it and would ask in this order.
- A price. A current appraisal or a broker’s opinion of value, and the seller’s expectation. Every return in this workbook moves with the price override in column Q.
- Current income. A trailing-12-month statement and a current rent roll. Compound noted that the reported income runs through December 2025 or June 2026.
- Leases. Abstracts and a rollover schedule for the office, retail and industrial properties. The screen grows revenue at one rate per type; a real building’s income steps when leases expire.
- Capital needs. A property condition report and the capital history. The capital figures here are one number per property type.
- The existing loan. Loan documents for the cost of early payoff or defeasance, the balloon amount and any extension options.
- Taxes and insurance. A tax reassessment estimate at the purchase price and current insurance quotes. The screen grows all expenses at the consumer price index.
- For apartments: in-place rents against market rents, recent lease trade-outs and concessions.
- For the older industrial sites: a Phase I environmental report. Compound named Maple Street, built in 1919, GRM Indianapolis, built in 1940, and Northern Ohio Industrial Park, built in 1946.
There are also limits in the inputs themselves. The exit cap rate is each deal’s own going-in rate plus 50 basis points, so a high yield on an old appraisal carries through to the sale value. Occupancy is one figure per property on the filing’s date.
This is the handoff point to due diligence. The screen tells you which sellers to call first and what to ask them.
Our view: use the shortlist as a reading order
We would start with the six rows the screen ranks first and treat the last two as questions. The screen is good at removing deals; it is weaker at ranking the survivors, because the survivors are the ones with the oldest-looking prices.
A high cap rate at appraised value has two readings. The property may earn a lot for its price, or the appraisal may no longer describe the property. All eight shortlisted deals carry the stale appraisal flag. The screen cannot tell the two readings apart, and it says so with the flag.
What we would change before using this on a live pipeline:
- Type real asking prices into the override column. The gates then test the seller’s price against today’s loan terms, which is the question you are being paid to answer.
- Decide which negative leverage test you mean. Against the 7.90% constant, 23 deals fail. Against the 6.90% rate, 14 do (our count). Write the choice down next to the gate.
- Add a return floor to the Result column. The three gates let a deal through with a negative IRR. A fourth test on IRR or equity multiple would keep the eighth-ranked deal off the shortlist under these assumptions.
- Revisit office growth deal by deal. A 0.0% rate for six buildings in Michigan and Ohio is a starting point. A building with long leases to one occupier and a multi-tenant building with space to fill should not share it.
What would change our reading: a current appraisal on any shortlisted deal that comes in well below the filed one, or a lender quote wide of 175 basis points. Either moves the cap rate or the constant, and the shortlist with it.
A pipeline screen and a single-deal screen answer different questions. This one ranks many deals on thin data. The real estate deal screener page takes one teaser and tests it against a grid of prices and rents. The deals that survive both go to a full real estate pro forma, with a rent roll and a debt schedule in place of one growth rate.
Midwest CMBS deal pipeline screen (Excel)Compound’s workbook from this run: a one-sheet Screen with the shared assumptions block, 31 deal rows, gates, flags, a formula-driven top-ten shortlist and the levered cash flows; an Assumptions sheet with a source for every input; and a Sources sheet listing each filing.Download · FreeFAQ
What is real estate deal pipeline screening?
It is the first pass over a list of possible acquisitions, before any deal gets a full model. Each deal goes on one row with the same loan terms and growth assumptions, a few pass or fail tests, and a rank. In this workbook 31 deals share one assumptions block, three gates remove 23, and a formula-driven shortlist ranks the 8 that remain by levered IRR.
Which metrics belong in a deal screening model?
Price per unit or per square foot, going-in cap rate, year-1 debt service coverage, year-1 cash-on-cash return, levered IRR and equity multiple cover most first-pass questions. This screen adds a refinance test against the existing loan and three flags.
What is negative leverage in a real estate deal?
Leverage is negative when the property’s yield on price is below the cost of the debt, so borrowing reduces the cash return on equity. This workbook tests the going-in cap rate against the annual loan constant of 7.90%, which includes principal. Testing against the 6.90% interest rate is a looser version of the same idea.
Why use CMBS filings to build a deal pipeline?
CMBS trusts report each loan and property every month on Form ABS-EE: size, occupancy, revenue, net operating income, the appraised value and the loan’s balance, rate and maturity date. A loan near maturity has to be repaid or refinanced, which is why the request used maturity as the filter. The filings do not give an asking price, so this screen uses appraised value as a stand-in.
How do you compare apartment, industrial, office and retail deals in one screen?
Share the loan terms, hold period and gates, and vary only what differs by type: the size basis (units or square feet), rent growth and capital at purchase. This workbook keeps those in a four-row block by type.
How does the shortlist re-sort when an assumption changes?
The rank column counts how many passing deals have a higher IRR, and each shortlist cell uses INDEX and MATCH to find the deal with that rank. The IRR, the gates and the rank all point at the assumptions block, so one changed input reorders the shortlist.





