Scottsdale Gateway II is a 107,888-square-foot office building in Scottsdale, Arizona, and its latest CMBS filing reports it 79.07% occupied. The one-sheet screen on this page prices it at the latest appraised value in that filing, $23,900,000, from an appraisal dated August 5, 2019, and finances it with a new loan at today’s rates. On those inputs about 15.0% of the leased area rolls each year, all four of the screen’s warning flags come up, and the levered IRR over a five-year hold is -13.3%. Those are the screen’s results for an assumed price and an assumed loan. They are no forecast for the building.
You are on the acquisitions team of an institutional investor with a stack of suburban office teasers, and each one gets about fifteen minutes. We asked Compound to build the screen that decides whether a building deserves lease-by-lease work, on a real property from public filings. It ran on November 15, 2026 and returned one Excel workbook.
What the workbook shows:
- About 15.0% of the leased area rolls each year. Two of the three tenants the filing names have leases that end inside the hold, with 37,906 square feet between them. By Year 5, 75.1% of the leased area has been re-leased at market rent.
- In-place rent is $30.35 per occupied square foot and the market rent assumption is $30.00. Space that rolls starts 1.2% lower and costs $38.00 per square foot to re-lease.
- Leasing costs take $487,007 a year. Cash flow after debt service is negative in every year of the hold, from negative $259,171 in Year 1 to negative $189,424 in Year 5.
- New debt costs more than the building yields. The going-in cap rate is 6.22% and the loan rate is 7.65%. Debt service coverage starts at 1.21x, under the 1.25x threshold.
- Most of the loss comes from the price. At the model’s 8.00% exit cap rate, Year-1 NOI supports a value of $18,584,613, which is 22.2% below the appraised value (our arithmetic). In the best corner of the sensitivity table the levered IRR is still -3.0%.
Each input on the Assumptions sheet names where it came from. Property, tenant and loan facts come from the CMBS loan-level filing for BBCMS Mortgage Trust 2019-C5 on SEC EDGAR, a Form ABS-EE filed on October 29, 2026, in which the property secures loan 26. The 10-year yield is from the Daily Treasury Par Yield Curve at the close of November 13, 2026. The floating-rate option uses the SOFR forward curve of the same date, which Compound computes from New York Fed SOFR and public swap trade data. Office employment is from the Bureau of Labor Statistics. Leasing benchmarks come from the Highwoods Properties and Cousins Properties 10-Qs for the third quarter of 2026 and from earnings calls held by Piedmont Realty Trust and Cousins. Asking rents come from two brokerage market reports found by web search. Every other input is marked “Request” or “Analyst assumption” with the reason for its value.
“I am screening a stack of suburban office deals and want an office lease rollover analysis that shows in fifteen minutes whether a building deserves lease-by-lease work, tested on a real property. From the CMBS loan-level filings, pick one suburban office property of roughly 100,000 to 300,000 square feet in a Mountain West metro such as Denver, Salt Lake City, Phoenix or Las Vegas, between 75% and 92% occupied, whose latest report names its three largest tenants with their square feet and lease expiration dates and gives net rentable area, occupancy, revenue, operating expenses, net operating income, appraised value and the loan terms. Use it as the subject and its latest appraised value as the price. Set average in-place rent and expenses per square foot from the filing. Set the annual rollover share from the named tenants' expirations inside five years, averaged per year, plus an analyst assumption for the rest of the leased area. Set market rent per square foot and one blended tenant improvement and leasing commission cost per rolled square foot, with downtime and free rent folded into that figure, as analyst assumptions checked against the leasing costs and rent spreads public office REITs report in their latest 10-K or earnings call. Add BLS employment in the metro's office-using sectors over the last five years as a demand check. Price one loan at 60% loan-to-value off today's 10-year Treasury yield and the SOFR forward curve. Build the screen itself as a one-sheet model: an inputs block (price, square feet, occupancy, in-place rent, annual rollover share, market rent, leasing cost per rolled square foot, expenses per square foot, loan-to-value, rate, amortization); a five-year annual projection in which the rolled share moves to market rent and the leasing cost is charged in the year the space turns; a returns block with going-in cap rate, levered IRR, equity multiple, DSCR by year and the gap between in-place and market rent; and a 2-by-2 sensitivity of levered IRR to leasing cost and market rent. Flag in-place rent above market, named tenants expiring inside the hold that total more than 30% of the area, a DSCR below 1.25x in any year, and negative leverage. 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.
What an office lease rollover analysis has to answer
A rollover analysis answers three questions about a leased building: how much space comes up each year, whether it re-leases at a higher or a lower rent, and what each new lease costs. A one-sheet version answers them with one blended annual share and one cost per square foot.
Compound’s workbook has three sheets. Screen holds the inputs block, the five-year projection, the returns, the flags and the sensitivity table. Assumptions holds every input with its source or its reason, and Sources lists each data source with its date. A change to one assumption moves the whole screen.
| B | C | D | |
|---|---|---|---|
| 5 | INPUTS | Unit | |
| 6 | Price (latest appraised value) | $23,900,000 | $ |
| 7 | Net rentable area | 107,888 | SF |
| 8 | Occupancy | 79.1% | % |
| 9 | In-place rent (FSG, per occupied SF) | $30.35 | $/SF/yr |
| 10 | Annual rollover share of leased SF | 15.0% | % per year |
| 11 | Market rent (FSG) | $30.00 | $/SF/yr |
| 12 | Leasing cost per rolled SF | $38.00 | $/SF |
| 13 | Operating expenses per SF of NRA | $10.17 | $/SF/yr |
| 14 | Loan-to-value | 60.00% | % |
| 15 | Interest rate, fixed (10-yr Treasury + spread) | 7.65% | % |
| 16 | Rate basis (Fixed or Floating) | Fixed | switch |
| 17 | Amortization | 30 | years |
| 18 | Market rent growth | 2.0% | % per year |
| 19 | Escalation on in-place leases | 2.5% | % per year |
| 20 | Operating expense growth | 3.0% | % per year |
| 21 | Capital reserve | $0.25 | $/SF/yr |
| 22 | Exit cap rate | 8.00% | % |
| 23 | Selling costs | 2.0% | % |
| 24 | Hold period | 5 | years |
The request listed eleven inputs for this block. Compound added seven that a five-year projection needs, each an analyst assumption with a reason on the Assumptions sheet: market rent growth of 2.0% a year, a 2.5% escalation on leases in place, expense growth of 3.0%, a capital reserve of $0.25 per square foot, an 8.00% exit cap rate, selling costs of 2.0% and a switch between a fixed and a floating rate.
A screen at this level leaves out what a full model has. The office lease-by-lease cash flow gives each tenant its own rows and posts every lease event in its month. Rent roll analysis starts from a rent roll you upload. This screen comes before both: it builds the rollover view from public filings, before the seller has sent anything.
The subject property: what the CMBS filing reports
The filing gives the building’s size, occupancy, twelve months of income, an appraisal, the loan and the three largest tenants with their lease expiration dates. The agent’s answer says it chose this property because it was the only one of 7 qualifying loans with trailing twelve-month financials.
The filing names the property Scottsdale Gateway II, at 8901 E Mountain View Rd in Scottsdale, built in 1998. The reporting period ended on October 13, 2026. For the twelve months from July 1, 2025 to June 30, 2026 the filing reports revenue of $2,588,884, operating expenses of $1,097,657, net operating income of $1,491,227 and net cash flow of $1,338,005.
The loan in the filing had an original amount of $16,500,000 and a balance of $15,390,423, at a 4.30% rate, maturing on November 6, 2029. The filing reports debt service of $979,845 for the trailing twelve months and coverage of 1.52x on NOI.
Three inputs follow from those figures. Leased area is net rentable area times occupancy, 85,307 square feet. In-place rent is filed revenue divided by leased area, $30.35 per square foot, and the source cell says the revenue “includes recoveries and other income, matching a full-service gross market rent”. Expenses are $10.17 per square foot of net rentable area.
The purchase price is an assumption that the request set: the latest appraised value in the filing, $23,900,000, or $221.53 per square foot (our arithmetic). The filing dates that appraisal August 5, 2019, more than seven years before the screen. On the filed NOI the price is a 6.24% cap rate. Every return on this page describes that assumed price.
Annual rollover share: two named expirations and an 18% assumption
The screen rolls 15.0% of the leased area each year, which is 12,816 square feet. That share is the two named leases that end inside the hold, averaged over five years, plus an analyst assumption of 18% a year on the rest of the leased area.
| B | C | D | E | |
|---|---|---|---|---|
| 29 | Tenant | SF | Lease expiration | Source / basis |
| 30 | Honor Health Care | 25,045 | 04-30-27 | BBCMS Mortgage Trust 2019-C5, Form ABS-EE |
| 31 | CaliberCos Inc | 18,319 | 02-29-36 | BBCMS Mortgage Trust 2019-C5, Form ABS-EE |
| 32 | Northsight Management | 12,861 | 02-28-28 | BBCMS Mortgage Trust 2019-C5, Form ABS-EE |
| 92 | DERIVED INPUTS (FORMULAS) | |||
| 94 | Leased SF | 85,307 | SF | Formula: NRA x occupancy |
| 97 | Named-tenant SF, all three | 56,225 | SF | Formula |
| 98 | Named-tenant SF expiring inside the hold | 37,906 | SF | Formula: tenants with expirations on or before the start date plus the hold |
| 99 | Named-tenant SF expiring inside the hold, % of NRA | 35.1% | % | Formula |
| 100 | Named-tenant rollover per year, averaged | 7,581 | SF/yr | Formula: SF expiring inside the hold / hold years |
| 101 | Other leased SF rolling per year | 5,235 | SF/yr | Formula: (leased SF - named-tenant SF) x analyst rollover rate |
| 102 | Annual rollover share of leased SF | 15.0% | % per year | Formula: (named + other rollover) / leased SF |
The filing names Honor Health Care with 25,045 square feet and a lease expiration of April 30, 2027, CaliberCos Inc with 18,319 square feet to February 29, 2036, and Northsight Management with 12,861 square feet to February 28, 2028. The hold runs five years from November 15, 2026, so the first and third leases end inside it. Together they are 37,906 square feet, or 35.1% of the net rentable area. The request set a flag at 30%, and it is raised.
The model spreads those 37,906 square feet evenly over the hold, 7,581 a year. The three named tenants hold 56,225 square feet, which leaves 29,082 square feet of leased area that the filing does not itemize (our arithmetic). Compound applied an 18% annual rollover rate to it, 5,235 square feet a year, and wrote the reason: “small suburban suites typically sign 3-to-5-year leases, so about one-fifth of that area turns each year; 18% leaves a little for multi-year renewals already signed”.
The average was the request’s instruction, and it hides the timing. Honor Health Care’s lease ends five and a half months into Year 1, and the agent’s answer puts it at 23% of the building on its own. The 12,816 square feet the model rolls in Year 1 are 51% of that one lease (our arithmetic). A building that passes the screen therefore goes on to a model with dates.
The screen holds the leased area at 85,307 square feet for all five years. The 22,581 vacant square feet (our arithmetic) stay vacant.
Market rent and leasing cost, checked against office REIT filings
Market rent is $30.00 per square foot and the leasing cost is $38.00 per rolled square foot, both analyst assumptions. Compound checked the cost against what three office REITs reported for the third quarter of 2026 and the rent against four published asking rents for Scottsdale and Phoenix.
| B | C | D | E | |
|---|---|---|---|---|
| 6 | Input | Value | Unit | Source / basis |
| 43 | Market rent (full-service gross) | $30.00 | $/SF/yr | Analyst assumption: 1998 Class B suburban building; set below Scottsdale submarket averages ($32.93 to $34.80) and near Phoenix Class B asking ($26.35 to $29.14); see benchmarks below. Public REIT cash spreads of +14% to +26% are Class A Sun Belt and are not applied here |
| 44 | Leasing cost per rolled SF (TI + LC + free rent + downtime) | $38.00 | $/SF | Analyst assumption: the three REITs' leasing cost per lease year times a 5-year term plus a downtime allowance averages about $39.60 (check below); set slightly lower because Cousins' concessions reflect trophy urban towers, while a 1998 suburban building gets smaller TI packages |
| 67 | LEASING COST AND MARKET RENT CHECKS | |||
| 68 | Highwoods 2nd-gen office leases, Q3 2026: tenant improvements | $4.44 | $/SF/lease yr | Highwoods Properties 10-Q for Q3 2026, filed 10/27/2026 (all office, new and renewal) |
| 69 | Highwoods: leasing commissions | $1.22 | $/SF/lease yr | Highwoods Properties 10-Q for Q3 2026 |
| 70 | Highwoods: rent concessions | $1.02 | $/SF/lease yr | Highwoods Properties 10-Q for Q3 2026 |
| 71 | Highwoods: average lease term | 7.2 | years | Highwoods Properties 10-Q for Q3 2026 |
| 72 | Piedmont: leasing capital spend, Q3 2026 | $5.21 | $/SF/lease yr | Piedmont Realty Trust Q3 2026 earnings call, 10/27/2026 |
| 73 | Cousins: average leasing concessions, Q3 2026 | $8.25 | $/SF/lease yr | Cousins Properties Q3 2026 earnings call, 10/30/2026 |
| 74 | Assumed lease term on rolled space | 5 | years | Analyst assumption: suburban Class B suites sign shorter terms than the REITs' 7-year average |
| 75 | Downtime on a new lease | 6 | months | Analyst assumption: Phoenix Class B space at roughly 19% to 25% vacancy |
| 76 | Share of rolled area going to new tenants | 40% | % | Analyst assumption: the rest renews in place with no downtime |
| 77 | Highwoods cost at the subject's lease term | $33.40 | $/SF | Formula: (TI + LC + concessions) x assumed term |
| 78 | Piedmont cost at the subject's lease term | $26.05 | $/SF | Formula: leasing capital x assumed term |
| 79 | Cousins concessions at the subject's lease term | $41.25 | $/SF | Formula: concessions x assumed term |
| 80 | Downtime allowance per rolled SF | $6.00 | $/SF | Formula: market rent x downtime months / 12 x new-tenant share |
| 81 | REIT benchmark leasing cost per rolled SF | $39.57 | $/SF | Formula: average of the three REIT costs plus downtime |
| 82 | Chosen leasing cost less benchmark | ($1.57) | $/SF | Formula: check |
The REITs report leasing costs per square foot per year of lease term. Highwoods’ 10-Q gives tenant improvements of $4.44, commissions of $1.22 and rent concessions of $1.02 on second-generation office leases, with an average term of 7.2 years. Piedmont gave $5.21 of leasing capital on its call, and Cousins gave $8.25 of concessions.
The three figures do not measure the same thing. The Highwoods figure adds tenant improvements, commissions and concessions, Piedmont’s is leasing capital, and Cousins’ is concessions alone. Compound restated each at a 5-year term, because “suburban Class B suites sign shorter terms than the REITs’ 7-year average”. That gives $33.40 for Highwoods, $26.05 for Piedmont and $41.25 for Cousins. It then added a downtime allowance of $6.00 per rolled square foot: 6 months of market rent on the 40% of rolled area assumed to go to new tenants. The benchmark is $39.57. The model uses $38.00, which is $1.57 lower, because “Cousins’ concessions reflect trophy urban towers, while a 1998 suburban building gets smaller TI packages”.
Market rent was checked against four asking rents, all full-service gross.
| Asking rent, third quarter of 2026 | $ per SF per year | Report named on the Assumptions sheet |
|---|---|---|
| Scottsdale Airpark average direct asking rent | $34.80 | Kidder Mathews Phoenix Office Market Report Q3 2026 |
| Central Scottsdale average direct asking rent | $32.93 | Kidder Mathews Phoenix Office Market Report Q3 2026 |
| Phoenix Class B average asking rent | $29.14 | Cushman & Wakefield MarketBeat Phoenix Office Q3 2026 |
| Phoenix Class B average direct rent | $26.35 | Kidder Mathews Phoenix Office Market Report Q3 2026 |
| Average of the four rent benchmarks | $30.81 | Formula |
| Market rent in the model | $30.00 | Analyst assumption |
The model’s $30.00 sits $0.81 below the average of the four. The reason on the sheet is that a 1998 Class B building should be set below the Scottsdale submarket averages and near the Phoenix Class B figures.
Compound also recorded the rent spreads the REITs reported, a 26.0% cash leasing spread at Piedmont and a 14.2% cash-basis increase on second-generation leases at Cousins, and did not apply them. The note says they are “Class A Sun Belt and are not applied here”.
In-place rent of $30.35 is $0.35 above the market assumption, a 1.2% gap, and the first flag is raised on it. The in-place figure is all filed revenue over occupied area, so it carries recoveries and other income, and a rent roll would show the base rent that should be compared.
The five-year projection: rolled space moves to market rent
Each year another 15.0% of the leased area moves from the in-place rent to the market rent, and the leasing cost for that area is charged in the same year. NOI rises from $1,486,769 in Year 1 to $1,556,515 in Year 5, and leasing costs of $487,007 a year take about a third of it.
| B | D | E | F | G | H | |
|---|---|---|---|---|---|---|
| 27 | Year | 1 | 2 | 3 | 4 | 5 |
| 28 | Year ending | Nov-27 | Nov-28 | Nov-29 | Nov-30 | Nov-31 |
| 29 | Leased SF | 85,307 | 85,307 | 85,307 | 85,307 | 85,307 |
| 30 | Cumulative share of leased SF rolled | 15.0% | 30.0% | 45.1% | 60.1% | 75.1% |
| 31 | SF rolled this year | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 |
| 32 | SF at market rent (cumulative) | 12,816 | 25,632 | 38,448 | 51,264 | 64,080 |
| 33 | In-place rent ($/SF) | $30.35 | $31.11 | $31.88 | $32.68 | $33.50 |
| 34 | Market rent ($/SF) | $30.00 | $30.60 | $31.21 | $31.84 | $32.47 |
| 35 | Rent on unrolled leases | 2,199,947 | 1,856,286 | 1,494,066 | 1,112,575 | 711,076 |
| 36 | Rent on rolled leases | 384,479 | 784,337 | 1,200,036 | 1,632,049 | 2,080,862 |
| 37 | Total revenue ($) | 2,584,426 | 2,640,623 | 2,694,102 | 2,744,624 | 2,791,938 |
| 38 | Operating expenses | (1,097,657) | (1,130,587) | (1,164,504) | (1,199,440) | (1,235,423) |
| 39 | Net operating income ($) | 1,486,769 | 1,510,036 | 1,529,597 | 1,545,184 | 1,556,515 |
| 40 | Leasing costs on rolled SF | (487,007) | (487,007) | (487,007) | (487,007) | (487,007) |
| 41 | Capital reserve | (26,972) | (26,972) | (26,972) | (26,972) | (26,972) |
| 42 | Cash flow before debt service ($) | 972,790 | 996,057 | 1,015,619 | 1,031,206 | 1,042,537 |
| 46 | Debt service | (1,231,961) | (1,231,961) | (1,231,961) | (1,231,961) | (1,231,961) |
| 50 | Cash flow after debt service ($) | (259,171) | (235,904) | (216,342) | (200,755) | (189,424) |
| 51 | DSCR (NOI / debt service) | 1.21x | 1.23x | 1.24x | 1.25x | 1.26x |
In-place rent grows 2.5% a year, from $30.35 to $33.50 in Year 5, and market rent grows 2.0% a year, from $30.00 to $32.47. The gap widens from $0.35 to $1.03 (our arithmetic), so each year’s rollover gives up a little more rent than the last.
Year-1 revenue is $2,584,426, slightly under the $2,588,884 the filing reports, because the first 12,816 square feet have already moved to the lower rent. Expenses start at the filed $1,097,657 and grow 3.0% a year.
Below NOI, the leasing cost is the rolled area times $38.00, which is $487,007 in each year. Over the hold that is $2,435,034, or 31.9% of the $7,628,102 of NOI the building earns (the sums and the share are our arithmetic on rows 39 and 40). Cash flow before debt service is $972,790 in Year 1.
The NOI line is smoother than a real building’s. Downtime and free rent are inside the $38.00, so revenue does not fall in the year a tenant leaves, and occupancy never moves from 79.1%.
The loan: 60% of the price at the 10-year Treasury plus a spread
The loan is $14,340,000 at a fixed 7.65%, which is the 10-year Treasury yield of 5.15% on November 13, 2026 plus an assumed 2.50% spread, on a 30-year schedule. Debt service is $1,231,961 a year, and NOI covers it 1.21x in Year 1.
Debt service coverage by year, against the 1.25x threshold
NOI over debt service on a loan of 60% of the appraised value at 7.65%
Compound's Screen tab, row 51, and Assumptions tab, cell C38. Property figures: SEC Form ABS-EE for BBCMS Mortgage Trust 2019-C5, filed October 29, 2026. Rate: 10-year Treasury par yield of November 13, 2026 plus an assumed spread.
Coverage stays under 1.25x for the first three years, and the flag is set on the minimum.
The fourth flag is negative leverage: the going-in cap rate of 6.22% is below the 7.65% interest rate, so borrowing lowers the cash return on equity. The test is generous to the deal: NOI is measured before leasing costs, which take about a third of it, so the cash the building yields after re-leasing is further below the loan rate than the cap rate shows. The loan constant with amortization is 8.59%. After debt service the cash flow is negative $259,171 in Year 1, and over five years the shortfalls add up to $1,101,596 (our arithmetic). The equity at closing is $9,560,000, and the buyer would fund those shortfalls on top of it.
The sheet has a switch for a floating rate. With “Floating” typed into the rate basis cell, each year’s rate becomes the 12-month forward SOFR at that year’s reset plus a 3.25% spread. The forwards on the Assumptions sheet run from 4.58% for Year 1 to 4.87% for Year 2 and 4.65% for Year 5. The agent’s answer reports that the floating loan costs about 7.8% to 8.1% and takes the levered IRR to -13.9%. The SOFR forward curve page shows how that curve is built.
The loan the filing reports is cheaper than either. It costs $979,845 a year at 4.30%. The new loan is smaller and its debt service is 25.7% higher (our arithmetic). The agent’s answer notes that taking over the existing loan would remove the negative leverage, and lists whether it can be assumed among the questions for the seller.
Returns and the four flags
The levered IRR is -13.3% and the equity multiple is 0.46x, against a 12% hurdle that Compound set as an analyst assumption. All four flags the request defined are raised, and the result line reads “Do not advance at this price: levered IRR below the hurdle”.
| B | C | D | |
|---|---|---|---|
| 59 | RETURNS | ||
| 60 | Going-in cap rate (Year-1 NOI / price) | 6.22% | |
| 61 | Cap rate on filing TTM NOI | 6.24% | |
| 62 | Unlevered IRR | 0.20% | |
| 63 | Levered IRR | (13.28%) | |
| 64 | Equity multiple | 0.46x | |
| 65 | Minimum DSCR over the hold | 1.21x | |
| 66 | Year-1 interest rate | 7.65% | |
| 67 | Year-1 loan constant | 8.59% | |
| 68 | In-place rent less market rent ($/SF) | $0.35 | |
| 69 | In-place rent vs market (%) | 1.2% | |
| 70 | Named tenants expiring inside the hold (% of NRA) | 35.1% | |
| 71 | Year-1 debt yield | 10.4% | |
| 72 | Value at the exit cap on Year-1 NOI | $18,584,613 | |
| 73 | Office-using employment, 5-yr change (Phoenix MSA) | 1.1% | |
| 74 | Levered IRR hurdle | 12.0% | |
| 76 | FLAGS | ||
| 77 | In-place rent above market | FLAG | $30.35 in place vs $30.00 market |
| 78 | Named tenants expiring inside the hold above threshold | FLAG | 35.1% of NRA vs 30% threshold |
| 79 | DSCR below threshold in any year | FLAG | Minimum 1.21x vs 1.25x threshold |
| 80 | Negative leverage (going-in cap below Year-1 interest rate) | FLAG | 6.22% cap vs 7.65% rate |
| 81 | Flags raised (of 4) | 4 | |
| 82 | Screen result | Do not advance at this price: levered IRR below the hurdle |
The unlevered IRR is 0.20%. The sale is priced on Year-5 NOI at the 8.00% exit cap rate, which gives $19,456,443. That is 18.6% below the purchase price (our arithmetic), after five years in which NOI grew. Selling costs take $389,129 and the loan repayment $13,553,803. The Year-5 levered cash flow is $5,324,086, against $9,560,000 of equity put in at closing. The 0.46x equity multiple is the sum of the five levered cash flows, the yearly shortfalls included, over that closing equity.
The purchase price against what the income supports
The price is the 2019 appraised value. The two values divide NOI by the model's 8.00% exit cap rate
Compound's Screen tab, cells C6, H53 and C72. Appraised value: SEC Form ABS-EE for BBCMS Mortgage Trust 2019-C5, filed October 29, 2026. The exit cap rate is an analyst assumption.
The four flags fall into two groups. Two are about the leases and do not move with the price: in-place rent above market, and named tenants with 35.1% of the building expiring inside the hold. The first of those is a narrow call. The gap is $0.35, on a market rent that the analyst set $0.81 below the $30.81 average of the four asking rents, and at that average the flag would clear. The other two, coverage below 1.25x and negative leverage, depend on the price and the rate. Year-1 NOI equals a 7.65% yield at a price of about $19.4 million (our arithmetic), close to the Year-5 sale price in the model.
The agent’s answer says the same thing in a sentence: “the price is a 2019 appraisal, and the property’s own NOI is worth about $18.6M at an 8% cap. That gap, not the rollover, drives most of the loss.”
Sensitivity: levered IRR to leasing cost and market rent
The 2-by-2 table moves the leasing cost by $10.00 and the market rent by $3.00 either side of the base case. The levered IRR runs from -29.9% to -3.0%, and no corner is positive.
| B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|
| 84 | SENSITIVITY: LEVERED IRR TO LEASING COST AND MARKET RENT | ||||||||
| 85 | Market rent ($/SF) | $27.00 | $33.00 | ||||||
| 86 | Leasing cost ($/SF) | $28.00 | (25.0%) | (3.0%) | |||||
| 87 | $48.00 | (29.9%) | (5.8%) | ||||||
| 90 | Sensitivity cash flows | Leasing cost | Market rent | ||||||
| 91 | Low leasing cost, low market rent | (9,560,000) | (169,459) | (186,178) | (208,186) | (235,801) | 2,695,104 | $28.00 | $27.00 |
| 92 | Low leasing cost, high market rent | (9,560,000) | (92,563) | (29,310) | 31,821 | 90,609 | 8,209,389 | $28.00 | $33.00 |
| 93 | High leasing cost, low market rent | (9,560,000) | (425,778) | (442,497) | (464,506) | (492,120) | 2,438,784 | $48.00 | $27.00 |
| 94 | High leasing cost, high market rent | (9,560,000) | (348,882) | (285,630) | (224,498) | (165,710) | 7,953,069 | $48.00 | $33.00 |
Levered IRR: the base case and the four corners
Five-year hold at the appraised value of $23,900,000, with a 60% loan at 7.65%
Compound's Screen tab, cells C63, D86, E86, D87 and E87. The purchase price is the request's assumption. Leasing cost, market rent, debt and exit terms are analyst assumptions on the Assumptions tab.
Market rent moves the result far more than the leasing cost does. At a $28.00 leasing cost, taking market rent from $27.00 to $33.00 moves the levered IRR from -25.0% to -3.0%. At a $33.00 market rent, taking the leasing cost from $28.00 to $48.00 moves it from -3.0% to -5.8%. The leasing cost is paid once on each square foot. The rent is collected every year afterwards and is then capitalized at 8.00% in the sale price, on the 64,080 square feet rolled by Year 5.
The $33.00 column is about where the Central Scottsdale asking rent of $32.93 sits. Even there, with the cheaper leasing cost, the screen returns -3.0%.
Demand check: office-using employment in Phoenix
Employment in the three office-using sectors of the Phoenix-Mesa-Chandler metro area was 634.7 thousand in September 2026, up 1.1% from 627.6 thousand in September 2021. Financial activities fell 4.7% over the five years, and professional and business services rose 4.6%.
Office-using employment, Phoenix-Mesa-Chandler metro area
Thousands of jobs in information, financial activities, and professional and business services. September of each year, not seasonally adjusted
Compound's Assumptions tab, row 110: BLS Current Employment Statistics (State and Metro Area), vintage October 30, 2026.
The screen shows the five-year change beside the returns and does not feed it into any formula. Flat office employment gives no reason to set market rent growth above the 2.0% in the model.
What the public data cannot tell you
The filing gives the building’s totals and three tenant names with dates. Rent by tenant, renewal talks, recent leasing costs and a current value are with the seller, and the agent’s answer lists what to ask for.
- A current rent roll, lease by lease. Rents, escalations, recoveries and renewal or termination options replace the single $30.35 rent, the 2.5% escalation and the 18% rollover rate.
- Honor Health Care’s renewal status. Its lease ends on April 30, 2027.
- New and renewal leases from the last 24 months. Their tenant improvements, commissions, free rent and downtime replace the $38.00 and $30.00 assumptions.
- Line-item operating statements for the trailing twelve months and the current-year budget. They would show how much of the filed revenue is recoveries and other income.
- Outstanding leasing obligations. Tenant improvements, commissions and free rent already owed are costs the screen does not see.
- A valuation newer than 2019, and the seller’s price expectation. Either one replaces the appraised value as the price.
- The existing loan documents. They say whether the loan can be assumed and what defeasance would cost.
The public inputs have their own limits. The asking rents are submarket and metro averages, the REIT leasing costs come from portfolios of larger and newer buildings, and the employment figures cover the whole metro area.
Our view: what the screen returns on these inputs
At the appraised value and on these assumptions the screen returns its do-not-advance line, and the price accounts for more of that result than the leases do. The result belongs to a price the request set and to inputs an analyst chose, so read it as a test of the screen and never as a forecast for the property or as advice to buy or sell it.
- The screen did the sorting it was asked to do. One sheet gave a result line, four flags with the figures behind each, and a table showing that the answer holds across the leasing assumptions.
- Read the lease flags and the price flags separately. On the model’s own exit cap rate the income supports about $18.6 million, so the lease-by-lease work is worth doing only if the price can be at or below that figure. At that price the screen’s levered IRR would be about 3.5%, still under the 12% hurdle, and the hurdle is met near $15.9 million (our arithmetic: the sheet’s cash flows and sale price, with the purchase price and the 60% loan rescaled).
- The blended share understates Year 1. The largest named lease ends in April 2027. If the building advanced, the first step would be to post that expiry in its month, with real downtime, in a lease-by-lease model or a full real estate pro forma.
The other side deserves a hearing. The 8.00% exit cap rate is an assumption, and it sets both the sale price and the $18.6 million. A buyer who believes the building can charge Scottsdale rents has a case for the $33.00 column, where the result is still negative at this price.
Three things would change our view: a valuation newer than 2019, a signed renewal for the largest tenant, and an answer on whether the 4.30% loan can be assumed.
Scottsdale Gateway II office rollover screen (Excel)Compound’s workbook from this run: the one-sheet Screen with inputs, five-year projection, returns, flags and the 2-by-2 sensitivity, the Assumptions sheet with a source or a reason for every input, and Sources.Download · FreeFAQ
What is an office lease rollover analysis?
It is a schedule of how much leased area expires in each year, set against the rent that space pays now, the rent it could re-lease at and the cost of re-leasing it. On one sheet, this screen reduces the schedule to an annual share of 15.0% of leased area.
How do you estimate lease rollover without a rent roll?
CMBS loan filings name a property’s three largest tenants with their square feet and lease expiration dates. This screen averages the named expirations inside the hold over five years and adds an assumed 18% annual rate on the rest of the leased area.
What leasing cost per square foot should an office screen use?
Add tenant improvements, leasing commissions, free rent and downtime for one lease. Office REITs report these costs per square foot per year of lease term, so multiply by the term you expect. Here three REITs’ figures at a 5-year term plus downtime average $39.57, and the model uses $38.00.
What does it mean when in-place rent is above market rent?
Leases that expire are likely to be renewed or replaced at a lower rent, so income falls as space rolls even if occupancy holds. In this screen in-place rent is $30.35 against a $30.00 market assumption, and the gap widens because leases in place escalate at 2.5% while market rent grows 2.0%.
When does a building move from a rollover screen to a lease-by-lease model?
When the screen’s return clears the hurdle, or would at a price the seller might accept. The flags then say what to model first: here, a named lease for 25,045 square feet that expires in April 2027.





