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.
“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.”
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.
| B | C | D | E | F | K | M | N | |
|---|---|---|---|---|---|---|---|---|
| 6 | Tenant | SF | % of NRA | Lease expiration | Remaining term (yrs) | Renewal probability | Expires inside hold | Expected first-rollover TI + LC ($) |
| 7 | Dimplex North America Limited | 179,200 | 21.8% | 6/30/2029 | 2.5 | 70% | Yes | 546,576 |
| 8 | Horner Services, Inc. Wensco of Michigan, Corporation | 129,088 | 15.7% | 8/31/2027 | 0.7 | 70% | Yes | 371,128 |
| 9 | Balsam Brands | 128,000 | 15.6% | 6/30/2026 | 0.0 | 70% | Yes | 368,000 |
| 10 | Other tenants A (not named in filing) | 86,270 | 10.5% | 6/30/2028 | 1.5 | 70% | Yes | 255,467 |
| 11 | Other tenants B (not named in filing) | 86,270 | 10.5% | 12/31/2029 | 3.0 | 70% | Yes | 271,025 |
| 12 | Other tenants C (not named in filing) | 86,270 | 10.5% | 6/30/2031 | 4.5 | 70% | Yes | 279,156 |
| 13 | Vacant (lease-up assumed) | 127,990 | 15.6% | 12/31/2027 | 0.0 | 0% | No | 725,064 |
| 14 | Total | 823,088 | 100.0% | 2,816,415 |
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.
| B | C | |
|---|---|---|
| 17 | IN-PLACE RENT DERIVED FROM REPORTED REVENUE | |
| 19 | Revenue (trailing 12 months) | 4,339,703 |
| 20 | Operating expenses (trailing 12 months) | 1,623,458 |
| 21 | Recoverable share of operating expenses | 90.0% |
| 22 | Physical occupancy | 84.5% |
| 23 | Estimated expense recoveries in revenue | 1,233,910 |
| 24 | Implied base rent (trailing 12 months) | 3,105,794 |
| 25 | Leased SF (NRA x occupancy) | 695,098 |
| 26 | In-place base rent, trailing 12 months ($/SF/yr) | $4.47 |
| 27 | In-place base rent, Year 1 after one escalation ($/SF/yr) | $4.60 |
| 28 | Market rent, Year 1 ($/SF/yr) | $5.00 |
| 29 | Market rent above in-place (mark-to-market) | 8.6% |
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
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.
| B | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45 | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total |
| 46 | Year ending | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | |
| 47 | In-place lease SF expiring | 257,088 | 86,270 | 179,200 | 86,270 | 86,270 | 0 | 0 | 0 | 0 | 0 | 695,098 |
| 48 | % of NRA | 31.2% | 10.5% | 21.8% | 10.5% | 10.5% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 84.5% |
| 49 | Cumulative % of NRA | 31.2% | 41.7% | 63.5% | 74.0% | 84.5% | 84.5% | 84.5% | 84.5% | 84.5% | 84.5% | |
| 53 | Probability-weighted costs, all lease generations | |||||||||||
| 54 | Tenant improvements | (321,360) | (506,562) | (237,642) | (117,837) | (121,372) | (372,544) | (319,797) | (275,492) | (136,605) | (140,703) | (2,549,915) |
| 55 | Leasing commissions | (417,768) | (473,969) | (308,934) | (153,188) | (157,784) | (484,308) | (415,736) | (358,139) | (177,587) | (182,914) | (3,130,327) |
| 56 | Downtime 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) |
| 57 | Free rent | (122,984) | (239,112) | (88,771) | (134,139) | (28,320) | (178,984) | (188,048) | (102,910) | (155,504) | (32,831) | (1,271,603) |
| 58 | Total 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) |
| 59 | Rollover 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) |
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.
| Assumption | Model | REIT figure | REIT source, as labeled on the sheet |
|---|---|---|---|
| Renewal probability | 70.0% | 75.8% | STAG retention, YTD to 9/30/2026 |
| Renewal probability | 70.0% | 70.8% | First Industrial retention, YTD to 9/30/2026 |
| Market rent over Year 1 in-place rent | 8.6% | 19.7% | STAG renewal cash rent change, YTD |
| Market rent over Year 1 in-place rent | 8.6% | 26.1% | STAG new-lease cash rent change, YTD |
| Market rent over Year 1 in-place rent | 8.6% | 40.5% | First Industrial cash rent increase, new and renewal, YTD |
| Market rent over Year 1 in-place rent | 8.6% | 16.0% | First Industrial signed 2027 renewals, cash |
| Renewal TI + LC ($/SF) | $1.75 | $1.44 | STAG renewal TI + LC, YTD |
| Renewal TI + LC ($/SF) | $1.75 | $2.63 | First Industrial renewal lease costs, YTD |
| New-tenant TI + LC ($/SF) | $5.50 | $2.65 | STAG new-lease TI + LC, YTD |
| New-tenant TI + LC ($/SF) | $5.50 | $8.69 | First 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 escalations | 3.0% | 3.5% | LXP new five-year lease |
| Exit cap rate | 8.8% | 6.9% | STAG Q3 2026 acquisitions, cash cap rate |
| Lease term (years) | 5.0 | 6.5 | STAG 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
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%.
| B | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 6 | Year ending | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
| 10 | Gross potential base rent | 3,906,957 | 4,064,194 | 4,235,475 | 4,424,733 | 4,576,788 | 4,726,702 | 4,868,504 | 5,014,559 | 5,164,995 | 5,319,945 |
| 11 | Downtime and vacancy loss | (800,495) | (98,916) | (142,585) | (70,702) | (72,823) | (186,114) | (229,290) | (165,295) | (81,963) | (84,422) |
| 12 | Free rent | (122,984) | (239,112) | (88,771) | (134,139) | (28,320) | (178,984) | (188,048) | (102,910) | (155,504) | (32,831) |
| 13 | General vacancy and credit loss | (89,504) | (111,785) | (120,124) | (126,597) | (134,269) | (130,848) | (133,535) | (142,391) | (147,826) | (156,081) |
| 14 | Net base rent ($) | 2,893,973 | 3,614,381 | 3,883,995 | 4,093,295 | 4,341,376 | 4,230,756 | 4,317,631 | 4,603,963 | 4,779,703 | 5,046,612 |
| 15 | Expense recoveries | 1,175,852 | 1,468,162 | 1,498,123 | 1,570,081 | 1,617,184 | 1,626,288 | 1,661,344 | 1,736,735 | 1,820,155 | 1,874,759 |
| 16 | Effective gross income ($) | 4,069,826 | 5,082,543 | 5,382,118 | 5,663,376 | 5,958,559 | 5,857,044 | 5,978,975 | 6,340,697 | 6,599,857 | 6,921,371 |
| 18 | NNN expense recoveries | ||||||||||
| 19 | Gross 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) |
| 20 | Recoverable 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) |
| 21 | Recoveries from tenants | 1,175,852 | 1,468,162 | 1,498,123 | 1,570,081 | 1,617,184 | 1,626,288 | 1,661,344 | 1,736,735 | 1,820,155 | 1,874,759 |
| 22 | Net expense cost to owner ($) | (496,310) | (254,166) | (275,874) | (257,135) | (264,850) | (312,206) | (335,305) | (319,814) | (298,090) | (307,033) |
| 23 | Recovery ratio | 70.3% | 85.2% | 84.4% | 85.9% | 85.9% | 83.9% | 83.2% | 84.4% | 85.9% | 85.9% |
| 24 | Average occupancy | 80.5% | 97.6% | 96.7% | 98.4% | 98.4% | 96.1% | 95.3% | 96.7% | 98.4% | 98.4% |
| 26 | Net operating income ($) | 2,397,663 | 3,360,216 | 3,608,121 | 3,836,160 | 4,076,526 | 3,918,550 | 3,982,326 | 4,284,149 | 4,481,612 | 4,739,578 |
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
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 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | |
|---|---|---|---|---|---|---|---|
| Net operating income ($) | 2,397,663 | 3,360,216 | 3,608,121 | 3,836,160 | 4,076,526 | 3,918,550 | 3,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) |
| DSCR | 1.91x | 2.68x | 2.51x | 2.67x | 2.83x | 2.72x | 2.77x |
| Debt yield | 13.2% | 18.5% | 19.8% | 21.3% | 22.9% | 22.3% | 22.9% |
| Cash-on-cash yield | 2.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
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”.
| B | C | D | |
|---|---|---|---|
| 38 | Existing CMBS loan | New acquisition loan | |
| 39 | Loan amount (existing: current balance) | 18,521,638 | 18,200,000 |
| 40 | Interest rate | 5.49% | 6.90% |
| 41 | Rate basis | Fixed, originated 11/13/2018 | Fixed: 10Y Treasury 5.15% + 1.75% |
| 42 | Amortization (months) | 360 | 360 |
| 43 | Interest-only term (months) | 60 | 24 |
| 44 | Maturity date | 12/6/2028 | 12/31/2036 |
| 45 | Annual debt service (existing: most recent; new: Year 1) | 1,309,564 | 1,255,800 |
| 46 | DSCR on trailing-12 NOI | 2.07x | 2.16x |
| 47 | DSCR as reported by servicer | 2.07x | n/a |
| 48 | Loan-to-value on purchase price | 66.1% | 65.0% |
| 49 | Debt yield on trailing-12 NOI | 14.7% | 14.9% |
| 50 | Prepayment | Locked out to 9/5/2028; defeasance only | Not modeled; assumed open at sale |
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.
| C | D | E | F | G | H | |
|---|---|---|---|---|---|---|
| 177 | Rent growth / exit cap | 7.75% | 8.25% | 8.75% | 9.25% | 9.75% |
| 178 | 1.00% | 25.1% | 23.8% | 22.5% | 21.3% | 20.2% |
| 179 | 2.00% | 26.3% | 25.0% | 23.8% | 22.6% | 21.5% |
| 180 | 3.00% | 27.5% | 26.2% | 25.0% | 23.9% | 22.8% |
| 181 | 4.00% | 28.7% | 27.4% | 26.2% | 25.1% | 24.0% |
| 182 | 5.00% | 29.9% | 28.6% | 27.4% | 26.3% | 25.2% |
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 · FreeFAQ
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.





