Debt-to-Income Calculator Modello Essentials
Calculate your debt-to-income ratio by listing monthly debts and income. Commonly used when evaluating mortgage or loan qualification thresholds.
Cosa include
- Calculator with DTI ratio output displaying front-end and back-end percentages based on your entries
- Monthly debt entry section for mortgage, car payments, student loans, credit cards, and other obligations
- Gross income input fields for salary, wages, rental income, and other sources of monthly earnings
- Front-end and back-end ratio display with common lender threshold reference values for comparison
- Color-coded result indicators that flag whether your DTI ratio falls within typical qualification ranges
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Anteprima
Scopri cosa contiene questo modello
Come usare questo modello Debt-to-Income Calculator
Enter monthly debts
List all monthly debt payments - mortgage, car loan, student loans, credit cards, and any other obligations.
Enter gross income
Add all sources of monthly gross income including salary, wages, rental income, and other earnings before taxes.
Read your DTI ratio
The calculator displays your front-end and back-end debt-to-income ratios as percentages. Lower is generally preferable.
Compare to thresholds
Reference values for common lender thresholds are shown alongside your ratio so you can see how your DTI compares.
Creati da Claude AI. Perfezionati da noi.
Utilizziamo Claude AI per creare ogni modello, dopo una ricerca approfondita. Poi interviene il nostro team. Miglioriamo il layout, testiamo ogni formula, correggiamo i casi limite e rifiniamo il design fino a ottenere qualcosa che useremmo noi stessi. L'AI ci porta all'80%. L'ultimo 20% è tutto giudizio umano.
Domande frequenti
What is front-end vs back-end DTI?
Front-end includes only housing costs (mortgage, taxes, insurance). Back-end includes all monthly debt obligations. Lenders typically look at both ratios.
What DTI ratio do lenders prefer?
Common thresholds are 28% front-end and 36% back-end, though requirements vary by lender and loan type. The template shows these reference values for comparison.
Do I use gross or net income?
Debt-to-income ratios use gross (pre-tax) income. Enter your monthly earnings before any deductions or withholdings.
What debts should I include?
Include minimum monthly payments for mortgages, car loans, student loans, credit cards, personal loans, and any other recurring debt obligations.
Come posso aprirlo in Google Sheets?
Carica il file .xlsx su Google Drive, poi aprilo con Google Sheets. Tutte le formule e la formattazione saranno conservate.
Altri modelli Essentials Debt Management
Cerchi modelli di fogli di calcolo premium?
I nostri modelli a pagamento includono dashboard multi-foglio avanzate, grafici nativi Excel e aggiornamenti continui.
Privato e sicuro
I tuoi dati finanziari restano sul tuo dispositivo. Non li vediamo mai.
Scopri di piu →