Last updated on
Sep 20, 2025
Amortization Schedule in Excel
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
Note: Integration described on this webpage may temporarily not be available.
0
Forms filled
0
Forms signed
0
Forms sent
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
Merge
Combine multiple PDFs into one.
Start now
Rearrange
Rearrange pages in a PDF document.
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
Upload your document to the PDF editor
Type anywhere or sign your form
Print, email, fax, or export
Try it right now! Edit pdf
Amortization Schedule Excel Feature
Welcome to our Amortization Schedule Excel feature! Are you looking to easily calculate and track your loan payments? Look no further, as this feature has got you covered.
Key Features:
Automatically generates detailed amortization schedules
Allows customization of input variables such as loan amount, interest rate, and term
Provides a visual representation of principal and interest payments over time
Potential Use Cases and Benefits:
Perfect for individuals managing personal loans or mortgages
Ideal for financial professionals to analyze loan scenarios
Helps users understand how their payments are allocated between principal and interest
With our Amortization Schedule Excel feature, say goodbye to manual calculations and hello to effortless loan tracking. Empower yourself with accurate data and make informed financial decisions.
All-in-one PDF software
A single pill for all your PDF headaches. Edit, fill out, eSign, and share – on any device.
How to Amortization Schedule in Excel
01
Go into the pdfFiller site. Login or create your account cost-free.
02
With a protected internet solution, you can Functionality faster than ever.
03
Enter the Mybox on the left sidebar to get into the list of the files.
04
Select the template from your list or press Add New to upload the Document Type from your pc or mobile device.
As an alternative, you can quickly transfer the necessary template from popular cloud storages: Google Drive, Dropbox, OneDrive or Box.
As an alternative, you can quickly transfer the necessary template from popular cloud storages: Google Drive, Dropbox, OneDrive or Box.
05
Your form will open inside the function-rich PDF Editor where you can customize the template, fill it up and sign online.
06
The highly effective toolkit allows you to type text in the contract, put and modify graphics, annotate, and so forth.
07
Use sophisticated functions to add fillable fields, rearrange pages, date and sign the printable PDF document electronically.
08
Click the DONE button to complete the changes.
09
Download the newly produced document, share, print, notarize and a much more.
Related features
What our customers say about pdfFiller
See for yourself by reading reviews on the most popular resources:
Gary G
2019-12-22
I lost all my forms that I filled out. I have to get blanks and start over. I'am not compurter literate. I could not retrieve my filled forms. What a waste of my time, No body bothered to let me know how l could retreve them. Only worried about what grade they would get.
Amy Gregory
2020-04-30
Had an issue with my subscription
Had an issue with my subscription cancellation, was rectified within less than an hour by Kim and very efficient customer service.
For pdfFiller’s FAQs
Below is a list of the most common customer questions. If you can’t find an answer to your question, please don’t hesitate to reach out to us.
What if I have more questions?
Contact Support
Does Excel have 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.
How do I create an 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 make an amortization schedule by hand?
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 does an amortization schedule work?
Amortization is the process of spreading out a loan into a series of fixed payments over time. You'll be paying off the loan's interest and principal in different amounts each month, although your total payment remains equal each period. ... The interest costs (what your lender gets paid for the loan).
How do I calculate loan repayments in Excel?
Principle = the amount you want to borrow.
The Interest Rate = the per annum interest rate divided by 12. So if the interest rate is 6.5%pa then calculate it as:
The term = how long you'll have the loan in months. So if it's a 30 year loan calculate it as:
How do I calculate mortgage payments using Excel?
Calculate the monthly payment. To figure out how much you must pay on the mortgage each month, use the following formula: "= -PMT(Interest Rate/Payments per Year,Total Number of Payments,Loan Amount,0)". For the provided screenshot, the formula is "-PMT(B6/B8,B9,B5,0)".
How do you prepare an 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 you do an 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 a loan 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.
How do you calculate amortized cost?
Straight-Line Method Divide the premium or discount by the number of months left outstanding on the bond to arrive at bond amortization. Multiply the bond's face value by the stated interest rate on the bond, and then subtract the premium amortization, or add the discount amortization to arrive at interest expense.
Other ready to use document templates
eSignature workflows made easy
Sign, send for signature, and track documents in real-time with signNow.