Excel Monthly Amortization Schedule [Free Download]

Download our free Excel Monthly Amortization Schedule template to generate your monthly amortization schedule and read the article to learn how to use this article efficiently.

Monthly Amortization Schedule Excel


Download the Excel Template

Download Excel Template

For: Excel 2007 or later
License: Private Use


What Is Monthly Amortization Schedule?
Excel Monthly Amortization Schedule Template
  How to Use This Template
  ⏵Excel Monthly Amortization Schedule with Extra Payments (Regular/Irregular) Template
Excel Monthly Amortization Schedule Template Tips

What Is a Monthly Amortization Schedule?

A monthly amortization schedule is an amortization schedule that shows the principal paid, interest paid, and the remaining loan balance after each monthly payment over the loan tenure. It allows the borrower to track his/her loan repayment process easily.


Excel Monthly Amortization Schedule Template

How to Use This Template

  • Open the Payoff Calc. sheet and insert all required inputs in the blue-shaded area of the Input Values column. The required inputs are:
  1. Original Loan Terms (Years)
  2. Loan Amount
  3. Annual Percentage Rate (APR)
  4. First Payment Date
  5. Payment Type
  6. Interest Compounding Frequency

Insert Required Inputs

  • After inserting all inputs, you will find your required regular monthly payment, an amortization table for your monthly loan, and a summary chart showing the principal paid, interest paid, and remaining balance over the loan tenure.
  • You will also find an output summary containing:
  1. Interest Rate (Per Period)
  2. Total Amount to be Paid
  3. Total Interest to be Paid
  4. Total No. of Payments
  5. Total Time

Monthly Amortization Schedule Excel

Read More: Loan Amortization Schedule with Variable Interest Rate in Excel


Excel Monthly Amortization Schedule with Extra Payments (Regular/Irregular) Template

If a borrower can earn extra money, they might want to make some extra payments with their regular payments. This will lower the total interest.

In this template, you can insert these extra payment inputs and get all the results and charts based on these inputs.

Monthly Amortization Schedule with Extra Payments

How to Use This Template

  • Open the Payoff Calc. (Extra Payments) sheet and insert all the required inputs in the blue shaded area of the Input Values column.

Insert Required Inputs

  • If you want to make some irregular extra payments, you have to record them manually in the Extra Payments (Irregular) column in the amortization table.

Insert Extra Irregular Payments

  • You will get your automated amortization schedule with extra payments and a new summary chart showing the principal paid, interest paid, and remaining balance trend over the loan years.
  • You will also find an output summary containing all important outputs such as estimated interest savings and time saved.

Monthly Amortization Schedule with Extra Payments

Read More: Excel Actual/360 Amortization Calculator Template


Excel Monthly Amortization Schedule Template Tips

  • Read and follow the added notes in the loan parameters to insert your loan input values properly.
  • When choosing interest compounding frequency, choose it as greater frequency than monthly payment frequency.
  • When choosing extra payment frequency, choose it as a multiple frequency of monthly payment frequency.

Related Articles


<< Go Back to Amortization Schedule | Finance Template | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo