calculate-loan

01 Loan payments

Can Qualifying Income Be Excluded? Loan Calculator

Calculator No. 01-9741 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

Qualifying income can sometimes be excluded from a loan calculation, but only when it is not part of the income figure you are measuring or when a lender’s documented method permits its removal. This calculator estimates a monthly loan payment and total interest from the loan amount, APR, and term; it does not determine qualifying income, eligibility, or approval.

Formula

The calculator uses the standard fixed-rate, fully amortizing loan payment formula. It calculates the monthly payment as:

Payment = P × r ÷ [1 − (1 + r)−n]

  • P is the starting loan principal, in dollars.
  • r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
  • n is the number of monthly payments, calculated as years × 12.

Total interest is calculated as the displayed monthly payment multiplied by the number of payments, minus principal: interest = payment × n − P. The payment expression is displayed to two decimal places. The total-interest output uses the payment value calculated by the formula before display rounding.

Worked Example

Using the calculator’s default inputs: principal P = $20,000, APR = 8%, and term = 5 years.

  1. Convert the APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
  2. Convert the term to monthly payments: n = 5 × 12 = 60.
  3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = approximately $405.53 per month.
  4. Calculate total interest using the unrounded formula payment: approximately $405.53 × 60 − $20,000 = $4,331.03.

The displayed results are approximately $405.53 per month and $4,331.03 in total interest. Small differences can arise if intermediate values are rounded by hand.

Assumptions

  • The APR remains fixed for the full loan term.
  • Payments are equal monthly payments, made at the end of each monthly period.
  • Interest compounds monthly at APR divided by 12.
  • The estimate excludes fees, taxes, insurance, PMI, and escrow because these are not calculator inputs.

What Qualifying Income Means

“Qualifying income” generally means income a lender considers when assessing an application or calculating a measure such as debt-to-income (DTI). The term does not have one universal definition across all lenders or loan types. A lender may consider factors such as the income source, how it is documented, whether it is expected to continue, and the calculation method used for that product.

“Excluded income” can also mean different things. It might be income a lender does not count toward qualification, or income a borrower chooses to leave out of a personal budgeting calculation. Those are not interchangeable. For a lender decision, the lender’s current documentation requirements and written calculation method control; this page does not model those rules.

When Income May Be Left Out

Income may be omitted from a personal estimate if it is irregular, temporary, uncertain, or unavailable for the payment being assessed. For example, a household making a conservative budget might calculate monthly cash flow using dependable wages and leave out a one-time bonus. That is a planning choice, not a rule about what a lender must accept.

For an application, do not assume that a source can be excluded simply because it is variable or because you would rather not use it. Lenders may have different ways to evaluate recurring, seasonal, self-employment, commission, rental, retirement, or benefit income. They may also request records to establish the source, amount, history, or continuity. Ask the lender which income it will consider and how it calculates the figure; provide information as requested rather than altering or omitting it to influence an outcome.

Qualifying Income and Loan Payment Are Different

This calculator answers a narrow arithmetic question: what would the scheduled payment and interest be for a specified principal, APR, and term under the assumptions above? It cannot tell you whether that payment fits a lender’s income test. A DTI calculation, for example, also needs the debts and income figures specified by the lender’s method; this calculator has no fields for either.

Suppose a person’s documented monthly income includes wages and a variable bonus. Whether the bonus is included in a qualifying-income figure depends on the applicable lender process. Whatever income figure is used, the payment formula itself does not change: principal, rate, and term determine the estimated payment. A longer term generally spreads principal repayment across more scheduled payments, while the total interest depends on the rate, term, and payment schedule.

Common Mistakes and Limits

  • Treating an estimate as an approval result: A calculated payment does not establish eligibility, accepted income, or a lender’s required DTI.
  • Confusing gross and take-home income: Use the income definition required for the calculation you are doing. This payment calculator does not decide which one applies.
  • Leaving out income without checking the purpose: A personal budget may omit uncertain income for caution, but an application should follow the lender’s instructions.
  • Forgetting costs beyond principal and interest: The result excludes any charges or recurring costs not entered, so it may not equal a complete bill or housing payment.
  • Rounding intermediate values: Manual rounding can cause small differences. The calculator displays the monthly payment to cents.

The formula assumes a fixed rate and regular monthly payments. It is not designed for variable rates, irregular payment dates, interest-only periods, balloon payments, fees financed into the balance, or extra payments. If any of those features apply, the actual payment schedule can differ.

Frequently Asked Questions

Can a lender exclude income from a loan application?
It depends on the lender’s process and the income source. Ask what documentation is needed and how each source will be handled. This calculator does not apply lender-specific qualification rules.

Can I leave irregular income out of my budget?
Yes, for a personal estimate you can choose to base a budget on dependable income and treat irregular receipts separately. That budgeting choice does not determine how a lender evaluates an application.

Does qualifying income mean take-home pay?
Not necessarily. The phrase depends on the calculation being used. Confirm whether the requested figure is gross income, net income, or another defined amount before comparing it with debts or payments.

Does this calculator tell me how much I qualify to borrow?
No. It estimates a payment for a loan amount you enter. It does not assess income, debts, credit information, lender criteria, or approval.

Why is the lender’s payment different from this estimate?
The lender’s figure may include items this calculator excludes, use a different rate or term, or reflect payment timing and loan features not modeled here. Review the inputs and the lender’s disclosed payment breakdown.

This result is an estimate for educational arithmetic, and the lender’s disclosure gives the exact figures.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →