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.
- Monthly rate r = 8 ÷ 1200 = 0.0066667 (0.66667% per month)
- Number of payments n = 5 × 12 = 60
- Payment = 20000 × (0.0066667 × (1.0066667^60)) / ((1.0066667^60) − 1)
- 1.0066667^60 = 1.48985 (rounded)
- Numerator = 20000 × (0.0066667 × 1.48985) = 20000 × 0.0099323 = 198.65
- Denominator = 1.48985 − 1 = 0.48985
- 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
- Debt Ratio Benchmarks: What Is a Good Debt Ratio?24.0 %
- Debt Ratio Calculation Formula & How to Use It25.00 %
- Car Loan Calculator: Estimate Your Monthly Payment$405.53
- Calculate My Payoff Date: Loan Payoff Calculator
- Student Loan Interest Deduction Limit: 2025 Rules$405.53
- Car Loan EMI Calculator Month Wise$405.53