Industrial warehouse acquisition model: 84.5% of area expires in hold

An acquisitions analyst underwrites a multi-tenant Indianapolis warehouse in Compound from its CMBS filing: a triple-net rent roll, lease term weighted by square feet, rollover costs, new debt priced on the rates of November 13, 2026, and returns at a price set to the 2018 appraised value.

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

Short answer

An industrial warehouse acquisition model carries a triple-net rent roll through rollover costs and expense recoveries to debt coverage and returns. In Compound's model of an 823,088-square-foot Indianapolis warehouse, every lease expires inside the 7-year hold, and the 25.0% levered IRR rests on a price set to a 2018 appraisal.

Try it now
On this page (11)
  1. 1. The subject property and the purchase price
  2. 2. Building a triple-net rent roll from a CMBS filing
  3. 3. WALT, tenant concentration and lease expirations
  4. 4. Probability-weighted rollover costs
  5. 5. NNN expense recoveries: gross expenses, recoveries and net cost
  6. 6. Price per square foot against REIT Schedule III
  7. 7. Sizing the acquisition loan: LTV, DSCR and debt yield by year
  8. 8. Levered and unlevered IRR, and the sensitivity table
  9. 9. What the public filings cannot tell you
  10. 10. Our view
  11. 11. FAQ

At a purchase price of $28.0 million, Compound’s model of a 1972 Indianapolis warehouse shows a 25.0% levered IRR over a 7-year hold. The same model shows a weighted average lease term of 1.9 years. Every lease in place, 84.5% of the building’s area, expires before the sale, and none of the four risk flags in the request trips. The lease flag tests the largest single lease, 21.8% of the area, against a 25% threshold, so it reads “OK” while the whole rent roll turns over.

The price explains most of the return. The request set the purchase price to the property’s latest appraised value, and the latest appraisal in the CMBS filing is dated August 2, 2018. Against the income reported for the twelve months to June 30, 2026, that price is a 9.70% cap rate. The 25.0% is what the model returns under that assumption. It is not a forecast for this property and not a view on what the building would sell for.

You are on the acquisitions team of an institutional investor looking at a multi-tenant warehouse. You need to know how much of the expenses the tenants pay, when the leases expire, what it costs to lease the space again, and whether the debt is covered in the weakest year. We asked Compound to build that model on a real property from public filings. It ran on November 15, 2026 and returned one Excel workbook of eight sheets and a short written answer.

What the workbook shows:

  • The building and the price. The filing names it Franklin Road Distribution Center, 221 South Franklin Road, Indianapolis: 823,088 square feet, built in 1972 and 84.45% occupied. $28.0 million is $34.02 a square foot. Plymouth Industrial REIT, which was public until January 2026, carried 17 Indiana warehouses at $35.00 a square foot in the Schedule III of its 10-K for fiscal 2024, so the price is 2.8% below that set.
  • The leases. The largest named tenant has 21.8% of the area. Leases on 31.2% of the area expire in Year 1.
  • Rollover. Leasing the space again costs $8.9 million over ten years on a probability-weighted basis, or $10.79 a square foot.
  • The debt. The new loan is $18.2 million, set by the 65% loan-to-value limit. The 1.30x DSCR test alone would have allowed $23.3 million. The lowest DSCR in the hold is 1.91x and the lowest debt yield is 13.2%, both in Year 1.
  • The returns. The unlevered IRR is 15.6% and the levered IRR is 25.0%. Across the sensitivity table the levered IRR runs from 20.2% to 29.9%.

The property, its tenants and its loan come from a CMBS loan-level filing on SEC EDGAR. The comparison cost per square foot comes from Schedule III of a REIT’s 10-K. The leasing benchmarks come from the filings and earnings calls of STAG Industrial, First Industrial Realty Trust and LXP Industrial Trust. The loan is priced from the Daily Treasury Par Yield Curve and the SOFR forward curve. Every other input is marked “Analyst assumption” with a reason.

Prompt to try

“I am underwriting the acquisition of a multi-tenant warehouse or distribution property and want an industrial acquisition model built on a real property. From the CMBS loan-level filings, pick one U.S. industrial warehouse or distribution property whose latest report names its 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 purchase price. Build the rent roll from the named tenants as filed, with the remaining leased area in clearly labelled "other tenants" rows and vacant space in its own row. Set in-place rent per square foot from reported revenue. Set market rent, annual escalations, renewal probability, and tenant improvement and leasing commission packages for a renewal and for a new tenant as analyst assumptions with a note on each, checked against what public industrial REITs report on rent spreads and occupancy in their latest 10-K or earnings call. Compare the price per square foot with what public industrial REITs carry buildings at in the same state (Schedule III). Price new acquisition debt off today's 10-year Treasury yield and the SOFR forward curve, sized to the tighter of 65% loan-to-value and a 1.30x DSCR, and show it next to the loan the property has now. Build: triple-net expense recoveries showing gross expenses, recoveries and the net cost to the owner; weighted average lease term by square feet and a tenant-concentration check; probability-weighted rollover costs; a 10-year annual cash flow with a 7-year hold; DSCR and debt yield by year with the lowest year called out; levered and unlevered IRR, equity multiple and cash-on-cash; and a sensitivity table of levered IRR to market rent growth and exit cap rate. Flag a tenant above 30% of the area, a lease that expires inside the hold for more than 25% of the area, negative leverage, and a debt yield below 9%. 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.

The subject property and the purchase price

Every property fact in the model is a field in one CMBS trust’s asset data file. The purchase price is an assumption that the request set, and the model labels it that way.

Compound chose loan 13 of JPMCC Commercial Mortgage Securities Trust 2019-COR4. The trust’s Form ABS-EE, filed on October 21, 2026 for the reporting period ended October 6, 2026, names the property and its three largest tenants with their square feet and lease expiration dates.

The same filing gives the financials for the twelve months from July 1, 2025 to June 30, 2026: revenue of $4,339,703, operating expenses of $1,623,458, net operating income of $2,716,245 and net cash flow of $2,551,998. It gives an appraised value of $28,000,000 dated August 2, 2018. Compound’s note beside that input reads “no newer valuation filed”.

The purchase price is a formula that points at the appraised value, and its source column says the instruction came from the request. At that price the building costs $34.02 a square foot, the trailing cap rate is 9.70%, and the going-in cap rate on the model’s Year 1 net operating income is 8.56%.

Compound’s answer states this directly: “Most of that return comes from the price, because the appraisal is dated 8/2/2018.”

Building a triple-net rent roll from a CMBS filing

A CMBS filing names only the largest tenants, so the rent roll has three filed rows, three assumed rows and one vacant row. In-place rent is backed out of reported revenue, because the filing does not split rent from recoveries. One of the three filed leases, Balsam Brands, expired before the report date.

Franklin_Road_Industrial_Acquisition_Model.xlsx
C10fx=(Assumptions!$C$7*Assumptions!$C$8-SUM($C$7:$C$9))*Assumptions!$C$58
BCDEFKMN
6TenantSF% of NRALease expirationRemaining term (yrs)Renewal probabilityExpires inside holdExpected first-rollover TI + LC ($)
7Dimplex North America Limited179,20021.8%6/30/20292.570%Yes546,576
8Horner Services, Inc. Wensco of Michigan, Corporation129,08815.7%8/31/20270.770%Yes371,128
9Balsam Brands128,00015.6%6/30/20260.070%Yes368,000
10Other tenants A (not named in filing)86,27010.5%6/30/20281.570%Yes255,467
11Other tenants B (not named in filing)86,27010.5%12/31/20293.070%Yes271,025
12Other tenants C (not named in filing)86,27010.5%6/30/20314.570%Yes279,156
13Vacant (lease-up assumed)127,99015.6%12/31/20270.00%No725,064
14Total823,088100.0%2,816,415
SummaryAssumptionsRent RollMonthly CFCash FlowDebtComps & BenchmarksSources
The rent roll at close from Compound's Rent Roll tab, with eight of its thirteen columns. Column headings are shortened; the values are as Compound wrote them, at the sheet's precision. Tenant names are as the CMBS filing gives them. Dates are shown as month/day/year.

The filing names Dimplex North America Limited with 179,200 square feet to June 30, 2029, a tenant it lists as “Horner Services, Inc. Wensco of Michigan, Corporation” with 129,088 square feet to August 31, 2027, and Balsam Brands with 128,000 square feet to June 30, 2026. Together they hold 53.0% of the net rentable area.

The filed occupancy of 84.45% implies more leased space than those three tenants hold. Compound put the remainder into three equal “other tenants” blocks of 86,270 square feet each and gave them assumed expirations in 2028, 2029 and 2031. Those rows are marked “Analyst assumption”, with the note “replace with the seller’s rent roll”. The vacant 127,990 square feet has its own row and is assumed to lease on December 31, 2027.

One row needs a second look. The filing shows the Balsam Brands lease expiring on June 30, 2026, which is before the report date. Compound kept the space as occupied and set it to roll at close with a 70% renewal probability. Its note says the building’s vacancy equals Balsam’s 128,000 square feet and that the tenant’s status should be confirmed with the seller.

Franklin_Road_Industrial_Acquisition_Model.xlsx
C23fx=C20*C21*C22
BC
17IN-PLACE RENT DERIVED FROM REPORTED REVENUE
19Revenue (trailing 12 months)4,339,703
20Operating expenses (trailing 12 months)1,623,458
21Recoverable share of operating expenses90.0%
22Physical occupancy84.5%
23Estimated expense recoveries in revenue1,233,910
24Implied base rent (trailing 12 months)3,105,794
25Leased SF (NRA x occupancy)695,098
26In-place base rent, trailing 12 months ($/SF/yr)$4.47
27In-place base rent, Year 1 after one escalation ($/SF/yr)$4.60
28Market rent, Year 1 ($/SF/yr)$5.00
29Market rent above in-place (mark-to-market)8.6%
SummaryAssumptionsRent RollMonthly CFCash FlowDebtComps & BenchmarksSources
The in-place rent derivation from Compound's Rent Roll tab, rows 19 to 29, unedited.

The reported revenue of $4,339,703 includes base rent and expense recoveries. Compound estimated the recoveries as operating expenses times a 90% recoverable share times occupancy, which gives $1,233,910, and took the rest as base rent. Divided by the leased area, in-place rent is $4.47 a square foot a year. After one 3% escalation it is $4.60 in Year 1.

The 90% is an analyst assumption, and the in-place rent depends on it. Market rent is set at $5.00, which is 8.6% above the Year 1 in-place rent.

WALT, tenant concentration and lease expirations

The weighted average lease term is 1.9 years by square feet, and every lease in place expires within five years of closing. Neither leasing flag trips, because each tests one tenant or one lease and the largest is 21.8% of the area.

WALT is one formula on the Rent Roll sheet: =SUMPRODUCT(C7:C12,F7:F12)/SUM(C7:C12). It multiplies each lease’s square feet by its remaining term at close and divides by the leased square feet. Counting only the three named tenants it is 1.2 years. Dimplex has 2.5 years left, Horner Services 0.7 and Balsam Brands 0.0.

In-place leases expiring by year, as a share of net rentable area

Year 1 is calendar 2027. No in-place lease expires in Years 6 or 7. The 2028, 2029 and 2031 expirations of the unnamed tenants are assumptions

Year 1 (2027)31.2%Year 2 (2028)10.5%Year 3 (2029)21.8%Year 4 (2030)10.5%Year 5 (2031)10.5%Year 6 (2032)0.0%Year 7 (2033)0.0%

Compound's Rent Roll tab, row 48. Named tenants and lease expiration dates: Form ABS-EE asset data file of JPMCC Commercial Mortgage Securities Trust 2019-COR4, loan 13.

Year 1 carries 257,088 square feet, 31.2% of the building: the Balsam Brands space at close and the Horner Services lease in August 2027. Dimplex follows in Year 3 with 21.8%. By the end of Year 5 the cumulative figure is 84.5%, which is all of the leased area.

The tenant-concentration flag compares the largest named tenant, 21.8% of the area, with the 30% threshold and returns “OK”. The expiry flag compares the largest single lease expiring inside the hold, also 21.8%, with the 25% threshold and returns “OK”. The next row on the sheet shows all leased area expiring inside the hold, 84.5%.

Compound’s answer heads its flag section “all OK, but look at rollover”, and we agree. In a multi-tenant warehouse with short leases, the cumulative row describes the risk better than a single-lease threshold does.

Probability-weighted rollover costs

Leasing the space again costs $8.9 million over ten years, or $10.79 a square foot of net rentable area. The largest year is Year 1 at $1.7 million, when the vacant space and two of the three named leases are in play.

Each lease reaches its expiration in the monthly engine and splits by probability. The 70% that renews gets one month of free rent, $0.50 a square foot of tenant improvements and $1.25 of leasing commissions. The 30% that leaves stays empty for six months, then a new tenant gets three months of free rent, $3.00 of tenant improvements and $2.50 of commissions. Every new lease runs five years and then rolls again on the same terms, with costs growing 3% a year.

Franklin_Road_Industrial_Acquisition_Model.xlsx
D47fx=SUMPRODUCT($C$7:$C$12,$J$7:$J$12,--(INT(($G$7:$G$12-1)/12)+1=D$45))
BDEFGHIJKLMN
45Year12345678910Total
46Year ending2027202820292030203120322033203420352036
47In-place lease SF expiring257,08886,270179,20086,27086,27000000695,098
48% of NRA31.2%10.5%21.8%10.5%10.5%0.0%0.0%0.0%0.0%0.0%84.5%
49Cumulative % of NRA31.2%41.7%63.5%74.0%84.5%84.5%84.5%84.5%84.5%84.5%
53Probability-weighted costs, all lease generations
54Tenant improvements(321,360)(506,562)(237,642)(117,837)(121,372)(372,544)(319,797)(275,492)(136,605)(140,703)(2,549,915)
55Leasing commissions(417,768)(473,969)(308,934)(153,188)(157,784)(484,308)(415,736)(358,139)(177,587)(182,914)(3,130,327)
56Downtime and vacancy loss(800,495)(98,916)(142,585)(70,702)(72,823)(186,114)(229,290)(165,295)(81,963)(84,422)(1,932,606)
57Free rent(122,984)(239,112)(88,771)(134,139)(28,320)(178,984)(188,048)(102,910)(155,504)(32,831)(1,271,603)
58Total rollover cost ($)(1,662,607)(1,318,559)(777,932)(475,866)(380,299)(1,221,950)(1,152,872)(901,837)(551,659)(440,871)(8,884,450)
59Rollover cost per SF of NRA($2.02)($1.60)($0.95)($0.58)($0.46)($1.48)($1.40)($1.10)($0.67)($0.54)($10.79)
SummaryAssumptionsRent RollMonthly CFCash FlowDebtComps & BenchmarksSources
The rollover schedule and cost rows from Compound's Rent Roll tab, without the rows for expected square feet renewing and going to new tenants. Values are as Compound wrote them; costs are in parentheses.

Over ten years the four cost lines are $2,549,915 of tenant improvements, $3,130,327 of leasing commissions, $1,932,606 of downtime and vacancy loss and $1,271,603 of free rent. Year 1 alone carries $800,495 of downtime and vacancy loss, which includes the vacant space earning nothing until its assumed lease date.

The request asked for each leasing assumption to be checked against what public industrial REITs report. Compound put the model’s value and the REIT figure side by side on the Comps & Benchmarks sheet.

AssumptionModelREIT figureREIT source, as labeled on the sheet
Renewal probability70.0%75.8%STAG retention, YTD to 9/30/2026
Renewal probability70.0%70.8%First Industrial retention, YTD to 9/30/2026
Market rent over Year 1 in-place rent8.6%19.7%STAG renewal cash rent change, YTD
Market rent over Year 1 in-place rent8.6%26.1%STAG new-lease cash rent change, YTD
Market rent over Year 1 in-place rent8.6%40.5%First Industrial cash rent increase, new and renewal, YTD
Market rent over Year 1 in-place rent8.6%16.0%First Industrial signed 2027 renewals, cash
Renewal TI + LC ($/SF)$1.75$1.44STAG renewal TI + LC, YTD
Renewal TI + LC ($/SF)$1.75$2.63First Industrial renewal lease costs, YTD
New-tenant TI + LC ($/SF)$5.50$2.65STAG new-lease TI + LC, YTD
New-tenant TI + LC ($/SF)$5.50$8.69First Industrial new-lease costs, YTD
Stabilized economic occupancy (Year 3)93.8%96.2%STAG operating portfolio, 9/30/2026
Stabilized economic occupancy (Year 3)93.8%94.1%First Industrial in-service, 9/30/2026
Annual rent escalations3.0%3.5%LXP new five-year lease
Exit cap rate8.8%6.9%STAG Q3 2026 acquisitions, cash cap rate
Lease term (years)5.06.5STAG new-lease term, YTD

The model’s market rent is the most cautious line in the table. It sits 8.6% above in-place rent, while the REITs report cash rent increases of 16.0% to 40.5% on leases they signed.

Rent increase on new and renewal leases: the model against REIT reports

Model: market rent over Year 1 in-place rent. REITs: cash rent change on leases signed, as each company reports it

Model: market rent over Year 1 in-place rent8.6%First Industrial: signed 2027 renewals16.0%STAG: renewal leases, year to date19.7%STAG: third quarter 2026 leasing23.8%STAG: new leases, year to date26.1%First Industrial: new and renewal, year to date40.5%

Compound's Rent Roll tab, cell C29, and Assumptions tab, rows 94 to 98: STAG Industrial third quarter 2026 supplemental and earnings call; First Industrial Realty Trust 10-Q and earnings call for the third quarter of 2026.

Compound’s notes give the reason for staying under the REIT figures: the building dates from 1972, and the REIT portfolios hold newer product.

NNN expense recoveries: gross expenses, recoveries and net cost

Triple-net leases pass taxes, insurance and common-area costs to the tenants, and the owner still pays for whatever space is empty. In Year 1 the tenants reimburse 70.3% of gross operating expenses, and from Year 2 through Year 7 the ratio is between 83.2% and 85.9%.

Franklin_Road_Industrial_Acquisition_Model.xlsx
D15fx=SUMIFS('Monthly CF'!$E$134:$DT$134,'Monthly CF'!$E$7:$DT$7,D$5)
BDEFGHIJKLM
5Year12345678910
6Year ending2027202820292030203120322033203420352036
10Gross potential base rent3,906,9574,064,1944,235,4754,424,7334,576,7884,726,7024,868,5045,014,5595,164,9955,319,945
11Downtime and vacancy loss(800,495)(98,916)(142,585)(70,702)(72,823)(186,114)(229,290)(165,295)(81,963)(84,422)
12Free rent(122,984)(239,112)(88,771)(134,139)(28,320)(178,984)(188,048)(102,910)(155,504)(32,831)
13General vacancy and credit loss(89,504)(111,785)(120,124)(126,597)(134,269)(130,848)(133,535)(142,391)(147,826)(156,081)
14Net base rent ($)2,893,9733,614,3813,883,9954,093,2954,341,3764,230,7564,317,6314,603,9634,779,7035,046,612
15Expense recoveries1,175,8521,468,1621,498,1231,570,0811,617,1841,626,2881,661,3441,736,7351,820,1551,874,759
16Effective gross income ($)4,069,8265,082,5435,382,1185,663,3765,958,5595,857,0445,978,9756,340,6976,599,8576,921,371
18NNN expense recoveries
19Gross operating expenses(1,672,162)(1,722,327)(1,773,997)(1,827,217)(1,882,033)(1,938,494)(1,996,649)(2,056,549)(2,118,245)(2,181,792)
20Recoverable operating expenses(1,504,946)(1,550,094)(1,596,597)(1,644,495)(1,693,830)(1,744,645)(1,796,984)(1,850,894)(1,906,421)(1,963,613)
21Recoveries from tenants1,175,8521,468,1621,498,1231,570,0811,617,1841,626,2881,661,3441,736,7351,820,1551,874,759
22Net expense cost to owner ($)(496,310)(254,166)(275,874)(257,135)(264,850)(312,206)(335,305)(319,814)(298,090)(307,033)
23Recovery ratio70.3%85.2%84.4%85.9%85.9%83.9%83.2%84.4%85.9%85.9%
24Average occupancy80.5%97.6%96.7%98.4%98.4%96.1%95.3%96.7%98.4%98.4%
26Net operating income ($)2,397,6633,360,2163,608,1213,836,1604,076,5263,918,5503,982,3264,284,1494,481,6124,739,578
SummaryAssumptionsRent RollMonthly CFCash FlowDebtComps & BenchmarksSources
Rows 5 to 26 of Compound's Cash Flow tab for the ten years, without the Year 0 column and the NOI growth row. Each cell sums the months of that year on the Monthly CF tab. Values are as Compound wrote them; deductions are in parentheses.

Gross operating expenses start from the filed trailing figure and grow 3% a year, to $1,672,162 in Year 1. Of that, 90% is recoverable. The monthly engine then bills the recoverable amount only on occupied space, less the 3% general vacancy and credit loss allowance.

The owner therefore pays three things: the 10% that no lease recovers, the recoverable share on vacant space, and the allowance. In Year 1, with average occupancy of 80.5%, recoveries are $1,175,852 and the net cost to the owner is $496,310. In Year 2 occupancy averages 97.6% and the net cost falls to $254,166. That occupancy is above the 94.1% and 96.2% the two REITs on the Comps & Benchmarks sheet report for their portfolios, and the building is 84.45% occupied today.

Vacancy in a triple-net building costs the owner twice, once in rent and once in unrecovered expenses. That is why Year 1 net operating income of $2,397,663 is below the $2,716,245 the filing reports for the trailing year, and why Year 2 rises to $3,360,216 once the vacant space is assumed leased. A gross-lease building works differently: in the office lease-by-lease cash flow the owner pays expenses up to a stop and recovers only the growth above it.

Price per square foot against REIT Schedule III

The purchase price of $34.02 a square foot is 2.8% below the square-foot-weighted figure for 17 Indiana warehouses on the books of a REIT that was public at the time, and 4.0% above their median. Schedule III records historical cost, so the comparison shows what one owner has invested in similar buildings. It does not show what they would sell for.

Compound took the comparison from Plymouth Industrial REIT’s 10-K for fiscal 2024, filed on March 3, 2025: 16 buildings in Indianapolis and one in Lafayette (our count of the sheet’s rows), 4,085,169 square feet in all, with a gross carrying amount of $142,999,000 at December 31, 2024. Plymouth was taken private in January 2026, so the figures are almost two years old on the date of this page.

Dollars per square foot: the subject against 17 Indiana warehouses in Schedule III

Gross carrying amount per square foot at December 31, 2024, against the subject's purchase price and its modeled sale price

Plymouth Indiana buildings: minimum$21.97Plymouth Indiana buildings: median$32.70Franklin Road at the purchase price$34.02Plymouth Indiana buildings: SF-weighted$35.00Plymouth Indiana buildings: average$41.66Plymouth Indiana buildings: maximum$97.70Franklin Road at the modeled Year 7 sale$59.49

Compound's Comps & Benchmarks tab, rows 26 to 38: Schedule III and Item 2 of Plymouth Industrial REIT's 10-K for fiscal 2024; Form ABS-EE asset data file of JPMCC Commercial Mortgage Securities Trust 2019-COR4.

One of the 17 is on the same road. The 10-K lists 3333 N. Franklin Road as a 276,240-square-foot building from 1967, carried at $29.30 a square foot, 100% occupied at an annualized rent of $3.30 a square foot.

Compound’s answer states the limit in one line: “Schedule III is historical cost, not market value.” The sheet adds that Plymouth bought most of these buildings between 2017 and 2022. The modeled sale price at the end of Year 7 is $59.49 a square foot, and only four of the 17 buildings are carried above that (our count from column F of the sheet).

Sizing the acquisition loan: LTV, DSCR and debt yield by year

The loan is the smaller of two amounts, and here the 65% loan-to-value limit sets it at $18.2 million. The lowest coverage of the hold comes in Year 1, at a 1.91x DSCR and a 13.2% debt yield.

The DSCR test divides Year 1 net operating income by the 1.30x minimum and then by the amortizing debt constant of 7.90%. On the Debt sheet that is =C7/Assumptions!$C$68/C9, and it returns $23,336,827. The loan-to-value test returns $18,200,000, and the sheet reports “LTV” as the binding constraint.

The fixed rate is the 10-year Treasury par yield of 5.15% at the close of November 13, 2026 plus a 1.75% spread, or 6.90%. The spread is an analyst assumption. A switch on the Assumptions sheet prices the loan off the SOFR forward curve instead, at the average forward rate for the quarters in each year plus 2.50%. That gives 7.09% in Year 1. The loan is interest-only for two years and then amortizes over 30 years, so debt service steps up in Year 3.

Year 1Year 2Year 3Year 4Year 5Year 6Year 7
Net operating income ($)2,397,6633,360,2163,608,1213,836,1604,076,5263,918,5503,982,326
Debt service ($)(1,255,800)(1,255,800)(1,438,383)(1,438,383)(1,438,383)(1,438,383)(1,438,383)
DSCR1.91x2.68x2.51x2.67x2.83x2.72x2.77x
Debt yield13.2%18.5%19.8%21.3%22.9%22.3%22.9%
Cash-on-cash yield2.7%9.6%14.3%19.1%21.3%14.2%16.0%

DSCR by year of the hold, new acquisition loan

Net operating income over debt service, in times. Years 1 and 2 are interest-only

Year 11.91Year 22.68Year 32.51Year 42.67Year 52.83Year 62.72Year 72.77Sizing minimum set by the request1.3

Compound's Cash Flow tab, row 38, and Assumptions tab, cell C68.

Year 1 is the lowest year on both measures because occupancy is lowest then. On a fully amortizing payment the Year 1 DSCR would be 1.67x. The debt yield never comes near the 9% floor in the request, and the going-in cap rate of 8.56% is 166 basis points above the loan rate (our arithmetic), so the negative-leverage flag is also “OK”.

Franklin_Road_Industrial_Acquisition_Model.xlsx
C11fx=C7/Assumptions!$C$68/C9
BCD
38Existing CMBS loanNew acquisition loan
39Loan amount (existing: current balance)18,521,63818,200,000
40Interest rate5.49%6.90%
41Rate basisFixed, originated 11/13/2018Fixed: 10Y Treasury 5.15% + 1.75%
42Amortization (months)360360
43Interest-only term (months)6024
44Maturity date12/6/202812/31/2036
45Annual debt service (existing: most recent; new: Year 1)1,309,5641,255,800
46DSCR on trailing-12 NOI2.07x2.16x
47DSCR as reported by servicer2.07xn/a
48Loan-to-value on purchase price66.1%65.0%
49Debt yield on trailing-12 NOI14.7%14.9%
50PrepaymentLocked out to 9/5/2028; defeasance onlyNot modeled; assumed open at sale
SummaryAssumptionsRent RollMonthly CFCash FlowDebtComps & BenchmarksSources
The loan comparison from Compound's Debt tab, rows 38 to 50, unedited. The existing loan's terms are from the CMBS filing; the new loan's terms are the model's.

The filing reports a balance of $18,521,638 at a fixed 5.49%, maturing on December 6, 2028, and a prepayment lockout to September 5, 2028. The new loan is slightly smaller and costs 6.90%. Because it starts interest-only, its Year 1 debt service of $1,255,800 is below the $1,309,564 the existing loan pays.

Compound’s answer adds that the existing loan “cannot be paid off at a 2026 close except through defeasance”. A buyer would either assume it or pay to defease it, and the model’s new loan carries neither cost. A property that is still being built has a different debt problem, covered in the construction-to-permanent loan model.

Levered and unlevered IRR, and the sensitivity table

At the assumed price the model returns a 15.6% unlevered IRR and a 25.0% levered IRR over seven years. Moving the exit cap rate by a full point in either direction changes the levered IRR by less than three points (our arithmetic on the table). The sale still supplies about two-thirds of the levered profit (our arithmetic from the Cash Flow and Debt sheets).

The equity is $10,402,000: the price, closing costs of 1.5% of the price and a 1% origination fee, less the loan. The unlevered equity multiple is 2.39x and the levered multiple is 3.96x. Cash-on-cash yield is 2.7% in Year 1, when rollover costs are heaviest, and averages 13.9% over the hold.

The sale at the end of Year 7 capitalizes Year 8 net operating income of $4,284,149 at an 8.75% exit cap rate, which gives a gross sale price of $48,961,699. Selling costs are 1.5%. Compound set the exit cap rate 185 basis points above the 6.9% cash cap rate STAG Industrial reported on its third quarter 2026 acquisitions, because the building dates from 1972.

Franklin_Road_Industrial_Acquisition_Model.xlsx
C177fx='Cash Flow'!C63
CDEFGH
177Rent growth / exit cap7.75%8.25%8.75%9.25%9.75%
1781.00%25.1%23.8%22.5%21.3%20.2%
1792.00%26.3%25.0%23.8%22.6%21.5%
1803.00%27.5%26.2%25.0%23.9%22.8%
1814.00%28.7%27.4%26.2%25.1%24.0%
1825.00%29.9%28.6%27.4%26.3%25.2%
SummaryAssumptionsRent RollMonthly CFCash FlowDebtComps & BenchmarksSources
The sensitivity table from Compound's Assumptions tab: levered IRR by market rent growth (rows) and exit cap rate (columns). Cell C177 holds the base-case levered IRR, shown in the formula bar; the excerpt puts the axis label in its place. It is an Excel data table, so it recalculates with the model. The base case is in bold.

The lowest cell is 20.2% and the highest is 29.9%. Along the base-case row, a 9.75% exit cap rate gives 22.8% and a 7.75% exit cap rate gives 27.5%.

The table is flat because the two inputs it varies matter less than two it holds fixed. Net operating income rises from $2,397,663 in Year 1 to $4,284,149 in Year 8 as the vacant space leases, rents move to market and escalate 3% a year. The price stays fixed at a figure from 2018. The return depends most on the purchase price and on the lease-up of the vacant and expiring space, and the table varies neither.

What the public filings cannot tell you

A CMBS filing and three REITs’ reports are enough to build the model, and they leave several of its main inputs as assumptions. Compound’s answer ends with what it would need from the seller, and each item replaces a specific assumption in the model.

  • A full current rent roll. Every tenant’s square feet, rent, expiration, renewal options and lease type. This replaces the three “other tenants” rows and the single in-place rent applied to every tenant.
  • The status of the Balsam Brands space. Whether the tenant renewed, is holding over or has left. The model treats the space as occupied.
  • A trailing operating statement that splits base rent from recoveries. This replaces the 90% recoverable share, which sets both the in-place rent and the net expense cost.
  • Tenant estoppels. To confirm the rents and terms the rent roll shows.
  • A current appraisal or broker opinion of value. A current value changes the cap rate, the loan amount and every return.
  • A property condition report and a Phase I environmental report. The model holds reserves of $0.15 a square foot a year and has no line for a roof or paving.
  • The servicer’s terms for assuming or defeasing the existing loan, with the cost. The model’s new loan assumes the property can be financed free of the existing one.
  • Whether the county will reassess property taxes after the sale. Operating expenses in the model grow 3% a year from the filed figure, with no step at closing.

None of the filings gives a market rent or a sale price for a warehouse of this age in this part of Indianapolis.

Our view

The model is a sound frame with one input that decides the answer, and Compound said which one. We would keep the structure, replace the price, and spend the diligence budget on the first two years of leasing.

Recoveries follow occupancy month by month, rollover costs follow each lease, and each assumption is next to a public figure a reviewer can check. The return needs more care. A 25.0% levered IRR on a 1972 warehouse tells you to check the price before anything else. The model’s trailing cap rate is 9.70%, against the 6.9% that STAG Industrial reported on its third quarter acquisitions, and the price is an appraisal from 2018. A current appraisal or broker opinion would replace it. The useful exercise is to raise the price until the levered IRR meets your hurdle, and to treat that price as the most you would bid.

There is a case for a higher bid. In-place rent is below the model’s market rent, the REITs report rent increases about two to five times the model’s (our arithmetic), and the building is 84.45% occupied with room to lease.

Three things would change our view: a current rent roll with longer leases on the unnamed tenants, confirmation that the Balsam Brands space is empty, and a defeasance quote. From here the work is a rent roll analysis against the leases themselves and a full real estate pro forma at the price the seller will take.

Franklin Road industrial acquisition model (Excel)Compound’s workbook from this run: a Summary with the four flags, an Assumptions sheet with a source or reason beside every input and the sensitivity table, the Rent Roll with WALT and rollover costs, a 120-month lease-by-lease engine, the 10-year Cash Flow, the Debt sheet, the Schedule III and REIT benchmark comparisons, and Sources.Download · Free

FAQ

What does an industrial warehouse acquisition model include?

A tenant-by-tenant rent roll, market leasing assumptions for each rollover, triple-net expense recoveries, a cash flow, a loan sized to lender tests, and returns with a sensitivity table. The model on this page has these on eight sheets, with a source or a reason beside every input.

How is WALT calculated for a warehouse?

Multiply each lease’s remaining term by its square feet, add the results, and divide by total leased square feet. This model weights by square feet, as the request asked, and returns 1.9 years.

What does triple-net mean for the owner's expenses?

Under a triple-net (NNN) lease the tenant reimburses its share of property taxes, insurance and common-area costs on top of base rent. The owner still pays the expenses on vacant space and any cost the leases exclude. In this model the tenants reimburse 70.3% of gross operating expenses in Year 1 and 85.2% in Year 2.

How do lenders size a loan with LTV and DSCR tests?

Each test gives a maximum loan, and the lender takes the smaller. The loan-to-value test multiplies the price or value by a percentage. The DSCR test divides net operating income by the required coverage and by the annual debt constant. Here 65% loan-to-value gives $18.2 million and a 1.30x DSCR gives $23.3 million, so loan-to-value sets the loan.

Can a rent roll be built from a CMBS filing?

In part. The asset data file in Form ABS-EE gives the three largest tenants with their square feet and lease expiration dates, plus net rentable area, occupancy, revenue and expenses. It gives no rent by tenant and nothing on smaller tenants. Those rows are assumptions until the seller provides the rent roll, and the model marks them that way.

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