Loan Affordability Formula
Learn how a loan affordability calculator estimates a manageable monthly payment and converts it into an estimated loan amount.
A loan affordability calculator estimates how much you may be able to borrow by comparing your debt ratio limit with the income left after living costs and existing debts. The lower monthly payment estimate is then converted into a loan amount using a standard amortizing loan formula.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Affordable Loan Amount
Where:
First find a monthly payment that fits both your target debt-to-income ratio and your remaining budget after expenses. Then calculate the present value of that payment stream over the chosen loan term and interest rate.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| monthlyIncome - Monthly income | Gross monthly income before deductions. | currency |
| debtToIncomeRatio - Target debt-to-income ratio | Maximum share of monthly income you want total debt payments to use. | percent |
| monthlyDebtPayments - Monthly debt payments | Current required monthly debt payments such as loans and credit cards. | currency |
| monthlyLivingExpenses - Monthly living expenses | Regular monthly non-debt costs such as housing, food, utilities, and transport. | currency |
| recommendedMonthlyPayment - Recommended monthly payment | Affordable monthly payment based on the lower of debt-ratio capacity and income left after expenses. | currency |
| annualInterestRate - Annual interest rate | Estimated yearly borrowing rate entered by the user. | percent |
| monthlyInterestRate - Monthly interest rate | Annual interest rate converted to a monthly decimal rate. | N/A |
| loanTermYears - Loan term | Repayment length in years. | years |
| numberOfPayments - Number of payments | Total number of monthly repayments over the full term. | months |
Step-by-Step Calculation
Calculate the maximum debt load from the target ratio
This estimates the most you want all monthly debt payments to reach based on your chosen debt-to-income ratio.
maxTotalDebtPayment = monthlyIncome * (debtToIncomeRatio / 100)
Find room for a new loan within the debt ratio
Subtract existing debt payments from the total debt limit to find how much space remains for a new payment.
availableMonthlyPayment = max(0, maxTotalDebtPayment - monthlyDebtPayments)
Calculate income left after expenses and current debts
This shows how much money remains after regular living costs and current debt obligations.
discretionaryAfterExpenses = monthlyIncome - monthlyLivingExpenses - monthlyDebtPayments
Choose the more conservative affordable payment
The calculator uses the lower of the two affordability limits so the estimate stays within both debt-ratio and cash-flow constraints.
recommendedMonthlyPayment = max(0, min(availableMonthlyPayment, discretionaryAfterExpenses))
Convert the annual rate to a monthly rate
Loan amortization is usually based on monthly payments, so the annual rate is converted to a monthly decimal.
monthlyInterestRate = annualInterestRate / 100 / 12
Calculate the total number of payments
This gives the number of monthly installments over the chosen repayment term.
numberOfPayments = loanTermYears * 12
Estimate the affordable loan principal
This is the standard present value formula for a fixed-payment loan. It converts an affordable monthly payment into an estimated loan amount.
affordableLoanAmount = recommendedMonthlyPayment * ((1 - pow(1 + monthlyInterestRate, -numberOfPayments)) / monthlyInterestRate)
Example: estimating an affordable personal loan
Maximum total debt payment
$5,000 × 0.36
$1,800
Available monthly payment from debt ratio
$1,800 - $500
$1,300
Income left after expenses and debts
$5,000 - $1,800 - $500
$2,700
Recommended monthly payment
min($1,300, $2,700)
$1,300
Monthly interest rate and number of payments
8% / 12 = 0.006667; 5 × 12 = 60
0.006667 monthly rate and 60 payments
Affordable loan amount
$1,300 × ((1 - (1 + 0.006667)^(-60)) / 0.006667)
About $52,932
Final Result
Estimated affordable loan amount: about $52,932, with an estimated monthly payment of $1,300.
Assumptions
- ✓Income, expenses, and debt payments are entered as steady monthly amounts.
- ✓The new loan uses fixed monthly repayments for the full term.
- ✓The interest rate stays constant over the repayment period.
- ✓No fees, taxes, insurance, or penalties are added unless reflected in the user's own affordability buffer.
Limitations
- !Actual lender affordability checks may use different rules, thresholds, or credit criteria.
- !Irregular income, seasonal expenses, or future changes in costs are not captured well by a simple monthly model.
- !The formula assumes a standard amortizing loan and may not fit interest-only or balloon-payment structures.
- !Very low or zero interest situations may need a different handling method than the standard amortization formula.
Common Mistakes to Avoid
Entering net income in one field but thinking the result is based on gross income.
Leaving out minimum credit card payments or other required debts.
Using unrealistically low living expenses to increase the estimate.
Confusing debt-to-income ratio with the share of income left after all expenses.
Assuming the estimated affordable amount is the same as a lender approval amount.
Related Formulas
Frequently Asked Questions
What formula is used to calculate loan affordability?
The calculator first finds an affordable monthly payment using your target debt ratio and your remaining budget after expenses. It then applies the standard loan present value formula to estimate the loan amount that payment can support.
Why does the formula use the lower of two payment limits?
Using the lower number makes the estimate more conservative. It helps avoid a result that fits a debt ratio on paper but not your actual monthly budget.
How is debt-to-income ratio applied in the calculation?
The calculator multiplies monthly income by the target debt-to-income ratio to estimate the maximum total monthly debt load, then subtracts existing debt payments.
How do interest rate and term affect the result?
A lower rate or longer term usually increases the loan amount supported by the same monthly payment, while a higher rate or shorter term usually reduces it.
Does this formula include fees or insurance?
No. The core formula only estimates principal affordability from payment capacity, rate, and term. Other borrowing costs are not built in unless you allow for them in your budget.
Can I use this formula for any type of loan?
It works best for fixed-payment installment loans. It is less suitable for interest-only loans, revolving credit, or loans with changing rates and payment structures.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.