Quarterly Loan Amortization Calculator and Payment Schedule

A quarterly loan amortization calculator estimates the payment due every three months and shows how each payment is split between interest and principal. Enter the loan amount, annual interest rate, and term in years to calculate a level quarterly payment and total interest; the schedule is an estimate based on fixed-rate assumptions.

Formula

The calculator treats the loan as a fixed-rate loan with equal payments at the end of each quarter. It converts the annual percentage rate (APR) to a quarterly rate by dividing by four, and converts the term from years to the number of quarterly payments.

• Quarterly rate, r = APR / 400, where APR is entered as a percentage per year. For an 8% APR, r = 0.02, or 2% per quarter.
• Number of payments, n = years × 4.
• Quarterly payment, PMT = P × r / [1 − (1 + r)⁻ⁿ].
• Total interest = (PMT × n) − P, using the displayed payment rounded to cents.

Here, P is the starting principal in dollars, r is the quarterly interest rate as a decimal, n is the count of quarterly payments, and PMT is the payment in dollars. The formula assumes interest is applied once per quarter at APR divided by four. A lender may use a different day-count convention or payment calculation, so its disclosed schedule can differ.

Worked Example

Using the calculator’s default values—$20,000 principal, 8% APR, and a five-year term:

1. Quarterly rate: 8 / 400 = 0.02.
2. Payment count: 5 × 4 = 20 quarterly payments.
3. Substitute into the payment formula: PMT = 20,000 × 0.02 / [1 − (1.02)⁻²⁰].
4. Unrounded payment is about $1,223.07; rounded to cents, the quarterly payment is $1,223.07.
5. Total of rounded payments: $1,223.07 × 20 = $24,461.40. Estimated total interest: $24,461.40 − $20,000 = $4,461.40.

The displayed totals use the rounded payment, as real payment amounts are generally expressed in currency units. A lender may adjust the final payment slightly to clear a small balance caused by rounding.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made at the end of each three-month period, with the first payment one quarter after borrowing.
• Interest compounds quarterly at APR divided by four; this is not the same as monthly compounding with payments merely collected quarterly.
• The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, and other loan-specific amounts.

How Quarterly Amortization Works

Amortization is the gradual repayment of principal through scheduled payments. In each quarter, interest is calculated on the outstanding balance. The rest of that quarter’s payment reduces principal. Because the balance shrinks over time, the interest portion normally declines and the principal portion normally grows, even though the scheduled payment stays level.

For example, with a 2% quarterly rate and a $20,000 opening balance, the first quarter’s interest under this model is $400. From the $1,223.07 payment, about $823.07 reduces principal, leaving an estimated balance of $19,176.93. In the next quarter, interest is calculated on that lower balance. This illustration assumes the payment is made on schedule and does not include fees or irregular adjustments.

A full amortization table lists each payment date or period, opening balance, interest, principal repaid, and closing balance. The calculator’s two outputs summarize the regular payment and aggregate interest; they do not themselves provide every row of that table.

When to Use the Estimate

Quarterly schedules are useful when a loan contract calls for payments four times a year, or when comparing the mechanics of quarterly payments with another payment frequency using consistent assumptions. Before relying on a figure, check the proposed contract for payment frequency, rate basis, first payment date, whether the APR is fixed or variable, and any balloon or final payment.

• Enter the amount actually borrowed as principal, rather than the total of all future payments.
• Enter the annual APR as a percentage: type 8 for 8%, not 0.08.
• Enter the term in years. A five-year term means 20 quarterly payments in this model.
• Compare the result with the lender’s payment schedule and ask which rate and compounding conventions it uses if the numbers differ.

The term may be entered as a fraction of a year when appropriate, but the calculator derives the payment count as years × 4. A non-whole number of quarters may therefore be unsuitable for a contract with a different final-period arrangement. For a term stated directly in quarters, convert it to years by dividing the quarter count by four, then confirm how the actual agreement handles its final payment.

Quarterly Versus Monthly Payments

Payment frequency changes the schedule, not just the label. This calculator uses four periods per year and APR divided by four. A monthly-payment calculation instead uses 12 periods per year and APR divided by 12. If two calculations use identical principal and APR but different payment frequencies, their payment amounts and total interest generally will not match: payments occur at different times and principal is reduced on different dates.

Do not divide a monthly payment by three to estimate a quarterly payment. A quarterly payment is calculated from its own period rate and number of periods. Likewise, do not use the quarterly formula if a lender quotes a nominal rate with a different compounding convention or specifies interest accrual using actual days. Use the contract’s stated method for an exact contractual figure.

Common Errors and Limits

• Mixing rate formats: APR of 8% must be entered as 8. The formula performs the percentage conversion.
• Mixing periods: The annual rate, quarterly rate, and payment count must use matching units. This calculator uses APR / 4 and four payments per year.
• Assuming APR captures every cost: APR and payment amount do not necessarily include every charge in a borrower’s cash flow. The calculator has no fee, insurance, tax, or escrow inputs.
• Ignoring variable rates or irregular payments: A changing rate, skipped payment, extra principal payment, or balloon balance requires a schedule that models those events.
• Expecting an exact payoff quote: Actual balances can depend on payment dates, accrued days, rounding practices, fees, and contract terms.

This is a level-payment model, not a lender’s account ledger. It does not determine eligibility, predict future rates, or establish the amount due on a particular date. Obtain the actual payment schedule and payoff figures from the lender when those exact amounts matter.

Frequently Asked Questions

How do I calculate a quarterly loan payment?
Convert APR to a quarterly decimal rate by dividing the percentage by 400, multiply the term in years by four to get the payment count, then use the level-payment formula shown above.

How many quarterly payments are in a five-year loan?
There are four quarters per year, so a five-year term contains 20 quarterly payments if the schedule has one payment each quarter.

Is quarterly compounding the same as monthly compounding?
No. This estimate applies APR divided by four each quarter. Monthly compounding applies APR divided by 12 each month. The schedules can produce different payments and total interest.

Why does my lender’s payment differ from this result?
The contract may use a different compounding or day-count method, payment timing, rounding rule, fees, or final-payment adjustment. Check the lender’s disclosed calculation and schedule.

Does total interest include fees or insurance?
No. The estimate subtracts principal from the sum of rounded scheduled payments. It does not include fees, taxes, insurance, PMI, escrow, or other charges.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

• Loan Amortization Credit Union Calculator
• Loan Amortization Calendar: Payments and Balance
• Loan Amortization Credit Line Calculator

in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Quarterly payment | $ | p * (apr / 400) / (1 - (1 + apr / 400) ^ -(yrs * 4)) | 2
out int | Total interest | $ | pmt * yrs * 4 - p | 2