What Is the Formula for Monthly Payments? | Stop Guessing Your Loan Cost

A fixed-rate loan’s monthly payment is PMT = P·r·(1+r)^n / ((1+r)^n − 1), using a monthly rate r and total payments n.

Monthly payments can feel like a black box. A lender shows a number, you nod, and the deal moves on. Then real life hits: a tighter budget month, a rate change, or a new loan offer that looks “close enough.” This is where the formula earns its keep.

Once you know how the monthly payment is built, you can sanity-check quotes, compare offers on equal ground, and spot small changes that swing the payment more than you’d expect. You don’t need fancy math skills. You just need the right inputs and a clean process.

What The Monthly Payment Formula Calculates

The classic monthly payment formula is built for a standard amortizing loan: same payment each month, interest charged on the remaining balance, and the loan fully paid off at the end of the term. Mortgages, auto loans, and many personal loans fit this setup.

The output is the monthly payment that covers principal and interest. It does not automatically include items that lenders often bundle into a “monthly payment” line item, such as property taxes, homeowners insurance, HOA dues, or private mortgage insurance. You can add those later, but the equation itself starts with principal and interest.

When The Formula Fits Well

• Fixed interest rate for the full term
• One payment every month
• No balloon payment at the end
• No interest-only period
• No payment holidays built in

When You Need A Twist

If the loan has a teaser rate, interest-only months, a balloon, or irregular payment timing, you can still compute payments, but you’ll use a variation. You’ll see the most common variations later, with a plain-language “what changes” view.

Formula For Monthly Payments For Fixed-Rate Loans

Here’s the standard amortization payment equation, written in a compact way:

PMT = P · r · (1 + r)ⁿ / ((1 + r)ⁿ − 1)

What Each Symbol Means

• PMT: monthly payment (principal + interest)
• P: principal (the amount borrowed)
• r: monthly interest rate (APR divided by 12, expressed as a decimal)
• n: total number of payments (loan term in months)

How To Get The Inputs Right

The two inputs that cause the most trouble are r and n. Most loan quotes show an annual percentage rate. The formula needs a monthly rate.

• If the APR is 6%, the decimal is 0.06.
• Monthly rate r = 0.06 / 12 = 0.005.
• If the term is 30 years, total payments n = 30 × 12 = 360.

That’s it. Once you have P, r, and n, the rest is plug-and-calc.

A Sample Walkthrough With Real Numbers

Say you borrow $20,000 at 8% APR for 5 years.

• P = 20,000
• APR = 8% → 0.08
• r = 0.08 / 12 = 0.006666…
• n = 5 × 12 = 60

Now compute the growth factor (1 + r)ⁿ. Then multiply P by r by that factor. Then divide by ((1 + r)ⁿ − 1). Your result is the monthly payment for principal and interest.

If you want a lender-aligned sanity check without building a spreadsheet first, the Federal Reserve Bank of Dallas hosts a payment calculator that shows payment totals and a schedule once you enter the loan basics. Use it as a cross-check, not as a substitute for understanding the inputs. Dallas Fed payment calculator for closed-end loans.

The Zero-Interest Shortcut

If the interest rate is 0%, the formula breaks because it divides by zero. In that special case, the payment is simply:

PMT = P / n

That’s the only time you can skip the compounding pieces.

What Lenders Mean By “Monthly Payment”

On mortgages, people often hear “monthly payment” and think it includes everything. Many lender worksheets show a blended figure that stacks multiple items:

• Principal + interest (this is what the formula gives)
• Property taxes (often escrowed)
• Homeowners insurance (often escrowed)
• Mortgage insurance (if required)
• HOA dues (if applicable)

So if your computed PMT doesn’t match the lender’s full monthly figure, that mismatch can be normal. To see how lenders frame the pieces, this CFPB explainer breaks down what goes into a mortgage payment and why. CFPB explanation of mortgage monthly payment calculation.

Inputs That Change The Payment More Than People Expect

Small shifts in the inputs can push the payment up or down fast. Here are the levers that tend to surprise people.

Loan Term Length

Stretching a loan from 48 to 72 months can drop the payment, yet it can raise total interest paid by a lot. A longer term means more months where interest accrues. If two offers differ in term, compare both the payment and the total cost over time.

Rate Type And Rate Timing

Fixed-rate loans keep r stable. Adjustable-rate loans reset r on a schedule. The same formula still works for each period with a fixed rate, but you’ll recalc when the rate changes. If a quote shows a teaser rate, ask what the rate can become at the first reset and what the cap rules are.

Fees Rolled Into The Balance

Some loans add fees into the borrowed amount. That increases P, which increases the payment. If you want a clean apples-to-apples view between two offers, separate “amount you receive” from “amount financed.” The formula cares about the financed amount.

Payment Timing

Most consumer loans use monthly payments. Some contracts use biweekly payments or other schedules. If the payment frequency changes, the rate per period and the number of periods change too. That means r and n both shift, not just one.

Input	What It Means In The Formula	Common Slip
P (Principal)	The financed amount you’ll repay over time	Using purchase price instead of amount financed
APR	The annual rate stated by the lender	Treating APR as the monthly rate
r (Monthly rate)	APR ÷ 12 as a decimal	Forgetting to convert percent to decimal
n (Total payments)	Term in months (years × 12)	Using years instead of months
(1 + r)n	Compounding factor across all payment periods	Raising (1 + APR) instead of (1 + monthly rate)
PMT	Monthly principal + interest payment	Expecting it to include taxes and insurance
Rounding	Currency rounding to cents	Rounding r too early and drifting from lender numbers
Fees in balance	Fees that increase P	Ignoring rolled-in fees and underestimating PMT

How To Calculate Monthly Payments By Hand Without Getting Lost

If you’ve ever tried to punch the formula into a calculator and ended up with nonsense, it’s usually because the steps got mashed together. A cleaner way is to compute in small chunks.

Step 1: Convert The Rate

Take the APR, turn it into a decimal, then divide by 12.

• 6% APR → 0.06
• r = 0.06 / 12 = 0.005

Step 2: Convert The Term

Convert the term to months.

• 15 years → n = 15 × 12 = 180
• 48 months → n = 48

Step 3: Compute The Growth Factor

Compute A = (1 + r)ⁿ. Keep extra decimals in your calculator so rounding doesn’t drift early.

Step 4: Compute The Numerator

Compute B = P × r × A.

Step 5: Compute The Denominator

Compute C = A − 1.

Step 6: Divide

PMT = B / C.

This step-by-step method keeps errors visible. If something looks off, you can spot which chunk went sideways.

How Spreadsheets And Calculators Match The Formula

Most calculators use the same math under the hood. Spreadsheets make it fast and transparent, which is handy when you want to compare several rates or terms.

Using PMT In Excel Or Google Sheets

The PMT function returns the periodic payment for a fixed-rate loan. A common pattern looks like this:

• Rate: APR/12
• Nper: years*12
• PV: principal (use a negative sign if you want the payment shown as a positive number)

Spreadsheets can also build an amortization schedule month by month. That schedule is where you see the shift from “mostly interest” early on to “mostly principal” later on.

Why Your Result Can Differ By A Few Cents

Lenders round each month’s interest charge to the nearest cent, then apply the remainder to principal. If your math rounds only at the end, you may see a small mismatch. Over many months, those pennies can move the ending balance by a bit. That’s normal.

Loan Setup	What Changes	How To Handle It
Interest-only period	Payment covers interest, not principal, for a set time	During that period: PMT = P × r; later recalc with new n and remaining balance
Balloon loan	Payments may be based on a longer schedule, with a large final balance due	Compute scheduled PMT, then compute remaining balance at balloon date
Adjustable-rate loan	r changes at reset points	Recalc PMT at each reset using remaining balance and remaining months
Biweekly payments	More frequent payments change the rate per period and count of periods	Use rate per period and periods per year that match the contract
Extra principal payments	Total paid per month rises, payoff time drops	Keep PMT as scheduled, then subtract extra from balance after interest posts
Fees added to balance	P increases	Use the financed amount as P, not the sticker price
0% promotional financing	r is zero for the promo window, then jumps	Use P/n for promo months; recalc once the rate changes

How Extra Payments Change The Outcome

Extra payments don’t change the formula that set the scheduled payment. They change the balance faster, which cuts the interest that would have been charged later.

What Happens Each Month

• Interest is computed on the current balance.
• Your scheduled payment is applied.
• Any extra amount goes straight to principal (if the lender applies it that way).

That last line is the one to verify. Some lenders require you to mark extra payments as “apply to principal.” If they treat it as an early payment instead, the payoff speed-up can shrink.

A Simple Rule Of Thumb

Extra principal early in the loan usually saves more interest than the same extra principal late in the loan, because it removes balance that would have accrued interest across many future months.

How To Read An Amortization Schedule Without Glazing Over

An amortization schedule is a month-by-month table that splits each payment into interest and principal, then shows the remaining balance.

What To Look For In The First Few Rows

• Interest portion is largest early on because the balance is largest.
• Principal portion starts smaller and grows over time.
• Balance drops slowly at first, then faster later.

This pattern is normal for fixed-rate amortizing loans. It’s also why refinancing decisions often hinge on timing. If you refinance and restart a long term, you may return to a “heavier interest” phase, even if the rate is lower.

Monthly Payment Calculation Checklist

Use this checklist when you’re comparing offers, double-checking a quote, or building your own sheet.

• Write down the financed amount (that’s P).
• Convert APR to a decimal, then divide by 12 (that’s r).
• Convert the term to months (that’s n).
• Compute PMT with the amortization formula.
• Ask what the lender bundles into their “monthly payment” figure.
• Check if fees are rolled into the balance.
• If the rate can change, recalc PMT at each reset using remaining balance and remaining months.
• If you plan extra payments, confirm they apply to principal.

Common Mistakes That Make Payments Look Wrong

Most “my math doesn’t match” moments come from one of these slips:

• Using APR as r without dividing by 12
• Using years as n instead of months
• Mixing up purchase price and amount financed
• Comparing principal-and-interest PMT to a lender’s all-in payment that includes taxes and insurance
• Rounding the monthly rate too early

If you fix those, your numbers usually line up closely with lender quotes, aside from small rounding differences.

A Quick Self-Check Before You Sign

Before you lock in a loan, run a quick test: take the quoted rate, term, and financed amount, compute PMT, and compare it to the lender’s principal-and-interest line. If the lender only shows an all-in monthly figure, ask for the principal-and-interest breakdown. That one line is the clean bridge between your math and their paperwork.

Once you can compute a payment from scratch, you’re not stuck trusting a single number on a page. You can compare offers with confidence and spot the hidden cost of small changes in rate, term, and fees.