The loan amount formula calculates the principal you can borrow based on your desired monthly payment, interest rate, and loan term. You enter the monthly payment you can afford, the annual interest rate (APR), and the number of years, and the calculator returns the maximum loan amount, along with the total interest you would pay over the life of the loan.
Formula
The loan amount formula is derived from the standard amortization formula. It solves for the principal (P) given a fixed monthly payment (M), a monthly interest rate (r), and the total number of payments (n). The formula is:
P = M × [ (1 + r)^n – 1 ] / [ r × (1 + r)^n ]
Where:
- P = loan amount (principal) in dollars
- M = monthly payment in dollars
- r = monthly interest rate (annual APR divided by 12, expressed as a decimal; e.g., 8% APR = 0.08/12 = 0.0066667)
- n = total number of monthly payments (loan term in years × 12)
This formula assumes a fixed interest rate and level monthly payments over the entire term. It is the same math used by lenders to determine how much you qualify for when you apply for a mortgage, auto loan, or personal loan.
Worked Example
Using the default values from the calculator: you want a monthly payment of $20,000? No—wait, the default loan amount is $20,000, but the calculator asks for the loan amount as an input. Actually, the calculator above is set up to compute the monthly payment from a given loan amount. To illustrate the loan amount formula, we need to reverse it. Let’s use a realistic scenario: you want a monthly payment of $400, an APR of 8%, and a term of 5 years. What loan amount can you borrow?
Step 1: Convert APR to monthly rate: r = 8% / 12 = 0.08 / 12 = 0.0066667.
Step 2: Total number of payments: n = 5 × 12 = 60.
Step 3: Plug into the formula: P = 400 × [ (1 + 0.0066667)^60 – 1 ] / [ 0.0066667 × (1 + 0.0066667)^60 ].
Step 4: Calculate (1 + r)^n = (1.0066667)^60 ≈ 1.48985.
Step 5: Numerator: 400 × (1.48985 – 1) = 400 × 0.48985 = 195.94.
Step 6: Denominator: 0.0066667 × 1.48985 = 0.0099323.
Step 7: Divide: 195.94 / 0.0099323 ≈ 19,727. So you could borrow about $19,727 with a $400 monthly payment at 8% APR for 5 years.
Check: If you borrow $19,727 at 8% APR for 60 months, the monthly payment is 19727 × (0.0066667) / (1 – (1.0066667)^-60) ≈ 400.00. The total interest paid would be 400 × 60 – 19727 = 24000 – 19727 = $4,273.
Assumptions
- Fixed interest rate: The formula assumes the APR stays constant for the entire term. Adjustable-rate loans would need a different calculation.
- Level payments: Payments are the same amount each month, made at the end of each period (in arrears).
- Monthly compounding: Interest is compounded monthly at a rate of APR/12, which is the standard for most amortizing loans.
- No fees or taxes: The formula does not include origination fees, closing costs, property taxes, insurance, PMI, or any other charges. Those would reduce the actual loan amount you receive or increase your effective payment.
When to Use the Loan Amount Formula
Use this formula when you have a target monthly payment in mind and want to know how large a loan you can take out without exceeding that budget. This is common when shopping for a car, planning a home renovation, or considering a personal loan. It helps you set a realistic borrowing limit before you talk to a lender.
For example, if you know you can afford $500 per month for a car loan, and the current APR is 6% for a 5-year term, the formula tells you the maximum price you can finance (before taxes and fees). This prevents you from falling in love with a car that is out of reach.
The formula is also useful for comparing different loan terms. A longer term lowers the monthly payment but increases total interest. You can use the formula to see how much more you could borrow with a 6-year term versus a 5-year term at the same payment.
How to Read the Result
The loan amount result is the principal you can borrow, not the total cost. The total cost is the monthly payment multiplied by the number of payments. For instance, borrowing $19,727 at $400/month for 60 months costs $24,000 in total payments, meaning $4,273 in interest.
Remember that the loan amount is the amount financed, before any down payment. If you have a down payment, the maximum purchase price is the loan amount plus the down payment. For a home, you also need to account for closing costs, which are not part of the loan amount.
The calculator also shows the total interest, which helps you see the long-term cost of borrowing. A lower interest rate or shorter term will reduce this figure, but it will also increase your monthly payment or reduce the loan amount you can get for a fixed payment.
Common Mistakes and Pitfalls
- Using the annual rate directly: The formula requires the monthly rate. Dividing the APR by 12 is essential; using 8% instead of 0.08/12 will give a wildly wrong result.
- Mixing up years and months: The term must be in months. If you input 5 years as 5, the formula will treat it as 5 payments, not 60. Always multiply years by 12.
- Ignoring fees: The formula gives the pure principal. If a lender charges a 2% origination fee, you will receive less than the loan amount, or the fee will be added to the principal, increasing your payment.
- Rounding too early: Rounding the monthly rate to a few decimals can shift the result significantly over a long term. Keep full precision in your calculations.
- Assuming the rate is fixed: If you have an adjustable-rate loan, the payment can change. This formula only works for fixed-rate loans.
Limitations of the Formula
The formula is a mathematical estimate. It does not account for your credit score, income, debt-to-income ratio, or the lender’s underwriting criteria. A lender will use these factors to decide whether to approve you and at what rate. The formula also assumes you make every payment on time; late fees or payment changes would alter the actual amortization.
For mortgages, the formula does not include property taxes, homeowners insurance, or PMI, which are often escrowed into the monthly payment. Those costs can make your actual monthly payment much higher than the principal and interest alone. Similarly, for auto loans, sales tax and registration fees are typically added to the amount financed, so the loan amount you need is higher than the car’s sticker price.
The formula also assumes the interest rate is constant. In reality, rates can change between the time you get a quote and closing, especially for mortgages. Always use the rate from your loan estimate or disclosure.
Alternatives and Related Calculations
If you already know the loan amount and want to find the monthly payment, you would use the standard payment formula: M = P × r × (1 + r)^n / [(1 + r)^n – 1]. That is the reverse of what we did here.
You might also want to calculate how much interest you will pay over the life of the loan, which the calculator provides. Another useful calculation is the total cost of the loan (monthly payment × number of payments).
If you are considering extra payments, you can use an amortization schedule to see how much faster you can pay off the loan and how much interest you save. That is a separate calculation, but it builds on the same formula.
Frequently Asked Questions
How do I calculate the loan amount if I know the monthly payment?
Use the formula P = M × [ (1 + r)^n – 1 ] / [ r × (1 + r)^n ], where r is the monthly interest rate (APR/12) and n is the number of monthly payments. For example, with a $400 monthly payment, 8% APR, and 5-year term, you get about $19,727.
What is the difference between loan amount and principal?
They are essentially the same. The loan amount is the initial principal balance you borrow. As you make payments, the principal decreases. The total interest is the extra money you pay for the privilege of borrowing.
Can I use this formula for any type of loan?
Yes, as long as the loan has a fixed interest rate and level monthly payments. This includes most auto loans, personal loans, student loans, and fixed-rate mortgages. For adjustable-rate loans or interest-only loans, the formula does not apply directly.
Does the formula include taxes and insurance?
No. The formula only covers principal and interest. For a mortgage, you must add property taxes, homeowners insurance, and possibly PMI to get your total monthly payment. For a car loan, add sales tax and registration fees to the amount financed.
Why does the calculator show a different result than my lender’s quote?
Lenders may include fees, points, or different rounding methods. They also use your credit score to set the APR, which may differ from the rate you entered. The calculator gives an estimate; your lender’s loan estimate or disclosure provides the exact figures.
This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures for your specific loan.
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
- JS Bank Credit Card: Features & How to Apply$405.53
- JD Gift Card Balance: How to Check It$60.00
- JD Bank Credit Card: How It Works & What to Know$405.53
- In-N-Out Gift Card Balance: Check & Use Guide$30.00
- JCPenney Credit Card Balance: How to Check It27 months
- How to Check T Cash Card Balance