Debt-to-Income Calculator قالب Essentials
Calculate your debt-to-income ratio by listing monthly debts and income. Commonly used when evaluating mortgage or loan qualification thresholds.
ماذا يتضمن
- 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
معاينة
اطلع على محتويات هذا القالب
كيفية استخدام قالب 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.
صُممت بواسطة Claude AI. أتقنّاها نحن.
نستخدم Claude AI لصياغة كل قالب بعد بحث معمّق. ثم يتدخل فريقنا. نحسّن التصميم، ونختبر كل صيغة، ونعالج الحالات الاستثنائية، وننقّح التصميم حتى يصبح شيئاً نستخدمه نحن فعلاً. الذكاء الاصطناعي يوصلنا إلى 80%. الـ 20% المتبقية هي حكم بشري بالكامل.
الأسئلة الشائعة
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.
كيف أفتح هذا في Google Sheets؟
ارفع ملف .xlsx إلى Google Drive، ثم افتحه باستخدام Google Sheets. جميع الصيغ والتنسيقات ستبقى محفوظة.
المزيد من قوالب Essentials في Debt Management
تبحث عن قوالب جداول بيانات احترافية؟
القوالب المدفوعة تشمل لوحات معلومات متعددة الأوراق متقدمة، ورسوم بيانية أصلية في Excel، وتحديثات مستمرة.