calculate-loan

01 Loan payments

Loan Amount Estimator: How It Works

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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.

A loan amount estimator calculates how large a loan you can afford based on your desired monthly payment, interest rate, and loan term. You enter those three figures and the calculator works backward from the standard payment formula to give you the maximum principal you could borrow. This is useful for planning a purchase or refinance before you apply, since it shows the price range your budget supports.

Formula

The estimator uses the standard amortization formula, rearranged to solve for the principal instead of the payment. The monthly payment is normally calculated as:

PMT = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

where:

  • PMT = monthly payment (in dollars)
  • P = loan principal, or the amount borrowed (in dollars)
  • r = monthly interest rate, equal to the annual percentage rate (APR) divided by 12 (as a decimal)
  • n = total number of monthly payments (loan term in years × 12)

To estimate the loan amount, we solve for P:

P = PMT × ((1 + r)^n − 1) / (r × (1 + r)^n)

In the calculator above, you enter the monthly payment you can afford, the APR, and the term in years. The tool computes the principal that matches that payment exactly, assuming the payment is made at the end of each month and the interest rate stays fixed for the whole term.

Worked Example

Using the default values from the calculator: you want a monthly payment of $20,000, an APR of 8%, and a term of 5 years. First, convert the APR to a monthly rate: 8% / 12 = 0.6667% per month, or r = 0.006667 as a decimal. The number of payments is n = 5 × 12 = 60.

Now plug those into the rearranged formula:

P = 20000 × ((1 + 0.006667)^60 − 1) / (0.006667 × (1 + 0.006667)^60)

Calculate the growth factor: (1.006667)^60 ≈ 1.48985. Then the numerator is 20000 × (1.48985 − 1) = 20000 × 0.48985 = 9797.0. The denominator is 0.006667 × 1.48985 ≈ 0.009932. Dividing gives P ≈ 986,400. That is the loan amount that produces a $20,000 monthly payment at 8% over 5 years. The calculator rounds to the nearest dollar, so it shows $986,400 as the estimated principal.

Assumptions

  • Fixed interest rate for the entire loan term (no rate changes or adjustable periods).
  • Payments are made at the end of each month, starting one month after the loan is issued.
  • Interest compounds monthly at the APR divided by 12.
  • The estimate does not include fees, taxes, insurance, private mortgage insurance (PMI), or escrow amounts. Those costs would reduce the amount you can actually borrow for the same monthly payment.

When to Use a Loan Amount Estimator

This tool is helpful in several situations:

  • Budgeting for a car or home: If you know what monthly payment fits your budget, the estimator tells you the maximum purchase price you can finance (before down payment).
  • Comparing loan offers: Lenders may quote different rates and terms. You can enter each offer’s rate and term to see which one lets you borrow more for the same payment.
  • Planning a refinance: If you want to lower your monthly payment, the estimator shows how much principal you could refinance at a given rate to hit that target.
  • Setting a spending limit: Before visiting a dealership or seller, you can set a realistic cap based on your monthly cash flow.

The result is a starting point, not a guarantee. Lenders evaluate your credit history, debt-to-income ratio, and other factors when approving a loan, so the amount you qualify for may differ.

How to Read the Result

The primary output is the loan principal that matches your inputs. The secondary output, total interest, shows the cumulative interest you would pay over the full term if you made only the minimum payments. That figure helps you understand the true cost of borrowing.

For example, with the default values, the estimated loan amount is $986,400 and the total interest is about $213,600. That means over 5 years you would pay $1,200,000 in total (60 payments of $20,000), of which $213,600 is interest. The interest portion is roughly 18% of the total payments, which is typical for an 8% APR over 5 years.

If you lower the APR or lengthen the term, the estimated loan amount rises because the payment covers more principal. Conversely, a shorter term or higher rate reduces the amount you can borrow for the same monthly payment.

Common Mistakes and Misconceptions

A frequent error is confusing APR with the monthly rate. The APR is an annual figure; you must divide by 12 to get the monthly rate used in the formula. For example, 8% APR means r = 0.08/12 = 0.006667, not 0.08.

Another mistake is ignoring the effect of the term. Doubling the term does not double the loan amount; because interest compounds, the relationship is not linear. For instance, at 8% APR, a $1,000 monthly payment supports about $49,300 over 5 years, but about $82,400 over 10 years—roughly 67% more, not 100% more.

Some people assume the loan amount equals the purchase price, but if you make a down payment or trade-in, the loan amount is the price minus that amount. The estimator gives the loan principal, not the total price.

Finally, the calculator assumes level payments and a fixed rate. Many real loans have fees that are rolled into the principal, which changes the effective rate. Always check the loan estimate from the lender for the exact figures.

Limitations of the Formula

The standard amortization formula works only for fixed-rate, fully amortizing loans. It does not apply to interest-only loans, balloon payments, or adjustable-rate mortgages where the rate changes over time. For those products, the payment and the total interest can vary, so a simple estimator like this will not give an accurate loan amount.

Also, the formula assumes payments are made exactly on time every month. Late fees, missed payments, or extra payments will change the amortization schedule and the total interest. The estimate is most accurate when you follow the schedule exactly.

Finally, the calculator does not account for your other debts, credit score, or income. Those factors determine whether a lender will actually offer you that amount, and at what rate. The tool is a mathematical estimate, not a pre-approval.

Frequently Asked Questions

How is the loan amount different from the purchase price? The loan amount is the principal you borrow, which equals the purchase price minus any down payment, trade-in value, or rebates. For example, if you buy a car for $30,000 and put $5,000 down, the loan amount is $25,000.

Does the loan amount include taxes and fees? Not in this calculator. Taxes, registration, dealer fees, and loan origination fees are typically added to the amount financed, which increases the principal. If you want to include them, add them to the loan amount you enter or use a separate calculator that has a fees field.

What is a good APR to use? There is no single “good” rate because it depends on your credit, the loan type, and the market. Use the rate a lender quotes you, or use a typical rate for your situation as a starting point. The estimator is sensitive to the rate, so try a few values to see how the loan amount changes.

Can I use this for a mortgage? Yes, but remember that mortgages often include property taxes, homeowners insurance, and PMI in the monthly payment. Those costs reduce the amount you can borrow for a given total monthly payment. This calculator only covers principal and interest, so you would need to subtract those other costs from your monthly budget first.

Why does the calculator show “Cannot compute” for some inputs? That happens when the monthly payment is too low to cover the interest on the loan. For example, at 8% APR, a $10,000 loan has about $66.67 in monthly interest. If you enter a payment below that, the loan would never be paid off, so the formula has no solution. Increase the payment or lower the rate to get a valid result.

Is the result a guarantee I’ll be approved for that amount? No. The estimator only does the math. Lenders also check your credit score, debt-to-income ratio, employment history, and the collateral’s value. The actual loan amount may be lower or higher than the estimate.

Remember that this tool provides an estimate for educational purposes. Your lender’s loan disclosure will show the exact loan amount, payment, and total cost based on your specific terms.

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 →