Excel Quarterly Amortization Schedule [Free Download]

The quarterly amortization schedule is a helping tool to track one’s quarterly loan repayment process. It is assumed that the borrower pays his payments quarterly and the amortization table shows the principal paid, interest paid, and remaining balance after each payment over the loan tenure.

Download our free Excel Quarterly Amortization Schedule template to generate your quarterly loan amortization schedule and go through the article below to learn how to use this template.

This template would be greatly useful for bankers, financial planners, investors, and all kinds of borrowers and lenders who are looking forward to taking or giving away a loan.

Click here to enlarge the image

Download Excel Template

Download Excel Template

For: Excel 2007 or later
License: Private Use

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

What Is Quarterly Amortization Schedule?

The quarterly amortization schedule is an amortization schedule that assumes the regular payment is done quarterly for repaying a loan. The amortization schedule shows the principal paid, interest paid, and remaining balance after each payment over the loan terms. From this schedule, the borrower can easily track and visualize his loan repayment process.

Excel Quarterly Amortization Schedule Template

In this template, you will be able to insert all your loan parameters and get an amortization table with the required quarterly payment. You will also get an output summary showing you all the important outputs and a summary chart to display the principal paid, interest paid, and remaining balance trend over the loan terms.

How to Use This Template

Follow the instructions below to use this template efficiently.

Instructions:

Open the Payoff Calc. sheet and insert all your required inputs in the blue-shaded area of the Input Values column. The required inputs are:

Original Loan Terms (Years)
Loan Amount
Annual Percentage Rate
First Payment Date
Payment Type
Interest Compounding Frequency

Click here to enlarge the image

You will get your required quarterly payment amount and an automated amortization table along with a summary chart.
You will find an output summary containing the following outputs

Interest Rate (Per Period)
Total Amount to be Paid
Total Interest to be Paid
Total No. of Payments
Time Saved

Click here to enlarge the image

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

If the borrower earns some extra money during loan repayment, s/he might want to make some extra payments to repay the loan quicker and pay lesser interest. In this template, you would be able to insert these inputs too and get the following outputs along with an updated amortization schedule.

Click here to enlarge the image

How to Use This Template

Go through the instructions below to use this template properly.

Instructions:

Go to the Payoff Calc. (Extra Payments) sheet and insert all the required inputs in the blue shaded area of the Input Values column according to the loan parameters.

Click here to enlarge the image

After inserting inputs, you will get the required quarterly payment amount. You have to insert extra irregular payments manually in the Extra Payments (Irregular) column.

Click here to enlarge the image

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

Click here to enlarge the image

Excel Quarterly Amortization Schedule Template Tips

Hover your mouse on the loan parameters and you will find added notes there. Follow the notes to insert proper inputs and choose proper dropdowns.
When choosing interest compounding frequency, choose it as equal to or greater frequency than quarterly payment frequency.
When choosing extra payment frequency, choose it as a multiple of your regular quarterly payment frequency. So, you can choose quarterly, semi-annually, and yearly in this case.