Debt Exclusion Input Form
Formula Used
Gross Income = Primary Monthly Income + Secondary Monthly Income
Eligible Exclusion = Debt Paid by Others + Business-Paid Debt + Payoff Debt + Duplicate Debt + Court Offset + Other Verified Exclusion
Verification Adjusted Exclusion = Eligible Exclusion × Verification Strength
Exclusion Cap = Total Monthly Debt × Exclusion Cap Percentage
Accepted Exclusion = Smaller of Verification Adjusted Exclusion and Exclusion Cap
Included Monthly Debt = Total Monthly Debt − Accepted Exclusion
Adjusted DTI = (Included Monthly Debt + Stressed Proposed Payment) ÷ Gross Monthly Income × 100
Reserve Adjusted Capacity = Gross Income × DTI Limit − Included Debt − Monthly Reserve Requirement
How to Use This Calculator
- Enter the gross monthly income used for the finance review.
- Add the total monthly debt before any exclusion.
- Enter each exclusion category that has support or documentation.
- Set the verification percentage based on document strength.
- Choose the exclusion cap and target DTI limit.
- Add a proposed payment and stress multiplier if needed.
- Press the calculate button to view the summary above the form.
- Download the CSV or PDF file for records.
Example Data Table
| Scenario | Income | Total Debt | Eligible Exclusion | Accepted Exclusion | Adjusted Debt | DTI Result |
|---|---|---|---|---|---|---|
| Conservative file | $7,500 | $2,600 | $700 | $560 | $2,040 | 27.20% |
| Strong documentation | $9,700 | $3,100 | $1,720 | $1,548 | $1,552 | 22.49% |
| Limited documentation | $6,800 | $2,900 | $1,200 | $720 | $2,180 | 32.06% |
Debt Exclusion Planning Guide
What Debt Exclusion Means
Debt exclusion is the process of removing certain monthly obligations from a ratio test. It is used when a debt is not expected to remain a real burden. The debt may be paid by another party. It may also be cleared before closing. Some debts can be duplicated in records. Others may be offset by a verified order or agreement.
Why the Calculation Matters
Finance decisions often depend on debt ratios. A high ratio can reduce approval strength. A valid exclusion can improve the file. It can show a cleaner view of repayment capacity. This calculator compares debt before and after exclusion. It also shows the remaining capacity under your chosen limit.
Documentation Quality
Every exclusion should be supported. Strong proof may justify a higher verification percentage. Weak proof should use a lower percentage. This prevents overstatement. The calculator includes a documentation adjustment. It also applies an exclusion cap. These controls make the estimate more realistic.
Using the Result
Review the accepted exclusion first. Then compare the old and adjusted ratios. Check the reserve adjusted capacity. A positive headroom value means more room exists. A negative value means the file may be strained. Use the chart to explain the change visually. Export the result when you need a clean summary.
Important Reminder
This tool gives a planning estimate. It does not replace lender, accounting, or legal guidance. Real rules can vary by program. Always confirm treatment with the party reviewing the file.
FAQs
What is debt exclusion?
Debt exclusion removes a verified obligation from ratio testing. It is used when the debt should not count as an ongoing repayment burden.
Which debts can be excluded?
Common examples include debts paid by others, business-paid debts, debts paid off at closing, duplicate debts, and verified court ordered offsets.
Why does verification strength matter?
It adjusts the exclusion based on proof quality. Strong documents support more confidence. Weak documents should reduce the accepted exclusion estimate.
What does the exclusion cap do?
The cap prevents the accepted exclusion from exceeding a selected share of total debt. It adds a conservative control to the calculation.
What is adjusted DTI?
Adjusted DTI is the ratio after accepted exclusions are removed. It compares remaining debt and stressed proposed payment with gross monthly income.
What does headroom mean?
Headroom is the remaining capacity after included debt, reserves, and proposed payment. Positive headroom shows room under the selected limit.
Can this calculator approve financing?
No. It is a planning tool. Final treatment depends on lender rules, documents, program standards, and reviewer judgment.
Why add a stress multiplier?
A stress multiplier tests the proposed payment with a safety margin. It helps model higher payments or conservative underwriting assumptions.