Skip to content

Loan repayment schedule

Enter a loan and get the monthly payment and a full month by month repayment table.

Loan repayment schedule template, first page

Fill it in and preview

Loan repayment schedule

A spreadsheet that works out a loan paid in equal monthly instalments. Enter the amount, yearly interest rate and term and it gives the monthly payment, the total paid back and the interest, and a table of every payment split into interest and principal with the balance left. Download it as Excel, OpenDocument, PDF or CSV.

Loan

Loan repayment schedule

Fill in the yellow cells. The monthly payment, the totals and the full schedule on the next sheet follow.

Borrower Marta Silva

Loan amount 18,000.00

Yearly interest rate (%) 6.50

Loan term in years 5

First payment date 2027-04-01

Number of payments 60

Monthly payment 352.19

Total paid back 21,131.44

Total interest 3,131.44

Last payment date 2032-03-01

Schedule

Payment schedule

Payment Date Payment amount Interest Principal Balance
0 18,000.00
1 2027-04-01 352.19 97.50 254.69 17,745.31
2 2027-05-01 352.19 96.12 256.07 17,489.24
3 2027-06-01 352.19 94.73 257.46 17,231.78
4 2027-07-01 352.19 93.34 258.85 16,972.93
5 2027-08-01 352.19 91.94 260.25 16,712.68
6 2027-09-01 352.19 90.53 261.66 16,451.01
7 2027-10-01 352.19 89.11 263.08 16,187.93
8 2027-11-01 352.19 87.68 264.51 15,923.43
9 2027-12-01 352.19 86.25 265.94 15,657.49
10 2028-01-01 352.19 84.81 267.38 15,390.11
11 2028-02-01 352.19 83.36 268.83 15,121.28
12 2028-03-01 352.19 81.91 270.28 14,851.00
13 2028-04-01 352.19 80.44 271.75 14,579.25
14 2028-05-01 352.19 78.97 273.22 14,306.03
15 2028-06-01 352.19 77.49 274.70 14,031.33
16 2028-07-01 352.19 76.00 276.19 13,755.14
17 2028-08-01 352.19 74.51 277.68 13,477.46
18 2028-09-01 352.19 73.00 279.19 13,198.27
19 2028-10-01 352.19 71.49 280.70 12,917.57

Open this spreadsheet in nerixA preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Finance and accounting

What this template is for

A loan repayment schedule spreadsheet: enter amount, rate and term for the monthly payment, total interest and each payment split into interest and principal.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. See all Finance and accounting templates All free Excel and spreadsheet templates

Finance and accounting

What you fill in

The form asks for 5 details. The document fills itself in as you type.

  • Borroweroptional

    For example: Marta Silva

  • Loan amount

    For example: 18000

  • Yearly interest rate (%)

    The yearly rate in percent, such as 6.5.

    For example: 6.5

  • Loan term in years

    Up to 40 years.

    For example: 5

  • First payment dateoptional

    For example: 2027-04-01

Finance and accounting

What is inside

The parts of this document, in order.

  1. 1A spreadsheet that works out a loan paid in equal monthly instalments. Enter the amount, yearly interest rate and ter...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 03

    Download

    Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

Adapt it with nerix

Finance and accounting

Questions people ask

What details does this template ask for?

The form asks for 5 details, starting with Loan amount, Yearly interest rate, Loan term in years. 2 more are optional.

Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

What should I check before I use this template?

This is an estimate for a loan paid in equal monthly instalments. Your lender's schedule can differ because of fees, the way it counts days and rate changes, so check it against theirs.

Are these finance templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

Do these templates include tax rules?

No. Tax and invoicing rules differ by country. Each template has fields for amounts and references, and you add the tax details your local rules require.

Can I use them with my accounting software?

Yes. They are plain documents. Download the Word version, or copy the figures into your software.