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.

How do I create an amortization schedule in Excel?

Launch Microsoft Excel and open a new spreadsheet. Create labels in cells A1 down through A4 as follows: Loan Amount, Interest Rate, Months and Payments. Include the information pertaining to your loan in the cells B1 down through B3. Enter your loan interest rate as a percentage.

Does Excel have an amortization schedule?

An amortization schedule is a table that shows each loan payment and a breakdown of the amount of interest and principal. Typically, it will also show the remaining balance after each payment has been made.

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 you use the PPMT function in Excel?

Excel PPMT Function. The Excel PPMT function can be used to calculate the principal portion of a given loan payment. For example, you can use PPMT to get the principal amount of a payment for the first period, the last period, or any period in between. nper - The total number of payments for the loan.

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.

How do you calculate principal only payments?

Use PMT to calculate the monthly loan payment. Use PPMT to calculate the principal amount for the payment of interest. Subtract step 2 from step 1 to get the interest part of the specified payment.

How do you calculate payments on a loan?

Interest-Only Loan Payment Calculation Formula Multiply the amount you borrow by the annual interest rate. Then divide by the number of payments per year. There are other ways to arrive at that same result. Example (using the same loan as above): $100,000 times .06 = $6,000 per year of interest.

What is a principal amount of loan?

The principal of a loan is the amount borrowed. Interest is calculated on the principal. In a loan amortization schedule, the principal and interest are separated, so you can see which part of your monthly payment goes to paying off the principal, and which part is used to pay interest.

How is principal and interest calculated?

Consult your mortgage statement to find your annual percentage rate, or APR, and the principal balance on your loan. The principal balance is whatever you borrowed, less the amount you have paid back. The APR is your interest rate. Divide your APR by 12 to get your monthly interest rate.

Functionality index

Create and edit PDF documents online

Drop document here to upload

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 Dec 28, 2025

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

I like the program. I did pay for it, so I feel that I should be able to upload pictures to the file. Uploading images should be included in a basic membership. I still like the service.

carolina

What do you like best?
PDF Filler is great for completing forms, editing existing PDF documents, and digitally signing forms.
What do you dislike?
Meets all expectations and more. No issues whatsoever.
Recommendations to others considering the product:
We are only using part of the functionality of PDFfiller. No doubt other businesses will be able to take advantage of more of the features. Well worthwhile.
What problems are you solving with the product? What benefits have you realized?
PDF Filler saves us time in several ways: 1) saves time spent scanning documents, 2) makes completion of third party forms faster and more professional looking, 3) enables editing of existing PDF documents (rather than editing in Word, printing or saving as a PDF and re-signing), and 4) Digital signing.

Craig Calkins

What do you like best?
Very user friendly. Great app that also allows you to edit PDF documents while on-the-go.
What do you dislike?
It can sometimes freeze or crash, but rarely happens.
Recommendations to others considering the product:
Use this website & tool if you're on-the-go and work from your car or laptop frequently. It's very useful and easy to navigate.
What problems are you solving with the product? What benefits have you realized?
Working on the go without my computer nearby. Keeps my contracts neat & tidy by being able to cross things out and clearly type edits/changes.

Casey Kwitkin

I've been using PDFfiller regularly for over 2 years now, and it works wonderfully. I'm able to upload documents, add fillable lines, and get electronic signatures seamlessly. Customer service is also great - prompt and friendly in attending to any questions or issues. Makes running my business that much easier.

Monica K

This is excellent This is excellent! your system allow anyone to pull up filling and save documents to be able to come back for it that's awesomeness and genius, please keep up the good service that you provide your customer you keep them happy me as well.

Elijah Alexis

Great Functionality, Amazing Customer Support, Great Experience Overall This is a great platform, very seamless and user friendly. It does cost a bit so it would make sense if you use it quite often. More importantly, amazing support - the online chat response was quick (!!!), customer support staff was so friendly and understanding. Overall, such an amazing experience using this platform. Highly recommend you give it a go!

MaL

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