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.
“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.”
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.
| B | C | D | E | G | H | I | J | K | M | |
|---|---|---|---|---|---|---|---|---|---|---|
| 6 | Tenant | SF | % of NRA | Lease expiration | Remaining term (yrs) | Rent Year 1 ($/SF) | Annual rent Year 1 | % of rent | Above 25% of rent? | Basis |
| 7 | Signify Health, LLC | 151,650 | 62.9% | 11/30/2029 | 2.9 | 33.46 | 5,073,955 | 69.9% | FLAG | Named in CMBS filing |
| 8 | One Network Enterprises, Inc | 45,274 | 18.8% | 6/30/2027 | 0.5 | 33.46 | 1,514,792 | 20.9% | Named in CMBS filing | |
| 9 | Zimperium, Inc | 10,913 | 4.5% | 7/31/2028 | 1.6 | 33.46 | 365,131 | 5.0% | Named in CMBS filing | |
| 10 | Other tenants A (assumed suites) | 3,095 | 1.3% | 12/31/2027 | 1.0 | 33.46 | 103,554 | 1.4% | Assumed | |
| 11 | Other tenants B (assumed suites) | 3,004 | 1.2% | 6/30/2029 | 2.5 | 33.46 | 100,509 | 1.4% | Assumed | |
| 12 | Other tenants C (assumed suites) | 3,004 | 1.2% | 12/31/2031 | 5.0 | 33.46 | 100,509 | 1.4% | Assumed | |
| 13 | Vacant space | 24,131 | 10.0% | 0.0 | 0.00 | 0 | 0.0% | Vacant at closing | ||
| 14 | Total | 241,071 | 100.0% | 7,258,449 | 100.0% |
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.
| B | C | D | E | |
|---|---|---|---|---|
| 40 | MARKET LEASING ASSUMPTIONS (MLA) | Value | Unit | Source / basis |
| 41 | Market rent, Year 1 (full-service gross) | 31.00 | $/SF/yr | Analyst 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 |
| 42 | Market rent growth | 3.0% | %/yr | Analyst assumption: Highwoods and Cousins report rising Dallas rents and absorption; 3% is held below their roll-ups for a suburban asset |
| 43 | Renewal probability | 65% | % | Analyst assumption: market norm 60-70%; Highwoods Q3 2026 leasing was 76% renewals by SF, but that is not a retention rate |
| 44 | Downtime before a new tenant | 9 | months | Analyst assumption: Dallas vacancy of about 25% (Highwoods Q2 2026 call) means long re-leasing; 9 months of marketing plus build-out |
| 45 | New lease term | 84 | months | Analyst assumption: Highwoods Q3 2026 new leases averaged 7.7 years |
| 46 | Renewal lease term | 60 | months | Analyst assumption: Highwoods Q3 2026 renewals averaged 7.1 years; 5 years held for a suburban building |
| 47 | Free rent, new lease | 6 | months | Analyst assumption: Highwoods new-lease concessions imply about 4 months on 7.7 years; 6 months for weaker suburban demand |
| 48 | Free rent, renewal | 2 | months | Analyst assumption: Highwoods renewal concessions imply about 1.7 months |
| 49 | Tenant improvements, new lease | 45.00 | $/SF | Analyst assumption: Highwoods new-lease TI of $5.88/SF/yr x 7.7 years is about $45/SF |
| 50 | Tenant improvements, renewal | 20.00 | $/SF | Analyst assumption: Highwoods renewal TI of $3.99/SF/yr x 5 years is about $20/SF |
| 51 | Leasing commissions, new lease | 4.00% | % of lease rent | Analyst assumption: Highwoods new-lease LC of $1.56 is 3.8% of $40.97 base rent |
| 52 | Leasing commissions, renewal | 2.75% | % of lease rent | Analyst assumption: Highwoods renewal LC of $1.11 is 2.7% of $41.14 base rent |
| 53 | Lease-up lag on space vacant at closing | 12 | months | Analyst assumption: existing vacancy has already been marketed; 12 months to lease and build out |
| 54 | Blended downtime (probability-weighted) | 3.15 | months | Calculated: (1 - renewal probability) x downtime |
| 55 | Blended lease term | 68.4 | months | Calculated |
| 56 | Blended free rent | 3.40 | months | Calculated |
| 57 | Blended tenant improvements | 28.75 | $/SF | Calculated |
| 58 | Blended leasing commissions | 3.19% | % of lease rent | Calculated |
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.
| B | D | G | H | M | N | O | P | F | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26 | Tenant | Expiry month # | Renewal probability | Downtime, roll 1 (mo) | Start, roll 1 (month #) | Free rent ends, roll 1 | Expiry, roll 1 | Rent, roll 1 ($/SF) | Expense stop, in-place | Expense stop, roll 1 | TI, roll 1 ($) | LC, roll 1 ($) | Start, roll 2 (month #) |
| 27 | Signify Health, LLC | 35 | 65% | 3.2 | 38.2 | 41.6 | 106.6 | 33.87 | 13.89 | 15.18 | 4,764,221 | 933,342 | 109.7 |
| 28 | One Network Enterprises, Inc | 6 | 65% | 3.2 | 9.2 | 12.6 | 77.6 | 31.00 | 13.89 | 13.89 | 1,301,628 | 254,997 | 80.7 |
| 29 | Zimperium, Inc | 19 | 65% | 3.2 | 22.2 | 25.6 | 90.6 | 31.93 | 13.89 | 14.31 | 323,161 | 63,309 | 93.7 |
| 30 | Other tenants A (assumed suites) | 12 | 65% | 3.2 | 15.2 | 18.6 | 83.6 | 31.93 | 13.89 | 14.31 | 91,651 | 17,955 | 86.7 |
| 31 | Other tenants B (assumed suites) | 30 | 65% | 3.2 | 33.2 | 36.6 | 101.6 | 32.89 | 13.89 | 14.74 | 91,625 | 17,950 | 104.7 |
| 32 | Other tenants C (assumed suites) | 60 | 65% | 3.2 | 63.2 | 66.6 | 131.6 | 35.94 | 13.89 | 16.11 | 100,121 | 19,614 | 134.7 |
| 33 | Vacant space | 0 | 0% | 12.0 | 12.0 | 18.0 | 96.0 | 31.93 | 0.00 | 14.31 | 1,118,472 | 215,741 | 99.2 |
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.
| B | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Year ending | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
| 8 | BASE CASE (PROBABILITY-WEIGHTED) | ||||||||||
| 9 | Average occupancy | 85.1% | 98.5% | 94.4% | 88.7% | 100.0% | 99.7% | 95.0% | 98.5% | 89.4% | 91.1% |
| 10 | Effective gross revenue ($) | 6,436,042 | 7,412,669 | 7,781,468 | 5,753,820 | 8,387,714 | 8,633,628 | 8,095,053 | 9,010,909 | 8,201,042 | 7,082,574 |
| 12 | Net operating income ($) | 3,086,907 | 3,963,060 | 4,228,371 | 2,094,130 | 4,618,233 | 4,751,063 | 4,096,011 | 4,891,895 | 3,958,458 | 2,712,712 |
| 13 | Tenant 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) |
| 14 | Leasing commissions | (254,997) | (297,005) | (17,950) | (933,342) | 0 | (19,614) | (304,480) | (97,034) | (193,604) | (1,114,459) |
| 16 | Cash flow before debt service ($) | 1,470,015 | 2,070,696 | 4,054,858 | (3,669,290) | 4,550,401 | 4,561,461 | 2,165,357 | 4,225,432 | 2,700,261 | (4,169,112) |
| 17 | Debt 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) |
| 18 | Levered cash flow from operations ($) | (580,185) | 20,496 | 2,004,658 | (5,951,088) | 2,268,603 | 2,279,663 | (116,441) | 1,943,634 | 418,463 | (6,450,910) |
| 19 | DSCR (annual NOI / debt service) | 1.51x | 1.93x | 2.06x | 0.92x | 2.02x | 2.08x | 1.80x | 2.14x | 1.73x | 1.19x |
| 20 | Months with monthly DSCR below threshold | 6 | 0 | 1 | 6 | 0 | 0 | 0 | 0 | 2 | 5 |
| 21 | DSCR flag | BELOW | BELOW | ||||||||
| 22 | Cash-on-cash return | (2.0%) | 0.1% | 7.0% | (20.8%) | 7.9% | 8.0% | (0.4%) | 6.8% | 1.5% | (22.6%) |
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
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 row | Base case | Stress case |
|---|---|---|
| Unlevered IRR | 4.7% | 1.3% |
| Levered IRR | 2.0% | (5.2%) |
| Unlevered equity multiple | 1.36x | 1.10x |
| Levered equity multiple | 1.13x | 0.71x |
| Unlevered profit ($) | 26,605,499 | 6,671,381 |
| Levered profit ($) | 6,349,862 | (13,584,256) |
| Equity at closing plus largest annual levered shortfall ($) | 35,033,410 | 40,465,012 |
| Gross sale price at exit ($) | 64,730,883 | 41,206,581 |
| Forward 12-month NOI at exit ($) | 5,502,125 | 3,502,559 |
| Exit value per SF | 268.51 | 170.93 |
| Average cash-on-cash (hold) | (1.5%) | (0.3%) |
| Minimum annual DSCR | 0.92x | (0.28x) |
| Years with annual DSCR below threshold | 2 | 1 |
| Months with monthly DSCR below threshold | 20 | 21 |
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%
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.
| B | C | D | E | |
|---|---|---|---|---|
| 25 | Existing (MSC 2021-L6) | New fixed | New floating | |
| 26 | Loan amount ($) | 36,300,000 | 26,800,000 | 29,800,000 |
| 27 | Interest rate, Year 1 | 3.72% | 7.65% | 7.52% |
| 28 | Rate basis | Fixed 3.72% (2021) | 10-year Treasury + spread | 1M SOFR forward + spread |
| 29 | Spread over index | n/a | 2.50% | 3.00% |
| 30 | Maturity date | 7/1/2031 | 12/31/2036 | 12/31/2036 |
| 31 | Term (months) | 120 | 120 | 120 |
| 32 | Interest-only (months) | 120 | 36 | 120 |
| 33 | Amortization (years) | 0 | 30 | 0 |
| 34 | Debt service, Year 1 | 1,369,115 | 2,050,200 | 2,272,636 |
| 35 | DSCR on Year-1 NOI | 2.25x | 1.51x | 1.36x |
| 36 | Debt yield on Year-1 NOI | 8.5% | 11.5% | 10.4% |
| 37 | Loan-to-value on purchase price | 66.9% | 49.4% | 54.9% |
| 38 | Prepayment | Lockout to 2/28/2031 | Open after year 3 (assumed) | Open after year 1 (assumed) |
| 39 | Months to maturity from closing | 54 | 120 | 120 |
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
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).
| B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|
| 12 | Exit cap rate | ||||||
| 13 | Market 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.00 | 1.0% | (0.3%) | (1.5%) | (2.8%) | (4.0%) | |
| 16 | $31.00 | 4.2% | 3.0% | 2.0% | 0.9% | (0.1%) | |
| 17 | $33.00 | 6.8% | 5.8% | 4.8% | 3.9% | 3.0% | |
| 18 | $35.00 | 9.1% | 8.2% | 7.3% | 6.4% | 5.6% |
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.
- 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.
- 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.
- 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.
- 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 · FreeFAQ
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.





