Free Debt-to-Income (DTI) Ratio Calculator
Your Debt-to-Income (DTI) ratio is one of the most critical metrics in personal lending. Lenders look at two ratios: Front-End DTI (housing expenses divided by gross monthly income) and Back-End DTI (all recurring monthly debt payments divided by gross monthly income). This spreadsheet helps you accurately project your ratios prior to applying for a conventional mortgage, FHA loan, VA loan, or auto financing.
Prefer not to use a spreadsheet?
Track this free in your browser with zero setup or sign-up.
Purpose & Design
Measure your borrowing health by calculating the exact debt-to-income percentages that mortgage underwriters and commercial lenders use to evaluate loan approvals.
Included Worksheets:
Key Formulas & Calculations
This workbook comes pre-programmed with verified Excel formulas that recalculate instantly as you update your data:
- ✓Total Monthly Debt = Housing Payment + Auto Loans + Student Loans + Credit Card Minimums + Other Debt
- ✓Back-End DTI Ratio = (Total Monthly Debt Payments / Monthly Gross Income) * 100
- ✓Front-End DTI Ratio = (Housing Payment / Monthly Gross Income) * 100
How to Use This Spreadsheet
- 1Input your total gross monthly income (pre-tax salary, wages, and verified steady bonus or side income).
- 2Enter your anticipated or current monthly housing payment (including mortgage principal, interest, taxes, and homeowner insurance).
- 3Record all regular installment and revolving minimum debt payments: auto loans, student loans, and credit card minimums.
- 4Review the calculated Back-End DTI percentage against conventional underwriting thresholds (typically 36% to 43%).
- 5Adjust loan balances or debt payments to see how paying off specific debts improves your borrowing power.
Who Benefits from This Template?
- 💡Prospective homebuyers preparing to apply for pre-approval on a mortgage.
- 💡Consumers planning auto purchases who want to ensure financing terms remain comfortably affordable.
- 💡Individuals seeking a comprehensive health check on their recurring monthly debt obligations.
Prefer not to use a spreadsheet?
Track this free in your browser with zero setup or sign-up.
Frequently Asked Questions
What is a good DTI ratio for a mortgage approval?
Most conventional mortgage lenders prefer a back-end DTI of 36% or lower, though many loan programs permit DTIs up to 43%, and certain FHA or VA programs allow higher ratios with compensating factors.
Do living expenses like groceries and utilities count toward DTI?
No. Lenders only count contractual debt obligations reported on your credit bureau files (credit cards, loans, mortgages) and child support/alimony. Groceries, utilities, and subscriptions are not included in official DTI math.