This hypothetical neighborhood shopping center produces less recoverable income than its marketing package suggests. Correcting the CAM schedule reduces NOI by $30,000. The resulting investment may still work, but only if the buyer prices the actual leases, funds the leasing plan, and distinguishes restricted capital accounts from operating profit.
All property details, lease provisions, dollar amounts, loan terms, and values below are invented for education. This is not a Jaken-funded deal, a market comparable, or a representation of current Chicago financing terms.
Investment thesis and the facts needed to test it
The proposed acquisition is a 25,000-square-foot suburban Chicago retail center. The thesis is to preserve a service-oriented tenant mix, repair exterior components, and renew or replace a near-term tenant without relying on a major rent increase. The seller labels the property “NNN” and reports $390,000 NOI.
The buyer’s first task is to test recoveries. The relevant evidence is the executed leases and amendments, operating-expense invoices, historical CAM reconciliations, tenant payment histories, and disputes. An attractive tenant roster does not resolve whether each expense is contractually billable or collectible.
The broader research context is commercial-property operating income and retail leasing risk. The OCC provides lending-underwriting guidance, and Brixmor’s annual filing provides an example of actual retail-ownership disclosures. Neither source establishes these hypothetical lease terms or property values. OCC CRE handbook, Brixmor 2025 Form 10-K
Rebuild the CAM schedule before trusting NOI
Assume total operating expenses are $200,000. Of these, $150,000 enter the model’s preliminary CAM pool and $50,000 remain direct owner expenses. The center has three tenants and a vacant suite. Their actual lease clauses differ.
| Space | Share of area | Preliminary share of $150,000 | Collectible recovery after assumed lease terms |
|---|---|---|---|
| Tenant A | 40% | $60,000 | $30,000 after specified exclusions and cap |
| Tenant B | 25% | $37,500 | $20,000 under a fixed recovery arrangement |
| Tenant C | 15% | $22,500 | $10,000 after a negotiated limitation |
| Vacant space | 20% | $30,000 | $0 |
| Total | 100% | $150,000 | $60,000 |
The seller’s statement assumes $90,000 of collectible reimbursements. Lease-level review supports $60,000. The $30,000 adjustment is a reduction in revenue, while operating expenses remain $200,000. Do not add a second $30,000 expense for the same leakage.
The public DSW lease filed in 2006 illustrates why the clause matters: Section 16 specifies exclusions, exceptions for certain amortized work, estimates, reconciliation, and conditioned audit rights. Its negotiated terms are historical examples; they do not govern this invented center. DSW historical lease, Section 16.
The table deliberately simplifies clause calculations. In a real acquisition, attach each actual formula, excluded expense, cap base, and reconciliation. A fixed recovery, an expense stop, and a cap on controllable expenses have different mechanics. Treating them all as a percentage of total expenses would recreate the original error.
Reconciled annual operations
| Annual operating line | Seller presentation | Buyer base case |
|---|---|---|
| Collected base rent | $500,000 | $500,000 |
| CAM and other expense recoveries | $90,000 | $60,000 |
| Total effective revenue | $590,000 | $560,000 |
| Operating expenses | ($200,000) | ($200,000) |
| NOI | $390,000 | $360,000 |
At a $4.2 million purchase price, seller-presented NOI implies approximately a 9.29% cap rate. The corrected base case implies approximately 8.57%. These are arithmetic illustrations, not a statement that either cap rate is appropriate for this property.
At an assumed 8% valuation cap rate, $390,000 implies $4,875,000, while $360,000 implies $4,500,000. The difference is $375,000. This helps frame negotiation, but the buyer should not present the calculation as an independent appraisal. Tenant rollover and capital work still require analysis.
Sources and uses: fund the entire plan
| Uses | Amount |
|---|---|
| Purchase price | $4,200,000 |
| Closing, diligence, and financing costs | $150,000 |
| Physical improvements | $150,000 |
| Tenant improvements and leasing commissions | $150,000 |
| Opening operating liquidity | $100,000 |
| Additional contingency | $50,000 |
| Total uses | $4,800,000 |
| Sources | Amount |
|---|---|
| Acquisition loan | $2,500,000 |
| Investor equity | $2,300,000 |
| Total sources | $4,800,000 |
The loan is approximately 59.52% of the purchase price and 52.08% of total uses. The hypothetical plan assumes the capital, operating-liquidity, and contingency accounts are fully funded at closing. If the lender instead holds back money or requires reimbursable draws, the monthly funding schedule must change.
The equity basis is $2.3 million, not the $1.7 million difference between price and loan. Ignoring $600,000 of other uses would materially inflate the displayed investor return.
Financing assumptions and operating cash flow
Assume a $2.5 million loan at a hypothetical 7% annual rate with monthly payments, 25-year amortization, and a five-year maturity. Annual scheduled debt service is approximately $212,034. Base-case DSCR using $360,000 NOI is approximately 1.698 times. Debt yield is 14.4%.
Neither metric establishes that every lender would approve the loan. Lease credit, collateral, reserves, sponsor capacity, legal conditions, and execution still matter. Use Jaken’s commercial financing overview to identify a relevant discussion category, then verify the actual proposed terms. Jaken commercial asset-class financing
The base-case annual operating bridge is:
| Cash-flow line | Amount |
|---|---|
| NOI | $360,000 |
| Debt service | ($212,034) |
| Recurring reserve contribution | ($20,000) |
| Operating cash after debt and recurring reserve | $127,966 |
If all $300,000 of physical and leasing work occurs in year one, the total property cash-flow statement also shows those payments. They are funded from the separate $300,000 capital accounts already included in acquisition uses. Recording both the expenditures and account withdrawals avoids either omitting capital costs or deducting them twice from new operating cash.
Tenant rollover changes the downside
Assume one tenant contributing $100,000 of annual base rent expires. The base case already includes the $150,000 leasing budget, but the downside assumes the space remains vacant for the whole year. Assume $10,000 of recoveries are also lost and $5,000 of operating costs are avoided.
Downside NOI is therefore $360,000 minus $100,000 minus $10,000 plus $5,000, or $255,000. DSCR falls to approximately 1.203 times. After $212,034 debt service and a $20,000 recurring reserve contribution, operating cash is approximately $22,966.
That is still positive before unplanned costs, but it leaves far less flexibility. If the tenant’s departure also requires $80,000 beyond the original leasing budget, the opening contingency of $50,000 would be insufficient by $30,000 before considering any retained operating cash or other demands. This is a contingency-account gap, not yet an entity-wide capital call: the separate $100,000 opening operating liquidity could cover it if unrestricted and not already needed for other obligations. Show both accounts and a monthly schedule to determine the maximum cash deficit, rather than netting the full year’s cash against an early invoice automatically.
A second financing structure changes the risk
Compare the selected five-year amortizing loan with a hypothetical $2.5 million bridge at 9% interest-only for 24 months. Assume the same funded capital accounts and the same all-in transaction-cost allowance solely to isolate payment and maturity effects; actual fees and eligibility require separate quotes. Bridge annual interest is $225,000, approximately $12,966 more than the selected loan’s debt service. Base cash after the $20,000 recurring reserve becomes $115,000 rather than approximately $127,966.
The bridge preserves no additional initial equity in this comparison and repays no principal. At month 24 it still owes $2.5 million, while the amortizing loan’s modeled balance is approximately $2,420,745. Its shorter maturity also requires refinancing or sale during the leasing plan. A bridge might nevertheless be the executable choice if the long-term lender cannot accept the property’s current condition; that would require a separately supported two-year takeout and adequate liquidity. The selected base case uses the five-year loan because the assumed terms provide lower cash burden and more time without adding leverage. Neither proposal is an actual offer.
A stress on expense recoveries
Now assume the eligible operating-expense pool rises by $20,000. The effect on NOI depends on the actual leases. If none of that increase is collectible because of caps or fixed payments, NOI falls dollar for dollar by $20,000. If $8,000 is collectible, the net decrease is $12,000.
This is why “expenses are passed through” is an inadequate underwriting assumption. Model each material clause and identify which categories are excluded or capped. Property-tax, insurance, utility, and maintenance changes can affect tenants differently. Do not apply a generalized recovery percentage merely because it reproduces the seller’s current total.
For a Chicago-area acquisition, verify the subject parcel’s tax information and obtain an actual insurance quotation. This case makes no claim about a future reassessment, premium trend, or local rent growth. Those require separate current property-specific research.
Five-year cash flow and concrete exit proceeds
Assume a five-year hold, with annual NOI of $360,000, $370,000, $380,000, $390,000, and $390,000. These are hypothetical execution assumptions rather than forecasts. The $20,000 annual recurring reserve is deposited and spent on recurring replacement work in the same year, leaving no accumulated balance. The separately funded $300,000 initial physical and leasing program is spent in year one. The opening $100,000 operating reserve and $50,000 contingency are assumed unused and returned at sale; a real downside can consume them.
| Year | NOI | Debt service | Recurring replacement funding/spend | Cash before owner allocation |
|---|---|---|---|---|
| One | $360,000 | ($212,034) | ($20,000) | $127,966 |
| Two | $370,000 | ($212,034) | ($20,000) | $137,966 |
| Three | $380,000 | ($212,034) | ($20,000) | $147,966 |
| Four | $390,000 | ($212,034) | ($20,000) | $157,966 |
| Five | $390,000 | ($212,034) | ($20,000) | $157,966 |
The loan’s modeled principal after 60 monthly payments is approximately $2,279,054. For the sale at the end of year five, assume forward NOI remains $390,000. At an 8% exit cap rate, gross value is $4,875,000. With assumed selling costs of 2% ($97,500), net proceeds after the modeled principal are approximately $2,498,446, before reserve return, income taxes, unmodeled payoff charges, and ownership allocations. At 9%, gross value is approximately $4,333,333, costs approximately $86,667, and corresponding net proceeds approximately $1,967,613. The model assumes no additional prepayment charge at scheduled maturity.
Using the full $2.3 million initial equity, end-of-year cash timing, all stated annual cash made available, and return of the unused $150,000 opening reserve/contingency, the base 8% exit produces approximately $3,378,277 cumulative equity cash, a 1.469-times multiple and 8.83% annual IRR before taxes and investor-specific fees or waterfall. The 9% exit with the same operating years produces approximately $2,847,444 cumulative cash, a 1.238-times multiple and 4.87% IRR. These are property-equity model outputs, not promised member distributions. Actual reserve use, retained cash, tax, costs, and ownership terms change results.
The decision is conditional: the leases must support corrected income, capital scope must be funded, and owners must accept the lower return and liquidity under the downside. Seek a price adjustment or decline if the plan depends on billing nonrecoverable expenses or ignoring the rollover. The NNN label and advertised cap rate remain prompts for diligence rather than an investment conclusion.
What the buyer should resolve before the inspection deadline
Request the last three CAM reconciliations, evidence of delivery to tenants, any objections, and a tenant-by-tenant receivables aging. Determine whether balances will be collected by the seller, assigned to the buyer, or adjusted at settlement. That allocation can affect closing cash without changing normalized recurring NOI. Ask counsel to identify the recovery provisions that require interpretation rather than assuming the property manager’s existing billing practice is contractually correct.
For the expiring tenant, obtain the complete option and notice provisions, current communications, and renewal proposal. Budget a replacement using a space plan, realistic delivery condition, and written leasing-cost assumptions. A reserve called “TI/LC” is only an allowance until those inputs are supported. The investment committee should approve both the acquisition price and the maximum additional capital it is prepared to contribute if the vacancy lasts longer.
After closing, compare actual collections and CAM billings against this schedule quarterly. Preserve the original investment case so improvements can be distinguished from corrections to the opening model.