Stress Testing a Real Estate Deal Before Committing Capital

A deal survives a downside only if cash lasts through the next sale or refinancing, and only if the proceeds then cover the debt with something left for the equity. Lower occupancy cuts collected revenue while most expenses stay put, higher rates raise debt service, and overruns draw on the same reserve, so the three have to be run together. The useful output is a set of failure thresholds: the occupancy, the rate and the overrun at which cash or coverage gives out. Positive cash flow today says little about whether the invested capital comes back.

A deal that pays its debt can still fail to return the equity

Stress testing asks one question in several forms: when does cash run out, and what remains for the equity when the property is sold or refinanced. Those are separate boundaries. A property can pay interest every month and still trip a coverage test written into the loan. It can also pass that test and then sell for less than the debt plus the equity put in.

Four boundaries come in sequence. Net operating income falls below debt service. A lender-defined coverage test is breached. Usable reserves run out. Repayment at maturity exceeds what a sale or refinancing can raise. Each has its own date, which is why a single blended downside return hides the moment extra capital is first needed.

Two screening questions come first: can the deal be explained in two sentences, and where does the investor sit in the capital stack? The second decides which boundary the investor bears. Cash left after senior debt service reaches a junior position only after every intervening claim and charge has been paid.

The starting point is a sources and uses reconciliation covering acquisition funding, planned capital work, financing costs and funded reserves. Every dollar needs a use. A reserve restricted to construction cannot also cover an operating shortfall in the model.

Fund interests add a timing layer. Where the underlying assets are illiquid, a general partner may find it hard to raise enough cash to meet every redemption request, and the duty to satisfy a request is often subject to an efforts standard and other limits. Property-level reserves therefore say little about when a fund investor is paid.

“In the context of a real estate fund, where the underlying assets are often highly illiquid, it may be difficult for the GP to generate sufficient cash to satisfy all redemption requests.”

Occupancy breakeven turns on the expenses that survive vacancy

Occupancy stress only means something when it cuts collected revenue while the costs that continue during vacancy stay in the model. Multiplying NOI by the occupancy percentage assumes every operating cost falls in step with revenue. Property taxes, insurance, base staffing and most maintenance do not.

The breakeven has a direct form. Full-occupancy revenue multiplied by occupancy, less operating expenses, equals NOI. Setting NOI equal to debt service and solving gives breakeven occupancy as operating expenses plus debt service, divided by full-occupancy revenue. When some expenses vary with occupancy, the same equality is solved with that expense relationship in place of a flat figure.

Physical occupancy counts occupied space. Economic occupancy compares collected revenue with potential revenue. A concession or an unpaid balance leaves physical occupancy unchanged and still reduces collections, so a revenue bridge that shows vacancy and collection loss as separate lines makes any double deduction visible.

Lease structure sets the path. A building with many small leases loses occupancy gradually and the shortfall builds slowly. A single-tenant building is either leased or empty, so the same average occupancy can hide a cliff. Timing changes the reserve needed even when the end percentage is identical.

Rent assumptions belong in the same test. Lower rent on every occupied unit is a different shock from empty units at full rent, and the breakeven occupancy rises when rents fall because each occupied unit contributes less.

Rate exposure follows payment terms and the maturity date

Rate stress follows the loan’s mechanics: when the rate can change, what it can change to, and when the balance must be repaid. A fixed rate holds the payment path steady through its term and moves the exposure to the refinancing date. A floating-rate moves the exposure into every payment.

Interest-only debt service is principal multiplied by the annual rate. An amortizing loan adds scheduled principal. Debt service coverage is the NOI the lender defines divided by the debt service the lender defines, so the test depends on those definitions and the threshold differs from one lender to the next.

Floors and caps change the arithmetic. A floor stops a falling benchmark from lowering the modeled rate. A cap limits the benchmark only during its term and only on the notional amount it covers. Protection expires, and its expiration date belongs next to the debt schedule.

Debt documents can also change the rate after a breach. A real estate debt agreement may provide a higher interest rate after default or transfer of the collateral property, which raises the payment at the point cash is already short.

Higher rates also reduce what reaches equity. When mortgage rates and the cost of capital rise, more of the property’s cash goes to lenders and less is left as yield for investors.

A fund that states its borrowing as a target shows another angle. One fund document targets debt of 65% of gross real estate assets, tested quarterly, and does not intend to exceed 70% to 75% when acquiring an asset. A ratio of that kind rises when values fall, with no new borrowing at all.

Cost overruns and lease-up delays draw on one reserve

An overrun percentage applies to a specific budget line. When construction is already inside total capital expenditures, a construction cost increase changes that component once. Applying the same increase again to the inclusive total counts the cost twice.

Reserve runway is the cash left after the overrun is paid, divided by the monthly operating deficit. The sequence matters. Once the overrun is funded, only the remaining eligible cash supports operations, and a reserve counted against both uses is counted twice.

Delay compounds the problem. A lease-up that takes longer adds months of carry, and those months may extend past the loan maturity. A reserve that covers the extra carry still leaves the repayment unresolved if no sale, extension or refinancing is assumed to be executable on that date.

Construction cost, occupancy, interest rate and NOI belong in a single run, because the shocks draw on the same cash. A table where each row changes a single input shows which input matters most. It cannot show whether two shocks together exhaust the reserve.

What the offering materials need to contain for a stress test to run

Investors in a syndication typically review a marketing deck and then a private placement memorandum that summarizes the deal and lists its risks. The risk list names categories. A stress test turns those categories into numbers, which requires the underlying inputs.

Those inputs include the business plan, comparable sales and rents, the financials and the underwriting itself. Rent comparables set the size of the rent shock, and the financials set the fixed expense base. The underwriting shows what exit value and refinancing proceeds were assumed.

Depth of review tends to rise with the capital the deal needs and the size of the checks. A larger check justifies rebuilding the model from the rent roll and the loan documents.

Making a commitment subject to satisfactory due diligence gives the stress test a place in the sequence. The findings can then change the terms before capital is committed.

“Part of the property pillar is what’s the business plan.”

Worked example: a hypothetical $10 million property under a combined downside

Both cases use the same hypothetical capital and a one-year period. NOI basis: forward-year stabilized, equal to collected revenue less operating expenses, and excluding debt service, capital expenditures, reserve deposits and sponsor adjustments. The price is $10,000,000, the capital budget is $1,000,000 and the funded reserve is $400,000. Total uses are $10,000,000 plus $1,000,000 plus $400,000, which equals $11,400,000. An interest-only loan of $8,000,000 leaves equity of $11,400,000 minus $8,000,000, which equals $3,400,000. Fees are zero in both cases.

Base case. Full-occupancy revenue is $1,500,000 and occupancy is 90%, so collected revenue is $1,500,000 multiplied by 90 divided by 100, which equals $1,350,000. Operating expenses are $550,000, so NOI is $1,350,000 minus $550,000, which equals $800,000. At a 6% rate, debt service is $8,000,000 multiplied by 6 divided by 100, which equals $480,000. Coverage is $800,000 divided by $480,000, about 1.67 times, and annual cash after debt service is $800,000 minus $480,000, which equals $320,000.

Base-case breakeven occupancy is ($550,000 plus $480,000) divided by $1,500,000. The numerator is $1,030,000 and the result is about 68.67%. The base case sits well above cash breakeven.

Rate sensitivity on base NOI. At 7%, debt service is $8,000,000 multiplied by 7 divided by 100, which equals $560,000, and coverage is $800,000 divided by $560,000, about 1.43 times. At 8%, debt service is $640,000 and coverage is $800,000 divided by $640,000, which equals 1.25 times. Coverage falls to one times when the rate equals $800,000 divided by $8,000,000, which is 10%. Whether any of those levels trips a covenant depends entirely on the loan documents.

Stressed case. Occupancy falls to 75%, rents come in 5% below plan, operating expenses run 10% over and the rate is 8%. The rent factor is 100 minus 5, which equals 95%. The expense factor is 100 plus 10, which equals 110%. Revenue is $1,500,000 multiplied by 75 divided by 100 multiplied by 95 divided by 100, which equals $1,068,750. Expenses are $550,000 multiplied by 110 divided by 100, which equals $605,000. NOI is $1,068,750 minus $605,000, which equals $463,750. Debt service is $640,000, so coverage is $463,750 divided by $640,000, about 0.72 times, and the annual operating deficit is $640,000 minus $463,750, which equals $176,250.

Breakeven occupancy under the stressed rent, the stressed expenses and the 8% rate is ($605,000 plus $640,000) divided by ($1,500,000 multiplied by 95 divided by 100). The numerator is $1,245,000, adjusted full-occupancy revenue is $1,425,000, and breakeven is about 87.37%. Occupancy of 75% sits far below it. The same property that tolerated occupancy down to 68.67% now needs 87.37%.

Reserve. A 20% overrun on the $1,000,000 capital budget costs $1,000,000 multiplied by 20 divided by 100, which equals $200,000. The reserve falls to $400,000 minus $200,000, which equals $200,000. The monthly deficit is $176,250 divided by 12, which equals $14,687.50, so runway is $200,000 divided by $14,687.50, about 13.62 months. After twelve months the reserve holds $200,000 minus $176,250, which equals $23,750, and nothing remains for a second year.

Exit on the same 8% cap rate. Base value is $800,000 divided by 8%, which equals $10,000,000, so the $8,000,000 loan is 80% of value and equity cushion before costs is $2,000,000. Stressed value is $463,750 divided by 8%, which equals $5,796,875. The loan is then about 138% of value, and a sale falls short of the debt by $8,000,000 minus $5,796,875, which equals $2,203,125. Equity is wiped out before any selling cost, and the lender is impaired as well.

Arithmetic pitfalls that make a stress test look sturdier than it is

Scaling NOI by the occupancy decline builds an expense assumption into a revenue shock. If expenses persist during vacancy, the shortcut understates the drop in NOI. In the example, a 15 point fall in occupancy cuts NOI by far more in proportion than the shortcut implies, because the $550,000 of expenses barely moves.

Treating a familiar coverage level as the contractual threshold mixes a scenario setting with a financing term. Lenders define NOI and debt service differently, and the numerator or payment period in the model can differ from the agreement. Reconciling to the contractual definitions shows whether the model tests payment capacity or covenant compliance.

Counting the starting reserve against both an overrun and an operating deficit uses the same cash twice. In the example, the reserve of $400,000 covers a $200,000 overrun and a $176,250 deficit with only $23,750 to spare. Counted separately, each shock looks comfortable.

Running each assumption alone cannot show whether simultaneous stresses exhaust cash. A 75% occupancy by itself, an 8% rate by itself and a 20% overrun by itself each leave the property solvent on some measure. Together they leave almost nothing.

Equating gross sale value with equity recovery ignores the claims paid from proceeds. Selling costs and outstanding debt come first, and separate retained cash only adds to total distributions afterward. Zero sale proceeds and zero total distributions are different boundaries, and equity can be impaired well before either is reached.

Assuming the refinancing will happen sizes the funding gap incorrectly. At maturity the gap is the balance due minus the replacement loan and usable cash. Replacement proceeds entered as a model input remain conditional on a lender agreeing to them at that value and income.

Questions a stress-test checklist for sponsor diligence answers

Does the sources and uses table give every dollar a use and flag which reserves can fund which obligations? The starting cash balance links financing proceeds to the capital budget and shows what is actually available for operating shortfalls.

What occupancy produces NOI equal to debt service under stressed rents and stressed expenses? The answer depends on fixed expenses and on how many units pay rent at the lower level.

At what rate does coverage reach the lender’s own threshold, and at what rate does it reach one times? The first is a covenant boundary and the second a cash boundary, and they sit at different rates.

Do floors and caps apply throughout the hold, and when do they expire? Their terms decide which payments are protected and their expiry dates mark where the protection ends.

How many months of cash remain after the modeled overrun is paid? Runway is the remaining eligible reserve divided by the monthly deficit.

Does a lease-up that takes longer run past the loan maturity? The cash bridge at the maturity date shows how much repayment still depends on a refinancing or extension.

What happens when stressed NOI and a higher exit cap rate arrive together? Selling costs and the loan balance set the residual that is left for equity.

What does the downside waterfall actually pay to the capital position under review? The order of claims and the preferred return terms decide how a reduced pool of cash is split, and a preferred return is a contractual allocation that available cash may not cover.

Which assumption makes this deal different from the others under review? A difference that can be tied to a number in the cash survival or capital recovery tests is easier to judge than one stated in general terms.