Breakeven occupancy and reserve runway calculator

This calculator finds the occupancy at which a property’s income exactly covers operating expenses and debt service, then tests today’s occupancy against that line. It shows net operating income and cash flow after debt service at the current occupancy, and when that cash flow is negative it converts the reserves into months of runway. It answers how much vacancy a deal can absorb before the sponsor has to fund the gap.

Formulas

• Breakeven occupancy = (operating expenses + debt service) / (gross potential rent + other income at full occupancy)
• Net operating income = (gross potential rent + other income) x occupancy - operating expenses
• Cash flow after debt service = net operating income - debt service
• Reserve runway in months = reserves / (monthly shortfall), where monthly shortfall = negative cash flow / 12

Worked example with the starting inputs

With the starting inputs in the form (annual gross potential rent $1,200,000; annual other income at full occupancy $60,000; annual operating expenses $480,000; annual debt service $420,000; current occupancy 88 percent; cash reserves available $150,000), the results are: breakeven occupancy: 71.4 percent; net operating income at current occupancy: $628,800; cash flow after debt service: $208,800; reserve runway: No monthly shortfall.

These inputs are hypothetical and are shown only so the arithmetic can be checked by hand.

What breakeven occupancy and reserve runway mean in a real deal

Breakeven occupancy is the share of potential income a property must collect to pay operating expenses and debt service. Below it, the sponsor writes checks from reserves or calls capital from limited partners.

The numerator adds annual operating expenses to annual debt service, such as 480,000 plus 420,000, which gives 900,000 of yearly obligations. The denominator is gross potential rent plus other income at full occupancy, the figures a lender reads from the rent roll and trailing operating statement. Lenders compare this to debt service coverage, and a limited partner reading the offering memorandum uses it to gauge the sponsor’s margin of safety.

How to read and stress the result

Compare breakeven occupancy with current occupancy first. If the gap to the underwriting case is narrow, test a lower occupancy and a higher expense line, then watch how fast the reserve runway shortens.

Stress the inputs one at a time. Lower other income if parking or fee revenue depends on a few tenants. Raise operating expenses to reflect the property tax reassessment an appraiser may assume after a sale. Raise debt service to match a floating-rate loan at its cap. Then check net operating income against the cap rate used at acquisition, because weaker income changes the value an appraiser will support.

Where the result misleads

The runway assumes a constant monthly shortfall, yet leasing commissions and tenant improvements arrive in lumps. A reserve balance already pledged to those items is not available to cover debt service.

Definitions differ across documents. The loan agreement may require a lender controlled reserve account, a cash sweep or a minimum debt service coverage test that trips well before breakeven is reached, so the practical cushion is smaller than the calculator shows. The term sheet may count other income differently, and an appraiser may haircut it. Physical occupancy can also exceed economic occupancy once concessions and bad debt are counted. Read the output next to the operating agreement and the limited partner reporting package. Talk to Richard.