How do you set up an amortization schedule for a mortgage?

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 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.

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 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.

What is a loan amortization schedule and what are some ways these schedules are used?

An amortization schedule is often used to produce identical payments for the term (repayment period) of a loan, resulting in the principal being paid off and the debt retired at the end of the loan. This is in contrast to an interest only, or balloon loan. ... This formula comes from the Wikipedia article on amortization.

How do you calculate principal and interest on a mortgage?

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 monthly mortgage payments?

M = the total monthly mortgage payment. P = the principal loan amount. r = your monthly interest rate. Lenders provide you an annual rate so you'll need to divide that figure by 12 (the number of months in a year) to get the monthly rate. ... n = number of payments over the loan's lifetime.

How do you calculate principal and interest in Excel?

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 is P&I calculated on a mortgage?

Calculating Your Mortgage Payment To figure your mortgage payment, start by converting your annual interest rate to a monthly interest rate by dividing by 12. Next, add 1 to the monthly rate. Third, multiply the number of years in the term of the mortgage by 12 to calculate the number of monthly payments you'll make.

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

Stress free I am able to get many projects done quicker and more efficiently with the use of PDFfiller. I enjoy the benefit of multiple different ways to finalize the project, send for signatures, print, email, save, etc. I love that this software is simple to use and I don't feel I need training to use it. Almost all the functions this software has is what I need to complete task in my professional role. I wish there were ways to combine documents, or if there is, making it easier to do so.

Verified Reviewer

I believe it's the best PDF Editor out there I really love using it especially when i'm not able to fix things in Adobe Acrobat I use this site and it gets the job done perfectly

ANDREW DANIEL F

Love it It's the easiest app I've used when it comes to filling in forms. Simply save your form in your files and export or attach to the App and it's self explanatory No cons It's point click and fill in. Can't go wrong

LaTosha M.

Has worked perfectly fine with editing… Has worked perfectly fine with editing non-fillable pdf forms. No issues with saving in various forms to my computer. Works just as expected.

David Slocum

Kara was great at explaining and… Kara was great at explaining and providing me the info I needed to be successful with the platform.. She saved the day.. Thanks Kara..

angela porter

Not sure how I "subscribed", yet PDFfiller honoured their policy of full cancellation and FULL REFUND. I'm IMPRESSED !!! The went further and added an offer of a further FREE TRIAL. If their products are as good as their service, I'll definitely intentionally subscribe at some stage in the future ... after South Africa's political siege they call "Lockdown". Well done PDFfiller.

David W

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