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

I like the site and the program. I do not appreciate being told of the cost until I had invested significant time filling it out. Not nice. Felt compelled to buy product - not fair. P.S. Even though I felt I had to buy it, I like it and have since used it multiple times.

Ellen G

I couldn't find 2018 W2 forms in the… I couldn't find 2018 W2 forms in the library. I looked for an hour. I could find 2016 W2s, 2019 W2s, but, not 2018. I found all kinds of IRS forms, but, not 2018 W2s. Finally I gave up after 2 days and emailed support. They responded immediately with form. It was awesome. I was shocked. They get A+ in my book !!!!! Jeff R.

Jeff B. Robinson

Easy alternative for PDF editing and updating More secure way to share documents with signature requests. Needs more cost-friendly modules for multiple users.

Rafat S.

Best software for PDF editing! My non-profit radio station has been more productive than ever before with PDFfiller! An user-friendly web app able to do much more than you thought it would do! - Edit PDF files easily - Recognize text and make them editable - Sign document simple as 1-2-3 It is not really cons, but some features are actually useless for me (ex: print to other companies to be sent at our offices)

Verified Reviewer

I mislead them on my intentions for the service level that I required. Once I brought it to their attention, I answered 3 questions; and the matter was immediately resolved. Outstanding customer service comms. !!!

William J Clements

Their customer service is great! Joyce helped me out and was super helpful and considerate! Best customer service experience I’ve had. Thanks for the quick response!

Sarah 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