Business Loan Affordability and Debt-Service Coverage Calculator
Use the Business Loan Affordability and Debt-Service Coverage Calculator
Estimate operating income available for debt service, requested-loan payment, combined DSCR, post-debt cash flow, and maximum affordable borrowing.
- Combined debt-service coverage
- Maximum affordable borrowing
- Complete loan schedule
Use normalized recurring revenue and operating expenses from reliable financial statements. Stress-test lower revenue, higher expenses, and higher rates before accepting a debt commitment.
What this calculator covers
Inputs you can model
- Currency
- Annual revenue
- Annual cost of goods sold
- Annual operating expenses
- Existing annual debt service
- Requested loan amount
- Annual interest rate %
- Loan term
- Target debt-service coverage ratio
- First payment date
Results you can review
- Meets target coverage
- Estimated loan capacity available
- Requested loan within estimated capacity
- Debt-service coverage ratio
- Operating income available for debt service
- Annual cash flow after debt service
- Monthly requested-loan payment
- New annual debt service
- Total annual debt service
- Maximum affordable monthly payment
Method, policy basis, and limitations
How the estimate is built
Revenue less cost of goods sold and operating expenses produces income available for debt service. The requested loan is amortized, combined with existing annual debt service, and compared with the selected target DSCR.
Important limitation
This is not a credit decision, covenant calculation, cash-flow forecast, or lender commitment. Taxes, owner drawings, working-capital needs, balloon payments, seasonal volatility, collateral, fees, and lender-specific EBITDA adjustments are excluded.
Your inputs
Enter the values you know. Required fields should be completed first, and optional fields can be left blank if they do not apply to your situation.
Run the calculator to see the planning signal, key measures, reconciliation detail, and any schedules or stress scenarios returned for these inputs.
Your results
The top cards show the most important answers first. Detailed schedules, scenario tables, and supporting notes appear underneath for deeper review.
Inputs changed. Run the calculator again to refresh these results; copy, print, PDF, and Excel actions are unavailable until then.
This is not a credit decision, covenant calculation, cash-flow forecast, or lender commitment. Taxes, owner drawings, working-capital needs, balloon payments, seasonal volatility, collateral, fees, and lender-specific EBITDA adjustments are excluded.
