Financing stress-test calculator: cash flow, DSCR and refinancing gaps
Test two different questions: can the property cover scheduled debt payments, and can you fund the balance due at maturity? A positive annual cash-flow result does not answer both.
Your Expert Online editorial tool · Updated 22 October 2026 · USD · No account needed.
Real-estate financing stress-test calculator
Start with the hypothetical example or enter your own assumptions. All money inputs are in US dollars; income, expenses and debt payments are annual. This compares scenarios—it does not decide whether a deal is suitable.
Read the companion guide: Before You Sign the Loan.
Your scenario comparison
NOI less debt service is before capital projects, income taxes and other excluded cash uses; it is not distributable profit. A DSCR above 1 does not establish a safe investment or lender approval. If debt service is zero, DSCR is not applicable.
How to run a useful financing stress test
- Start with collected income and operating expenses. Use annual figures and source documents. Income should already reflect vacancy and collection losses. Keep capital projects and loan payments separate from operating expenses.
- Enter annual principal and interest. If your quoted payment includes escrow for taxes and insurance, separate those amounts so they are not counted again in operating costs. The loan calculator can illustrate a fixed monthly principal-and-interest payment.
- Stress income and expenses together. Enter an income decrease and an expense increase. Then enter replacement-loan debt service to see whether that same stressed property income can support the assumed refinancing payment.
- Calculate maturity cash separately. Use principal expected to remain at maturity, assumed replacement proceeds, cash refinancing costs and cash genuinely earmarked for the gap.
Worked example: coverage falls before the cash gap disappears
Hypothetical illustration. Annual collected income of $180,000 less $60,000 in operating expenses gives $120,000 NOI. With annual debt service of $90,000, DSCR is 1.33×, leaving $30,000 before capital projects, income taxes and other excluded cash uses.
Reduce income by 10% to $162,000 and raise expenses by 10% to $66,000. NOI falls to $96,000. Coverage is now 1.07×, leaving $6,000. With replacement debt service of $105,000, coverage becomes 0.91× and NOI is $9,000 short of debt service.
Separately, $800,000 of principal due plus $20,000 cash refinancing costs, less $700,000 replacement proceeds, creates a $120,000 maturity gap. Applying $60,000 of earmarked cash still leaves $60,000 unfunded. The annual operating result and this one-time gap must not be added together as though they share the same period.
How to read DSCR without overreading it
A ratio of 1 means modeled NOI equals scheduled debt service. It does not cover every cash need or establish lender approval. Lenders may use different income adjustments and covenant definitions. With zero debt service, the ratio is shown as not applicable. Negative NOI is retained rather than hidden.
Turn the output into a document request
For each assumption, record the source, date and reason it could change. Obtain the loan schedule for the maturity balance, evidence for replacement proceeds and a budget for cash refinancing costs. Keep operating reserves separate from cash available to fill the gap.
Read Before You Sign the Loan for the broader decision framework, use the checklist below for open questions, and budget capital work with the renovation calculator. The calculator is an editorial tool from Your Expert Online, not a claim that Naor has reviewed your figures.
Before-you-sign financing checklist
Check items as you review them. Print a blank copy for a meeting, or print your checked items. The print version includes space for notes, sources and unresolved questions.
Print opens a clean page in a new tab. Use your browser’s Save as PDF destination if you prefer a file.
Financing stress-test definitions
How are the scenarios calculated?
Net operating income (NOI) = collected property income − operating expenses. DSCR = NOI ÷ annual debt service. Operating stress reduces income by your selected percentage and increases expenses by your selected percentage, keeping current debt service unchanged. The refinancing scenario uses that same stressed NOI with your replacement-loan annual debt service.
Refinancing gap = the greater of zero and (principal due + cash refinancing costs − replacement proceeds). Unfunded gap = the greater of zero and (refinancing gap − cash earmarked for it). Any proceeds above the principal and costs are shown separately, before lender restrictions and other uses.
What does this calculator leave out?
It does not model an amortization schedule, changing rates, taxes on income, capital expenditure, sale proceeds, lending eligibility or lender-specific covenant definitions. Loan payments are inputs, not quoted offers. Timing differences within a year can still create cash shortages. Use documented assumptions and confirm loan terms with your lender.
Where does the framework come from?
The tool is Your Expert Online’s editorial application of cash-flow and refinancing questions discussed in the companion guide, which cites Naor Gozlan’s published forum writing. It is not a claim that Naor reviewed your figures.
For definitions and context: OCC Commercial Real Estate Lending handbook (DSCR, pages 42–43); OCC refinance-risk guidance; and CFPB’s explanation of principal, interest and other payment costs. Definitions checked 21 October 2026.