Home › Calculators › Loan calculator with payment schedule
Loan calculator with payment schedule
Monthly payment, total interest and a month-by-month schedule in Excel. Free, instant, no sign-up.
- Type Loan amount, Yearly interest rate (%) and Years (and plus months if needed).
- Choose Payment type: Same payment every month or Same principal, falling payment.
- Type Extra payment each month (optional) to see how much you save.
- Press Calculate loan.
- Type Loan amount, Yearly interest rate (%) and Years (and plus months if needed).
- Choose Payment type: Same payment every month or Same principal, falling payment.
- Type Extra payment each month (optional) to see how much you save.
- Press Calculate loan.
💡 Simple guide · no technical skills needed
When do I need this?
You are thinking about a loan and want to know the monthly payment and total interest.
Good to know
- The bank may add fees, so the real cost can be higher.
- This is an estimate, not an offer.
Words explained
- Excel
- A spreadsheet program (tables with rows and columns). Google Sheets and LibreOffice open the same files.
Stuck? Press Help in the bottom corner and write your question in any language. You get an answer in seconds, or a real person answers you.
More free tools
Calculators
For everyday sums: percent, loans, VAT, working days, dates, ages, units and time zones.
PDF tools
For when you have a PDF: join, cut, shrink, turn pages, or get the text and tables out of it.
Images
For photos and pictures: make them smaller, change the size or type, or copy the text in them.
Excel, CSV and lists
For Excel and lists: clean up, join, split, convert or compare them.
Invoices, banking and VAT
For invoices, bank account numbers (IBAN), VAT numbers and bank upload files.
Websites and e-mail
For your website and e-mail: find problems and get the fix in plain words.
Products, customs and cars
For sending goods abroad (customs codes) and checking used cars.
QR codes and barcodes
Make a QR code (link, Wi-Fi, payment) or a barcode in one click.
Live rates and data
Today's numbers from official sources. Nothing to upload, just read.
Text and code tools
For text and code: count words, change capital letters, remove repeats, tidy JSON, make passwords, encode or compare text.
Audio and video
For your own video and sound files: get the MP3, make a GIF, cut, shrink or change the format.