Shopping center underwriting: the anchor pays 47.3% of base rent

An acquisitions analyst at an institutional retail investor asks Compound for a one-sheet screen of a real shopping center from public filings: the anchor and shop rent split, a read of the anchor's own 10-K and earnings call, one loan at the Treasury yield of November 13, 2026, and four flags.

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

Short answer

Shopping center underwriting tests whether a center's rents, tenants and debt support its price. In Compound's one-sheet screen of a California center priced at its $61,000,000 appraised value, Home Depot pays 47.3% of base rent, its lease ends in year three of a five-year hold, and the levered IRR is 9.6%.

Try it now
On this page (12)
  1. 1. The subject: a Home Depot-anchored center from a CMBS filing
  2. 2. Splitting reported revenue into anchor rent and shop rent
  3. 3. Anchor vs shop: 63.4% of the area, 47.3% of the base rent
  4. 4. Market rent checked against shopping-center REIT 10-Ks
  5. 5. Is the Home Depot store safe? The anchor's 10-K and earnings call
  6. 6. The five-year cash flow and the anchor lease expiration
  7. 7. Sizing the loan: 60% of value at the 10-year Treasury plus a spread
  8. 8. The results panel and the four flags
  9. 9. Levered IRR sensitivity to shop rent and shop occupancy
  10. 10. What public data cannot tell you about this center
  11. 11. Our view: ask for the rent roll, and price the renewal first
  12. 12. FAQ

A Home Depot store fills 63.4% of the rentable area at Towne Center East in Signal Hill, California. On Compound’s split of the revenue in the center’s CMBS filing, it pays 47.3% of the base rent. Its lease ends on January 31, 2029, in the third year of a five-year hold that starts at the end of 2026. Priced at the $61,000,000 appraised value that the request set as the price, the screen shows a 7.0% going-in cap rate against a 6.90% loan rate.

You review shopping-center teasers on the acquisitions team of an institutional real estate investor. Each one gets half an hour and one decision: ask for the rent roll and book a visit, or pass. We asked Compound to build that screen and test it on a real anchored center from public data. It ran on November 15, 2026 and returned one Excel workbook and a summary.

What the workbook shows:

  • One tenant carries almost half the rent. Home Depot leases 103,423 of 163,039 square feet at $20.59 a square foot. The shop space, 36.6% of the area, pays the other 52.7% of base rent.
  • The anchor lease ends inside the hold. The filing gives January 31, 2029 as the expiration, and the hold runs to December 31, 2031. The base case assumes a renewal at market rent.
  • Leverage is positive by 10 basis points. The going-in cap rate is 7.00% and the loan prices at 6.90%: the 10-year Treasury at 5.15% plus a 175 basis point spread. The loan constant on a 30-year schedule is 7.90%.
  • The base case returns 9.6% levered. Net operating income covers debt service 1.48x in Year 1, and the equity multiple is 1.53x over five years.
  • Two of four flags trip, and both concern the anchor. The lease expires inside the hold, and the $20.59 rent sits above the $20.50 market rent assumed. Across the sensitivity grid the levered IRR runs from 4.6% to 13.5%.

The price is an assumption the request set: the latest appraised value on file, which the filing dates August 27, 2019. The returns on this page describe a model at that price. They are no forecast for the property and no advice to buy or sell it.

Each input on the Assumptions sheet carries a citation, the word “Request” or the words “Analyst assumption” with a reason. The property, its three largest tenants, its income and its loan come from CMBS loan-level filings on SEC EDGAR. The anchor’s store count and sales come from Home Depot’s 10-K filings and its latest earnings call. Rent and occupancy benchmarks come from the 10-K filings of three shopping-center REITs. County demographics come from the Census Bureau’s American Community Survey, and the loan rate starts from the Daily Treasury Par Yield Curve.

Prompt to try

“I review shopping-center teasers and want a shopping center underwriting screen that tells me in half an hour whether to ask for the rent roll and book a visit, tested on a real property. From the CMBS loan-level filings, pick one anchored retail property in California, Oregon, Washington, Colorado or Utah whose largest tenant is a big-box store that is not a grocer (home improvement, off-price apparel, a discount department store or a warehouse club) run by a public company, and whose latest report names its three largest tenants with their square feet and lease expiration dates and gives net rentable area, occupancy, revenue, operating expenses, net operating income, appraised value and the loan terms. Use it as the subject and its latest appraised value as the price. Treat the largest tenant as the anchor and the rest of the leased area as shop space. Split reported revenue into an anchor rent and a shop rent per square foot, with a note on the split, and set market rent for each as an analyst assumption checked against the average base rent for anchors and shops that public shopping-center REITs report in their latest 10-K. Read the anchor's latest 10-K and earnings call for its store count, sales per square foot and closure plans, and say in two lines whether the store looks safe. Add county population, households and median household income from the Census ACS data. Price one loan at 60% loan-to-value off today's 10-year Treasury yield plus a spread. Build the screen itself as a one-sheet model: an inputs block (price, total area, anchor square feet and rent, shop square feet and rent, anchor and shop occupancy, expenses per square foot, one blended recovery rate, loan-to-value, rate); an anchor-versus-shop block; a five-year annual cash flow; a results panel with going-in cap rate, the anchor's share of total rent, shop rent against market, levered IRR and DSCR; and a 3-by-3 sensitivity grid of levered IRR to shop rent and shop occupancy. Flag an anchor lease that expires inside the hold, anchor rent above market, shop occupancy more than five points below what the REITs report, and negative leverage. Use the stored public data wherever it has the figure, and web search only for what it lacks. Put every input on an Assumptions sheet with one column that says where it came from: a cited source, or "analyst assumption" for a figure I would set myself, with the reason for the value you chose. Every output must be a live formula that traces back to the Assumptions sheet. Add a Sources sheet listing each data source, what it gave and its date. Deliver one Excel workbook and a short summary of the result, the flags, and what I would need from the seller to firm it up. Cite every sourced figure.”

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: a Home Depot-anchored center from a CMBS filing

Compound picked Towne Center East in Signal Hill, California, a 163,039 square foot center that secures loan 3 in the CSAIL 2019-C18 trust. The filing for the period ended October 13, 2026 names the three largest tenants with their square feet and lease dates, which is what the request required.

Every CMBS deal files a loan-level data file with the SEC each month on Form ABS-EE. Compound read the one filed on October 28, 2026 and put these facts on the Assumptions sheet, each cited to that filing:

ItemAs filed
Net rentable area163,039 SF
Physical occupancy99.11%
Largest tenantHome Depot, 103,423 SF, lease to January 31, 2029
Second largest tenantPetSmart, 26,550 SF, lease to March 31, 2029
Third largest tenantCostco Fuel Center (ground lease pad), 8,317 SF, lease to April 30, 2034
Revenue, annualized from January to June 2026$5,379,396
Operating expenses, annualized$1,106,852
Net operating income, annualized$4,272,544
Latest appraised value$61,000,000, dated August 27, 2019
Loan balance, interest only$38,550,000, maturing October 1, 2029
Annual debt service and coverage$1,217,511 and 3.51x

Source: CSAIL 2019-C18 Commercial Mortgage Trust, Form ABS-EE, Exhibit 102, filed October 28, 2026, as cited on Compound’s Sources sheet.

The filing reports six months of income, which Compound annualized because the reported debt service is an annual figure.

Three things in that table matter before any modeling. The appraisal is seven years old, so the price is a starting point and Compound’s answer calls it stale as a price. At $61,000,000 the center costs $374 a square foot (our arithmetic). The two largest tenants’ leases end two months apart in early 2029. The loan in place matures on October 1, 2029, eight months after the Home Depot lease.

For the anchor’s rent, the store’s sales and the appraiser’s market rents, Compound went to the trust’s 2019 term sheet, a free writing prospectus also on EDGAR, and cited it as a second source. The loan’s 3.115% interest rate comes from the same document.

Splitting reported revenue into anchor rent and shop rent

The filing gives one revenue figure for the whole center, so the split is a calculation with one sourced input and one assumption. The anchor rent is the $20.59 a square foot in the 2019 term sheet, recoveries are assumed at 80.0% of expenses, and shop rent is what remains.

Shopping_Center_Screen_Towne_Center_East.xlsx
C46fx=C24-C44-C45
BCDE
33REVENUE SPLIT: ANCHOR VS SHOP
34Anchor in-place base rent$20.59$/SFCSAIL 2019-C18 term sheet (FWP), Nov-2019 (Sources #2): Home Depot underwritten base rent; rent under the 2029 extension not disclosed, so held at this figure
35Blended expense recovery rate80.0%%Analyst assumption: 80%, in line with the 82% the 2019 underwriting shows (row below); NNN anchor plus shop CAM
362019 underwritten reimbursements$580,054$CSAIL 2019-C18 term sheet (FWP), Nov-2019 (Sources #2)
372019 underwritten expenses$709,773$CSAIL 2019-C18 term sheet (FWP), Nov-2019 (Sources #2)
382019 underwritten recovery ratio81.7%%Formula: reimbursements / expenses (check on the recovery rate)
39Anchor occupancy100.0%%Analyst assumption: Home Depot occupies its whole 103,423 SF box
40Shop square feet (NRA less anchor)59,616SFFormula: NRA less anchor SF
41Total leased square feet161,588SFFormula: NRA x physical occupancy
42Shop leased square feet58,165SFFormula: total leased less anchor leased
43Shop occupancy97.6%%Formula: shop leased / shop SF
44Expense recoveries in reported revenue$877,601$Formula: recovery rate x operating expenses x physical occupancy
45Anchor base rent$2,129,480$Formula: anchor rent x anchor SF x anchor occupancy
46Shop rent (residual, incl. other income)$2,372,316$Formula: reported revenue less recoveries less anchor rent. Note: the residual also holds Costco fuel pad and ATM ground rent and any Home Depot percentage rent (about $0.2m in 2019), so shop rent per SF is overstated by roughly $3-4/SF
47Shop rent$40.79$/SFFormula: shop rent / shop leased SF
48Operating expenses$6.79$/SFFormula: operating expenses / NRA
49Check: split rebuilds reported revenue (difference)$0$Formula: recoveries + anchor rent + shop rent less reported revenue; should be 0
ScreenAssumptionsSources
The revenue split block of Compound's Assumptions sheet, rows 33 to 49, unedited. Column E gives the source of each input or the formula behind each computed row.

Recoveries are 80.0% of the $1,106,852 of operating expenses, scaled by 99.11% occupancy: $877,601. Anchor base rent is $20.59 on 103,423 square feet: $2,129,480. The residual, $2,372,316, is assigned to the shops, and over 58,165 leased shop square feet it comes to $40.79 a square foot. The recovery rate is an analyst assumption with a check beside it. The 2019 underwriting in the term sheet shows reimbursements of $580,054 against expenses of $709,773, a ratio of 81.7%.

The request asked for a note on the split, and Compound wrote one on the residual row. The residual holds more than shop rent. It also holds the ground rent on the Costco fuel pad, the rent on an ATM pad and any percentage rent Home Depot pays. The term sheet passages Compound cited put the first two at $46,739 and $24,150 a year in 2019. The note estimates that the extra income overstates shop rent by roughly $3 to $4 a square foot.

Read the $40.79 as an upper estimate on these two inputs. It rises if recoveries run below 80.0% or the anchor pays less than $20.59. The true figure needs the rent roll.

Anchor vs shop: 63.4% of the area, 47.3% of the base rent

Home Depot occupies 63.4% of the center and pays 47.3% of base rent. The shop space is 97.6% occupied on this split and pays about twice the anchor’s rent per square foot.

Shopping_Center_Screen_Towne_Center_East.xlsx
C47fx=C46/$E$46
BCDE
39ANCHOR VS SHOP
40AnchorShopTotal
41Square feet103,42359,616163,039
42Share of NRA63.4%36.6%100.0%
43Occupancy100.0%97.6%99.1%
44Leased square feet103,42358,165161,588
45In-place rent ($/SF)$20.59$40.79$27.86
46Base rent, Year 1 ($)2,129,4802,372,3164,501,796
47Share of base rent47.3%52.7%100.0%
48Market rent ($/SF)$20.50$40.00
49In-place rent / market rent100.4%102.0%
50REIT average in-place ABR ($/SF)$14.39$33.07
51REIT average leased97.1%92.6%
52Lease expiration31-Jan-2029Various
ScreenAssumptionsSources
The anchor-versus-shop block of Compound's Screen sheet, rows 39 to 52, unedited. Every cell is a formula that reads the inputs block above it, and each input reads the Assumptions sheet.

The blended in-place rent for the center is $27.86 a square foot, a figure that describes neither kind of space.

Share of rentable area against share of base rent

Towne Center East. Shop base rent is the residual of reported revenue and includes pad rent and any percentage rent

Home Depot: share of rentable area63.4%Home Depot: share of base rent47.3%Shop space: share of rentable area36.6%Shop space: share of base rent52.7%

Compound's Screen sheet, rows 42 and 47, from the CSAIL 2019-C18 Form ABS-EE for the period ended October 13, 2026 and the trust's 2019 term sheet.

A big-box anchor that pays less than its share of the area is normal for the format. The number to carry forward is the 47.3%: one lease decision by one tenant controls almost half of the base rent.

One caution on the shop column is ours. The request defined shop space as everything that is not the anchor, and the workbook follows it. That puts PetSmart’s 26,550 square feet in the shop total, where it is 44.5% of the area (our arithmetic). A box that size is a junior anchor, and the term sheet passage Compound cited gives the appraiser’s 2019 market rent for junior anchor space as $24.00 a square foot, well under the inline figures. On a rent roll we would split the shop column into a junior anchor, the pads and the inline shops.

Market rent checked against shopping-center REIT 10-Ks

Compound set market rent at $20.50 a square foot for the anchor and $40.00 for the shops, both labeled analyst assumptions, and checked them against what three public REITs report. The subject’s rents sit above the REIT averages for both kinds of space, and the Assumptions sheet says why.

Rent per square foot: the subject against three shopping-center REITs

Dollars per square foot a year. Brixmor and Kite figures are in-place annualized base rent. Regency figures are rents on new and renewal leases signed in 2025

Anchor: subject in place (Home Depot)$20.59Anchor: market rent assumed$20.50Anchor: Regency, leases signed in 2025$15.73Anchor: Kite Realty, in place$15.29Anchor: Brixmor, 10,000 SF and up$13.49Shop: subject in place (residual)$40.79Shop: market rent assumed$40.00Shop: Regency, leases signed in 2025$41.67Shop: Kite Realty, in place$36.35Shop: Brixmor, under 10,000 SF$29.79

Compound's Assumptions sheet, rows 34, 47, 52, 53 and 57 to 64: fiscal 2025 Form 10-K of Brixmor Property Group, Kite Realty Group and Regency Centers, and the CSAIL 2019-C18 term sheet.

The anchor market rent of $20.50 is the appraiser’s 2019 figure for this property, held flat. The average in-place anchor rent at Brixmor and Kite is $14.39, so Home Depot’s $20.59 is $6.20 above it (our arithmetic). Compound’s reason, written beside the input: this is an infill Los Angeles County box whose sales ran 19% above the chain average.

The shop market rent of $40.00 sits inside the appraiser’s 2019 inline range of $28.00 to $45.00, and between Kite’s in-place shop rent of $36.35 and the $41.67 Regency signed on shop leases in 2025. The REIT average in-place shop rent is $33.07, $7.72 below the subject’s residual figure (our arithmetic).

Two of the four flags come from this comparison:

  • Anchor rent above market: FLAG. $20.59 against $20.50. The margin is nine cents a square foot (our arithmetic), and the market figure is seven years old. We read this flag as a prompt to get a current market rent for the box.
  • Shop occupancy more than five points below the REITs: OK. The shops are 97.6% occupied. The three REITs report 92.2%, 92.3% and 93.2% leased for shop space, an average of 92.6%, so the flag would trip below 87.6%.

Is the Home Depot store safe? The anchor’s 10-K and earnings call

Compound’s two-line view is that the store looks safe on credit and sales, and that the risk is the lease term. Home Depot is opening stores, discloses no closure program, and this store outsold the chain average in the last year the filings report.

Shopping_Center_Screen_Towne_Center_East.xlsx
BCDE
106ANCHOR CHECK: THE HOME DEPOT
107Store count, end of fiscal 2025 (1-Feb-2026)2,359storesHome Depot FY2025 10-K (Sources #3)
108Store count, end of Q2 fiscal 20262,364storesHome Depot Q2 FY2026 earnings call, 18-Aug-2026 (Sources #5)
109New stores planned in fiscal 202615storesHome Depot Q2 FY2026 earnings call (Sources #5): "approximately 15 new stores"; no closure program in the 10-K or the call
110California stores247storesHome Depot FY2025 10-K (Sources #3)
111Average store size (enclosed)104,000SFHome Depot FY2025 10-K (Sources #3)
112Chain sales per retail square foot, fiscal 2024$599.92$/SFHome Depot FY2024 10-K (Sources #4); the FY2025 10-K no longer reports this figure
113Subject store sales per square foot, 2018$532.00$/SFCSAIL 2019-C18 term sheet (FWP), Nov-2019 (Sources #2); 19% above the $447 chain average then
ScreenAssumptionsSources
The anchor check block of Compound's Assumptions sheet, rows 106 to 113, unedited. Each row cites the Home Depot filing or call it came from by its number on the Sources sheet.

Home Depot’s fiscal 2025 10-K reports 2,359 stores at year end, 247 of them in California, with an average store of 104,000 square feet. The subject store, at 103,423 square feet, is a standard box. On the second-quarter fiscal 2026 call, held August 18, 2026, the company gave a count of 2,364 stores and said it plans to open about 15 in the fiscal year.

Sales per square foot took one more step. Home Depot’s fiscal 2025 10-K does not report the figure, so Compound took it from the fiscal 2024 10-K, $599.92, and said so in the source column. The store-level figure is older: the 2019 term sheet reports $532 a square foot for this store in 2018, when the chain averaged $447.

The Screen sheet states the view in two lines, quoted here as Compound wrote them:

Anchor view: Home Depot is growing its fleet (about 15 openings planned for FY2026, no closure program disclosed), and this store sold $532/SF in 2018 against a $447 chain average, so the store looks safe.

The risk is term, not credit: the lease runs to 31-Jan-2029, inside the hold, with one five-year option left; rent at $20.59/SF is already at the appraiser’s market rent, so a renewal brings no mark-up.

A screen asks a narrow question about the anchor: is there a reason in its own filings to expect the store to close? Our grocery-anchored retail model goes further, testing the grocer’s rent against its reported sales and carrying percentage rent and co-tenancy through a monthly cash flow.

The five-year cash flow and the anchor lease expiration

Net operating income starts at the filed $4,272,544 and reaches $4,752,311 in Year 5. The anchor’s rent changes once, in the first year that ends after its lease expires, and one input decides whether it renews or goes dark.

Shopping_Center_Screen_Towne_Center_East.xlsx
D60fx=IF(D57=1,D58*$C$9*(1+$C$21)^(D$55-1),D58*$C$19*(1+$C$23)^(D$55-1))
BCDEFGHI
54FIVE-YEAR ANNUAL CASH FLOW
55YearYear 0Year 1Year 2Year 3Year 4Year 5Year 6
56Period endingDec-26Dec-27Dec-28Dec-29Dec-30Dec-31Dec-32
57Anchor on current lease (1 = yes)110000
58Anchor occupied SF103,423103,423103,423103,423103,423103,423
59Shop occupied SF58,16558,16558,16558,16558,16558,165
60Anchor base rent2,129,4802,129,4802,227,5052,283,1932,340,2732,398,779
61Shop base rent2,372,3162,443,4852,516,7902,592,2942,670,0632,750,164
62Expense recoveries877,601903,929931,047958,978987,7481,017,380
63Effective gross revenue ($)5,379,3965,476,8945,675,3425,834,4655,998,0836,166,324
64Operating expenses(1,106,852)(1,140,058)(1,174,259)(1,209,487)(1,245,772)(1,283,145)
65Net operating income ($)4,272,5444,336,8364,501,0834,624,9784,752,3114,883,179
66Reserves (TI/LC and capital)(163,039)(163,039)(163,039)(163,039)(163,039)
67Cash flow before debt service ($)4,109,5054,173,7974,338,0444,461,9394,589,272
68Debt service(2,892,572)(2,892,572)(2,892,572)(2,892,572)(2,892,572)
69Cash flow after debt service ($)1,216,9341,281,2261,445,4721,569,3671,696,700
71Purchase price and closing costs(61,610,000)
72Net loan proceeds36,234,000
73Sale proceeds, net (Year 6 NOI / exit cap)66,007,108
74Loan payoff(34,415,086)
75Unlevered cash flow ($)(61,610,000)4,109,5054,173,7974,338,0444,461,93970,596,380
76Levered cash flow ($)(25,376,000)1,216,9341,281,2261,445,4721,569,36733,288,722
77DSCR (NOI / debt service)1.48x1.50x1.56x1.60x1.64x
ScreenAssumptionsSources
The five-year cash flow on Compound's Screen sheet, rows 54 to 77, unedited. Year 0 is the close on December 31, 2026. Year 6 is projected only to value the sale at the end of Year 5. Negative values are in parentheses.

Year 1 reproduces the filing’s annualized revenue, expenses and net operating income. The growth rates are analyst assumptions with reasons: shop rent 3.0% a year, expenses 3.0%, market rent 2.5%, and none on the anchor’s rent within its term.

In Years 1 and 2 Home Depot pays $2,129,480. From Year 3 the formula in row 60 moves the anchor to market rent, grown at 2.5% a year from the $20.50 starting figure, and anchor rent becomes $2,227,505.

That step deserves a second look. It is 4.6% higher than the in-place rent, or about $21.54 a square foot (our arithmetic), while the two-line anchor view says a renewal brings no mark-up. Both follow from stated assumptions: market rent equals in-place rent today, and market rent grows. We would also run the renewal flat at $20.59, because the rent under the remaining option is set by a lease that public filings do not show.

The renewal itself is an input, cell C82 on the Assumptions sheet: 1 for a renewal at market, 0 for a dark box. Compound set it to 1 and gave the reason that Home Depot had two five-year options in 2019, has since extended to January 2029, and is opening stores. It also ran the other case and reported it in its answer. With the anchor dark from its expiration, coverage falls as low as 0.58x within the five years, the unlevered IRR is about negative 10.9%, and the equity is not returned.

After reserves of $1.00 a square foot and debt service, cash flow is $1,216,934 in Year 1 and $1,696,700 in Year 5.

The sale is priced on Year 6 net operating income of $4,883,179 at a 7.25% exit cap rate, 25 basis points above the going-in rate, less 2.0% selling costs. Net proceeds are $66,007,108. Before costs that is a sale value of about $67.4 million, which is 10.4% above the purchase price (our arithmetic). The return therefore depends on selling a 1992 center for more than its 2019 appraisal.

Sizing the loan: 60% of value at the 10-year Treasury plus a spread

The loan is $36,600,000 at 6.90%, the 10-year Treasury yield of 5.15% on November 13, 2026 plus a spread of 175 basis points. The loan-to-value ratio is the request’s, the Treasury yield is sourced, and the spread and the 30-year amortization are analyst assumptions.

The annual payment on that loan is $2,892,572, a loan constant of 7.90%. Net operating income covers it 1.48x in Year 1, rising to 1.64x in Year 5, and the debt yield is 11.7%. After a 1.0% loan fee and 1.00% closing costs, the equity at close is $25,376,000.

Year 1 net operating income against annual debt service

The new loan is 60% of the $61,000,000 price, amortizing over 30 years. The loan in place is interest only, as filed

Net operating income, Year 1$4,272,544Debt service on the new 6.90% loan$2,892,572Debt service on the 3.115% loan in place$1,217,511

Compound's Screen sheet, cells D65 and C84, and Assumptions sheet, cell C30: CSAIL 2019-C18 Form ABS-EE for the period ended October 13, 2026; Daily Treasury Par Yield Curve, November 13, 2026.

The filing reports $1,217,511 of annual debt service on the $38,550,000 interest-only loan in place, at the 3.115% rate in the term sheet, and coverage of 3.51x. The new loan is smaller and costs 2.4 times as much a year (our arithmetic). The filing gives October 1, 2029 as that loan’s maturity. Whether a buyer could assume it, and what prepaying it early would cost, is in the loan documents. The negative leverage flag reads OK, by 10 basis points: a 7.00% cap rate against a 6.90% rate. Compound’s answer adds the caveat we would add. The loan constant, which includes principal, is 7.90%, 90 basis points above the cap rate (our arithmetic). On cash paid out each year, the debt costs more than the property yields, and the levered return depends on the sale.

The results panel and the four flags

The screen returns a 9.6% levered IRR, an 8.2% unlevered IRR and a 1.53x equity multiple at the appraised value, with two of four flags raised. Both raised flags point at the Home Depot lease.

Shopping_Center_Screen_Towne_Center_East.xlsx
E103fx=IF(C103<=D103,"FLAG","OK")
BCDE
89RESULTS
90Going-in cap rate7.0%
91Anchor share of total base rent47.3%
92Shop rent vs market (in-place / market)102.0%
93Levered IRR9.6%
94DSCR, Year 11.48x
95Minimum DSCR, Years 1-51.48x
96Unlevered IRR8.2%
97Equity multiple1.53x
98Debt yield, Year 111.7%
99Going-in cap rate less loan rate (bps)10
101FLAGS
102SubjectTestResult
103Anchor lease expires inside the hold (expiry vs hold end)31-Jan-202931-Dec-2031FLAG
104Anchor rent above market ($/SF)$20.59$20.50FLAG
105Shop occupancy more than 5 pts below REITs97.6%87.6%OK
106Negative leverage (going-in cap vs loan rate)7.00%6.90%OK
107Flags raised2
ScreenAssumptionsSources
The results panel and the flags on Compound's Screen sheet, rows 89 to 107, unedited. The outlines around the two raised flags are ours.

Each flag is a formula with its test beside it, so you can see how close each one is. The rent flag trips on nine cents. The shop occupancy flag has ten points of room, and the leverage flag has 10 basis points.

Levered IRR sensitivity to shop rent and shop occupancy

Across the grid the levered IRR runs from 4.6% to 13.5%. A $4.00 change in shop rent moves the return about three points, and a five-point fall in shop occupancy lowers it about two.

Shopping_Center_Screen_Towne_Center_East.xlsx
D111fx=IRR(C117:H117)
BCDEF
109LEVERED IRR: SHOP RENT (ROWS) X SHOP OCCUPANCY (COLUMNS)
110Shop occupancy (across) / shop rent (down)Rent $/SF92.6%97.6%100.0%
111$36.794.6%6.4%7.3%
112$40.797.8%9.6%10.5%
113$44.7910.7%12.6%13.5%
ScreenAssumptionsSources
The sensitivity grid on Compound's Screen sheet, rows 109 to 113, with the heading in row 109 shortened. Each cell is the IRR of its own row of levered cash flows further down the sheet, so the grid recalculates when an input changes.

Levered IRR in the nine sensitivity cases

Shop rent steps of $4.00 a square foot and shop occupancy steps of five points, capped at 100.0%. The base case is highlighted

Shop rent $36.79, occupancy 92.6%4.6%Shop rent $36.79, occupancy 97.6%6.4%Shop rent $36.79, occupancy 100.0%7.3%Shop rent $40.79, occupancy 92.6%7.8%Shop rent $40.79, occupancy 97.6%9.6%Shop rent $40.79, occupancy 100.0%10.5%Shop rent $44.79, occupancy 92.6%10.7%Shop rent $44.79, occupancy 97.6%12.6%Shop rent $44.79, occupancy 100.0%13.5%

Compound's Screen sheet, cells D111 to F113.

The low-rent row is the one to read. If the pad rent and percentage rent in the residual mean true shop rent is closer to $36.79 than $40.79, the return at current occupancy is 6.4%, below the 6.90% cost of the debt. The rent roll decides which row of the grid the deal is on.

What public data cannot tell you about this center

Public filings name three tenants, give one revenue figure and carry an appraisal from 2019. The rest comes from the seller, and Compound’s answer ends with the list.

  • The rent roll and sales. The filing names the three largest tenants and gives no rent for any of them. You would ask for the full rent roll with Home Depot’s rent under its current extension, the rent under its last option and its notice date, and for Home Depot and PetSmart sales reports with the percentage rent history. The term sheet passage Compound cited describes a trigger event under the loan if Home Depot does not exercise an extension option at least 12 months before its lease expires.
  • Income by line. Reported revenue is one number. Trailing twelve months and three years of operating statements, with recoveries separated from pad rent and other income, would replace the residual.
  • Recoveries. The 80.0% rate is an assumption. The reconciliations for common area costs, taxes and insurance would replace it.
  • Value. The $61,000,000 is a 2019 appraisal. A current appraisal or a broker’s opinion of value would say what the price should be.
  • The trade area. County figures describe a region of 9,694,934 people. Trade-area population, traffic counts and competing centers come from a site visit and a market analysis.

Our view: ask for the rent roll, and price the renewal first

We agree with the answer Compound gave: ask for the rent roll and book the visit, and settle the Home Depot renewal before anything else. On public data the center clears its debt service with room, and every material open question sits in one lease.

The case for the next step is on the sheet. The center is 99.1% occupied, the anchor is opening stores, and income covers a new loan at today’s rates 1.48x.

The other side is on the sheet too. The base case assumes a renewal at a rent slightly above today’s. With the anchor dark the equity is not returned. Leverage is positive by 10 basis points on the rate and negative on the constant. The shop rent is a residual that includes income the shops do not pay.

Three documents would change the view. Home Depot’s option terms would replace the renewal assumption with a contract. The rent roll would replace the $40.79 residual with actual shop rents and put PetSmart, whose lease ends two months after the anchor’s, on its own line. A current valuation would replace a price set in 2019.

A screen stops there by design. Once the seller’s documents arrive, the work moves to a rent roll analysis and due diligence on the documents, and a center that needs a new anchor or new pads calls for a retail value-add pro forma with a monthly leasing plan.

Shopping center underwriting screen (Excel)Compound’s workbook from this run: the one-sheet Screen with inputs, the anchor and shop block, a five-year cash flow, the loan, results, four flags and the 3-by-3 levered IRR grid; the Assumptions sheet with a source or a reason for every input; and the Sources list.Download · Free

FAQ

How do you underwrite a shopping center?

Start with who pays the rent. Split income between the anchor and the shop space, compare each rent with market, and check the anchor’s lease expiration against your hold. Then run a cash flow with recoveries, size the debt and test coverage. In this screen the anchor pays 47.3% of base rent and its lease ends in year three.

What happens to the underwriting when the anchor lease expires during the hold?

The model needs an explicit assumption: a renewal, and at what rent, or a dark box. With a renewal at market rent this screen shows a 9.6% levered IRR. Compound’s answer reports that with the anchor dark, coverage falls as low as 0.58x and the equity is not returned.

How do you check an anchor tenant using public filings?

Read the tenant’s 10-K and latest earnings call for store count, openings, closure plans and sales per square foot. Home Depot reported 2,364 stores and about 15 planned openings, and the CMBS term sheet gives this store’s 2018 sales as $532 a square foot.

What is negative leverage in a shopping center acquisition?

Negative leverage means the debt costs more than the property yields at the purchase price. Test it twice: against the interest rate and against the loan constant, which includes principal. In this screen the 7.00% cap rate is above the 6.90% rate and below the 7.90% constant.

Can you underwrite a shopping center from public data alone?

You can screen one. CMBS loan-level filings give area, occupancy, income, the largest tenants and the loan, and tenant and REIT 10-K filings give the anchor’s health and rent benchmarks. Compound cites each figure to its filing and labels the rest as analyst assumptions. Pricing the deal takes the seller’s rent roll and leases.

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