How do I create a loan amortization schedule?

Use the PPMT function to calculate the principal part of the payment. ... Use the IPMT function to calculate the interest part of the payment. ... Update the balance. Select the range A7:E7 (first payment) and drag it down one row. ... Select the range A8:E8 (second payment) and drag it down to row 30.

How do I create a loan amortization schedule in Excel?

Use the PPMT function to calculate the principal part of the payment. ... Use the IPMT function to calculate the interest part of the payment. ... Update the balance. Select the range A7:E7 (first payment) and drag it down one row. ... Select the range A8:E8 (second payment) and drag it down to row 30.

How do you create a loan amortization schedule?

To calculate amortization, start by dividing the loan's interest rate by 12 to find the monthly interest rate. Then, multiply the monthly interest rate by the principal amount to find the first month's interest. Next, subtract the first month's interest from the monthly payment to find the principal payment amount.

What is the formula for calculating amortization?

Calculating the Payment Amount per Period You can use the amortization calculator below to determine that the Payment Amount (A) is $400.76 per month. P = $20,000. r = 7.5% per year / 12 months = 0.625% per period. n = 5 years * 12 months = 60 total periods.

How do I calculate interest on a loan in Excel?

rate - The interest rate per period. We divide the value in C6 by 12 since 4.5% represents annual interest, and we need the periodic interest. nper - the number of periods comes from cell C7; 60 monthly periods for a 5 year loan. pv - the loan amount comes from C5.

How do you calculate principal on a loan?

Divide your interest rate by the number of payments you'll make in the year (interest rates are expressed annually). So, for example, if you're making monthly payments, divide by 12. 2. Multiply it by the balance of your loan, which for the first payment, will be your whole principal amount.

Why is more interest paid at the beginning of a loan?

In the beginning, you owe more interest, because your loan balance is still high. So most of your monthly payment goes to pay the interest, and a little bit goes to paying off the principal. Over time, as you pay down the principal, you owe less interest each month, because your loan balance is lower.

Why do you pay more interest at the start of a mortgage?

The way it works is that you always pay off interest first, and then any excess goes to pay off the principal. However early in the mortgage there is more interest, and so less of the payments go toward principal. Later in the mortgage there is less interest, so more of the payments go to principal.

Why is interest typically paid on a loan?

Paying Interest When you borrow money, you generally have to pay interest. ... Each month, a portion of your payment goes towards reducing your debt, but another portion is your interest cost. With those loans, you pay down your debt over a specific time period (a 15-year mortgage or 5-year auto loan, for example).

How does interest accrue on a loan?

The interest on a student loan is calculated by multiplying the loan balance with the annual interest rate and the number of days since the last payment divided by the number of days in the year. ... (During a deferment, the federal government will pay the interest as it accrues on subsidized loans.

Functionality index

Create and edit PDF documents online

Drop document here to upload

Select from device

Up to 100 MB for PDF and up to 25 MB for DOC, DOCX, RTF, PPT, PPTX, JPEG, PNG, JFIF, XLS, XLSX or TXT

Based on 12500+ reviews

Last updated on Jan 16, 2026

Try these PDF tools

Edit PDF

Quickly edit and annotate PDFs online.

Start now

Sign

eSign documents from anywhere.

Start now

Request signatures

Send a document for eSignature.

Start now

Share

Instantly send PDFs for review and editing.

Start now

Find forms online

Browse the online library of forms.

Start now

Merge

Combine multiple PDFs into one.

Start now

Rearrange

Rearrange pages in a PDF document.

Start now

Collaborate

Exchange comments and edit PDFs collaboratively.

Start now

Compress

Compress PDFs to reduce their size.

Start now

Convert

Convert PDFs into Word, Excel, JPG, or PPT files and vice versa.

Start now

Create from scratch

Start with a blank page.

Start now

Edit DOC

Edit Word documents.

Start now

Document creation is just the beginning

Learn more about security

Create and edit documents with a trusted solution

Try easy-to-use tools for all your document management needs.

Upload your document

pdfFiller scores top ratings on review platforms

Easy to use and affordable way to edit your pdf documents. I love that it is cloud based so you can access them anywhere. You can even sign like a docusign.

Helen S

Getting to put 3 people on the account has been great. All of the features are exactly what I needed, and the editor is easy to use. I was a little wary if it would be worth the money, but I'm very happy with my purchase.

Chel

It was fast, easy and extremely self explanatory. I actually signed up for it because it was worth it. I recommend it to anyone who needs access to documents quickly. There was also a plethora of different forms to choose from.

Stephanie S

It is a convenient application It is a convenient application which allows professional appearance to forms. I am a little concerned about shared documents which need editing if the recipient is not a subscriber.

Kenneth Cureton

I thoroughly enjoyed using the platform which made editing and using the documents incredibly easy. Their customer service is also excellent and went above and beyond to accommodate my request immediately.

Molly M

A Comprehensive and User-Friendly PDF Editing & Document Management Solution I recently started using pdfFiller for my document needs, and my overall experience has been very positive. The platform offers a wide array of features that make handling PDFs and documents incredibly efficient. All-in-One Functionality: pdfFiller truly lives up to its promise as an "all-in-one" solution. Whether you need to edit, merge, split, sign, or even rearrange pages, everything is available in one intuitive dashboard. This has streamlined my workflow significantly by eliminating the need to juggle multiple applications.

Deborah Swan

Show more Show less

Watch pdfFiller eSignatures in action

Check out a quick video tutorial that shows how to create and place your signature or send a document for signing.

Related features

Create and edit documents with a trusted solution

Try easy-to-use tools for all your document management needs.

Upload your document