Amortization Schedule Template
Amounts, taxes and totals are calculated in real time from what you enter — what you fill is what the PDF outputs.
See a loan payment by payment: the monthly figure, how much of each one is interest and how much is principal, the balance after every payment and the month the loan clears.
📎 After you download — enhance your PDF
📋 Field Overview
Fields this template needs — the fill page groups them into sections.
📝 Companion Guide
Step-by-step guide with field explanations, tax tips and common mistakes for this template.
Read the Guide →💳 Pricing
Templates are currently free to use, with no sign-up or watermark. Check this page for current feature and pricing information.
View All Templates →💡 Usage Tips
- Fill only the four loan fields — the payment, the totals and the whole table are calculated for you
- Compare offers by total interest, not by monthly payment: a longer term lowers the payment and raises the cost
- One extra payment a year typically cuts years off a mortgage — put a small number in Extra Monthly Payment and watch the payoff date move
- Add escrow, mortgage insurance or fees in Notes so the document matches what you actually pay each month
❓ FAQ
From the amount, the annual rate and the term, using the standard amortization formula payment = P x r / (1 - (1 + r)^-n), where r is the yearly rate divided by 12 and n is the number of payments. Interest for each month is the remaining balance × r, principal is the rest of the payment, and the final payment clears whatever balance is left.
Interest is charged on the balance, so it is largest at the start. On a $200,000 loan at 6.5% the first payment puts about $180 toward principal and $1,083 toward interest; by the last year that reverses. The yearly summary in this document shows exactly when the split turns.
Yes — the extra goes straight to principal, so every later month is charged interest on a smaller balance. $200 a month on that same loan clears it roughly nine years early and saves about $90,000 in interest; enter it in Extra Monthly Payment to see your own figures.
Close, not identical. Lenders use their own day-count, payment dates and rounding, and may fold in escrow or fees. Use this to plan and compare; use your servicer's statement for the official payoff figure.
No. These templates are for general business record-keeping only. They are not legal, tax, or professional advice. Consult a qualified advisor for compliance in your jurisdiction.