The model is confessing. Read it that way.
Every spreadsheet has one or two numbers quietly carrying the sales pitch. Find them before they start carrying your money.
If one assumption saves the deal, it is not conservative. It is fragile. The useful move is not memorizing "DSCR (debt service coverage ratio)." It is knowing what you would verify next.
DSCR is net operating income divided by annual debt service.
NOI / annual debt service = DSCR
If NOI is $780,000 and annual debt service is $650,000:
$780,000 / $650,000 = 1.20x
That means the property produces $1.20 of NOI for every $1.00 of debt service. The thinner that cushion, the less room the business plan has to trip.
DSCR is the pressure gauge between the property’s operations and its loan payment. At 1.20x, the gauge does not say “great deal.” It says the modeled NOI covers debt service with twenty cents per dollar left before the other claims on cash start introducing themselves.
This gauge measures survival, not applause
DSCR is not a return metric. It is a survival metric.
| If this changes | DSCR moves because |
|---|---|
| Occupancy drops | NOI falls |
| Insurance jumps | NOI falls |
| Interest rate rises | Debt service rises |
| Amortization begins | Debt service rises |
| Taxes reassess | NOI falls |
A property can show a nice equity multiple and still have ugly debt coverage. The lender cares about the payment, not the pitch.
That is the useful cruelty of DSCR. It ignores the beautiful five-year story and asks whether this year’s operations can carry this year’s debt.
Interest-only can pad the gauge
Suppose a model uses interest-only debt at $610,000 per year.
| Case | NOI | Debt service | DSCR |
|---|---|---|---|
| Interest-only year | $780,000 | $610,000 | 1.28x |
| Amortizing year | $780,000 | $720,000 | 1.08x |
| NOI miss plus amortization | $725,000 | $720,000 | 1.01x |
That is how a deal can look comfortable early and then start breathing through a straw.
The first row did not prove the debt was comfortable. It proved the payment was temporarily smaller. When amortization begins, the same NOI produces 1.08x. Miss the NOI as well and 1.01x leaves one cent of modeled coverage per debt-service dollar. That is not a cushion. It is upholstery.
Read the loan before trusting the dial
Read the lender term sheet for interest rate, amortization, maturity, interest-only period, reserve requirements, rate caps, covenants, and extension tests.
Then read the model to see which of those terms actually made it into the cash flow. Debt details left outside the model are not details. They are traps with paperwork.
Check the items that can move either side of the ratio:
- Rent roll, occupancy, collections, and the operating statements supporting NOI.
- Current tax bill, insurance quote, and any reassessment or premium assumptions.
- Loan term sheet and draft loan documents for rate, amortization, interest-only period, and covenants.
- Rate-cap terms, reserve requirements, extension tests, and maturity date.
The model is the gauge face. Those documents are the pressure line. A clean display connected to invented inputs is just office decoration.
Find the year with the least room
Build a DSCR calendar by year:
| Year | NOI | Debt service | DSCR | Note |
|---|---|---|---|---|
| 1 | $___ | $___ | ___x | Interest-only? |
| 2 | $___ | $___ | ___x | Renovation disruption? |
| 3 | $___ | $___ | ___x | Amortization begins? |
Then lower NOI by 5% and raise debt service by 5%. If DSCR barely survives the base case, do not let projected upside do the lender’s job.
Average DSCR can smooth over the exact year when renovation disrupts income, amortization starts, or a rate cap expires. Debt is paid by date, not by the emotional average of five columns.
Make the tightest reading explain itself
Ask which year has the lowest DSCR and why. Average DSCR can hide one ugly year, and one ugly year can be enough.
Your next move is to circle the lowest annual DSCR, trace its NOI and debt service to source documents, and rerun that year with the required 5% stress in both directions. If the pressure gauge is already near the edge in the base case, upside is not a repair kit.
PR Steinfurth Equity provides educational information only. Nothing on this website is an offer to sell or a solicitation of an offer to buy any security, nor investment, legal, or tax advice. Any securities offering is made only to qualified investors through official offering documents. Real estate investments involve risk, including possible loss of principal. Past performance is not indicative of future results.