calculate-loan

01 Loan payments

Free Monthly Amortization Schedule: How to Build One

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

Monthly payment $405.53
Total interest
$4,331.67
= 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 free monthly amortization schedule is a table that shows each monthly loan payment, split into the interest portion and the principal portion, along with the remaining balance after every payment. You can generate one at no cost using the calculator below, a spreadsheet template, or a free online tool—you only need the loan amount, interest rate, and term. The schedule lets you see exactly how much of each payment goes toward interest versus paying down the loan, which is useful for budgeting and for understanding how extra payments shorten your loan.

Formula

The monthly payment for a fixed-rate loan is calculated with the standard amortization formula:

M = P × [ r(1 + r)^n ] / [ (1 + r)^n – 1 ]

  • M = monthly payment (in dollars)
  • P = principal, the original loan amount (in dollars)
  • r = monthly interest rate = annual percentage rate (APR) divided by 12, then divided by 100 (so an 8% APR gives r = 0.08 / 12 = 0.0066667)
  • n = total number of payments = loan term in years × 12

Each payment is the same amount for the whole term. In the first month, the interest is P × r, and the rest of the payment reduces the principal. For every subsequent month, the interest is recalculated on the new, smaller balance, so the interest portion shrinks and the principal portion grows over time.

Worked Example

Using the calculator defaults: a $20,000 loan at 8% APR for 5 years.

  1. Convert APR to a monthly rate: r = 8 / 1200 = 0.0066667
  2. Total payments: n = 5 × 12 = 60
  3. Apply the formula: M = 20000 × [0.0066667 × (1.0066667)^60] / [(1.0066667)^60 – 1]
  4. (1.0066667)^60 ≈ 1.489846
  5. Numerator: 20000 × 0.0066667 × 1.489846 ≈ 198.646
  6. Denominator: 1.489846 – 1 = 0.489846
  7. M ≈ 198.646 / 0.489846 ≈ 405.53

So the monthly payment is $405.53. Total paid over 60 months is 60 × 405.53 = $24,331.80. Total interest is $24,331.80 – $20,000 = $4,331.80, which matches the calculator’s output.

Assumptions

  • The interest rate is fixed for the entire term.
  • Payments are made at the end of each month, starting one month after the loan is issued.
  • Interest compounds monthly at APR / 12.
  • The schedule does not include fees, taxes, insurance, PMI, escrow, or prepayment penalties unless you add them separately.

How to Read an Amortization Schedule

Each row of the schedule shows the payment number, the payment amount, the interest paid that month, the principal paid that month, and the remaining balance. Early in the loan, most of the payment goes to interest. For the $20,000 example, the first payment is $405.53, of which $133.33 is interest (20000 × 0.0066667) and $272.20 is principal, leaving a balance of $19,727.80. By the final payment, the interest portion is only about $2.68 and the principal portion is $402.85.

This pattern matters because it means you build equity slowly at first. If you are considering paying off a loan early, the schedule shows that making an extra payment in the first few months saves more interest than the same extra payment made later, because the balance is higher early on.

Common Mistakes and Misconceptions

  • Using the APR directly as a monthly rate. Always divide by 12 (and by 100 if the APR is written as a percentage). An 8% APR is 0.08 per year, not 0.08 per month.
  • Rounding the payment too early. If you round the monthly payment to the cent and then multiply by the number of months, the total may differ by a few cents from a schedule that carried more decimal places. Most lenders round the payment to the cent and adjust the final payment slightly to make the balance hit zero.
  • Assuming interest is simple. Amortized loans charge interest on the remaining balance, not on the original amount, so the total interest is much less than principal × rate × term.
  • Forgetting the final payment adjustment. Because of rounding, the last payment is often a few cents different from the regular payment. A complete schedule will show this.

How to Build Your Own Schedule in a Spreadsheet

You do not need a paid tool. A spreadsheet with a few formulas will generate a full schedule in minutes.

  1. Enter the loan amount, APR, and term in separate cells.
  2. Calculate the monthly payment using the formula above, or use the spreadsheet’s built-in PMT function: =PMT(rate, nper, pv) where rate is APR/12, nper is term in months, and pv is the loan amount as a negative number.
  3. Create columns: Payment Number, Payment, Interest, Principal, Balance.
  4. For row 1: Interest = previous balance × monthly rate; Principal = payment – interest; New balance = previous balance – principal.
  5. Copy the formulas down for the total number of payments.

The last balance should be $0.00 (or within a few cents due to rounding). If it is not, check that you used the monthly rate and the correct number of payments.

Free vs. Paid Tools and What to Look For

Many banks, credit unions, and personal finance websites offer free amortization calculators. They all use the same formula, so the results will match if you enter the same inputs. The differences are in convenience: some let you add extra payments, show a printable schedule, or display a pie chart of interest versus principal.

When choosing a free tool, check that it lets you input the APR (not just a nominal rate), that it shows the monthly payment and total interest clearly, and that it allows you to print or export the schedule. Avoid tools that ask for personal information or require an account—a simple calculator does not need your email address.

For extra payments, a good schedule will show how an additional amount each month reduces the total interest and shortens the term. For example, adding $50 per month to the $405.53 payment on the $20,000 loan would pay it off in about 52 months instead of 60, saving roughly $500 in interest. The exact numbers depend on when you make the extra payment.

Limits of the Standard Schedule

The standard amortization schedule assumes every payment is made on time and in full. Real-world loans can differ:

  • Variable-rate loans change the interest rate at set intervals, so the payment changes and the schedule must be rebuilt for each rate period.
  • Biweekly payments (half the monthly payment every two weeks) result in 26 half-payments per year, which equals 13 full payments—one extra per year. This shortens the term and reduces interest, but the schedule looks different.
  • Deferred interest or interest-only periods (common on some student loans or mortgages) mean the payment does not cover principal for a while, so the balance stays flat or even grows.
  • Fees and insurance are not part of the principal and interest schedule. If your lender escrows property taxes or insurance, your actual monthly bill will be higher than the schedule shows.

For these cases, use a calculator that models the specific terms, or ask the lender for a custom schedule.

Frequently Asked Questions

Can I get a free amortization schedule without entering my email?
Yes. Many websites, including this one, generate a schedule directly in the browser without asking for contact information. Look for a calculator that shows the full table on the page or lets you download a CSV or PDF.

Why does my schedule show a different total interest than the simple interest calculation?
Because amortized interest is calculated on the declining balance each month, not on the original principal. Simple interest (principal × rate × years) overstates the cost. The schedule’s total interest is the correct figure for a fixed-rate amortized loan.

What happens if I make an extra payment?
The extra amount goes directly to principal, reducing the balance faster. This lowers the interest charged in all future months and shortens the loan term. You can see the effect by adding the extra payment to the schedule and watching the final payment number move up.

Is the monthly payment the same every month?
For a fixed-rate loan, yes, the payment is constant. The split between interest and principal changes each month, but the total payment stays the same until the final payment, which may differ by a few cents due to rounding.

Does the schedule include taxes and insurance?
No, unless you add them as separate inputs. The schedule covers only principal and interest. If your lender collects taxes and insurance in an escrow account, your actual monthly payment will be higher than the schedule shows.

Can I use the schedule for a car loan or personal loan?
Yes, the same formula applies to any fixed-rate, fully amortizing loan—auto, personal, student, or mortgage. As long as the rate is fixed and payments are monthly, the schedule works the same way.

The result from this calculator is an estimate based on the inputs you provide; the lender’s official disclosure will give the exact payment and total cost 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

The whole Loan payments section →