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.

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)\".

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.

What is the formula for monthly payments?

Calculating Monthly Payments. The following formula is used to calculate the fixed monthly payment, P, required to fully amortize a loan of L dollars over a term of n months at a monthly interest rate of c. (If the annual rate is 6%, for example, c = 0.06 / 12 = 0.005.) P=Lc(1+c)n(1+c)n1.

What is the formula for calculating principal and interest?

Simple Interest Formulas and Calculations: Use this simple interest calculator to find A, the Final Investment Value, using the simple interest formula: A = P(1 + rt) where P is the Principal amount of money to be invested at an Interest Rate R% per period for t Number of Time Periods.

What is amortization with example?

Amortization. Amortization is the practice of spreading an intangible asset's cost over that asset's useful life. Intangible assets are not physical assets, per se. Examples of intangible assets that are expensed through amortization might include: Patents and trademarks.

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

this makes filling out medical forms sooo much easier. I can fill them out and email them back without needing to print them and rescan or fax them back. Thank you for this wonderful software ! So this being a followup review I can tell you I still love it as much as I did before. I was able to use it to fill out medical forms and also a form for a winter retreat. The only drawback to this PDFfiller.com is the cost.

Jim

I use PDFfiller to create and sign military and employment documents. It is fairly easy to use. I love being able to save docs to my Google Drive. And the electronic signature is awesome.

Jason M

I really appreciated the customizable aspects of your software -- it made all the difference to my forms! The only thing that I would've liked more is if upon searching for the form, you could filter and guarantee that its the most up to date form the gov has issued. Thank you

shelley

Just started using it today Just started using it today. I'm afraid it will only let me save 5 documents to my computer because I got a pop-up about that

Sara

I needed to create new documents when… I needed to create new documents when my original templates had disappeared because I moved and my email locked me out. PDF Filler came to the rescue and made it possible for me to create all new documents and templates and I was back in business.

Dale R.

With pdfFiller the process of filling out pdf forms becomes easier like ABC PdfFiller is a very comprehensive online PDF editor and form filling platform. With relatively intuitive and easy-to-use features, users can quickly create and fill out documents, forms, and contracts, save signatures, add text, embed images and combine multiple PDFs. In addition, it also provides access to thousands of free templates, cloud storage solutions and compatibility with popular file formats such as Adobe Acrobat and Microsoft Office. The software offers many features, such as customizable templates, unlimited storage and legally binding digital signatures. With its user-friendly interface, PdfFiller is the ideal tool for businesses and individuals who need a quick and efficient digital document management process. Among the advantages is it's easy to use and navigate interface. Additionally, it has support for over 20 different document formats. It can also access forms quickly and efficiently. The process of filling out the form is electronic and sign the document with the eSignature feature so multiple users can collaborate on the document at the same time. It also has special security features to keep all data safe. The downside is that the existing form templates are very limited. It's also inappropriate.for relatively long documents besides mac or iOS version is not provided besides it has a subscription fee to pay.

Mohd Nubli B.

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