Bought at its appraised value of $18,475,000, the grocery-anchored center in this model shows a 14.9% levered IRR over a 10-year hold. If the grocer leaves when its lease ends in month 95 of that hold, the same model shows 4.7%, and at the low point net operating income covers 0.54x of debt service.
You work in acquisitions or asset management at an institutional real estate investor, and a grocery-anchored center has reached your desk. The grocer pays the lowest rent per square foot in the center and brings the traffic that the shop tenants pay for. A grocery-anchored retail model has to show what the anchor pays and what the rest of the rent roll loses if the anchor closes. We asked Compound to build one on a real property from public data. It ran on November 15, 2026 and returned one Excel workbook and a summary.
The price is an assumption that the request set: the latest appraised value in the filing. The returns are the output of that price and of the other assumptions in the workbook. They are neither a forecast for this property nor advice to buy or sell it.
What the workbook shows:
- The base case returns 14.9% levered and 11.1% unlevered. The levered equity multiple is 2.53x.
- The anchor-goes-dark case returns 4.7% levered. The equity multiple is 1.27x and the minimum DSCR is 0.54x.
- The grocer occupies 47.9% of the area and pays 29.9% of the base rent. The filing names Kroger as the largest tenant, on a lease that expires November 30, 2034.
- The grocer’s rent is 1.15% of its estimated sales. With expense recoveries its occupancy cost is 1.66%.
- Leverage is positive. The going-in cap rate is 8.88%, against a 7.00% fixed rate on new debt.
Each input on the Assumptions sheet carries a citation 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 grocer’s sales come from its 10-K, and leasing benchmarks from the earnings calls of three shopping-center REITs. County demographics come from the Census Bureau and retail employment from the Bureau of Labor Statistics. Debt is priced off the Daily Treasury Par Yield Curve and the SOFR forward curve. The Georgia assessment ratio and the county millage rate came from web pages of the Georgia Department of Revenue and the Gwinnett County Tax Commissioner.
“I am underwriting the acquisition of a grocery-anchored shopping center and want an anchored retail model built on a real property. From the CMBS loan-level filings, pick one U.S. anchored retail property whose largest tenant is a grocer, 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 purchase price. Build the tenant table from the named tenants as filed, classed as anchor, junior anchor, shop or pad, with the remaining leased area in clearly labelled "other shop tenants" rows and vacant space in its own row. Set in-place rent from reported revenue, with a lower rent per square foot for the anchor than for shop space and a note on the split you chose. If the grocer is a public company, take its sales per square foot from its latest 10-K to test the anchor's rent-to-sales ratio and to model percentage rent above a natural breakpoint. Set market rents, recovery type per tenant class, renewal probabilities, co-tenancy rent relief and leasing costs as analyst assumptions with a note on each, checked against what public shopping-center REITs report on leasing spreads and occupancy in their latest 10-K or earnings call. Add the trade area: population, households and median household income for the county from the stored Census data, and retail employment from BLS. Price new acquisition debt off today's 10-year Treasury yield and the SOFR forward curve, and show it next to the loan the property has now. Build: expense recoveries by tenant class; percentage rent; a base case and an anchor-goes-dark case where the grocer leaves at its lease expiration and co-tenancy relief applies to shop tenants; a 10-year cash flow, monthly rolled up to annual; property tax reassessed at the purchase price; the debt schedule with DSCR and debt yield by year; net operating income by tenant class; levered and unlevered IRR, equity multiple and cash-on-cash; and a sensitivity table of levered IRR to shop occupancy and exit cap rate. Flag an anchor lease that expires inside the hold, the anchor's share of base rent, 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.”
That is the request as we sent it, without its closing line, which asks that no name or email be put in the workbook.
Which property is the subject, and where does the price come from?
Compound chose Singleton Square in Norcross, Georgia, a 130,512 square foot center that a CMBS filing reports as 94.75% occupied with Kroger as its largest tenant. The purchase price of $18,475,000 is the latest appraised value in that filing, because the request said to use it.
The Assumptions sheet cites the property rows to the BBCMS Mortgage Trust 2025-C32 Form ABS-EE, Exhibit 102, loan 26, filed October 29, 2026. The appraised value is from an appraisal dated October 16, 2024, so the price is two years old as a market reading. At $141.56 per square foot it is a starting point that an investor would replace with a bid.
The filing reports revenue of $2,350,991, operating expenses of $689,128 and net operating income of $1,661,863 for January 1 to June 30, 2026. Compound read them as annualized and gave the reason: the filing’s 1.9782x DSCR equals that net operating income divided by annual debt service of $840,076. On the price, the reported income is a 9.00% cap rate. The model’s own year-1 net operating income is $1,641,353, an 8.88% cap rate, after the tax reassessment described below.
Read that yield with the appraisal’s date in mind. The workbook’s note on the exit cap rate says the 2024 appraisal implies about 7.2% on the net operating income at securitization. The income the filing reports now is higher than the income that appraisal valued, so the going-in cap rate sets newer income against an older value. A seller who priced today’s income at the appraisal’s yield would ask more than $18,475,000, and the base-case return would be lower.
| B | C | D | |
|---|---|---|---|
| 5 | SUBJECT PROPERTY | ||
| 6 | Property | Singleton Square | |
| 7 | Address | 6000-6050 Singleton Road, Norcross, GA 30093 (Gwinnett County) | |
| 8 | Net rentable area (SF) | 130,512 | |
| 9 | Physical occupancy (reported) | 94.8% | |
| 10 | Grocery anchor | Kroger, 62,580 SF, lease expires 11/30/2034 | |
| 11 | Purchase price = latest appraised value ($) | 18,475,000 | |
| 12 | Price per SF ($) | 141.56 | |
| 13 | Reported NOI, most recent ($) | 1,661,863 | |
| 14 | Underwritten year-1 NOI ($) | 1,641,353 | |
| 15 | Going-in cap rate, underwritten NOI | 8.88% | |
| 16 | Going-in cap rate, reported NOI | 9.00% | |
| 18 | RETURNS BY CASE | Base | Anchor goes dark |
| 19 | Levered IRR | 14.9% | 4.7% |
| 20 | Unlevered IRR | 11.1% | 6.5% |
| 21 | Levered equity multiple (x) | 2.53x | 1.27x |
| 22 | Average cash-on-cash, years 1-10 | 9.4% | 7.2% |
| 23 | Minimum DSCR over hold (x) | 2.09x | 0.54x |
| 24 | Forward 12-month NOI at exit ($) | 2,417,427 | 1,403,610 |
| 25 | Year-1 cash-on-cash (selected case) | 10.7% | |
| 26 | Levered profit (selected case) ($) | 15,156,639 |
How is the rent roll built when the filing names three tenants?
The filing gives square feet and expiration dates for Kroger, ATL Fitness and AL Noor Banquet, and no rent per tenant. Compound classed the three, put the rest of the leased area in four rows labelled “Other shop tenants”, gave vacant space its own row, and solved the shop rent so that rebuilt revenue equals reported revenue.
The class rule is on the Assumptions sheet: a grocer or any tenant of 40,000 square feet and over is an anchor, and a tenant of 10,000 to 39,999 square feet is a junior anchor. That makes Kroger the anchor and the other two named tenants junior anchors. The filing names no pad tenant, so the pad class carries assumptions and no income.
Compound split the unnamed leased area evenly into rows A to D, at about 9,564 square feet each, and staggered their expirations from 2027 to 2031. Both choices are marked as analyst assumptions, with a note that the seller’s rent roll is needed. The vacant row holds 6,852 square feet and leases up over 12 months.
In-place rent works from the top down. The anchor pays $8.50 per square foot and the junior anchors $14.00, both analyst assumptions. Recoveries and percentage rent are computed from the reported expenses and the grocer’s sales. Shop rent is the residual: $24.30 per square foot makes the parts add up to the reported $2,350,991, and the check row shows zero.
| B | C | D | E | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|
| 6 | Tenant | Class | SF | Lease expiration | In-place rent ($/SF) | Base rent ($) | % of base rent | Pro-rata share | Recoveries ($) | % rent ($) |
| 7 | Kroger | Anchor | 62,580 | 11/30/2034 | 8.50 | 531,930 | 29.9% | 47.9% | 231,965 | 44,814 |
| 8 | ATL Fitness | Junior anchor | 12,826 | 06/30/2035 | 14.00 | 179,564 | 10.1% | 9.8% | 58,920 | - |
| 9 | AL Noor Banquet | Junior anchor | 10,000 | 12/31/2032 | 14.00 | 140,000 | 7.9% | 7.7% | 45,938 | - |
| 10 | Other shop tenants A | Shop | 9,564 | 12/31/2027 | 24.30 | 232,351 | 13.0% | 7.3% | 47,114 | - |
| 11 | Other shop tenants B | Shop | 9,564 | 12/31/2028 | 24.30 | 232,351 | 13.0% | 7.3% | 47,114 | - |
| 12 | Other shop tenants C | Shop | 9,564 | 12/31/2029 | 24.30 | 232,351 | 13.0% | 7.3% | 47,114 | - |
| 13 | Other shop tenants D | Shop | 9,564 | 06/30/2031 | 24.30 | 232,351 | 13.0% | 7.3% | 47,114 | - |
| 14 | Vacant | Shop | 6,852 | 12/31/2026 | 0.00 | - | 0.0% | 5.3% | - | - |
| 15 | Total | 130,512 | 14.40 | 1,780,900 | 100.0% | 100.0% | 525,277 | 44,814 | ||
| 17 | IN-PLACE RENT SOLVE (TIES TO CMBS REVENUE) | |||||||||
| 18 | Solved shop in-place rent ($/SF/yr) | 24.30 | ||||||||
| 19 | Shop market rent, 2027 ($/SF/yr) | 26.50 | ||||||||
| 20 | Shop mark-to-market (market / in-place - 1) | 9.1% | ||||||||
| 21 | Revenue rebuilt: base rent + recoveries + % rent + other income ($) | 2,350,991 | ||||||||
| 22 | Revenue reported in CMBS filing ($) | 2,350,991 | ||||||||
| 23 | Check: rebuilt less reported ($) | - | ||||||||
| 24 | Anchor share of in-place base rent | 29.9% | ||||||||
| 25 | Anchor in-place rent ($/SF) / shop in-place rent ($/SF) | 35.0% | ||||||||
| 26 | Kroger chain sales per SF, FY2025 ($) | 737.29 | ||||||||
| 27 | Kroger base rent / sales (rent-to-sales) | 1.15% | ||||||||
| 28 | Kroger occupancy cost / sales (base rent + recoveries) | 1.66% | ||||||||
| 29 | Kroger natural breakpoint ($/SF of sales) | 680.00 |
Kroger has 47.9% of the area and 29.9% of the in-place base rent of $1,780,900. The workbook sets a concentration threshold of 25% of base rent, as an analyst assumption, and the Summary prints the result: “FLAG: Kroger is 30% of base rent and 30% of year-1 NOI”.
Share of in-place base rent by tenant row
Rent Roll sheet, column I. Named tenants as the CMBS filing names them; shop rows are an analyst split of the unnamed leased area.
Compound workbook, Rent Roll sheet. Anchor and junior anchor rents are analyst assumptions; shop rent is solved from reported revenue.
Does the grocer’s rent hold up against its sales?
On chain-average sales, Kroger’s base rent at this store is 1.15% of sales and its occupancy cost with recoveries is 1.66%. Rent is a small cost to a store selling at that rate.
The filing has no store sales, so Compound went to the grocer’s 10-K, as the request asked. The Kroger Co. Form 10-K for fiscal 2025, filed March 31, 2026, reports $132,712M of sales to retail customers without fuel and 180 million square feet of supermarket space. The workbook divides one by the other for chain sales of $737.29 per square foot. It then assumes this store sells at 100% of the chain average, an analyst assumption that the seller’s sales report replaces.
At that rate the store’s estimated sales are $46,139,539 a year. Base rent of $531,930 is 1.15% of that, and base rent plus $231,965 of recoveries is 1.66%.
Percentage rent uses the same figure. Compound assumed a rate of 1.25% of sales and a natural breakpoint, which is base rent divided by the rate: $42,554,400 of sales, or $680 per square foot. At fiscal 2025 sales that produces $44,814 a year. The cash flow grows store sales at 2.5% a year, set below the 2.9% identical sales growth in the 10-K, while the anchor’s rent stays flat. Percentage rent rises from $74,012 in year 1 to $172,649 in year 8, the year the lease ends.
By our arithmetic, a store at 80% of the chain average would sit below the $680 breakpoint at fiscal 2025 sales and pay no percentage rent.
Who pays the operating expenses?
The model has four recovery types, one per tenant class. The anchor reimburses taxes and insurance in full and 60% of its share of common area maintenance, while shop tenants pay their full share plus a 15% administrative fee.
The filing reports one operating expense total. Compound split the $689,128 into real estate tax, insurance, common area maintenance, management and non-recoverable expenses at 35%, 10%, 42%, 8% and 5%, as an analyst assumption. Each class then pays its pro-rata share of each recoverable line at the percentage in its column.
| B | C | D | E | F | |
|---|---|---|---|---|---|
| 44 | Assumption | Anchor | Junior anchor | Shop | Pad |
| 45 | Recovery type | Mod. NNN: tax, ins.; CAM 60% | NNN pro-rata | NNN + 15% CAM admin | Tax & ins.; own CAM |
| 48 | CAM recovery (% of pro-rata share) | 60% | 100% | 100% | 0% |
| 49 | CAM administrative fee | 0% | 0% | 15% | 0% |
| 50 | Market base rent, 2027 ($/SF/yr) | 11.00 | 15.50 | 26.50 | 35.00 |
| 52 | Contract rent escalation (per year) | 0.0% | 2.0% | 3.0% | 2.0% |
| 53 | Renewal probability | 85% | 75% | 75% | 80% |
| 54 | Renewal rent (% of market) | 80% | 95% | 100% | 100% |
| 55 | Downtime if not renewed (months) | 18 | 12 | 9 | 9 |
| 59 | Tenant improvements, new lease ($/SF) | 30.00 | 25.00 | 35.00 | 0.00 |
| 60 | Tenant improvements, renewal ($/SF) | 5.00 | 5.00 | 5.00 | 0.00 |
| 61 | Leasing commission, new (% of lease-term base rent) | 6.0% | 6.0% | 6.0% | 6.0% |
| 63 | Percentage rent rate (% of sales) | 1.25% | 0.00% | 0.00% | 0.00% |
| 64 | Co-tenancy relief applies (1 = yes) | 0 | 0 | 1 | 0 |
In place, the tenants reimburse $525,277 of expenses, and Kroger pays $231,965 of that. The owner keeps the management fee, the non-recoverable line, the 40% of the anchor’s maintenance share that the anchor does not pay, and every share that falls on vacant space.
Property tax changes at a sale, and the request asked for tax reassessed at the purchase price. Compound took Georgia’s assessment ratio of 40% of fair market value and the 34.86 mill rate for unincorporated Gwinnett County from the web pages named on the Sources sheet. Year-1 real estate tax is $257,615 and total operating expenses are $746,465, against the $689,128 the filing reports.
What do the leasing assumptions rest on?
Market rent, renewal probability, downtime and leasing costs are analyst assumptions, each with a note. Compound checked the shop assumptions against the latest earnings calls of three shopping-center REITs and set shop occupancy and retention below theirs, citing the center’s 1993 vintage.
The shop market rent for 2027 is $26.50 per square foot, 9.1% above the solved in-place rent. The benchmark rows on the same sheet give renewal spreads of 15% at Regency Centers, 7.3% at Kimco Realty and 25.2% at Phillips Edison. Shop renewal probability is 75%, below the 84% retention Regency reported and the 90% Phillips Edison reported.
The anchor’s column differs in every row. Kroger renews with 85% probability at 80% of market rent, which is $11.00 per square foot in 2027. If it does not renew, the box is empty for 18 months. Rollover is probability-weighted in the monthly cash flow, so the base case already carries the 15% chance that the anchor leaves.
Shop occupancy: two REITs and the model's assumption
Share of small-shop space occupied. REIT figures are as stated on third-quarter 2026 earnings calls.
Compound workbook, Assumptions sheet: Regency Centers call of November 6, 2026 and Kimco Realty call of October 29, 2026; the 92.0% is an analyst assumption.
The model holds shop occupancy to 92.0% through a general vacancy allowance.
What does the 10-year cash flow show in the base case?
Net operating income grows from $1,641,353 in year 1 to $2,262,867 in year 10, with dips in the years when large leases roll. Year 9 has negative cash flow after debt service, because the anchor’s lease and a junior anchor’s lease end seven months apart.
The Monthly CF sheet runs 132 months: the 120-month hold and one more year, which sets the income that the exit cap rate is applied to.
| B | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | Hold year # | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 6 | Year ending | FY2027 | FY2028 | FY2029 | FY2030 | FY2031 | FY2032 | FY2033 | FY2034 | FY2035 | FY2036 |
| 10 | Base rent | 1,780,900 | 1,890,144 | 1,996,850 | 2,059,165 | 2,112,069 | 2,260,462 | 2,081,899 | 2,227,669 | 2,244,677 | 2,587,677 |
| 11 | Percentage rent | 74,012 | 89,160 | 104,688 | 120,603 | 136,916 | 153,638 | 170,777 | 172,649 | 61,542 | 28,018 |
| 13 | Expense recoveries | 550,391 | 592,957 | 608,886 | 625,271 | 642,125 | 668,855 | 656,271 | 671,264 | 645,353 | 733,948 |
| 17 | Effective gross revenue ($) | 2,387,818 | 2,471,560 | 2,606,341 | 2,697,829 | 2,780,766 | 2,950,129 | 2,812,290 | 2,951,835 | 2,828,951 | 3,220,757 |
| 25 | Total operating expenses ($) | (746,465) | (767,423) | (790,686) | (812,967) | (835,498) | (861,621) | (877,576) | (903,840) | (921,538) | (957,890) |
| 27 | Net operating income ($) | 1,641,353 | 1,704,137 | 1,815,654 | 1,884,862 | 1,945,267 | 2,088,508 | 1,934,714 | 2,047,995 | 1,907,413 | 2,262,867 |
| 32 | Tenant improvements | - | (359,364) | (119,544) | (119,544) | (119,544) | - | (305,194) | (119,544) | (795,379) | (119,544) |
| 33 | Leasing commissions | - | (105,052) | (50,413) | (51,925) | (53,483) | - | (164,194) | (58,442) | (400,796) | (62,001) |
| 34 | Cash flow before debt service ($) | 1,615,250 | 1,212,836 | 1,618,006 | 1,684,870 | 1,742,862 | 2,058,248 | 1,434,159 | 1,837,907 | 678,173 | 2,047,265 |
| 42 | Debt service ($) | 786,727 | 788,883 | 786,727 | 895,696 | 895,581 | 897,567 | 895,327 | 895,186 | 895,035 | 896,869 |
| 44 | Levered cash flow ($) | 828,523 | 423,953 | 831,279 | 789,175 | 847,281 | 1,160,681 | 538,831 | 942,720 | (216,863) | 16,789,033 |
| 47 | DSCR (NOI / debt service) | 2.09x | 2.16x | 2.31x | 2.10x | 2.17x | 2.33x | 2.16x | 2.29x | 2.13x | 2.52x |
| 49 | Cash-on-cash (levered cash flow before sale / equity) | 10.7% | 5.5% | 10.7% | 10.1% | 10.9% | 14.9% | 6.9% | 12.1% | (2.8%) | 14.8% |
| 51 | NOI BY TENANT CLASS | ||||||||||
| 52 | Anchor | 485,856 | 497,325 | 508,248 | 520,216 | 532,653 | 543,973 | 560,789 | 489,410 | 406,892 | 593,192 |
| 53 | Junior anchor | 295,521 | 301,143 | 306,573 | 312,392 | 318,388 | 323,983 | 264,236 | 357,473 | 262,335 | 399,620 |
| 54 | Shop | 859,976 | 905,669 | 1,000,833 | 1,052,254 | 1,094,226 | 1,220,552 | 1,109,689 | 1,201,112 | 1,238,186 | 1,270,055 |
Year 9 is 2035. The Kroger lease ends on November 30, 2034 and the ATL Fitness lease on June 30, 2035. Even with an 85% renewal probability on the anchor, weighted downtime and free rent take net operating income to $1,907,413. Tenant improvements of $795,379 and leasing commissions of $400,796 take levered cash flow to a negative $216,863.
Net operating income by hold year, base case
Annual CF sheet, row 27. The purchase closes December 31, 2026, so year 1 is calendar 2027.
Compound workbook, Annual CF sheet. Projection from the assumptions on the Assumptions sheet; the price is the appraised value in the CMBS filing.
The bottom of the excerpt is net operating income by tenant class, with expenses allocated by area. In year 1 the anchor produces $485,856, the junior anchors $295,521 and the shops $859,976. The anchor’s share is 29.6%.
The sale is at a 9.25% cap rate on the next 12 months of net operating income, $2,417,427, for a gross price of $26,134,342. That forward year has no large lease expiring, so its income is above year 10’s $2,262,867. The exit cap rate is an analyst assumption. Its note sets it about 35 bp above a going-in cap rate rounded to 8.9%, for a 1993 center with a grocer lease expiring in 2034.
What happens if the anchor goes dark?
In the anchor-goes-dark case the levered IRR is 4.7%, the equity multiple is 1.27x, and net operating income does not cover debt service after the grocer leaves. The gap to the base case of 14.9% is about ten points of IRR.
The case is one switch on the Assumptions sheet. Set to 2, it sends Kroger out at its November 30, 2034 expiration with no renewal. The box stays empty for 36 months, and shop tenants get co-tenancy relief: their base rent drops to 50% for 12 months. All three inputs are analyst assumptions, because the actual clauses are in leases that a public filing does not contain.
IRR by case
Levered and unlevered IRR over the 120-month hold, at a purchase price equal to the appraised value.
Compound workbook, Summary sheet, rows 19 and 20. Both cases are projections from analyst assumptions.
Income falls first. Compound’s answer puts net operating income in the dark case at $0.48M in 2035, against $1,907,413 in the base case. The sale price falls second. The hold ends in month 120, and the box that emptied after month 95 is still inside its 36 months of downtime. The 9.25% exit cap rate applies to $1,403,610 of forward income in place of $2,417,427.
The 4.7% is one downside case and it is not the floor. Shop tenants return to full rent after 12 months while the box stays empty for 24 more. No shop tenant leaves, although the workbook’s note says relief typically runs 12 months before a termination right. The cost of re-leasing the box falls after the 120-month hold ends, so it is outside the return. The model also keeps the loan current through the months when income does not cover debt service.
This page models a stabilized center where the anchor is a risk to price. Retail value-add pro forma starts from a center that needs a new anchor and a leasing plan. Shopping center underwriting is the one-sheet screen you would run before either.
How does new debt compare with the loan in place?
New fixed-rate debt is $11,085,000 at 7.00%, with a 2.09x DSCR and a 14.81% debt yield in year 1. The loan the property has now is larger and at a lower rate, and the model assumes the seller defeases it.
The fixed rate is built from two cells. The 10-year Treasury par yield closed at 5.15% on November 13, 2026, a sourced figure. The 185 bp spread is an analyst assumption. The floating alternative resets monthly at 1-month forward SOFR plus 260 bp, and its year-1 average rate is 7.12%. The loan amount is the lesser of 60% of the price and year-1 net operating income divided by a 9% minimum debt yield. The second test would allow $18,237,252, so the loan-to-value limit sets the loan, and equity is $7,777,975.
| B | D | E | F | |
|---|---|---|---|---|
| 71 | LOAN COMPARISON (YEAR 1) | Existing loan | New fixed | New floating |
| 72 | Loan amount ($) | 12,400,000 | 11,085,000 | 11,085,000 |
| 73 | Interest rate, year-1 average | 6.68% | 7.00% | 7.12% |
| 74 | Year-1 debt service ($) | 840,076 | 786,727 | 800,419 |
| 75 | DSCR on underwritten year-1 NOI (x) | 1.95x | 2.09x | 2.05x |
| 76 | Debt yield on year-1 NOI | 13.24% | 14.81% | 14.81% |
| 77 | Loan-to-value at purchase price | 67.12% | 60.00% | 60.00% |
| 78 | Debt constant (debt service / loan) | 6.77% | 7.10% | 7.22% |
| 79 | Leverage spread: going-in cap less debt constant | 2.11% | 1.79% | 1.66% |
| 80 | Maturity | 12/06/2034 | 12/31/2036 | 12/31/2036 |
The filing reports the existing loan at $12,400,000 and 6.68% fixed, maturing December 6, 2034, six days after the Kroger lease ends. It also gives a prepayment lockout to June 5, 2034, with defeasance allowed from March 6, 2027. Compound flagged the maturity and stated its treatment on the Summary sheet: the model assumes defeasance by the seller and new debt.
The request asked for a negative leverage flag. The Summary reads “No negative leverage: going-in cap 8.88% vs loan rate 7.00%”. Compound added a second test: once the fixed loan starts to amortize after 36 months, its debt constant is 8.08%, and the going-in cap rate is still above it.
How much do shop occupancy and exit cap rate move the return?
Across seven shop occupancy levels and seven exit cap rates, the base-case levered IRR runs from 12.7% to 17.1%. Every cell in the table is above the 4.7% of the anchor-goes-dark case.
| B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|
| 56 | Levered IRR (corner) / exit cap | 14.9% | 8.50% | 8.75% | 9.00% | 9.25% | 9.50% | 9.75% | 10.00% |
| 57 | Shop occupancy | 86.0% | 15.0% | 14.6% | 14.2% | 13.8% | 13.4% | 13.0% | 12.7% |
| 58 | Shop occupancy | 88.0% | 15.3% | 14.9% | 14.6% | 14.2% | 13.8% | 13.4% | 13.1% |
| 59 | Shop occupancy | 90.0% | 15.7% | 15.3% | 14.9% | 14.6% | 14.2% | 13.8% | 13.5% |
| 60 | Shop occupancy | 92.0% | 16.1% | 15.7% | 15.3% | 14.9% | 14.6% | 14.2% | 13.9% |
| 61 | Shop occupancy | 94.0% | 16.4% | 16.1% | 15.7% | 15.3% | 15.0% | 14.6% | 14.3% |
| 62 | Shop occupancy | 96.0% | 16.8% | 16.4% | 16.0% | 15.7% | 15.3% | 15.0% | 14.6% |
| 63 | Shop occupancy | 98.0% | 17.1% | 16.8% | 16.4% | 16.0% | 15.7% | 15.4% | 15.0% |
Read along the 92.0% row, the base assumption: at an 8.50% exit cap rate the IRR is 16.1%, and at 10.00% it is 13.9%. Read down the 9.25% column: 86.0% shop occupancy gives 13.8% and 98.0% gives 16.0%. Each variable moves the return by about two points across its range. One lease event moves it by ten.
What does the trade area add?
Gwinnett County has 1,018,099 people and a median household income of $94,643, and its population grew 1.4% in a year. Private retail employment in the county fell 4.2% over the year to March 2026.
Population and the 337,825 households are American Community Survey 1-year estimates for 2025. Retail employment is from the Bureau of Labor Statistics Quarterly Census of Employment and Wages: 46,891 jobs in March 2026 against 48,941 a year earlier.
The model does not use county figures as inputs. They are a check on the growth assumptions. A growing county with falling retail employment is a reason to look at which retailers are shrinking before you accept 3% market rent growth. Real estate market analysis goes further on market data without a tenant model.
What can public data not tell you about this center?
Public filings give the property totals, three tenants and the loan. Rent per tenant, the lease clauses and the store’s sales are in documents the seller holds, and the model marks each place where one of them goes.
Compound’s answer ends with the list of what to get from the seller. Each item replaces a block of analyst assumptions:
- A certified rent roll. It replaces the four “Other shop tenants” rows, the assumed anchor and junior anchor rents and the solved shop rent.
- The Kroger lease and store sales reports. They replace the chain-average sales assumption, the 1.25% percentage-rent rate and the renewal terms, and show any go-dark rights and exclusives.
- The shop leases’ co-tenancy clauses. They replace the 50% relief for 12 months in the dark case.
- Operating statements. Trailing 12-month and three-year statements with common area maintenance reconciliations replace the expense split.
- Tax bills by parcel and the insurance schedule. They confirm the tax district behind the 34.86 mill rate.
Our view
The question a grocery-anchored retail model must answer is what the deal returns if the anchor’s lease ends inside the hold and the tenant leaves. On this center the answer is ten points of levered IRR, and the model that shows it was built from public filings before any seller document arrived.
The base case alone reads as a comfortable deal. The cap rate is above the loan rate, the DSCR does not fall below 2.09x in any year, and the grocer’s rent is a small share of its sales. The flags point the other way: the anchor lease ends in month 95, and the existing loan matures six days later.
Three things in this workbook are worth copying. The first is the rent solve: when a filing gives only total revenue, fix the anchor rents as labelled assumptions and solve the shop rent so the model ties to the reported figure. The second is the data table that puts the dark case beside the base case on the first page. The third is the source column, which separates the sourced property facts, sales, benchmarks and base rates from the assumed rents, recoveries, renewal odds, leasing costs, loan spreads and exit cap rate.
That column also tells you where to spend diligence time. The store sales report and the shop leases decide whether 4.7% is the right number for the downside, and the shop leases’ termination rights decide how much lower it can go.
Grocery-anchored retail model (Excel)Compound’s workbook from this run: a Summary with returns by case, flags and the loan comparison; the Assumptions sheet with a source or a reason for every input; the Rent Roll with the in-place rent solve; a 132-month Monthly CF; the Annual CF with debt, DSCR and net operating income by tenant class; and the Sources list.Download · FreeFrequently asked questions
What is a grocery-anchored retail model?
It is a cash flow model of a shopping center whose largest tenant is a supermarket. It separates tenants into classes such as anchor, junior anchor, shop and pad, because each class pays, recovers and renews on different terms. It usually adds percentage rent on the grocer’s sales and a case where the anchor leaves.
How do you model percentage rent in a grocery-anchored retail model?
Estimate the store’s annual sales, set the percentage-rent rate, and compute the natural breakpoint as base rent divided by that rate. The tenant pays the rate on sales above the breakpoint. In this workbook, base rent of $531,930 and a 1.25% rate give a breakpoint of $680 per square foot, against estimated sales of $737.29 per square foot from the grocer’s 10-K.
How do expense recoveries differ between an anchor and shop tenants?
Shop tenants usually reimburse their pro-rata share of taxes, insurance and common area maintenance, often with an administrative fee. Anchors often negotiate a reduced share of maintenance. This workbook assumes the anchor pays taxes, insurance and 60% of its maintenance share, and shops pay a full share plus a 15% fee.
How do you model an anchor going dark?
Set the anchor’s renewal probability to zero at its expiration, hold the box empty for a downtime period, and apply co-tenancy relief to shop tenants. This workbook uses 36 months of downtime and a drop to 50% of shop base rent for 12 months, both analyst assumptions.
Can you build a grocery-anchored retail model from public data alone?
You can build the structure and a first set of numbers. A CMBS loan-level filing gives the property’s area, occupancy, income, appraised value, three largest tenants and loan terms, and the grocer’s 10-K gives sales per square foot. Rent per tenant, recovery terms and the percentage-rent and co-tenancy clauses come from the seller.





