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

In less than ten minutes I was messaged back by customer service via email, it's 11:15 pm by the way, and the problem at hand was resolved immediately. This is not a robot or program typing this, I am a real human being, my name is Mike and I totally love PDFfiller.

Mike

It does what I need it to, it saves others from having to read my very poor handwriting, and, since it saves the files, if I need to file them again next year, I just have to change a couple of dates, and "Voila!"

Dennis

I find it tedious that I cannot page or scroll down with my cursor on the document. I also like pdf filler apps used by realtors that let you initial and then step to the next blank to complete.

John L

After contacting customer support, I was told that certain web browsers are more compatible than others in completing forms. Once I changed from Mozilla Firefox to Chrome, I was able to complete all fields of the form without problems. But it would have been helpful to publicize this information on your website so that much time was not wasted.

Robert W W

What do you like best?
The availability of tax forms that are accessible and fillable at your finger tips is awesome.
What do you dislike?
Sometimes searching for a form content takes a few tries to find the correct form.
What problems are you solving with the product? What benefits have you realized?
Completing client tax reporting forms timely.

User in Accounting

PDFfiller for the win!! PDFfiller for the win!! Of course, I've enjoyed avoiding filling out forms by hand and being able to create & save legible documents I can duplicate and email. But tonight, PDFfiller LiveChat surprised me! They helped solve a document problem for my daughter's online university application. The application program wouldn't let her upload her SAT scores, or continue her application until they were loaded! The website kept saying the 2-page file was too big!? So I loaded it onto PDFfiller, and got a helpful LiveChat rep, who quickly compressed the file for me. Voila, it worked!! PDFfiller, you just saved the day!

Jennifer Kennedy

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