calculate-loan

01 Loan payments

Free Home Amortization Schedule: How to Get One

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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 home amortization schedule is a table that shows each monthly mortgage payment broken down into principal and interest, and you can get one at no cost from most lenders, online calculators, or by building it yourself in a spreadsheet. You enter your loan amount, interest rate, and term, and the schedule shows your balance declining month by month until the loan is paid off. This article explains what an amortization schedule contains, how to read one, and the free ways to generate it without paying a service.

Formula

The standard amortization formula calculates a fixed monthly payment that fully repays the loan over the term. The payment is:

M = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

Where:

  • M = monthly payment (in dollars)
  • P = principal loan amount (in dollars)
  • r = monthly interest rate = annual rate (APR) ÷ 12 ÷ 100 (a decimal)
  • n = total number of monthly payments = years × 12

Each month, the interest portion is the current balance times the monthly rate, and the principal portion is the payment minus that interest. The balance after each payment is the previous balance minus the principal portion. Repeating this for every month produces the full schedule.

Worked Example

Using the default values from the calculator above: a $20,000 loan at 8% APR for 5 years.

  1. Monthly rate r = 8 ÷ 1200 = 0.0066667 (0.66667% per month)
  2. Number of payments n = 5 × 12 = 60
  3. Payment = 20000 × (0.0066667 × (1.0066667^60)) / ((1.0066667^60) − 1)
  4. 1.0066667^60 = 1.48985 (rounded)
  5. Numerator = 20000 × (0.0066667 × 1.48985) = 20000 × 0.0099323 = 198.65
  6. Denominator = 1.48985 − 1 = 0.48985
  7. Payment = 198.65 ÷ 0.48985 = 405.52 (rounded to cents)

So the monthly payment is $405.52. Total paid over 60 months = 405.52 × 60 = $24,331.20. Total interest = 24,331.20 − 20,000 = $4,331.20. These match the calculator outputs above.

The first month’s interest is 20,000 × 0.0066667 = $133.33, so the principal portion is 405.52 − 133.33 = $272.19, leaving a balance of $19,727.81. The second month’s interest is calculated on that lower balance, which is why the interest portion shrinks each month.

Assumptions

  • Fixed interest rate for the entire term (no adjustable-rate changes).
  • Payments are made monthly at the end of each month.
  • Interest compounds monthly at APR ÷ 12.
  • No prepayment penalties, late fees, or skipped payments.
  • Property taxes, homeowners insurance, PMI, HOA dues, and closing costs are not included unless you add them separately.

Where to Get a Free Amortization Schedule

You have several genuinely free options, and none require paying a service or entering a credit card.

  • Your lender or servicer – Most mortgage companies provide an amortization schedule in your closing documents or through your online account. You can also request one by phone or email at no charge.
  • Online calculators – Many financial websites, including this one, let you enter your loan details and instantly see a full schedule. Look for one that lets you view the month-by-month table, not just the payment amount.
  • Spreadsheet software – Excel, Google Sheets, and LibreOffice Calc have built-in functions (PMT, PPMT, IPMT) that generate the schedule. You can also build the table manually with the formula above.
  • Bank and credit union websites – Many large banks publish free amortization calculators on their public sites, even for non-customers.
  • Government consumer sites – Some federal agencies host calculators as educational tools, though they may not generate a downloadable full schedule.

How to Read the Schedule

Each row in an amortization schedule typically shows five columns: payment number, payment amount, interest paid, principal paid, and remaining balance. Early in the loan, most of each payment goes to interest. For a 30-year mortgage at a typical rate, it can take more than 20 years before the principal portion exceeds the interest portion. This is called the amortization curve, and it is not linear.

For example, on a $300,000 loan at 6% for 30 years, the payment is about $1,798.65. The first month’s interest is $1,500, so only $298.65 goes to principal. By month 180 (year 15), the interest is about $1,080 and principal about $718. The balance drops slowly at first and accelerates later.

Common Mistakes and Misconceptions

One frequent error is confusing the annual rate with the monthly rate. If you divide the annual rate by 12 incorrectly (e.g., using 8% instead of 0.6667%), the payment will be wildly wrong. Always convert APR to a monthly decimal before using the formula.

Another misconception is that paying

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 →