Break-even collections for debt service and required reserves

Break-even collections should cover the obligations the owner actually intends to fund. A property can cover scheduled debt service while failing to fund required reserves, taxes omitted from the operating model or essential capital work. Define the cash obligations first, then solve for the collection level that pays them without counting the same expense twice.

The OCC commercial real estate handbook’s cash-flow and DSCR discussion explains why the income and debt-service definitions matter. The calculation below is a hypothetical cash budget. Its break-even threshold is not a lender covenant unless the actual documents adopt the same definition.

Separate fixed and collection-sensitive costs

Assume annual contractual billings of $1.2 million. Fixed operating costs are $360,000. Variable operating costs equal 10% of actual cash collections. Scheduled annual debt service is $420,000. Required cash reserve deposits are $60,000 and are not already included in operating expenses.

Let C represent annual collections. Cash after all specified obligations is:

C − 0.10C − 360,000 − 420,000 − 60,000 = 0.90C − 840,000

Setting that result to zero gives required collections of $933,333.33, or 77.778% of the $1.2 million billing base. If the model ignores reserve deposits, the threshold falls to $866,666.67, or 72.222%. The 5.556 percentage-point difference is the cash consequence of funding the reserve, not a change in physical occupancy.

Keep collections distinct from occupancy

A building can be physically occupied while rent is unpaid or reduced by concessions. The billing base may itself reflect vacant space, lease terms and changes during the year. Dividing required collections by contractual billings measures a collection ratio against that stated base; it does not calculate the percentage of occupied units or square feet.

If the $1.2 million base is gross potential rent rather than actual contractual billings, say so and bridge vacancy and concessions to billed rent first. Otherwise the denominator can conceal a second loss allowance. The question is how much cash arrives, not whether a spreadsheet uses a familiar occupancy label.

Reconcile the reserve convention

At $960,000 of collections, variable costs are $96,000 and operating cash before debt is $504,000. DSCR using $420,000 of debt service is 1.20x. After debt service, $84,000 remains; after the $60,000 reserve deposit, free cash is $24,000.

If a lender instead deducts the same $60,000 reserve allowance in its cash-flow numerator, the resulting measure is $444,000 ÷ $420,000 = 1.057x. Both ratios can be calculated correctly under different definitions. Do not subtract the reserve in the numerator and then use that already reduced cash flow to fund the identical deposit a second time in the cash budget.

A noncash underwriting allowance and an actual required deposit may also differ. Record each separately, reconcile their purpose and use only actual cash movement in the bank-account projection.

Add capital needs without obscuring the base threshold

Suppose a $90,000 capital project must be paid during the year and cannot be funded from the restricted reserve. Full-year required collections become ($840,000 + $90,000) ÷ 0.90 = $1,033,333.33, or 86.111% of billings. At the same $960,000 collections, the project turns the $24,000 surplus into a $66,000 deficit.

If the reserve may pay $50,000 of that project under the actual agreement, distinguish the reserve withdrawal from operating collections. The operating account then pays $40,000 of project cost, leaving a $16,000 deficit. The reserve account separately receives $60,000 and pays $50,000, increasing its balance by $10,000 before any other activity. The withdrawal is not new property income.

Solve a reserve that changes with collections

Now replace the fixed $60,000 deposit with a different, entirely fictional requirement: annual deposits equal the greater of $60,000 or 8% of actual collections. No other assumptions change. The deposit switches branches where 0.08C = $60,000, or C = $750,000. A solution must satisfy both the cash equation and the branch condition.

For collections at or below $750,000, the fixed-deposit equation remains 0.90C − $840,000 = 0. Its candidate solution is $933,333.33, which is outside that branch and therefore invalid. At the breakpoint itself, cash is 0.90 × $750,000 − $840,000 = negative $165,000; the property has not reached break-even.

For collections above $750,000, the deposit is 0.08C and cash becomes C − 0.10C − 0.08C − $780,000 = 0.82C − $780,000. Break-even is $951,219.51, or 79.268% of the $1.2 million billing base. This solution is valid because it is above the breakpoint. Holding the deposit at $60,000 while solving collections would understate the required level by $17,886.18.

The $90,000 capital-year test must use the same branch logic. Its variable-deposit solution is ($780,000 + $90,000) ÷ 0.82 = $1,060,975.61, or 88.415% of billings, and is also above the breakpoint. If an explicitly permitted $50,000 reserve release funds part of the project, operating collections must fund only the remaining $40,000: ($780,000 + $40,000) ÷ 0.82 = $1 million. At that level the reserve receives $80,000 and releases $50,000, increasing by $30,000. The account reconciliation agrees with the operating cash equation; the release is not revenue.

At $960,000 collections, the variable reserve deposit is $76,800. Free cash before capital is $960,000 − $96,000 − $360,000 − $420,000 − $76,800 = $7,200, compared with $24,000 under the earlier fixed-deposit structure. The $16,800 difference is exactly the extra deposit. This piecewise method applies only to the stated fictional requirement; an actual monthly test, reserve cap, suspension condition or release rule would need its own dated calculation.

Test the timing as well as the annual total

An annual break-even result does not prove every month is funded. Assume the $90,000 project is due in month 2 while a large tenant’s annual rent is paid in month 6. Even if full-year collections reach $1,033,333.33, the early invoice may need working capital. Build a monthly schedule using actual payment timing rather than allocating all receipts evenly for convenience.

Include opening unrestricted cash, monthly collections, expenses, debt, reserve deposits, eligible reserve releases and capital payments. The minimum cumulative balance identifies the peak additional cash requirement. Keep a minimum operating buffer as a separate planning target; zero cash may balance the arithmetic while leaving no tolerance for a late payment.

The final worksheet should display at least three thresholds: operations plus debt, operations plus debt and required reserves, and all specified obligations including capital. Label the collection denominator and the expense convention beside each result. That makes the break-even figure a usable cash-management tool instead of a percentage whose meaning changes from one conversation to the next.