How To Calculate Monthly Payment On A Loan | Get The Number Right

A fixed-rate loan payment comes from the loan amount, the monthly rate, and the number of months, using the standard amortization formula.

Monthly payments feel simple until you try to match a lender’s quote down to the cent. Most loans people run into use one steady payment that follows a predictable pattern. Once you know what numbers to grab and which math fits your loan type, you can check any offer on your own.

What A Monthly Loan Payment Covers

A standard payment has two parts: interest and principal. Interest is the charge for borrowing. Principal is the portion that reduces what you owe.

Early on, interest takes a bigger share because the balance is higher. Over time the balance drops, interest falls, and more of each payment goes to principal. The payment stays the same, but the split changes month to month.

Inputs You Need Before You Start

Pull these figures from the loan offer, the disclosure, or your account screen. If you see both an interest rate and an APR, treat them as two separate measures. The interest rate is the figure that typically drives the payment math, while APR rolls in certain fees so you can compare offers. The Consumer Financial Protection Bureau explains interest rate vs APR in plain language.

Principal

This is the amount you borrow. Some paperwork calls it the loan amount or the amount financed.

Interest Rate

Use the stated interest rate for the loan unless the lender says the payment uses APR. Many lenders compute the payment from the note rate and disclose APR as a comparison tool.

Term In Months

Convert years to months by multiplying by 12. A 5-year loan is 60 months. A 3-year loan is 36 months.

Loan Features That Change The Math

If you see variable rate, interest-only, balloon, precomputed interest, add-on interest, or a large up-front fee, your loan may not follow the standard fixed-payment pattern. Later sections show how to spot these cases.

Calculate Monthly Payment On A Loan Using The Amortization Formula

For a fixed rate and fixed term, lenders use an amortization payment. The formula is:

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

Where:

  • P = principal
  • i = monthly interest rate (annual rate ÷ 12, as a decimal)
  • n = number of monthly payments

Step 1: Convert The Annual Rate To A Monthly Decimal

Divide by 100 to convert percent to decimal, then divide by 12.

  • 7% per year → 0.07 per year
  • 0.07 ÷ 12 → 0.0058333333 per month

Step 2: Convert The Term To Total Payments

If the term is 5 years, n = 5 × 12 = 60. If the term is already in months, n is that number.

Step 3: Plug Values Into The Formula

Work in this order: compute (1+i)^n, then compute the top and bottom of the fraction, then multiply by P.

Worked Sample With Real Numbers

Say you borrow $18,000 at 7% for 5 years.

  • P = 18,000
  • i = 0.07 ÷ 12 = 0.0058333333
  • n = 60

Compute (1+i)^n:

  • (1 + 0.0058333333) ^ 60 = 1.417625 (rounded)

Compute the fraction:

  • i(1+i)^n = 0.008269479
  • (1+i)^n − 1 = 0.417625
  • Fraction = 0.019799 (rounded)

Multiply by P:

  • Payment = 18,000 × 0.019799 = $356.38

That’s the monthly payment when rounded to the nearest cent.

Special Case: 0% Interest

At 0%, the amortization formula breaks because it divides by zero. Use:

Payment = P ÷ n

A $12,000 loan over 48 months at 0% has a payment of $250.00.

Numbers To Pull From A Loan Offer

This table helps you grab the right input and avoid mixing “amount financed” with totals.

Loan Item What It Means Where You Often See It
Principal (P) The amount you borrow Loan amount, principal, amount financed
Interest Rate The rate used to compute interest charges Note rate, interest rate, contract rate
APR Rate plus certain fees, used for comparing offers APR disclosure; CFPB explains what APR is and why it can exceed the rate on this APR page
Term (n) Total number of scheduled payments Loan term in months, number of payments
Payment Frequency How often payments are due Monthly, biweekly, weekly
First Due Date Date the first payment is scheduled Payment schedule or account summary
Fees Charges tied to the loan Origination fee, points, finance charge
Balloon Amount Large final payment after smaller scheduled payments Balloon, final payment, maturity payment

Build The Payment In A Spreadsheet

A spreadsheet lets you check your work and run “what if” tests without redoing the math by hand.

Use The Formula In Cells

Set:

  • A1: principal (P)
  • A2: annual rate as percent (7 for 7%)
  • A3: years

Then:

  • B2 (i): =A2/100/12
  • B3 (n): =A3*12

Monthly payment:

=A1*(B2*(1+B2)^B3)/((1+B2)^B3-1)

Sanity Checks That Catch Math Slips

Two fast checks catch most errors.

Check 1: First-Month Interest Should Be P × i

Using the sample loan, first-month interest is 18,000 × 0.0058333333 = $105.00. Since the payment is $356.38, the first-month principal paydown is $251.38.

Check 2: Total Paid Should Exceed Principal

Total paid is payment × months. For the sample: 356.38 × 60 = $21,382.80, which lines up with a loan that charges interest.

How Rate And Term Change The Payment

Term and rate both move the payment. Longer terms tend to lower the monthly payment, while higher rates raise it. The table below uses fixed-rate amortization and rounds payments to cents.

Loan Setup Monthly Payment Total Of Payments
$10,000 at 6% for 36 months $304.22 $10,951.92
$10,000 at 6% for 60 months $193.33 $11,599.80
$10,000 at 9% for 36 months $318.00 $11,448.00
$10,000 at 9% for 60 months $207.58 $12,454.80
$10,000 at 0% for 36 months $277.78 $10,000.08
$10,000 at 0% for 60 months $166.67 $10,000.20

The 0% rows show small differences in totals due to cent rounding. Many lenders round each monthly payment to cents, so totals can drift by a few cents from clean arithmetic.

When The Standard Formula Is The Wrong Fit

If your payment quote does not match your math, look for one of these structures.

Variable-Rate Loans

With a variable rate, the payment can change after a reset. To model it, you need the reset rules and a schedule of future rates. Without that, you can only compute the payment for the current rate period.

Interest-Only Loans

During an interest-only stretch, the payment can be as low as P × i. Once the loan starts paying down principal, a new payment is computed over the remaining months.

Balloon Loans

A balloon loan ends with a large final payment. The monthly payment may be computed as if the loan amortizes over a longer span, while the contract ends earlier with the balloon balance still due.

Precomputed Or Add-On Interest

Some contracts compute total interest up front, then split (principal + stated interest) across months. If the paperwork mentions “precomputed,” “rule of 78s,” or “add-on,” ask for the full schedule and the early payoff terms.

Make An Amortization Schedule To See The Split

You can build a month-by-month schedule in a spreadsheet with five columns:

  • Month number
  • Starting balance
  • Interest = starting balance × i
  • Principal = payment − interest
  • Ending balance = starting balance − principal

Carry the ending balance down as the next month’s starting balance. Keep extra decimals during the math, then round outputs to cents. If the final balance ends a few cents off zero, adjust the last payment by those cents.

Reverse The Math To Solve For A Loan Amount

Sometimes you know the payment you can afford and you want to see what loan size fits. You can rearrange the same amortization pieces to solve for P.

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

Use the same i and n you would use for a payment calculation. This gives a clean estimate of the principal that matches a standard fixed-rate payment. If your loan includes fees rolled into the balance, the cash you receive can be lower than this P.

What Extra Payments Do To The Schedule

Extra money sent to principal changes the path of the schedule. The monthly payment may stay the same, but the balance drops faster and interest shrinks sooner because interest is computed from the remaining balance.

If your lender applies extra funds to the next due date, ask to apply them to principal instead. Then you can model the change by subtracting the extra amount from the balance after the regular principal portion posts for that month.

  • Extra principal early in the loan tends to cut more interest than the same extra principal late in the loan.
  • Adding even a small extra amount each month can shave months off the payoff date.

Common Mistakes That Throw Off The Payment

  • Using APR in place of the note rate. APR is useful for comparison, but payment math often uses the note rate.
  • Skipping the divide-by-12 step. The formula needs a monthly rate.
  • Mixing years and months. Keep n in months.
  • Missing the decimal conversion. 7% is 0.07, not 7.
  • Rounding too early. Round at the end for the cleanest match.

Quick Checklist Before You Sign

Run this check right before you accept a loan offer.

  • Confirm the principal used for payment math.
  • Confirm the interest rate used for payment math.
  • Confirm the number of months and the first due date.
  • Scan for balloon, interest-only, or variable-rate language.
  • Ask for a full payment schedule if any line looks unclear.

If you run the amortization formula with the same rate, term, and principal shown on the offer, your payment should match the quoted payment within a few cents. If it doesn’t, the loan likely uses a structure outside standard amortization.

References & Sources