Office lease-by-lease cash flow: one tenant pays 69.9% of the rent

An acquisitions analyst tests a bid on a multi-tenant office building at its latest appraised value. Compound builds the 120-month model from the property's CMBS loan filing, posts every lease event in its month, and runs the case where the largest tenant leaves.

Compound Research · Updated Nov 15, 2026 · 14 min read

Short answer

An office lease-by-lease cash flow posts each tenant's rent, expense recoveries, free rent and leasing costs in the month they occur. In Compound's 120-month model of a Dallas-area office building bought at its 2021 appraised value of $54.3 million, the levered IRR is 2.0% in the base case and (5.2%) if the largest tenant leaves.

Try it now
On this page (13)
  1. 1. How an office lease-by-lease cash flow is built
  2. 2. The subject property: what the CMBS filing reports
  3. 3. The rent roll: 62.9% of the building in one lease
  4. 4. Leasing assumptions, checked against office REIT filings
  5. 5. Lease events in their month, and expense stops that reset
  6. 6. The 120-month base case, year by year
  7. 7. The stress case: the largest tenant leaves
  8. 8. New acquisition debt beside the existing loan
  9. 9. Can the existing loan be refinanced at its maturity?
  10. 10. Returns and the sensitivity to market rent and exit cap rate
  11. 11. What the public data cannot tell you
  12. 12. Our view: what this model says about the bid
  13. 13. FAQ

One tenant pays 69.9% of the rent at Granite Tower, an office building in Farmers Branch, Texas, and its lease ends on November 30, 2029. A buyer who pays the building’s latest appraised value of $54.3 million, from an appraisal dated April 13, 2021, and holds it for ten years earns a levered IRR of 2.0% in the model on this page. If that tenant leaves, the levered IRR is (5.2%).

You are on the acquisitions team of an institutional investor and the building is on your list. The CMBS filing for the loan on the property reports 90.0% occupancy, net operating income of $3,829,826 and debt service coverage of 2.80x. A bid depends on what happens to that income as each lease ends. We asked Compound to build the lease-by-lease model from public filings. It ran on November 15, 2026 and returned one Excel workbook.

What the workbook shows:

  • The purchase price is an assumption set by the request. It is the latest appraised value in the filing, $54,300,000 or $225.24 per square foot. The appraisal is dated April 13, 2021, 5.7 years before the assumed closing, and the workbook flags its age.
  • The cap rate falls from 7.05% to 5.68% in the first year of ownership. Trailing NOI over the price is 7.05%. Year-1 NOI in the model is $3,086,907, because the second-largest tenant’s lease ends on June 30, 2027.
  • New debt costs more than the building yields. The 10-year Treasury at 5.15% plus a 2.50% spread gives a 7.65% fixed rate. A coverage test sizes the loan at $26,800,000, which is 49.4% of the price.
  • NOI falls below debt service in 2030. In the base case NOI drops to $2,094,130 and annual DSCR to 0.92x, in the same year that $4,764,221 of tenant improvements and $933,342 of leasing commissions come due.
  • On the model’s terms, the loan now on the property does not refinance in full. The filing shows $36,300,000 at 3.72%, due July 1, 2031. The model’s largest new loan at that date is $32,893,252, and the test that binds is a 60% loan-to-value limit at an assumed 8.50% cap rate.

Each input on the Assumptions sheet names where it came from. Property and loan facts come from the CMBS loan-level filing for Morgan Stanley Capital I Trust 2021-L6 on SEC EDGAR, a Form ABS-EE filed on October 30, 2026. The 10-year yield is from the Daily Treasury Par Yield Curve, and the floating-rate loan option uses the SOFR forward curve, both at the close of November 13, 2026. Leasing benchmarks come from the Highwoods Properties 10-Q for the third quarter of 2026 and from earnings calls held by Highwoods and Cousins Properties. Every other input is marked “Analyst assumption” and carries the reason for its value.

Prompt to try

“I am deciding whether to bid on a multi-tenant office building and want a lease-by-lease office cash flow model built on a real property. From the CMBS loan-level filings, pick one U.S. multi-tenant office property 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; prefer one with a large lease expiring within four years. Use it as the subject and its latest appraised value as the purchase price. Build the rent roll from the named tenants as filed, and put the remaining leased area in clearly labelled "other tenants" rows with assumed staggered expirations and vacant space in its own row. Set in-place rent per square foot from reported revenue. Set market rent, renewal probability, downtime, free rent, tenant improvement and leasing commission costs as analyst assumptions, with a note on how you chose each, and check them against what public office REITs report for that market in their latest 10-K or earnings call if the stored data has it. Price new acquisition debt off today's 10-year Treasury yield and the SOFR forward curve, and show it next to the loan the property has now, including its maturity date. Build: a 120-month cash flow with base rent, expense recoveries over a base-year expense stop that resets when a lease renews or is replaced, free rent, tenant improvements and leasing commissions posted in the month of each lease event; a probability-weighted base case and a stress case where the largest expiring tenant leaves; the debt schedule with monthly DSCR; sale at the forward NOI over an exit cap rate; levered and unlevered IRR, equity multiple, cash-on-cash by year; weighted average lease term; and a sensitivity table of levered IRR to market rent and exit cap rate. Flag any year where DSCR falls below 1.25x, any tenant above 25% of rent, and whether the current loan can be refinanced at its maturity at today's rates. 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.”

Try this prompt free →

That is the request as we sent it, without its closing line, which asks that no name or email be put in the workbook.

How an office lease-by-lease cash flow is built

A lease-by-lease cash flow gives every tenant its own rows and posts rent, recoveries, free rent, tenant improvements and commissions in the month each one happens. Property income is the sum of those rows, so one large expiration appears in the month and the year where it lands.

Compound’s workbook follows the order an analyst would check it in: Assumptions, then the Rent Roll with a lease event schedule for each case, then the two monthly cash flow sheets (CF_Base and CF_Stress), Debt, Annual, Summary and Sensitivity. The cash flow sheets run for 132 months, because the sale is priced on the 12 months of NOI after it.

For a first pass on a building’s rollover, the office lease rollover analysis works on one sheet with blended assumptions. The core office pro forma works in annual periods on a building let to credit tenants. Rent roll analysis summarizes the leases themselves and stops before the 120-month cash flow.

The subject property: what the CMBS filing reports

The filing gives the building’s size, occupancy, trailing income, appraisal and loan, and it names the three largest tenants with their square feet and lease expiration dates. It gives no rent by tenant, so the model spreads reported revenue evenly over the leased area.

The filing names the property Granite Tower, at 4055 Valley View Lane in Farmers Branch, in the Dallas area. It was built in 1999 and has 241,071 square feet of net rentable area, 90.0% occupied. For the twelve months from April 1, 2025 to March 31, 2026 the filing reports revenue of $7,081,413, operating expenses of $3,251,587 and NOI of $3,829,826.

The loan in the filing is $36,300,000 at a fixed 3.72%, interest-only for its full 120-month term, due July 1, 2031, with annual debt service of $1,369,115.

Two inputs follow from the request. The purchase price equals the appraised value. In-place rent is reported revenue divided by the leased area of 216,940 square feet, which gives $32.64 per square foot, and the source cell says why: “seller rent roll not available”. One 2.5% escalation moves that to $33.46 for Year 1, and every tenant in the model pays that same rent. Reported revenue can include expense recoveries and other income as well as base rent, so the base rent in place may be lower than this figure. Filed operating expenses are $13.49 per square foot. A 3.0% growth assumption moves them to $13.89 for Year 1, and that figure is also the base-year expense stop for every lease in place.

The rent roll: 62.9% of the building in one lease

Signify Health, LLC leases 151,650 square feet, which is 62.9% of the building and 69.9% of Year-1 rent. The weighted average lease term is 2.3 years, and every lease in the roll expires inside the ten-year hold.

Granite_Tower_Office_Acquisition_Model.xlsx
K7fx=IF(J7>Assumptions!$C$98,"FLAG","")
BCDEGHIJKM
6TenantSF% of NRALease expirationRemaining term (yrs)Rent Year 1 ($/SF)Annual rent Year 1% of rentAbove 25% of rent?Basis
7Signify Health, LLC151,65062.9%11/30/20292.933.465,073,95569.9%FLAGNamed in CMBS filing
8One Network Enterprises, Inc45,27418.8%6/30/20270.533.461,514,79220.9%Named in CMBS filing
9Zimperium, Inc10,9134.5%7/31/20281.633.46365,1315.0%Named in CMBS filing
10Other tenants A (assumed suites)3,0951.3%12/31/20271.033.46103,5541.4%Assumed
11Other tenants B (assumed suites)3,0041.2%6/30/20292.533.46100,5091.4%Assumed
12Other tenants C (assumed suites)3,0041.2%12/31/20315.033.46100,5091.4%Assumed
13Vacant space24,13110.0%0.00.0000.0%Vacant at closing
14Total241,071100.0%7,258,449100.0%
SummaryAssumptionsRent RollCF_BaseCF_StressDebtAnnualSensitivitySOFR CurveSources
The in-place rent roll from Compound's Rent Roll tab, with ten of its twelve columns. Tenant names, square feet and expiration dates for the first three rows are as the CMBS filing gives them. The values are as Compound wrote them, shown to the sheet's precision.

The first three rows are the filing’s three largest tenants. The filing accounts for the rest of the leased area only as a total, so Compound put it in three rows marked “Assumed”, split 34%, 33% and 33%, with expirations it spread across 2027, 2029 and 2031. The 24,131 vacant square feet have their own row.

Signify Health’s share of rent is higher than its share of area because the vacant space pays nothing. The request set the concentration flag at 25% of rent. One Network Enterprises, Inc has 0.5 years left at closing.

The sheet computes the weighted average lease term by square feet and by rent, and both are 2.34 years. They match because every tenant carries the same rent per square foot.

Leasing assumptions, checked against office REIT filings

Market rent, renewal probability, downtime, free rent and leasing costs are analyst assumptions, and each one has a note that gives its reason. Compound checked them against the leasing terms Highwoods Properties reports in its 10-Q and against earnings calls of two office REITs.

Granite_Tower_Office_Acquisition_Model.xlsx
C57fx=$C$43*$C$50+(1-$C$43)*$C$49
BCDE
40MARKET LEASING ASSUMPTIONS (MLA)ValueUnitSource / basis
41Market rent, Year 1 (full-service gross)31.00$/SF/yrAnalyst assumption: about 5% below in-place gross rent and about 20% below the Dallas Class A average asking rent above $39 (Highwoods Q2 2026 call); Farmers Branch/LBJ is a commodity suburban submarket
42Market rent growth3.0%%/yrAnalyst assumption: Highwoods and Cousins report rising Dallas rents and absorption; 3% is held below their roll-ups for a suburban asset
43Renewal probability65%%Analyst assumption: market norm 60-70%; Highwoods Q3 2026 leasing was 76% renewals by SF, but that is not a retention rate
44Downtime before a new tenant9monthsAnalyst assumption: Dallas vacancy of about 25% (Highwoods Q2 2026 call) means long re-leasing; 9 months of marketing plus build-out
45New lease term84monthsAnalyst assumption: Highwoods Q3 2026 new leases averaged 7.7 years
46Renewal lease term60monthsAnalyst assumption: Highwoods Q3 2026 renewals averaged 7.1 years; 5 years held for a suburban building
47Free rent, new lease6monthsAnalyst assumption: Highwoods new-lease concessions imply about 4 months on 7.7 years; 6 months for weaker suburban demand
48Free rent, renewal2monthsAnalyst assumption: Highwoods renewal concessions imply about 1.7 months
49Tenant improvements, new lease45.00$/SFAnalyst assumption: Highwoods new-lease TI of $5.88/SF/yr x 7.7 years is about $45/SF
50Tenant improvements, renewal20.00$/SFAnalyst assumption: Highwoods renewal TI of $3.99/SF/yr x 5 years is about $20/SF
51Leasing commissions, new lease4.00%% of lease rentAnalyst assumption: Highwoods new-lease LC of $1.56 is 3.8% of $40.97 base rent
52Leasing commissions, renewal2.75%% of lease rentAnalyst assumption: Highwoods renewal LC of $1.11 is 2.7% of $41.14 base rent
53Lease-up lag on space vacant at closing12monthsAnalyst assumption: existing vacancy has already been marketed; 12 months to lease and build out
54Blended downtime (probability-weighted)3.15monthsCalculated: (1 - renewal probability) x downtime
55Blended lease term68.4monthsCalculated
56Blended free rent3.40monthsCalculated
57Blended tenant improvements28.75$/SFCalculated
58Blended leasing commissions3.19%% of lease rentCalculated
SummaryAssumptionsRent RollCF_BaseCF_StressDebtAnnualSensitivitySOFR CurveSources
The market leasing block of Compound's Assumptions tab, rows 40 to 58, with the column headings from the top of the sheet. The last five rows blend the renewal and new-lease terms by the renewal probability.

Market rent is $31.00 per square foot, below the $32.64 the building collects now. The Assumptions sheet compares it with the Dallas Class A average asking rent of $39.00 that Highwoods gave on its second-quarter call, and the model sits 20.5% below that figure.

The leasing costs come from the Highwoods 10-Q. It reports tenant improvements on new leases of $5.88 per square foot per year over an average term of 7.7 years, which the sheet multiplies out to $45.28. The model uses $45.00. On the same arithmetic the renewal figure is $19.95 against a model input of $20.00, and commissions are 3.81% and 2.70% of rent against inputs of 4.00% and 2.75%.

Two inputs are set harder than the benchmark. Highwoods’ concessions imply 3.9 months of free rent on a new lease, and the model gives 6 months “for weaker suburban demand”. Downtime before a new tenant is 9 months, with a note that Highwoods put Dallas office vacancy at about 25%.

Renewal probability is 65%, and the base case uses it to make one blended lease event. When a lease expires, the space is empty for 3.15 months, which is the 9 months weighted by the chance that the tenant does not renew, and then a 68.4-month lease starts with 3.40 months of free rent, $28.75 of tenant improvements and a 3.19% commission. A real tenant either stays or goes, so the blended case describes neither outcome, and the request asked for a stress case beside it.

Lease events in their month, and expense stops that reset

Each lease has a start month, a month when free rent ends and an expiry month for up to two leases after the one in place, and the cash flow sheets read those months. When a lease renews or is replaced, its expense stop resets to the operating cost per square foot of the year it starts, so recoveries from that tenant fall to zero and then build again.

Granite_Tower_Office_Acquisition_Model.xlsx
Q27fx=Assumptions!$C$35*(1+Assumptions!$C$34)^(INT(M27/12))
BDGHMNOPFQRST
26TenantExpiry month #Renewal probabilityDowntime, roll 1 (mo)Start, roll 1 (month #)Free rent ends, roll 1Expiry, roll 1Rent, roll 1 ($/SF)Expense stop, in-placeExpense stop, roll 1TI, roll 1 ($)LC, roll 1 ($)Start, roll 2 (month #)
27Signify Health, LLC3565%3.238.241.6106.633.8713.8915.184,764,221933,342109.7
28One Network Enterprises, Inc665%3.29.212.677.631.0013.8913.891,301,628254,99780.7
29Zimperium, Inc1965%3.222.225.690.631.9313.8914.31323,16163,30993.7
30Other tenants A (assumed suites)1265%3.215.218.683.631.9313.8914.3191,65117,95586.7
31Other tenants B (assumed suites)3065%3.233.236.6101.632.8913.8914.7491,62517,950104.7
32Other tenants C (assumed suites)6065%3.263.266.6131.635.9413.8916.11100,12119,614134.7
33Vacant space00%12.012.018.096.031.930.0014.311,118,472215,74199.2
SummaryAssumptionsRent RollCF_BaseCF_StressDebtAnnualSensitivitySOFR CurveSources
The base-case lease event schedule from Compound's Rent Roll tab, with thirteen of its 25 columns. Column headings are shortened, and the in-place expense stop is moved next to the stop for the next lease. Month numbers count from the closing on December 31, 2026.

Take the Signify Health row. The lease in place ends in month 35, which is November 2029. The blended next lease starts at month 38.2, its free rent ends at month 41.6 and it expires at month 106.6. Rent on the next lease is $33.87 per square foot. The tenant improvements are $4,764,221 and the commission is $933,342. A second event follows at month 109.7, early in 2036, the last year of the hold.

In November 2029 the Signify Health block on CF_Base shows base rent of $444,235 and expense recoveries of $10,692. The next three months show nothing. In March 2030 the block posts the tenant improvements and the commission in full, and the row for occupied area shows 128,903 of the 151,650 square feet, because the schedule keeps fractions of a month. The free rent runs into June 2030.

The lease in place has a stop of $13.89, and by 2029 operating expenses are $14.74 per square foot, so the tenant pays the difference. The recovery formula on CF_Base takes the excess of expenses over the stop for the lease in place and for each of the two that follow.

The next Signify Health lease gets a stop of $15.18, the expense level of the year it starts. Recoveries from that space are zero for the rest of 2030 and $5,755 a month in 2031. A model that grows recoveries on one line from the trailing figure never shows this drop.

The 120-month base case, year by year

Base-case NOI runs from a low of $2,094,130 in 2030 to a high of $4,891,895 in 2034, and two of the ten years have a DSCR below the 1.25x threshold. Cash-on-cash averages (1.5%) over the hold.

Granite_Tower_Office_Acquisition_Model.xlsx
D19fx=IF(D17<0,D12/-D17,"")
BDEFGHIJKLM
5Year ending2027202820292030203120322033203420352036
8BASE CASE (PROBABILITY-WEIGHTED)
9Average occupancy85.1%98.5%94.4%88.7%100.0%99.7%95.0%98.5%89.4%91.1%
10Effective gross revenue ($)6,436,0427,412,6697,781,4685,753,8208,387,7148,633,6288,095,0539,010,9098,201,0427,082,574
12Net operating income ($)3,086,9073,963,0604,228,3712,094,1304,618,2334,751,0634,096,0114,891,8953,958,4582,712,712
13Tenant improvements(1,301,628)(1,533,284)(91,625)(4,764,221)0(100,121)(1,554,211)(495,307)(988,247)(5,688,730)
14Leasing commissions(254,997)(297,005)(17,950)(933,342)0(19,614)(304,480)(97,034)(193,604)(1,114,459)
16Cash flow before debt service ($)1,470,0152,070,6964,054,858(3,669,290)4,550,4014,561,4612,165,3574,225,4322,700,261(4,169,112)
17Debt service(2,050,200)(2,050,200)(2,050,200)(2,281,798)(2,281,798)(2,281,798)(2,281,798)(2,281,798)(2,281,798)(2,281,798)
18Levered cash flow from operations ($)(580,185)20,4962,004,658(5,951,088)2,268,6032,279,663(116,441)1,943,634418,463(6,450,910)
19DSCR (annual NOI / debt service)1.51x1.93x2.06x0.92x2.02x2.08x1.80x2.14x1.73x1.19x
20Months with monthly DSCR below threshold6016000025
21DSCR flagBELOWBELOW
22Cash-on-cash return(2.0%)0.1%7.0%(20.8%)7.9%8.0%(0.4%)6.8%1.5%(22.6%)
SummaryAssumptionsRent RollCF_BaseCF_StressDebtAnnualSensitivitySOFR CurveSources
The base case from Compound's Annual tab: twelve of its fourteen rows, without the operating expense and capital reserve rows and the total column. Each cell sums the monthly CF_Base sheet for that year. Negative values are in parentheses.

2027. One Network’s lease ends in month 6. Average occupancy for the year is 85.1%. Annual DSCR is 1.51x, but the monthly DSCR is below the threshold in 6 of the 12 months.

2030. The Signify Health event lands. NOI is $2,094,130, the year’s leasing costs take cash flow before debt service to ($3,669,290), and debt service steps up to $2,281,798 as the 36-month interest-only period ends. Levered cash flow from operations is ($5,951,088), which is (20.8%) of the equity.

2036. The second Signify Health event falls in the year of the sale. Tenant improvements are $5,688,730, DSCR is 1.19x and cash-on-cash is (22.6%).

Cash-on-cash return by year, base case

Levered cash flow from operations over equity at closing of $28,582,500

2027-2.0%20280.1%20297.0%2030-20.8%20317.9%20328.0%2033-0.4%20346.8%20351.5%2036-22.6%

Compound's Annual tab, row 22, and Summary tab, rows 39 to 48. Property figures: SEC Form ABS-EE for Morgan Stanley Capital I Trust 2021-L6, filed October 30, 2026. Leasing and debt terms are analyst assumptions on the Assumptions tab.

Over the ten years the base case earns $38,400,840 of NOI and spends $19,749,859 on tenant improvements and commissions, which is 51% of the NOI (the sum and the share are our arithmetic on the Annual sheet’s total column). Levered cash flow from operations adds up to ($4,163,107). All of the base-case profit comes from the sale.

The stress case: the largest tenant leaves

In the stress case Signify Health’s renewal probability is 0%, its space is empty for 9 months and the replacement lease gets 6 months of free rent. NOI in 2030 is negative $639,435, and that year also carries $7,457,042 of tenant improvements and $1,438,381 of commissions.

Those two leasing costs sum to $8,895,423 (our arithmetic), the figure the agent’s answer rounds to about $8.9M that the equity would fund. Average occupancy in 2030 is 58.1%. Levered cash flow from operations is ($11,882,512), and cash-on-cash for the year is (41.6%).

Summary sheet rowBase caseStress case
Unlevered IRR4.7%1.3%
Levered IRR2.0%(5.2%)
Unlevered equity multiple1.36x1.10x
Levered equity multiple1.13x0.71x
Unlevered profit ($)26,605,4996,671,381
Levered profit ($)6,349,862(13,584,256)
Equity at closing plus largest annual levered shortfall ($)35,033,41040,465,012
Gross sale price at exit ($)64,730,88341,206,581
Forward 12-month NOI at exit ($)5,502,1253,502,559
Exit value per SF268.51170.93
Average cash-on-cash (hold)(1.5%)(0.3%)
Minimum annual DSCR0.92x(0.28x)
Years with annual DSCR below threshold21
Months with monthly DSCR below threshold2021

The table is the returns block of Compound’s Summary sheet, rows 23 to 36, unedited.

IRR over the 120-month hold: base case and stress case

Purchase at the appraised value of $54,300,000, new fixed-rate loan at 7.65%

Unlevered IRR, base case4.7%Levered IRR, base case2.0%Unlevered IRR, stress case1.3%Levered IRR, stress case-5.2%

Compound's Summary tab, cells C23, C24, D23 and D24. The purchase price is the request's assumption. Leasing, debt and exit terms are analyst assumptions on the Assumptions tab.

The stress case has fewer years below the DSCR threshold than the base case, 1 against 2, which follows from the lease terms. In the stress case the replacement lease starts at month 44 and runs 84 months, so it expires at month 128, after the sale. The base case’s blended lease expires at month 106.6 and puts a second round of leasing costs into 2036. In the stress case the DSCR for 2036 is 2.40x.

The cost of the stress shows up at the exit. The sale price is the NOI of the 12 months after the sale divided by the exit cap rate, and in the stress case those 12 months include the replacement lease’s expiry. Forward NOI is $3,502,559 against $5,502,125 in the base case, and the sale price is $41,206,581 against $64,730,883.

New acquisition debt beside the existing loan

The new fixed-rate loan is $26,800,000 at 7.65%, sized by a 1.35x DSCR test. The loan now on the property is $36,300,000 at 3.72%, and the model’s Year-1 NOI covers the existing debt service 2.25x and the new debt service 1.51x.

Granite_Tower_Office_Acquisition_Model.xlsx
D26fx=ROUNDDOWN(MIN(C8,C9,C6/Assumptions!$C$71/C10),-5)
BCDE
25Existing (MSC 2021-L6)New fixedNew floating
26Loan amount ($)36,300,00026,800,00029,800,000
27Interest rate, Year 13.72%7.65%7.52%
28Rate basisFixed 3.72% (2021)10-year Treasury + spread1M SOFR forward + spread
29Spread over indexn/a2.50%3.00%
30Maturity date7/1/203112/31/203612/31/2036
31Term (months)120120120
32Interest-only (months)12036120
33Amortization (years)0300
34Debt service, Year 11,369,1152,050,2002,272,636
35DSCR on Year-1 NOI2.25x1.51x1.36x
36Debt yield on Year-1 NOI8.5%11.5%10.4%
37Loan-to-value on purchase price66.9%49.4%54.9%
38PrepaymentLockout to 2/28/2031Open after year 3 (assumed)Open after year 1 (assumed)
39Months to maturity from closing54120120
SummaryAssumptionsRent RollCF_BaseCF_StressDebtAnnualSensitivitySOFR CurveSources
The loan comparison from Compound's Debt tab, rows 25 to 39, unedited. The existing loan's terms are from the CMBS filing. The terms of both new loans are analyst assumptions priced off the 10-year Treasury yield and the SOFR forward curve of November 13, 2026.

The Debt sheet sizes the new loan three ways on Year-1 NOI. A 55% loan-to-value limit allows $29,865,000. A 10.0% debt yield allows $30,869,073. A 1.35x DSCR on a 30-year amortizing payment allows $26,856,376, and that is the binding test. The loan is rounded down to $26,800,000. Equity at closing is $28,582,500 after closing costs of 1.5% and a 1.00% origination fee.

The rate is 7.65%, the building’s Year-1 NOI is 5.68% of the price, and the unlevered IRR is 4.7%. Borrowing at a rate above the going-in yield and above the unlevered return lowers the equity return, so the levered IRR of 2.0% sits below the unlevered one.

The floating-rate option is in the third column. A 3.00% spread over the one-month SOFR forward gives 7.52% for Year 1 and a larger loan, because the test uses an interest-only payment. The agent’s answer reports that the floating loan cuts the base levered IRR to 1.1%. The SOFR forward curve page shows how that curve is built.

The loan in the filing costs $1,369,115 a year, and the new loan costs $2,050,200 a year on a smaller balance. The filing gives a prepayment lockout that ends on February 28, 2031 and a defeasance option that began on August 1, 2023. Whether a buyer could take over that loan is a question for the loan documents.

Can the existing loan be refinanced at its maturity?

On the model’s terms it cannot be refinanced in full. At a 7.65% rate, an 8.50% valuation cap rate and a 60% loan-to-value limit, the largest new loan is $32,893,252 against the $36,300,000 due on July 1, 2031.

Refinance test at the existing loan's maturity

Balance due against the largest new loan each lender test allows

Balance due July 1, 2031$36.3MMaximum loan at 60% LTV, base case$32.9MMaximum loan at 60% LTV, stress case$32.5MMaximum loan at DSCR, base case$43.8MMaximum loan at debt yield, base case$46.6M

Compound's Debt tab, rows 45 to 52. Balance and maturity: SEC Form ABS-EE for Morgan Stanley Capital I Trust 2021-L6, filed October 30, 2026. Rate: 10-year Treasury par yield of November 13, 2026 plus an assumed spread. The lender tests are analyst assumptions.

The maturity falls in month 55. In the base case the NOI of the following 12 months is $4,659,877, and the debt yield and DSCR tests both clear the balance. The loan-to-value test does not. At an 8.50% cap rate the building is valued at $54,822,087, and 60% of that is the $32,893,252 limit. The shortfall is $3,406,748 in the base case and $3,786,306 in the stress case, and the sheet returns “No: paydown needed” for both.

The result depends on the valuation cap rate, which the Assumptions sheet marks as an analyst assumption set equal to the exit cap. The debt yield test allows $46,598,774 and the DSCR test $43,784,668, both above the balance. The NOI under all three tests comes from the model’s assumed rents and lease events, so the test describes this model and is not a statement about the loan.

Returns and the sensitivity to market rent and exit cap rate

The base case returns a 2.0% levered IRR and a 1.13x multiple on all the equity paid in over the hold. Across the sensitivity table the levered IRR runs from (9.3%) to 9.1%.

The Summary sheet’s levered multiple divides the sum of the positive monthly cash flows by the sum of the negative ones. Its denominator therefore includes the months in which the buyer funds a shortfall as well as the $28,582,500 paid at closing. Against the equity at closing alone, the base-case levered profit of $6,349,862 is 22.2% and the stress-case loss of $13,584,256 is 47.5% (our arithmetic).

Granite_Tower_Office_Acquisition_Model.xlsx
C13fx=Summary!C24
BCDEFGH
12Exit cap rate
13Market rent ($/SF)2.0%7.50%8.00%8.50%9.00%9.50%
14$27.00(3.1%)(4.6%)(6.1%)(7.7%)(9.3%)
15$29.001.0%(0.3%)(1.5%)(2.8%)(4.0%)
16$31.004.2%3.0%2.0%0.9%(0.1%)
17$33.006.8%5.8%4.8%3.9%3.0%
18$35.009.1%8.2%7.3%6.4%5.6%
SummaryAssumptionsRent RollCF_BaseCF_StressDebtAnnualSensitivitySOFR CurveSources
The two-way table from Compound's Sensitivity tab, rows 12 to 18, unedited: base-case levered IRR by Year-1 market rent (rows) and exit cap rate (columns). The grid is an Excel data table that feeds each pair of values through the model. Negative values are in parentheses.

In the base case the 12 months after the sale earn $5,502,125, and at the 8.50% exit cap rate the price is $64,730,883, or $268.51 per square foot, before selling costs of 1.5%.

Market rent moves the result more than the exit cap rate does. One step of $2.00 in market rent takes the levered IRR from 2.0% to 4.8% going up and to (1.5%) going down. One step of 0.50% in the exit cap rate takes it to 3.0% or to 0.9%. At a market rent of $29.00 the return is negative at every exit cap rate above 7.50%.

Every lease expires during the hold, so the whole building is repriced to market at least once, and the largest space twice.

What the public data cannot tell you

Public filings give the building’s totals and the names of three tenants. The rent each tenant pays, its expense stop, its options and its plans are in documents that only the seller has.

The agent’s answer ends with the list a buyer would send to the seller. Each item replaces an assumption in the workbook.

  • The current rent roll and lease abstracts. Rent by tenant, escalations, expense stops, options and leasing costs already owed replace the single $33.46 rent, the single $13.89 stop and the three assumed rows.
  • Signify Health’s intentions for its 2029 expiry. Sublease or give-back activity, the tenant’s credit and any guaranty replace the 65% renewal probability.
  • One Network’s renewal status. Its lease ends six months after the assumed closing.
  • Operating statements for 2023 to 2025, the trailing twelve months and the 2026 budget, with the tax assessment and protest history. The model grows one year of filed expenses at 3.0%.
  • A new appraisal and a property condition report. The appraisal in the filing is from 2021, and the capital reserve of $0.25 per square foot is an assumption.
  • The existing loan documents. Whether the loan can be assumed, what defeasance would cost and what reserves the lender holds.

Our view: what this model says about the bid

At the 2021 appraised value and on these assumptions, the levered return is 2.0% and the debt costs 7.65%. That result belongs to a price the request set and to inputs an analyst chose, so read it as a test of the model and never as a forecast for the property or as advice to buy or sell it.

  1. The trailing cap rate is the wrong number to anchor on. It is 7.05%, and the first year of ownership earns 5.68%, because a lease the filing already dates ends six months in.
  2. The decision of one tenant is most of the underwriting. The gap between the two cases is the gap between a levered multiple of 1.13x and one of 0.71x on all equity paid in. On the equity at closing it is the gap between a profit of 22.2% and a loss of 47.5% (our arithmetic). No public source says which is closer.
  3. Size the equity for 2030 as well as for closing. Equity at closing plus the largest annual shortfall is $35,033,410 in the base case and $40,465,012 in the stress case.
  4. Check both exits against a stabilized NOI. The base-case sale is priced on 12 months in which the building is 100.0% leased in all but the last month, with a 1.0% vacancy and credit allowance, while the Assumptions sheet notes Dallas office vacancy of about 25%. That forward NOI of $5,502,125 is above the NOI of every year in the hold, so the base-case sale price sits on the favourable side. The stress-case sale is priced on 12 months that include an expiry. We would add a row that prices the sale on a stabilized year and compare.

What would change our view is on the seller list: a signed extension for the largest tenant, or a rent roll with rents well below $31.00.

Granite Tower office acquisition model (Excel)Compound’s workbook from this run: Summary, Assumptions, Rent Roll with the lease event schedule, monthly base and stress cash flows, Debt with the refinance test, Annual, Sensitivity, the SOFR forward curve and Sources.Download · Free

FAQ

What is an office lease-by-lease cash flow?

It is a projection that gives each tenant its own rows for rent, expense recoveries, free rent, tenant improvements and commissions, and adds them up to property NOI month by month.

What is a base-year expense stop, and why does it reset?

Under a full-service gross lease the landlord pays operating expenses up to a fixed amount per square foot, usually the expenses of the lease’s first year, and the tenant pays any excess. A new or renewed lease gets a new base year: in this model the largest tenant’s stop moves from $13.89 to $15.18.

How do you model renewal probability in an office cash flow?

One method weights the renewal terms and the new-lease terms by the probability and posts a single blended event. Here a 65% probability turns 9 months of downtime into 3.15 months. The other method runs each outcome as its own case, as the stress case here does.

How is weighted average lease term (WALT) calculated?

Multiply each lease’s remaining term by its square feet or by its rent, add the products and divide by the total. The workbook computes both on the Rent Roll sheet and gets 2.34 years.

How is the sale price set at the end of a 120-month hold?

The model divides the NOI of the 12 months after the sale by an exit cap rate, here 8.50%, and deducts selling costs of 1.5%. A lease expiry in that forward year lowers the price directly, as the stress case shows.

CoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix ResearchCoatueCentri ConsultingAvra783 Capital PartnersOctahedron CapitalArix Research

See this workflow on your own deal

Try it now