gizmobench
BrowseDaily
← All guides

GizmoBench guides

Monthly Loan Payment Formula with 2 Examples and a Private Calculator

GizmoBench ·

The standard loan payment formula is M = P × [r(1+r)^n] / [(1+r)^n − 1], where M is the periodic payment, P is the principal borrowed, r is the periodic interest rate, and n is the total number of payments over the loan’s life. It applies to fixed-rate loans with equal periodic payments, the kind most auto loans and standard mortgages use, and it calculates principal and interest only: escrow, mortgage insurance, and lender fees sit on top of this number.

TL;DR:

  • Using the loan payment formula requires dividing the annual interest rate by the number of payments per year to obtain the correct periodic rate; combining the full annual rate directly results in significantly higher payments.
  • For a 30-year, $200,000 loan at 7%, the monthly principal and interest payment is approximately $1,330, excluding taxes, insurance, or mortgage insurance.
  • Early loan payments are mostly interest, with the principal component gradually overtaking interest halfway through the term, and paying extra toward principal reduces total interest over the life of the loan.
  • When loans feature balloon payments, interest-only periods, or negative amortization, applying the standard formula can be misleading and more detailed schedule disclosures are necessary.
  • Additional costs such as property taxes, homeowners insurance, and mortgage insurance are added on top of the principal and interest to determine the total monthly obligation.
GizmoBench
Calculate Loan Payments Quickly
Use GizmoBench’s practical online tools to calculate money figures directly in your browser, without an account or software installation.
Explore GizmoBench tools

Table of Contents

The standard amortization formula and what each symbol means

The formula above is the one TransUnion’s loan payment calculator presents, and it is worth breaking down piece by piece before touching a calculator. M is the fixed amount due each period, whether that period is a month, a quarter, or a week, depending on how the loan is structured. P is the original principal, the amount borrowed before any interest accrues. r is the periodic interest rate, not the annual rate quoted in a loan advertisement. n is the total count of payments across the loan’s full term.

Confusing the annual rate with the periodic rate is probably the single most common error in manual loan math. For a monthly-payment loan, TransUnion’s calculator guidance is direct: divide the annual percentage rate by 12 to get the monthly rate, and multiply years by 12 to get the total number of payments. A 6% annual rate becomes a 0.5% monthly rate (0.06 / 12 = 0.005 in decimal form), and a 30-year mortgage becomes 360 monthly payments.

The formula can be rearranged without changing what it calculates. One common alternative form separates the numerator and denominator as (1+r)^n in two places, which is exactly what appears above, and another expresses the same relationship by isolating the annuity factor. Regardless of the form, the arithmetic has to produce the same payment for the same inputs. Two conditions worth flagging:

  • When r equals zero (a zero-interest loan), the formula simplifies to M = P / n, since there is no interest to compound.
  • When n is very large relative to r, the payment approaches P × r, because the annuity factor converges toward a fixed multiple of the rate.

The derivation itself traces back to the present value of an annuity. A loan is, mathematically, a payout annuity: the lender hands over a lump sum today (the principal) in exchange for a stream of equal future payments that, when discounted back to today at the periodic rate, exactly equal that lump sum. OpenStax’s Principles of Finance walks through this present-value-of-annuity approach, showing how solving the annuity equation for the payment variable produces the same M = P × r(1+r)^n] / [(1+r)^n − 1] formula. Treating the loan as an annuity is also the reasoning [LibreTexts’ math coverage of payout annuities/05%3A_Personal_Finance/5.04%3A_Payout_Annuities_and_Loans) uses to explain why the formula extinguishes the balance exactly at the final payment, assuming every payment is made on schedule and no extra principal is applied early.

Step-by-step worked examples of monthly payment calculations

Numbers make this concrete faster than symbols do. Two examples below use different principals, rates, and terms so the pattern generalizes.

Example A: a $20,000 loan at 7% annual interest over 5 years.

  1. Convert the rate: r = 0.07 / 12 = 0.0058333 (rounded for display, carried at full precision internally).
  2. Set the term: n = 5 × 12 = 60 monthly payments.
  3. Compute (1+r)^n: (1.0058333)^60 ≈ 1.41763.
  4. Compute the numerator: r × (1+r)^n = 0.0058333 × 1.41763 ≈ 0.0082696.
  5. Compute the denominator: (1+r)^n − 1 ≈ 0.41763.
  6. Divide and multiply by principal: M = 20,000 × (0.0082696 / 0.41763) ≈ $396.02 per month.

Example B: a $200,000 loan at 7% annual interest over 30 years.

Here r is the same 0.0058333 monthly rate, but n = 30 × 12 = 360 payments, a much larger exponent. Running the same steps, (1.0058333)^360 comes out to roughly 8.1164, which changes the ratio significantly compared to Example A’s 60-payment horizon. The resulting payment lands near $1,330 per month on the $200,000 principal, principal and interest only.

Statistic Callout: The CFPB explains that lenders calculate principal and interest so that, if every scheduled payment is made, the loan amortizes fully by the end of its term. That single design goal is why the formula above works the same way for a car loan and a 30-year mortgage: only the numbers change.

The most frequent beginner mistake is plugging the annual rate straight into r without dividing by the number of payments per year. Doing that with Example A’s 7% rate (using 0.07 instead of 0.0058333) produces a payment many times too high, because the formula assumes r matches the payment period, not the calendar year. A second mistake is mismatching n and the payment frequency, using 5 (years) instead of 60 (months) as the exponent. Both errors are avoidable by writing out the conversion step explicitly before touching a calculator.

A quick way to check any manual result is to run the same inputs through a spreadsheet PMT function or an online calculator and compare the output to the cent. If the two disagree by more than rounding, the periodic rate or payment count is the first place to look.

How amortization schedules split interest and principal

Illustration of payments shifting toward principal

Every payment in a fixed-rate loan is really two payments bundled together: interest on whatever balance remains, and a reduction of that balance. The interest portion of any given payment equals the outstanding balance at the start of that period multiplied by the periodic rate. The principal portion is simply the fixed payment minus that interest amount. Because the balance shrinks a little with each payment, the interest charge shrinks too, which means the principal portion grows every period even though the total payment stays flat.

The remaining balance after k payments can be computed directly, without stepping through every prior period one at a time, using a variant of the same present-value logic that produced the original payment formula. In practice, most borrowers do not compute this by hand. They read it off an amortization table, which lists, payment by payment, the interest charged, the principal repaid, and the balance left over.

  • Early payments on a 30-year mortgage are interest-heavy: in Example B above, the very first payment’s interest portion alone is a large share of the total, since the full $200,000 balance is still accruing interest.
  • The principal portion overtakes the interest portion only partway through the term, and exactly when depends on the rate and length of the loan.
  • Rounding accumulates: computing each row’s interest and principal to full precision and only rounding for display, as OpenStax’s Excel and financial calculator guide recommends, keeps the schedule internally consistent.
  • The final payment is sometimes adjusted by a few cents to clear whatever rounding difference has built up, a detail Maricopa’s open mathematics text on loans walks through with numeric examples.

This structure is also why paying extra toward principal early in a loan’s life saves more in total interest than the same extra payment made later: less balance outstanding means less interest accruing in every subsequent period.

When the standard formula doesn’t apply

The fixed-payment formula assumes every payment is identical and the loan fully amortizes by the last one. Several common loan structures break that assumption, and applying the standard formula to them gives a misleading answer.

A balloon payment loan has smaller regular payments calculated as if the loan amortized over a longer period, followed by one large final payment covering whatever balance is left. An interest-only period means the borrower pays only accruing interest for a set stretch, with no reduction in principal at all during that window. Negative amortization goes a step further: the payment does not even cover the full interest due, so the unpaid interest gets added to the balance, and the loan grows before it starts shrinking.

  • Balloon loans calculate the regular payment using a longer amortization period than the loan’s actual term, which is why a final lump sum remains due.
  • Interest-only payments use the standard interest formula but skip the principal-reduction component entirely for the interest-only window.
  • Negative amortization increases the outstanding balance rather than decreasing it, the opposite of what the standard formula assumes.
  • Adjustable-rate loans use the initial rate to calculate initial payments, per CFPB guidance, but the payment recalculates when the rate resets.

Because these products depart from the standard math, lenders are required to disclose them clearly. The CFPB’s TILA-RESPA integrated disclosure guide requires a Projected Payments table on both the Loan Estimate and Closing Disclosure, showing how the payment could change over the life of the loan, including any balloon amount or adjustable-rate reset. If a loan has any of these features, asking the lender for the exact amortization schedule, rather than reconstructing it from the standard formula, is the more reliable approach.

What lenders add on top of principal and interest

The number the formula produces is not usually the number that shows up on a mortgage bill. Most lenders bundle additional recurring costs into a single monthly payment, and separating the math from the total bill matters for budgeting.

  • Escrow accounts collect a portion of property taxes and homeowners insurance each month, holding the funds until the annual bill is due, a practice the CFPB’s key mortgage terms page describes.
  • Mortgage insurance, when required, adds a separate recurring charge that is not part of the principal-and-interest formula.
  • Other recurring additions, such as homeowners association dues collected by the servicer, can appear in the total as well, depending on the loan.

The Loan Estimate and Closing Disclosure documents required under TILA-RESPA lay these components out in a Projected Payments table, listing principal and interest, mortgage insurance, and estimated escrow as separate line items so the borrower can see what each piece contributes to the total. Confirming the full monthly obligation, not just the principal-and-interest figure from the formula, avoids budgeting surprises after closing.

Pro Tip: When comparing two loan offers, compare both the APR and the full projected monthly payment including escrow, since a lower quoted rate can still produce a higher total bill once taxes, insurance, and mortgage insurance are added in.

Calculating payments with Excel, financial calculators, and GizmoBench

Manual arithmetic is useful for understanding the formula, but most people compute real loan payments with a spreadsheet, a dedicated financial calculator, or an online tool. Each handles the same inputs slightly differently.

  • In Excel or Google Sheets, the PMT function takes the form PMT(rate_per_period, nper, pv), where rate_per_period is the periodic rate (APR divided by payments per year), nper is the total number of payments, and pv is the principal, entered as a negative number if you want the payment returned as a positive figure, or positive if you are comfortable with a negative payment output.
  • On a standard financial calculator, the usual sequence is: set payments per year, enter N for the total number of payments, enter I/Y for the annual rate (the calculator divides internally, depending on the model), enter PV for the principal, then compute PMT.
  • There are online loan payment tools that run amortization math directly in the browser, with no account required and no file or number ever leaving the device, generating both the monthly payment and a full amortization breakdown from the same inputs.
  • Whichever tool is used, double-check that the rate entered matches the payment period (periodic, not annual) and that rounding is applied only for display, not mid-calculation.

Calculate your loan payment with GizmoBench’s free tools

Working through the formula by hand is worth doing once, to understand where the numbers come from, but checking a real loan does not require redoing that arithmetic every time. Some calculators run entirely in the browser, so a principal, rate, and term never have to leave the device to get a monthly payment and an amortization breakdown back.

The everyday tools collection groups the calculators most useful alongside loan math: a percentage calculator for converting an APR into a periodic rate or checking a rate difference between two offers, and an APY calculator for understanding how a compounding rate compares to a simple annual rate when shopping loan or savings terms side by side. A typical workflow looks like this:

  • Enter the principal, periodic rate, and number of payments to get the fixed monthly payment.
  • Generate the amortization schedule to see how much of each payment goes to interest versus principal.
  • Copy the resulting figures into a budget spreadsheet or compare them against a second loan offer.

For borrowers comparing commercial payment terms alongside personal loan math, the Debt Recovery Hub’s commercial payments bill calculator offers a separate, specialized view worth checking for business-related payment scheduling.

Sources

FAQ

How do I calculate my loan payment?

Use the formula M = P × [r(1+r)^n] / [(1+r)^n − 1], where P is the principal, r is the periodic interest rate (annual rate divided by payments per year), and n is the total number of payments. TransUnion’s calculator presents this same formula for standard fixed-rate loans, and it excludes escrow or added fees.

How much is a $200,000 loan at 7%?

For a 30-year term at 7% annual interest, converting to a monthly rate of 0.0058333 and 360 total payments produces a principal-and-interest payment of near $1,330 per month, principal and interest only. Adding taxes, insurance, or mortgage insurance would increase the total monthly bill beyond that figure.

How much would a $20,000 loan cost per month?

A shorter term or lower rate would reduce that monthly figure but increase or decrease total interest paid depending on the direction of the change.

How much is a monthly payment on a $100,000 loan?

The payment depends entirely on the rate and term chosen, since the formula scales proportionally with principal for a fixed rate and term. Entering the specific rate and number of payments into the formula, or into an amortization tool, is the only way to get an exact figure for a given set of terms.