Business Loan & Debt Service Calculator

Enter your proposed loan amount, interest rate, and term alongside your net operating income and existing debt obligations to calculate your monthly payment, total interest, DSCR, qualification status, maximum qualifying loan amount, and NOI cushion.

✓ Monthly payment derived from loan terms — enter rate and term, not a pre-calculated payment✓ Total interest paid over loan life — the number most borrowers never calculate before signing✓ DSCR with Approved / At Risk / Below Minimum status vs. your lender's specific threshold✓ Maximum qualifying loan amount — the reverse calculation borrowers actually need✓ NOI cushion — exactly how much income can fall before DSCR breaches the lender minimum✓ Free Excel download✓ No signup required

Download This Calculator

Get the Excel spreadsheet behind this calculator to use offline, customize for your needs, and publish as a web tool using Sheetflow.

Download Excel File

Monthly Payment & Total Interest

Computes your amortized monthly payment from loan amount, rate, and term — and surfaces the total interest paid over the full loan life, the number most borrowers overlook before signing.

DSCR & Qualification Status

Calculates DSCR from your NOI and all debt obligations — new loan plus existing — and compares it against your lender's minimum threshold with an Approved / At Risk / Below Minimum status flag.

Max Qualifying Loan & NOI Cushion

Works backwards from your lender's DSCR minimum to show the largest loan your business qualifies for — and how much NOI can fall before coverage breaches the floor.

Frequently Asked Questions

What is DSCR and how do lenders use it to evaluate a business loan?

Debt Service Coverage Ratio (DSCR) measures whether a business generates enough operating income to cover its loan payments. The formula:

DSCR = Annual Net Operating Income ÷ Annual Total Debt Service

A DSCR of 1.0 means income exactly equals debt payments — the business breaks even on its debt obligations with nothing left over. A DSCR of 1.44 means the business generates $1.44 in operating income for every $1.00 in annual debt payments — a 44% cushion above the minimum needed to service the loan.

Lenders use DSCR as their primary cash-flow underwriting metric because it directly answers their most important question: does this business generate enough income to repay the loan even if conditions deteriorate? A business that qualifies at 1.44x can absorb a 31% decline in income before its DSCR reaches 1.0 — the point where cash flow no longer covers debt service.

DSCR is a coverage ratio, not a profitability metric. A business can be highly profitable on paper but still have a low DSCR if it carries significant existing debt or has low operating income relative to what it's borrowing. Conversely, a capital-light business with modest revenue can have a very high DSCR if its debt obligations are small.

Two variables dominate the calculation: how much you earn (NOI) and how much you owe (total annual debt service, including all existing loans plus the new one). The calculator computes both and surfaces the ratio, the qualification threshold, and the cushion between where you are and where you need to be.

How do I calculate my DSCR when applying for a business loan?

The calculation has four steps. Here is a complete walkthrough using the default scenario — a business owner applying for a $500,000 loan.

  1. Calculate annual net operating income. NOI is revenue minus all operating expenses, before debt service payments and before income taxes. For the default scenario: $120,000. This is the income available to cover loan payments — not gross revenue, and not net income after taxes.
  2. Calculate the monthly payment on the new loan. Using the standard amortization formula (PMT): $500,000 at 7.5% annual rate over 10 years = $5,935.09 per month. Annualized: $71,221 per year. Most borrowers stop here and forget to include step 3.
  3. Add existing annual debt service. If the business has other loans already outstanding — equipment financing, a line of credit, a prior term loan — their annual payments count against the same pool of NOI. Default scenario: $12,000/year in existing debt service. Total annual debt service: $71,221 + $12,000 = $83,221.
  4. Divide NOI by total annual debt service. $120,000 ÷ $83,221 = 1.44× — cleared the typical 1.25× minimum. Status: Approved.

Two additional outputs tell you the shape of the qualification:

  • Maximum qualifying loan: working backwards from the 1.25× DSCR threshold at these terms, the largest loan this business qualifies for is $589,713 — only $89,713 more than the $500,000 being requested. The business qualifies, but barely has room to borrow more.
  • NOI cushion: income can fall by $15,974 (13.3%) before DSCR hits the 1.25× floor. For a business with any revenue volatility, that is a thin margin.

What DSCR is required for different types of business loans?

DSCR requirements vary by lender type, loan program, and how much the lender weighs other factors alongside coverage:

Loan typeTypical minimum DSCR
SBA 7(a) loan1.15–1.25×
SBA 504 loan1.25×
Conventional bank term loan1.20–1.35×
Commercial real estate loan1.25–1.30×
USDA Business & Industry loan1.25×
Credit union business loan1.20–1.25×
Online / alternative lenders1.0–1.15× (with higher rates)

The minimum is not the target. A DSCR at exactly 1.25× will qualify at many banks, but it is a marginal application. A 1.35× or higher is where approvals happen smoothly and terms are favorable. Below 1.25×, lenders may still approve with additional collateral, a personal guarantee, or a co-borrower.

DSCR is global, not per-loan. Most lenders look at the total debt service across all of the business's obligations — not just the loan being requested. Including existing debt payments in the calculation is not optional; lenders will do it in underwriting regardless of what appears on the application.

Lenders stress-test DSCR. Many commercial lenders run a sensitivity analysis: what is DSCR if revenue drops 10–15%? A marginal 1.25× application looks worse after stress-testing. This is the practical purpose of the NOI cushion output — it answers the stress-test question before the lender asks it.

How do I improve my DSCR to qualify for a larger loan?

DSCR has two components: income (NOI) and obligations (total debt service). Improving it means either increasing the numerator or decreasing the denominator.

Increase NOI. The most direct path but often the slowest. Every $1,000 of additional annual operating income adds $1,000 ÷ total debt service to DSCR. For the default scenario where total debt service is $83,221, adding $10,000 in NOI (from $120,000 to $130,000) moves DSCR from 1.44× to 1.56×. Meaningful improvement, but operating income is hard to increase quickly before a loan application.

Extend the amortization term. Longer terms mean lower monthly payments, which reduces annual debt service and raises DSCR. Moving from a 10-year to a 15-year amortization on the same $500,000 at 7.5% reduces monthly payment from $5,935 to $4,635 — saving $15,600 per year in debt service, which improves DSCR from 1.44× to 1.62×. The trade-off is significantly more total interest paid over the life of the loan.

Reduce the loan amount. Borrowing $400,000 instead of $500,000 drops annual new debt service from $71,221 to $56,977. DSCR improves from 1.44× to 1.60×, and the maximum qualifying loan calculation confirms you have more runway.

Pay off existing debt first. The $12,000 in existing annual debt service in the default scenario is fully included in the lender's coverage calculation. If that debt can be retired before applying, the NOI available for the new loan increases by $12,000 per year — improving DSCR from 1.44× to 1.71× without touching the new loan terms.

Lower the interest rate. A rate reduction from 7.5% to 6.5% on a $500,000 10-year loan saves approximately $3,000 per year in debt service, which improves DSCR from 1.44× to 1.48×. Meaningful at the margin, but rate negotiation has less leverage than term extension or loan amount reduction.

Why does a $500,000 loan actually cost $712,000 — and what can I do about it?

The total cost of a loan is the sum of all payments over its full term, not just the principal. On a $500,000 loan at 7.5% over 10 years:

  • Monthly payment: $5,935.09
  • Total payments: $5,935.09 × 120 months = $712,211
  • Total interest: $712,211 − $500,000 = $212,211
  • Interest as a percentage of principal: 42.4%

Most borrowers focus on the monthly payment and are surprised by the total. The $212,211 in interest is real money leaving the business — money that would otherwise be available for investment, payroll, or working capital. The interest as a percentage of principal at common rates and terms:

Rate5-year term10-year term15-year term
5.0%13.4%27.3%42.3%
7.5%20.3%42.4%66.5%
10.0%27.5%58.6%93.4%

The relationship between rate, term, and total interest is nonlinear. A 10% rate over 15 years costs 93% of principal in interest — you repay nearly double what you borrowed. Rate matters, but term is the bigger lever: moving from 10 to 15 years at 7.5% increases total interest from 42.4% to 66.5% of principal, even though monthly payments drop by $1,300.

The practical implication: if you can afford the higher monthly payment, a shorter amortization term saves significantly more in total interest than a rate reduction of 1–2 percentage points. On the default scenario, reducing the term from 10 to 7 years (while staying at 7.5%) cuts total interest from $212,211 to $143,567 — a $68,644 saving at the cost of $1,551 more per month.

The total interest figure also reframes the interest deductibility argument for business owners who rely on the tax deduction to justify borrowing. At a 35% effective tax rate, the after-tax cost of $212,211 in interest is approximately $137,937 — still a significant cash outflow relative to the principal borrowed, and worth understanding before committing to long-term debt.

Transform Your Excel Models into Web Tools

Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.

Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.