Monthly Amortization Schedule

What is monthly amortization schedule?

A monthly amortization schedule is a table that details how much of each loan payment goes towards the principal balance, interest fees, and any other charges. It helps borrowers understand how their payments are allocated over time

What are the types of monthly amortization schedule?

There are two main types of monthly amortization schedules: fixed-rate and adjustable-rate. Fixed-rate schedules have stable payments throughout the loan term, while adjustable-rate schedules have payments that may fluctuate based on market conditions.

Fixed-rate amortization schedule
Adjustable-rate amortization schedule

How to complete monthly amortization schedule

To complete a monthly amortization schedule, follow these steps:

01
Gather all necessary loan details such as the principal amount, interest rate, and loan term
02
Use an online calculator or spreadsheet to set up the schedule
03
Input the loan details and calculate the monthly payment amount
04
Record the payment allocation towards principal, interest, and other fees each month
05
Review the schedule regularly to track the loan balance and payment progress

pdfFiller empowers users to create, edit, and share documents online. Offering unlimited fillable templates and powerful editing tools, pdfFiller is the only PDF editor users need to get their documents done.

Video Tutorial How to Fill Out monthly amortization schedule

Thousands of positive reviews can’t be wrong

Read more or give pdfFiller a try to experience the benefits for yourself
5.0
What a time saver all docs filled in.
What a time saver all docs filled in… What a time saver all docs filled in and signed ready to mail Thanks
Anthony Dorfling
5.0
Very happy with the product Very happy with the product, I used trial version to...
Very happy with the product Very happy with the product, I used trial version to promote it within the company, simply amazing, thanks team.Best regards,Juan Soto
JUAN SOTO
5.0
This software seems to be nice and easy to use, im still working my way round it...
This software seems to be nice and easy to use, im still working my way round it. I was looking to send a form to be returned filled in. Looks like this should be easy enough. I will keep my fingers crossed.
Gary G.

Questions & answers

You can build your own amortization schedule and include an extra payment each year to see how much that will affect the amount of time it takes to pay off the loan and lower the interest charges.
Having an adjustable-rate mortgage could cause amounts applied to principal and interest to change over time, as well. Your lender should be able to provide an amortization schedule, but you can also make your own.
Stay on top of a mortgage, home improvement, student, or other loans with this Excel amortization schedule. Use it to create an amortization schedule that calculates total interest and total payments and includes the option to add extra payments.
Loan Amortization Schedule 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.
Starting in month one, take the total amount of the loan and multiply it by the interest rate on the loan. Then for a loan with monthly repayments, divide the result by 12 to get your monthly interest. Subtract the interest from the total monthly payment, and the remaining amount is what goes toward principal.
Starting in month one, take the total amount of the loan and multiply it by the interest rate on the loan. Then for a loan with monthly repayments, divide the result by 12 to get your monthly interest. Subtract the interest from the total monthly payment, and the remaining amount is what goes toward principal.