Quarterly Payment Amortization Schedule Calculator

This quarterly payment amortization calculator estimates the level payment needed to repay a fixed-rate loan with payments every three months. Enter the loan amount, annual percentage rate (APR), and term in years; the results show the quarterly payment and total interest under the stated assumptions.

Formula

The calculator uses the standard fixed-payment amortization formula, adjusted for four payment periods per year. It first computes an unrounded payment, rounds that payment to the nearest cent, and uses the rounded payment to estimate total interest.

• Quarterly payment = round(P × r / (1 − (1 + r)⁻ⁿ), 2)
• Periodic rate, r = APR / 400. This treats the APR as a nominal annual rate divided into four equal quarterly periods.
• Number of payments, n = loan term in years × 4.
• Total interest = rounded quarterly payment × n − P.

P is the starting principal in dollars, APR is the annual percentage rate entered as a percentage, and the term is in years. For example, enter 8 for an 8% APR, not 0.08. The formula assumes payments are equal and made at the end of each quarter. It does not generate a dated, row-by-row schedule; it calculates the regular payment and the total interest implied by that payment.

Worked Example

Using the calculator’s default values—$20,000 principal, 8% APR, and a 5-year term—the loan has 20 quarterly payments. The periodic rate is 8% ÷ 4 = 2%, or 0.02 as a decimal.

1. Substitute into the payment formula: $20,000 × 0.02 ÷ [1 − (1.02)⁻²⁰].
2. The result before cent rounding is approximately $1,223.81, so the quarterly payment is $1,223.81.
3. Total of the rounded payments: $1,223.81 × 20 = $24,476.20.
4. Estimated total interest: $24,476.20 − $20,000 = $4,476.20.

Assumptions

• The interest rate stays fixed throughout the term.
• Payments are made at the end of each three-month period; the first payment is one quarter after the loan begins.
• Interest compounds quarterly at APR ÷ 4, consistent with the payment periods in this formula.
• Fees, taxes, insurance, PMI, escrow, and other charges are not included.
• The calculator rounds the regular payment to cents, then multiplies that rounded amount by the number of payments. A real lender may adjust the final payment to clear a small remaining balance caused by rounding.

How a Quarterly Amortization Schedule Works

Amortization means that each regular payment covers interest accrued for the period and pays down some principal. Early payments generally include a larger interest portion because interest is calculated on a larger outstanding balance. As principal falls, the interest portion usually decreases and more of each level payment reduces principal.

A row-by-row quarterly schedule typically lists the payment number or date, opening balance, payment, interest, principal repaid, and closing balance. For a simplified period, interest is opening balance × periodic rate; principal repaid is payment − interest; and closing balance is opening balance − principal repaid. With the example, first-quarter interest is $20,000 × 0.02 = $400. The $1,223.81 payment therefore reduces principal by $823.81, leaving an estimated balance of $19,176.19.

Repeating those calculations produces the schedule. The last row can differ slightly from the regular payment if the lender adjusts for rounding, exact payment dates, or its contractual calculation method. The calculator’s total-interest result is a useful level-payment estimate, not a substitute for the lender’s official schedule.

When to Use This Estimate

Quarterly payment calculations are useful for understanding a loan whose contract calls for four payments per year, or for comparing the arithmetic of different principal amounts, terms, and APR inputs on the same quarterly basis. They can also help explain how payment frequency affects the shape of an amortization schedule. Enter the loan’s actual quoted principal, APR, and term to obtain an estimate; get the applicable figures and payment calendar from the lender.

Do not assume a loan is quarterly simply because a budget or business report groups cash flows by quarter. Payment frequency is set by the loan terms. A loan with monthly installments does not become a quarterly-payment loan by adding three monthly installments together: each monthly payment reduces the balance before the next month’s interest accrues.

Quarterly Payments Compared with Monthly Payments

Payment frequency changes both the payment amount and the timing of principal reduction. A quarterly payment is larger than one monthly installment because it covers a longer period and combines more repayment into each due date. Under the same nominal APR, a quarterly schedule has four periods per year, while a monthly schedule has twelve. The formulas and period rates must match the contract’s payment frequency.

Comparisons can be misleading if one calculation uses APR divided by four and another uses APR divided by twelve without checking how the rate is defined. Some contracts may define interest using a different day-count convention or effective annual rate. Use the rate basis and accrual method stated in the loan disclosure rather than assuming that every product calculates interest identically.

Common Calculation Limits and Errors

• Entering APR as a decimal: The input expects a percentage such as 8, not 0.08.
• Using the wrong number of periods: A five-year quarterly term has 20 payments, not five or 60.
• Mixing payment frequencies: The periodic rate and payment count need to use the same period.
• Ignoring rounding: Rounding each payment to cents can make the final scheduled payment differ slightly from the others.
• Leaving out contract details: Fees, changing rates, irregular dates, deferred payments, and extra principal payments can alter the actual schedule.

The formula models a positive fixed APR and regular level payments. It does not calculate a variable-rate loan, a payment holiday, an interest-only period, or a schedule with extra or missed payments. If the loan’s terms include such features, the lender’s disclosure or a more detailed schedule is needed to represent them.

Frequently Asked Questions

How do I calculate a quarterly loan payment?
Convert the APR to a quarterly rate by dividing it by four, multiply the term in years by four to get the payment count, and apply the fixed-payment amortization formula. Round the resulting payment to cents if you are estimating payments in dollars.

How many quarterly payments are in a five-year loan?
There are 20 scheduled quarterly periods in five years: five years × four payments per year. A contract’s first due date or final payment treatment may affect the actual calendar dates.

Does a quarterly payment include both interest and principal?
In a standard amortizing loan, yes. Each payment covers the period’s interest and applies the remainder to principal. The proportions change over time as the balance declines.

Is quarterly interest the same as annual APR divided by four?
This calculator assumes that method: periodic rate = APR ÷ 4. A contract can use different conventions, so check its stated rate basis and interest calculation.

Why might my lender’s schedule show a different total?
Differences can come from exact payment dates, day-count methods, fees, rounding, a different compounding convention, or an adjusted final payment. The lender’s disclosure and official schedule govern the figures for that loan.

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

Related

• Amortization Schedule With Extra Payments
• Amortization Table Extra Principal Payment Calculator
• Amortization Schedule With Extra Principal Payments

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