The break-even row is where cash flow reaches zero and coverage reaches 1.00x, because those are the same statement measured from different ends. Below it the owner funds the difference.
| Occupancy | Collections | NOI | Cash flow after debt | DSCR |
|---|---|---|---|---|
| 100.0% | $1,000,000 | $650,000 | $170,000 | 1.35x |
| 95.0%Underwritten | $950,000 | $600,000 | $120,000 | 1.25x |
| 90.0% | $900,000 | $550,000 | $70,000 | 1.15x |
| 85.0% | $850,000 | $500,000 | $20,000 | 1.04x |
| 83.0%Break-even | $830,000 | $480,000 | $0 | 1.00x |
| 80.0% | $800,000 | $450,000 | ($30,000) | 0.94x |
| 75.0% | $750,000 | $400,000 | ($80,000) | 0.83x |
Annual convention throughout, and the occupancy factor is applied to the whole gross potential income. During an interest-only period debt service is lower and this number is lower with it; run it again on the amortizing payment, because that is the break-even the deal lives with for most of the term. It measures cash, not value: a property can sit above break-even and still be worth less than it cost.
Everything above is computed in your browser. Nothing you type is sent to Altyst or to the site hosting this calculator, and this frame sets no cookie. It is arithmetic on the figures you entered, not investment or lending advice.
One year of one scenario. A real underwriting builds the NOI from the rent roll and the T-12 and runs this for every year of the hold, including the year amortization starts. Altyst reads the documents and does all of it.