calculate-loan

01 Loan payments

Principal Interest Schedule Calculator and Guide

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

Monthly payment $405.53
Total interest
$4,331.80
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

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 principal interest schedule shows how each loan payment is divided between the amount borrowed (principal) and borrowing cost (interest), and how the remaining balance changes over time. This calculator estimates a fixed-rate loan’s monthly payment and total interest from the loan amount, annual percentage rate (APR), and term; it does not produce a month-by-month table.

Formula

The calculator uses the standard amortizing-loan payment formula. It finds the level monthly payment that would repay principal and interest in equal installments over the stated number of months:

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

  • P is the original principal, in dollars.
  • r is the monthly interest rate as a decimal: APR ÷ 12 ÷ 100.
  • n is the number of monthly payments: loan term in years × 12.

The monthly payment is rounded to the nearest cent. Estimated total interest is then monthly payment × number of payments − principal. Because the payment is rounded before the total is calculated, this estimate reflects repeated cent-rounded payments. A lender’s actual final payment may be adjusted for its precise accrual and rounding practices.

Worked Example

Using the calculator’s defaults—$20,000 principal, 8% APR, and a five-year term:

  1. Convert APR to a monthly decimal rate: 8 ÷ 100 ÷ 12 = 0.0066667 (approximately).
  2. Find the number of payments: 5 × 12 = 60.
  3. Substitute into the formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = approximately $405.53 per month.
  4. Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The results are an estimated monthly payment of $405.53 and total interest of $4,331.80. The total of the 60 estimated payments is $24,331.80, including repayment of the $20,000 principal.

Assumptions

  • The APR is fixed for the full term, and payments are level monthly installments.
  • Payments are assumed to be made at the end of each monthly period.
  • Interest is modelled monthly at APR ÷ 12; this is a simplifying convention and may not match every lender’s daily accrual method.
  • Fees, taxes, insurance, optional add-ons, and any separate charges are not included.

What a Principal Interest Schedule Shows

In a conventional amortizing loan, the payment usually contains both interest for the period and some principal repayment. Interest is calculated on the outstanding balance, so the interest portion generally declines as the balance falls. With a fixed payment, the principal portion generally grows over the repayment period. Early payments can therefore be interest-heavy without reducing the balance as quickly as a borrower might expect.

A full schedule, also called an amortization schedule, lists each period separately. It commonly shows the opening balance, scheduled payment, interest charged, principal paid, and closing balance. The calculator above estimates the payment and total interest, but does not generate those individual rows. To calculate a particular period’s interest in a simple monthly model, multiply the balance at the start of that period by the monthly rate. Subtract that interest from the payment to estimate the principal repaid, then subtract the principal from the opening balance.

For illustration, if a period begins with a $20,000 balance at an 8% APR under the monthly-rate assumption, the first month’s interest is about $20,000 × 0.08 ÷ 12 = $133.33. From a $405.53 payment, roughly $272.20 would go to principal. The exact schedule can differ because of payment dates, daily interest calculations, rounding, fees, or other contract terms.

How to Use and Read the Estimate

Enter the amount financed, the APR supplied for the loan, and its repayment term. The APR should be entered as a percentage per year—not as a monthly percentage. For instance, enter 8 for 8% APR. The result is a mathematical estimate based on those inputs, not a statement of what a lender will offer or collect.

  • Monthly payment is the modelled principal-and-interest installment. It excludes any costs not entered into the calculator.
  • Total interest is the estimated interest across the stated number of regular payments, based on the rounded monthly payment.
  • Total paid can be derived by adding principal and estimated interest; it is not a separate calculator output.

To understand an actual obligation, compare these estimates with the loan’s written payment schedule and disclosure. Check whether the amount financed includes all relevant charges, whether the quoted rate is fixed or can change, and whether the first payment date or payment frequency differs from the monthly assumption.

Common Questions and Misconceptions

Principal and interest are not two separate loans. They are components of a payment. Principal reduces the amount owed; interest is the financing cost charged for the period. A schedule helps distinguish the two and track the remaining balance.

Another frequent misunderstanding is that “total interest” is always simply the rate multiplied by the original principal and the term. That shortcut does not describe a standard amortizing loan, because the outstanding principal declines as payments are made. The payment formula accounts for that declining balance.

Rounding also matters. Displaying a monthly payment to cents and multiplying it by the number of installments can produce a slightly different total than calculations that retain extra decimal places internally or adjust the final installment. A schedule supplied by the lender is the relevant source for its exact figures.

Limits and Other Schedule Types

This calculation is intended for a standard fixed-rate loan repaid through equal monthly payments. It does not model variable rates, interest-only periods, balloon payments, skipped or late payments, payment holidays, additional principal payments, or fees rolled into the balance unless they are included in the principal input. Those features can change both the payment pattern and total interest.

A principal-interest schedule is also different from a payment quote that includes escrow, insurance, taxes, or other recurring charges. Those amounts may be collected alongside a loan payment, but they are not principal or interest in this formula. For a loan with irregular payment dates or daily interest accrual, the contractual method may produce different period-by-period amounts.

Frequently Asked Questions

What is a principal interest schedule?
It is a period-by-period record showing how loan payments are split between principal and interest, along with the changing balance. The calculator here estimates payment and total interest rather than listing every period.

Does more of each payment go to principal over time?
For a typical fixed-rate amortizing loan with level payments, yes: as the balance declines, the interest charge generally falls and more of the payment goes to principal. Contract terms and payment changes can affect that pattern.

Is APR the same as the monthly interest rate?
No. In this calculator, the monthly rate is APR divided by 12 and then by 100. Enter the annual percentage as a number, such as 8 for 8%, rather than entering a monthly rate.

Does total interest include fees or insurance?
No. The estimate includes only interest implied by the entered principal, APR, and term. Fees, insurance, taxes, and other charges are outside the calculation.

Why might my lender’s schedule differ?
Differences can result from the lender’s exact APR, payment dates, daily interest method, rounding, fees, or a final payment adjustment. Use the lender’s disclosure for the contractual schedule. This result is an estimate, and the lender’s disclosure gives the exact figures.

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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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 →