Retail value-add pro forma: a 1.3% IRR and a $3.65M refinance gap

An acquisitions analyst at an institutional retail investor asks Compound for a 60-month monthly pro forma on one strip center from public filings: replace the anchor, lease the vacant inline space, ground-lease two outparcel pads, and refinance a floating-rate bridge loan at about month 30.

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

Short answer

A retail value-add pro forma projects a shopping center month by month through re-leasing, capital spending and a refinance. In Compound's 60-month model of a 77% occupied Florida strip center priced at its $8,900,000 appraised value, the levered IRR is 1.3% and the month-30 refinance leaves a $3,646,066 shortfall.

Try it now
On this page (11)
  1. 1. What does the model return, and which flags are raised?
  2. 2. Which property is the subject, and where does the price come from?
  3. 3. How is a suite-level rent roll built when the filing names three tenants?
  4. 4. What does each part of the plan assume, and what does it cost?
  5. 5. How does occupancy move over the 60 months?
  6. 6. What do the leasing and yield assumptions rest on?
  7. 7. How are the two loans priced, and why does the refinance fall short?
  8. 8. What does the annual cash flow show?
  9. 9. What can public data not tell you about this center?
  10. 10. Our view
  11. 11. Frequently asked questions

Bought at its July 2026 appraised value of $8,900,000, the strip center in this model returns a 1.3% levered IRR and a 1.05x equity multiple over 60 months. The leasing plan takes occupancy from 77% to 100%. The return is lost in month 30, when a permanent loan of $4,492,304 has to repay a bridge balance of $8,093,447 while the anchor box is dark.

You work in acquisitions or asset management at an institutional real estate investor, and a strip center with empty space, an anchor lease that ends in two years and room for pads has reached your desk. A retail value-add pro forma has to carry all of it month by month: the suites that lease, the anchor that leaves, the rent relief while its box is empty, the pad construction and two loans. 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 1.3% levered and 5.1% unlevered. Levered profit is $422,006 on $9,186,661 of equity.
  • The refinance does not repay the bridge loan. Equity funds $3,646,066 in month 30.
  • Net operating income is below debt service in 30 of the 60 months. The lowest monthly DSCR is 0.28x.
  • The pads supply 398% of the profit. They earn $1,680,367, so the strip on its own loses money.
  • The stabilized yield on total cost is 7.5%. The strip’s exit cap rate is 7.75%, and the redevelopment yields that public shopping-center landlords report are 9% to 12%.

Each input on the Assumptions sheet carries a citation, the word “Request” or the words “Analyst assumption”, and a reason in the next column. The property, its three largest tenants, its income, its appraisals and its loan come from CMBS loan-level filings on SEC EDGAR. Leasing spreads and redevelopment yields come from the earnings calls of four shopping-center REITs. County population and income come from the Census Bureau and retail employment from the Bureau of Labor Statistics. The bridge loan is priced off the SOFR forward curve and the permanent loan off the Daily Treasury Par Yield Curve. The site’s land area, a traffic count, the sizes of two vacant suites, local asking rents and net-lease cap rates came from web pages: a leasing listing for the center, a listing site and a net-lease broker’s report, each named on the Sources sheet.

Shopping center underwriting is the one-sheet screen you would run first, and the grocery-anchored retail model is a stabilized center with one event to test. The general real estate pro forma has no pad development and no co-tenancy.

Prompt to try

“I am underwriting the repositioning of a strip center that has lost tenants and want a retail value-add pro forma built on a real property. From the CMBS loan-level filings, pick one retail property in Florida, Georgia, the Carolinas or Tennessee that is less than 85% occupied, or whose largest tenant's lease expires within two years, 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 a suite-level rent roll from the named tenants as filed, with the remaining leased area in clearly labelled "other tenants" rows and each vacant block as its own suite with a lease-up month. The plan has three parts: replace the anchor, lease the vacant inline space, and develop two outparcel pads on ground leases. Set market rent, downtime, renewal probability, leasing cost packages, co-tenancy triggers, percentage-rent breakpoints, and each pad's cost, timing, ground rent and term as analyst assumptions with a note on each, checked against the leasing spreads and redevelopment yields public shopping-center REITs report in their latest 10-K or earnings call. Support the lease-up with county population and household income from the Census ACS data and retail employment from BLS. Price an interest-only bridge loan off the SOFR forward curve plus a spread, and a permanent loan off the 10-year Treasury yield that refinances it at about month 30. Build a 60-month monthly model: rent roll, expenses and recoveries, co-tenancy rent relief while the anchor space is dark, percentage rent above the breakpoint, the outparcel schedule, both loans and the sale, with the pad ground leases valued at a lower cap rate than the strip. Report levered IRR, equity multiple, cash-on-cash, DSCR, debt yield, monthly occupancy, equity draws, stabilized NOI and exit value. Flag a refinance that does not repay the bridge loan, a month where DSCR falls below 1.0x, and pads that supply more than a third of the profit. 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.

What does the model return, and which flags are raised?

At the appraised value the base case returns a 1.3% levered IRR and a 1.05x equity multiple, against a 5.1% unlevered IRR. All three flags the request asked for are raised: the refinance does not repay the bridge loan, DSCR is below 1.00x in 30 months, and the pads supply 398% of the profit.

The buyer puts in $3,371,098 at close and another $5,815,564 over the hold, and gets back $9,608,667. The unlevered return of 5.1% is below the cost of both loans: the bridge loan costs 7.99% in month 1 and the permanent loan is fixed at 7.40%, so borrowing lowers the return on equity.

Lake Hills Plaza Retail Value-Add Pro Forma.xlsx
D28fx=IF(C28<0,"FLAG: refinance does not repay the bridge; equity funds "&TEXT(-C28,"$#,##0")&" in month "&Debt!D23,"OK: refinance repays the bridge")
BCD
5RETURNS AND KEY METRICS
6Levered IRR (%)1.3%
7Equity multiple (x)1.05x
8Levered profit ($)422,006
9Total equity contributed ($)9,186,661
10Equity at close ($)3,371,098
11Equity draws after close ($)5,815,564
12Peak cumulative equity outstanding ($)9,113,605
13Unlevered IRR (%)5.1%
14Average annual cash-on-cash, years 1-5 (%)1.4%
15Minimum monthly DSCR in hold (x)0.28x
16Debt yield at refinance, in-place NOI / perm loan (%)10.8%
17Debt yield at exit, forward NOI / perm balance before payoff (%)22.6%
18Stabilized NOI, next 12 months after exit ($)990,348
19Exit value, gross sale price ($)13,315,347
20Strip value10,778,680
21Pad value2,536,667
22Total project cost: price, closing costs and capital costs in hold ($)13,212,448
23Stabilized yield on total cost (%)7.5%
24Going-in yield, year 1 NOI / purchase price (%)2.4%
26FLAGS
27CheckValueResult
28Perm loan proceeds after fees less bridge payoff at refinance ($)(3,646,066)FLAG: refinance does not repay the bridge; equity funds $3,646,066 in month 30
29Months in hold with DSCR below threshold30FLAG: DSCR below 1.00x in 30 months, first in month 1
30Pad profit: ground rent, net pad sale value, less pad costs ($)1,680,367
31Pad profit as share of levered profit (%)398.2%FLAG: pads supply 398% of profit
SummaryAssumptionsRent RollCash FlowDebtSources
The Summary sheet, rows 5 to 31, columns B to D, as Compound wrote them. Every value is a formula on the Cash Flow, Debt or Assumptions sheet, and each flag is text that a formula builds from the value beside it. The returns follow from a purchase price equal to the appraised value in the CMBS filing.

The flags are formulas. Cell D28 reads the refinance shortfall from the Debt sheet and writes the dollar amount and the month into the sentence, so the flag changes when you move the refinance month or the price.

A pad share of 398% means the pads earn almost four times the profit of the whole deal. By our arithmetic the rest of the deal loses $1,258,361: the total profit of $422,006 less the pad profit of $1,680,367. Compound’s answer says it in words: “The strip on its own loses money after the anchor capital and the cost of the bridge.”

Which property is the subject, and where does the price come from?

Compound chose Lake Hills Plaza in Eustis, Florida, a 93,743 square foot center built in 1973 that a CMBS filing reports as 77% occupied. The purchase price of $8,900,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 Wells Fargo Commercial Mortgage Trust 2019-C50 Form ABS-EE, Exhibit 102, asset 39, for the period ended October 13, 2026. The Sources sheet says how the property was found: a screen of retail properties in five southeastern states that were under 85% occupied, or whose largest lease expires within two years.

The filing reports occupancy of 100% at securitization in 2018 and 77% in the latest report. For 2025 it reports revenue of $656,961, operating expenses of $531,600 and net operating income of $125,361. Revenue at securitization was $1,426,742.

The latest appraisal in the filing is $8,900,000, dated July 31, 2026, against $12,600,000 at securitization. The price works out to $94.94 per square foot by our arithmetic.

The filing gives the loan as $8,820,000 at origination on December 20, 2018, at a 5.4% fixed rate, with a 120-month term that matures on January 11, 2029. The balance at the end of the period is $8,181,997, and debt service for the latest reported year is $594,324. By our arithmetic the reported net operating income is 0.21x of that debt service.

The model does not carry this loan forward. It buys the center at the appraised value with new equity and a new bridge loan on December 31, 2026, a date marked as an analyst assumption. On the model’s year-1 income, the going-in yield on the price is 2.4%.

How is a suite-level rent roll built when the filing names three tenants?

The filing names three tenants with their square feet and lease expirations, and Compound keeps them as filed: Ollie’s Bargain Outlet, Planet Fitness and Aaron Rents. The other 8,659 square feet of leased space sit in two rows labelled as not named in the filing, and the 21,561 vacant square feet are six suites with a lease-up month each.

Lake Hills Plaza Retail Value-Add Pro Forma.xlsx
F136fx=(ROUND(Assumptions!$C$8*Assumptions!$C$9,0)-SUM(F133:F135))*Assumptions!$C$55
BCDEFGHIJKL
132SuiteTenantCategoryStatusArea (SF)Lease expirationIn-place rent ($/SF/yr)In-place recovery (% of share)Lease-up monthCo-tenancy clause (1/0)Sales ($/SF/yr)
133A-1Ollie's Bargain OutletAnchorLeased33,4312028-12-31$4.2540%0$250
134B-1Planet FitnessJr anchorLeased19,1422036-05-31$6.0050%0$0
135C-1Aaron RentsJr anchorLeased10,9502030-12-31$8.00100%1$0
136D-1Other tenants, group 1 (not named in filing)InlineLeased4,3302028-06-30$12.50100%1$0
137D-2Other tenants, group 2 (not named in filing)InlineLeased4,3302029-09-30$12.50100%1$0
138V-1Vacant: largest listed spaceInlineVacant6,08560$325
139V-2Vacant: smallest listed spaceInlineVacant99740$350
140V-3Vacant inline blockInlineVacant5,00090$0
141V-4Vacant inline blockInlineVacant4,000120$0
142V-5Vacant inline blockInlineVacant3,000150$0
143V-6Vacant inline blockInlineVacant2,479180$0
144Total93,743
SummaryAssumptionsRent RollCash FlowDebtSources
The rent roll inputs on the Assumptions sheet, rows 132 to 144, as Compound wrote them. We leave out the source and reason columns. The three named tenants, their areas and their lease expirations are as the CMBS filing gives them; rents, recoveries, lease-up months, co-tenancy clauses and sales are analyst assumptions.

The area of the unnamed tenants is a formula. Cell F136 multiplies net rentable area by reported occupancy, subtracts the three named tenants and splits what is left into two equal rows. The Summary sheet checks that the rent roll adds to 93,743 square feet.

A CMBS filing does not give rent by tenant. Compound set in-place rents as analyst assumptions: $4.25 per square foot for the anchor, $6.00 and $8.00 for the two junior anchors and $12.50 for the unnamed inline tenants. It chose them so that the model’s first month, multiplied by 12, comes to $648,857 of revenue against the $656,961 the filing reports for 2025.

Two of the six vacant suites, 6,085 and 997 square feet, are the largest and smallest spaces on a leasing listing for the center. The other four are an analyst split of the remaining vacant area. When the seller’s rent roll arrives, a rent roll analysis replaces every assumed row in this block.

What does each part of the plan assume, and what does it cost?

The plan replaces the anchor when its lease expires on December 31, 2028, leases the six vacant suites between months 4 and 18, and ground-leases two pads. Every leasing and pad input is an analyst assumption with a reason beside it, and capital costs over the hold total $4,134,448.

The Assumptions sheet sets market rent, downtime, renewal probability and leasing costs for three categories of space: anchor, junior anchor and inline. The anchor’s renewal probability is 0% because replacing it is the plan. The box sits empty for 9 months and re-leases at $7.50 per square foot against $4.25 in place. The landlord pays $25.00 per square foot of tenant improvements, $15.00 per square foot of work on the box, and a 6.0% commission on a 10-year term.

By our arithmetic on those inputs and the anchor’s 33,431 square feet, the tenant improvements are $835,775, the landlord work $501,465 and the commission $150,440, or $1,487,680 in all. The added base rent is $108,651 a year. The Summary sheet states the same ratio as a 7.3% anchor repositioning yield.

Lake Hills Plaza Retail Value-Add Pro Forma.xlsx
BCDF
87PadPad 1Pad 2
88Intended useQuick-service restaurant, drive-thruCoffee or bank, drive-thru
89Pad land area1.00.9acres
90Landlord pad development cost650,000575,000$
91Site work start month713month
93Ground rent commencement month2228month
94Annual ground rent85,00070,000$
95Ground rent increase every 5 years10.0%10.0%%
97Ground lease term2015years
98Leasing commission4.0%4.0%% of first 10 years of ground rent
99Exit cap rate6.0%6.2%%
SummaryAssumptionsRent RollCash FlowDebtSources
The outparcel pad block of the Assumptions sheet, as Compound wrote it. We show 10 of its 12 assumption rows and leave out the source column, where every row reads 'Analyst assumption'.

The pads are ground leases: the landlord pays for entitlement, site work, utilities and parking changes, and the tenant builds its own building. Pad 1 costs $650,000 and starts paying $85,000 a year in month 22. Pad 2 costs $575,000 and starts paying $70,000 a year in month 28. The site’s land area of 809,781 square feet, from the leasing listing, is the evidence the workbook gives that two pads of about an acre each fit.

How does occupancy move over the 60 months?

Occupancy rises from 77.0% in month 1 to 100.0% in month 18, then falls to 64.3% for months 25 to 33 while the anchor box is dark. It returns to 98.6% in month 34 and ends the hold at 100.0%.

Strip occupancy at ten points in the hold

Share of the 93,743 square feet occupied. Month 1 is January 2027; the anchor lease expires at the end of month 24.

Month 1, January 202777.0%Month 684.5%Month 12, December 202794.2%Month 18, June 2028100.0%Month 24, December 202898.6%Months 25 to 33, anchor box dark64.3%Month 34, new anchor in place98.6%Month 48, December 2030100.0%Months 49 to 5795.3%Month 60, December 2031100.0%

Compound workbook, Summary sheet, monthly strip occupancy grid, rows 97 to 101. A projection from the lease-up months, downtime and renewal probabilities on the Assumptions sheet.

The lease-up is 21,561 square feet over 18 months, a pace of 1,198 square feet a month. Compound’s answer ties that pace to the county data. Lake County’s population grew 2.7% from 2024 to 2025, from 444,204 to 456,068, against 0.4% for Florida, and median household income rose 4.5% to $80,076. Private retail employment in the county fell 1.9% between March 2025 and March 2026, from 19,111 to 18,742.

The model weights each lease expiration by its renewal probability: the Rent Roll sheet carries the suite at that probability for the months of downtime and at full occupancy afterwards. That is why occupancy reads 95.3% for months 49 to 57, when the Aaron Rents lease has expired and the model carries 60% of that suite as occupied.

Co-tenancy relief follows the anchor. The trigger is the anchor suite falling below 100% occupancy, the cure period is 3 months, and tenants with the clause then pay 50% of base rent. Compound assumed the clause for Aaron Rents and the two unnamed rows. The relief runs from month 28 to month 33 and comes to $35,976 by our sum. Percentage rent, charged only on suites with a sales figure, adds $188,730 over the hold by our sum.

What do the leasing and yield assumptions rest on?

Compound checked each assumption against what four shopping-center REITs said on their 2026 earnings calls, and the Summary sheet puts the model’s figure beside each benchmark. The leasing spreads sit inside or near the reported ranges, while the yields on the anchor work and on total cost fall below them.

Lake Hills Plaza Retail Value-Add Pro Forma.xlsx
C79fx=$C$23-Assumptions!$C$124
BCDEF
69ItemModelBenchmark lowBenchmark highBenchmark
70Anchor re-leasing spread: market rent over Ollie's in-place rent76.5%70.0%Brixmor anchor spreads above 70%, Q3 2026
71Jr anchor re-leasing spread: market rent over Aaron's in-place rent25.0%31.5%43.0%Kimco 31.5% and Brixmor 43% new-lease spreads, Q3 2026
72Inline renewal spread: market rent over other tenants' in-place rent20.0%7.3%25.2%Kimco 7.3% to Phillips Edison 25.2% renewal spreads, Q3 2026
73Inline renewal probability vs Regency retention70.0%84.0%Regency retention 84%, Q2 2026
75Pad 1 ground rent yield on landlord cost13.1%9.0%12.0%Phillips Edison 9-12% redevelopment yields
76Pad 2 ground rent yield on landlord cost12.2%9.0%12.0%Phillips Edison 9-12% redevelopment yields
77Anchor repositioning yield: rent uplift / anchor TI, commission and landlord work7.3%9.0%10.0%Regency ~9% and Brixmor 10% reinvestment yields
78Stabilized yield on total cost7.5%9.0%12.0%Phillips Edison 9-12% development yields
79Spread of stabilized yield over strip exit cap(0.3%)1.5%Regency delivers at least 150 bps over market caps
SummaryAssumptionsRent RollCash FlowDebtSources
The benchmark check block of the Summary sheet, as Compound wrote it. We show 9 of its 12 rows; the other three compare the inline rent and two cap rates with web sources named on the Sources sheet. REIT figures are as stated on earnings calls and at an investor conference in 2026.

The anchor’s 76.5% re-leasing spread is the ratio of two assumed rents, $7.50 over $4.25, so the benchmark tests the two assumptions as a pair and says nothing about the rent this anchor pays. Brixmor said on its third-quarter call of October 27, 2026 that its anchor spreads were above 70%. The junior anchor spread of 25.0% is below the 31.5% Kimco and the 43% Brixmor reported for new leases. The inline spread of 20.0% is inside the range of renewal spreads, from Kimco’s 7.3% to Phillips Edison’s 25.2%. The 70% inline renewal probability is below Regency’s 84% retention.

Each pad earns more on its cost than the 9% to 12% Phillips Edison gave for redevelopment, and Compound’s note gives the reason: the land is already in the purchase price. The anchor work yields 7.3%, below the roughly 9% Regency and the 10% Brixmor described. The whole project yields 7.5% on its total cost.

Yields in the model against the REIT range and the exit cap rate

Annual income divided by cost. The REIT range is the 9% to 12% redevelopment yield stated on a third-quarter 2026 earnings call.

Pad 1 ground rent on pad cost13.1%Pad 2 ground rent on pad cost12.2%REIT redevelopment yields, high12.0%REIT redevelopment yields, low9.0%Strip exit cap rate7.8%Stabilized yield on total cost7.5%Anchor repositioning yield7.3%

Compound workbook, Summary sheet rows 23 and 75 to 78 and Assumptions sheet row 124. Model yields follow from analyst assumptions; the REIT range is cited to the Phillips Edison call of October 27, 2026.

Regency said it delivers projects at least 150 basis points above market cap rates. This model’s stabilized yield is 0.3 percentage points below its own 7.75% exit cap rate.

How are the two loans priced, and why does the refinance fall short?

The bridge loan floats at one-month SOFR plus 3.75% and costs 7.99% in month 1. The permanent loan is fixed at 7.40%, and in month 30 it is sized at $4,492,304 against a bridge balance of $8,093,447.

The bridge loan advances 65% of the price, $5,785,000, at close and then funds 85% of capital costs as they are spent. It is interest-only with a rate cap struck at 5.5%. The forward curve is market-implied as of the close of November 13, 2026 and starts at 4.19%, and the highest all-in rate during the bridge term is 8.71%. Our page on the SOFR forward curve shows how such a curve is read.

The permanent loan takes the 10-year Treasury par yield of 5.15% on the same date and adds a spread of 2.25%, an analyst assumption, with 30-year amortization.

Lake Hills Plaza Retail Value-Add Pro Forma.xlsx
D31fx=PV(D24/12,Assumptions!$C$116*12,-D25/Assumptions!$C$118/12)
BD
22PERMANENT LOAN SIZING
23Refinance month30
24Fixed rate (10-year Treasury + spread)7.40%
25In-place NOI at refinance, trailing 3 months annualized485,219
26Forward 12-month strip NOI at refinance574,164
27Forward 12-month Pad 1 rent at refinance85,000
28Forward 12-month Pad 2 rent at refinance70,000
29Value at refinance9,945,236
30Maximum loan, loan-to-value6,464,404
31Maximum loan, DSCR on in-place NOI4,492,304
32Maximum loan, debt yield on in-place NOI5,107,572
33Permanent loan amount ($)4,492,304
34Monthly payment (P&I)31,104
35Bridge balance repaid at refinance8,093,447
36Refinance surplus (+) or shortfall (-) after fees ($)(3,646,066)
SummaryAssumptionsRent RollCash FlowDebtSources
The permanent loan sizing block of the Debt sheet, rows 22 to 36, columns B and D, as Compound wrote them. The 65% loan-to-value, 1.30x DSCR and 9.5% debt yield limits are analyst assumptions; the refinance month is set by the request.

The loan is the smallest of three tests. The loan-to-value test allows $6,464,404, the debt yield test $5,107,572 and the DSCR test $4,492,304. The DSCR test binds because it uses in-place income: the last three months of net operating income, annualized, which is $485,219. Those three months are months 28 to 30. The anchor suite is empty, co-tenancy relief is running, and net operating income in month 30 is $40,435.

Month 30: the bridge balance against three loan sizing tests

The permanent loan is the smallest of the three tests. The gap to the bridge balance, plus loan costs, is paid with equity.

Bridge balance to repay$8,093,447Loan at 65% of value$6,464,404Loan at 9.5% debt yield$5,107,572Loan at 1.30x DSCR (the loan made)$4,492,304

Compound workbook, Debt sheet, cells D30 to D35. Sizing limits are analyst assumptions; the refinance month is set by the request.

After the loan’s 1.0% costs, the shortfall is $3,646,066. None of the three tests would repay the bridge: the loan-to-value test rests on a value at refinance of $9,945,236, and 65% of it is still below the balance.

The request set the refinance at about month 30, and the Assumptions sheet labels that input “Request”. Compound’s answer points at the fix: “Moving the refinance to after the new anchor opens (about month 37 or later) would largely close this.” The Cash Flow sheet shows why. Net operating income in month 37, the first month after the new anchor’s free rent, is $74,748. Twelve times that is $896,974 by our arithmetic, against the $485,219 that the month-30 sizing uses. The workbook sizes the loan only at month 30, so it gives no shortfall for a later date.

DSCR is below 1.00x in every month of the bridge term. It starts at 0.29x, reaches 0.97x in month 23 and drops again when the anchor leaves. After the refinance it is 1.30x, which the sizing test fixes, and the lowest month of 2030 is 2.40x.

What does the annual cash flow show?

Net operating income goes from $217,752 in 2027 to $911,549 in 2030, the first full year with the new anchor. Levered cash flow is negative in each of the first three years, and 2029 alone takes $4,947,095 of equity.

Lake Hills Plaza Retail Value-Add Pro Forma.xlsx
C46fx=(C38+C40)/$C$9
BCDEFGH
34Year ending20272028202920302031Total
35Year of hold12345
36Total effective gross income ($)712,1221,051,5951,053,3451,483,5781,499,3215,799,961
37Operating expenses(494,370)(524,096)(537,174)(572,029)(591,722)(2,719,390)
38Net operating income ($)217,752527,500516,171911,549907,5993,080,571
39Capital costs(1,493,168)(812,296)(1,604,649)(57,607)(166,729)(4,134,448)
40Debt service, interest and principal(522,565)(652,683)(517,987)(373,246)(373,246)(2,439,726)
41Levered cash flow ($)(541,480)(253,932)(4,907,216)480,6979,015,0353,793,103
42Equity contributions(541,480)(253,932)(4,947,095)-(73,056)(5,815,564)
43Distributions--39,880480,6979,088,0919,608,667
44Strip occupancy, year end (%)94.2%98.6%98.6%100.0%100.0%
45Minimum monthly DSCR (x)0.28x0.68x0.68x2.40x2.42x
46Cash-on-cash: NOI less debt service / total equity contributed (%)(3.3%)(1.4%)(0.0%)5.9%5.8%
47Debt yield, year end, annualized NOI / loan balance (%)5.8%8.3%14.1%20.8%21.0%
SummaryAssumptionsRent RollCash FlowDebtSources
The annual summary block of the Summary sheet, rows 34 to 47, as Compound wrote it. Each cell sums or looks up the monthly Cash Flow sheet. The 2031 levered cash flow includes the sale. All figures are projections from the assumptions on the Assumptions sheet.

Net operating income by year of the hold

Calendar years 2027 to 2031 in the model, beside the 2025 figure the CMBS filing reports.

2027 NOI$217,7522028 NOI$527,5002029 NOI$516,1712030 NOI$911,5492031 NOI$907,599Reported 2025 NOI (CMBS filing)$125,361

Compound workbook, Summary sheet row 38 and Assumptions sheet cell C17. Model years are projections from analyst assumptions; the 2025 figure is cited to the CMBS filing.

Net operating income is flat from 2028 to 2029 because the anchor’s nine months of downtime offset the lease-up and the pad rent. Capital costs peak in 2029, at $1,604,649, as the anchor work and the new tenant’s improvements are paid. Cash-on-cash is negative in 2027 and 2028, about zero in 2029 and 5.9% and 5.8% in the last two years. The workbook divides each year by the total equity contributed over the hold, $9,186,661.

The sale is priced on the 12 months after the hold, which is why the Cash Flow sheet runs to month 72. That forward income is $990,348: $835,348 from the strip and, by our arithmetic, $155,000 from the two ground leases. The strip is valued at a 7.75% cap rate, $10,778,680, and the pads at 6.00% and 6.25%, $2,536,667 together. The exit value of $13,315,347 compares with a total project cost of $13,212,448.

Compound also removed $75,000 from the reported 2025 operating expenses as an analyst assumption. Its note says that 2025 expenses of $5.67 per square foot are double the $2.68 at securitization, and asks for the seller’s trailing 12-month detail to confirm the adjustment.

What can public data not tell you about this center?

Public filings give the property totals, three tenants and the loan. Rent by tenant, the lease clauses, the right to build on the parking field and the anchor’s options are in documents the seller holds, and the workbook 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 and the leases. They replace the assumed in-place rents, recovery shares and the two unnamed rows, and show any caps on common area charges.
  • The anchor’s renewal options and notice dates. The answer says these “decide whether the anchor can be replaced at all”.
  • Co-tenancy and percentage-rent clauses, with sales reports. They replace the 50% relief, the three-month cure and the assumed sales and breakpoints.
  • Operating history. A trailing 12-month statement and the 2025 statement by line, the 2026 tax bill and the insurance policy replace the expense split and test the $75,000 adjustment.
  • Outparcel rights. The reciprocal easement agreement, the site plan, a survey and any no-build areas in the anchor leases decide whether either pad can be built.
  • Property condition and leasing interest. The July 2026 appraisal, an environmental report and letters of intent for the six vacant suites.

The sources have limits too. The filing’s income is for 2025, the appraisal that sets the price is one opinion dated July 31, 2026, and the REIT benchmarks are company-wide figures.

Our view

In this model two inputs that the request fixed decide the return: the price and the refinance month. The leasing plan succeeds on every line and still yields 7.5% on total cost against a 7.75% exit cap rate, and the model shows that before any seller document arrives.

A summary page with a 100% occupied center and net operating income of $990,348 can read as a finished plan. The flags say where it is thin. The whole profit comes from two pads that depend on rights nobody has confirmed, the anchor work earns less than the cap rate the strip sells at, and the refinance falls in the nine months when the anchor box is empty.

The pads earn 13.1% and 12.2% on their cost, with exit cap rates inside the range of the net-lease cap rates cited on the Sources sheet. Leasing spreads are at or below what the REITs report. After the refinance, income covers debt service 2.4x by 2030.

Two things in this workbook are worth copying: the flag formulas, which stay current when an input changes, and the benchmark block, which puts each analyst assumption next to a dated statement from a public landlord.

Three things would change the result. A lower price raises every yield. A refinance after month 37 uses the new anchor’s rent. The seller’s leases will show whether the anchor can be replaced and whether the pads can be built.

Retail value-add pro forma (Excel)Compound’s workbook from this run: a Summary with returns, three flags, the annual summary, benchmark checks and the monthly occupancy grid; the Assumptions sheet with a source and a reason for every input; a suite-level Rent Roll; a monthly Cash Flow; the Debt sheet with the bridge loan, the permanent loan sizing and both schedules; and the Sources list.Download · Free

Frequently asked questions

What is a retail value-add pro forma?

It is a month-by-month projection of a shopping center through a repositioning: leasing vacant suites, replacing tenants, spending capital and refinancing. Income, capital and debt all change during the hold, so equity draws and debt coverage are tracked every month.

How do you model replacing an anchor tenant?

Set the anchor’s renewal probability to zero, then give the suite downtime, a market rent, free rent, tenant improvements, landlord work and a commission. In this model the box is empty for 9 months, re-leases at $7.50 per square foot against $4.25 in place, and the work yields 7.3% on its cost.

How is co-tenancy rent relief modeled?

Give each lease a flag for the clause, then set a trigger, a cure period and a rent reduction. Here the trigger is the anchor suite falling below 100% occupancy, the cure period is 3 months and flagged tenants then pay 50% of base rent until a new anchor is in place.

How do you value outparcel pads on ground leases?

Value the ground rent separately from the strip, at its own cap rate. This model values Pad 1 at a 6.00% cap rate and Pad 2 at 6.25%, against 7.75% for the strip, and reports the pad profit on its own line so you can see how much of the deal depends on it.

Why can a refinance fail to repay a bridge loan?

The permanent loan is sized on income in place at the refinance date, while the bridge balance has grown with every capital draw. In this model the refinance falls while the anchor box is empty: the permanent loan is $4,492,304 against a bridge balance of $8,093,447, and equity funds a $3,646,066 shortfall.

Can you build a retail value-add pro forma from public data alone?

You can build the structure and a first answer. A CMBS filing gives the area, occupancy, three largest tenants, income, appraised value and loan, and public rate curves price the debt. Rent by tenant, lease clauses and pad rights are assumptions until the seller provides the rent roll, the leases and the site documents.

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