DSCR and debt yield, modeled from live assumptions.
Enter your NOI, loan terms, and amortization schedule — Tenantvein calculates DSCR, debt yield, and coverage sensitivity instantly.
Request AccessThree steps to structured output.
Input assumptions
Enter NOI (or let Tenantvein pull it from the rent roll abstraction), loan amount, interest rate, amortization period, and IO period if applicable.
Automated calculation
Tenantvein runs the full debt service coverage calculation, amortization schedule, and debt yield metric — with sensitivity analysis across NOI and rate scenarios.
Review and export
Download the modeled amortization schedule, coverage table, and sensitivity matrix to Excel for your IC deck.
What Tenantvein models.
Debt Service Coverage Ratio
DSCR calculated from NOI and annual debt service — with IO period handled correctly.
Debt Yield
Debt yield (NOI ÷ loan balance) as a lender-side metric, computed alongside DSCR.
Amortization Schedule
Full 30-year amortization table generated from inputs, downloadable to Excel.
Sensitivity Matrix
DSCR across NOI scenarios (−20% to +20%) and rate scenarios (±100bps) in a single table.
LTV Crosscheck
Maximum loan proceeds at target DSCR and maximum LTV — both computed in one pass.
Breakeven Analysis
Minimum occupancy and minimum rent required to cover debt service at current assumptions.
Sample DSCR Output
Representative output. Every figure is traceable to the source document.
| Metric | Value | Threshold | Status |
|---|---|---|---|
| Stabilized NOI | $1,614,000 | — | |
| Loan Amount | $18,500,000 | — | |
| Interest Rate | 6.75% | — | |
| Annual Debt Service | $1,437,200 | — | |
| DSCR | 1.12x | 1.25x min | Below Min |
| Debt Yield | 8.72% | 8.0% min | Pass |