Model a car purchase-price ceiling from gross monthly income, other debts, a selected total-debt limit, down payment and nominal loan terms.
The selected percentage applies to total monthly debt, including existing debt and the proposed car payment. Payment headroom is gross monthly income times that percentage, less other monthly debts, with a zero floor. The percentage is an entered assumption, not a recommended threshold or lender approval rule.
The modeled loan uses equal end-of-month payments and annual nominal interest divided by 12. Adding the entered down payment gives the purchase-price ceiling. The gross remainder is before taxes and living expenses; taxes, fees, trade-in value, insurance, fuel and other ownership costs are not modeled. A negative gross remainder stays visible and has no allocation chart.