Quarterly Loan Amortization Calculator and Formula

Quarterly loan amortization divides a loan into equal payments made every three months, with each payment covering interest for that quarter and reducing principal. Enter the loan amount, annual APR, and term in years to estimate the quarterly payment and total interest; the schedule assumes a fixed rate and payments at quarter-end.

Formula

For a fully amortizing loan with quarterly payments, the level-payment formula is:

Payment = P × r / [1 − (1 + r)⁻ⁿ]

• P is the starting principal, in dollars.
• r is the interest rate per quarter, calculated as annual APR ÷ 400. For an 8% APR, r is 0.02, or 2% per quarter.
• n is the number of payments, calculated as loan term in years × 4.
• Payment is the quarterly installment in dollars. This calculator rounds it to the nearest cent before calculating total interest.

Total interest is calculated as the rounded quarterly payment multiplied by the number of payments, minus the original principal: Total interest = Payment × n − P. The calculation treats the stated APR as a nominal annual rate divided into four equal quarterly periods. A loan contract may define accrual, payment dates, or rates differently, so its disclosures control the actual schedule.

Worked Example

Using the calculator’s defaults: principal P = $20,000, APR = 8%, and term = 5 years.

1. Quarterly rate: 8 ÷ 400 = 0.02, or 2%.
2. Number of quarterly payments: 5 × 4 = 20.
3. Substitute in the formula: $20,000 × 0.02 ÷ [1 − (1.02)⁻²⁰].
4. The unrounded payment is about $1,223.84; rounded to cents, the quarterly payment is $1,223.84.
5. Total of payments: $1,223.84 × 20 = $24,476.80.
6. Total interest: $24,476.80 − $20,000 = $4,476.80.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal and made at the end of each three-month period.
• Interest compounds quarterly, using the stated APR divided by four.
• Fees, taxes, insurance, PMI, escrow, and other charges are not included.

How Quarterly Amortization Works

Amortization is the gradual repayment of principal through scheduled installments. At the start of each quarter, interest accrues on the remaining balance. The payment first covers that period’s interest; whatever remains reduces principal. Because the balance generally falls after each payment, later interest charges are smaller and more of the same-sized payment goes toward principal.

For the example, the first quarter’s interest is $20,000 × 0.02 = $400. Of the $1,223.84 payment, $823.84 therefore reduces principal, leaving about $19,176.16. The next quarter’s interest is calculated on that lower balance, not on the original $20,000. Small differences in the last payment can arise in real schedules because lenders may adjust for exact dates or rounding.

A quarterly schedule has four installments per year. It is not the same as making monthly payments that happen to be grouped into four-payment sets: monthly payments reduce the balance more frequently and use a different periodic rate and payment count.

Reading the Result and Using a Schedule

The quarterly payment is the recurring principal-and-interest amount under the formula, not necessarily the whole amount due on a statement. The total-interest output is an estimate across all scheduled payments, assuming none are missed, changed, prepaid, or recalculated. It is not the total of all possible borrowing costs if other charges apply.

A full amortization table usually lists each payment date, opening balance, interest, principal reduction, and closing balance. For each period, calculate interest as opening balance × quarterly rate, then subtract that interest from the payment to find the principal portion. Subtract principal repaid from the opening balance to get the next balance. The final scheduled payment should bring the balance to approximately zero, subject to rounding and contract details.

To build or check a schedule, keep a consistent number of periods and avoid rounding the balance too early. Displayed figures can be rounded to cents while internal calculations retain additional precision; a lender may use a different rounding convention, causing minor discrepancies.

Quarterly Versus Monthly Payments

Payment frequency changes both the timing of principal reduction and the number of periods used in the formula. A quarterly loan uses APR ÷ 4 and four payments per year; a monthly loan commonly uses APR ÷ 12 and twelve payments per year. Comparing only the installment amounts is misleading because each installment covers a different length of time. Compare the schedule, total payments, and total interest over the same principal and term, while checking how the lender defines its rate and accrual periods.

Quarterly payment timing can matter for budgeting when income or business receipts arrive on a quarterly cycle. It can also mean a larger individual payment than a monthly schedule, even when annual totals are in the same general range. This calculator does not determine whether a payment fits a particular budget or whether an applicant qualifies.

Common Errors and Limits

• Using the wrong rate conversion: For this quarterly model, divide APR by 400 to get the decimal quarterly rate. Do not enter 8 as 0.08 in the APR field; enter 8 for 8%.
• Using the wrong payment count: Multiply years by four, not twelve. The term field is in years.
• Confusing APR with the contract’s periodic rate: The formula assumes a nominal APR divided evenly by four. An effective annual rate or a daily-accrual method may produce a different result.
• Assuming every payment covers all costs: The calculation excludes fees and other charges unless they are included in the amount entered as principal.
• Expecting an exact payoff quote: Actual balances depend on payment dates, accrued interest, rounding, and contract terms. A payoff amount may also include amounts this calculator does not model.

The standard level-payment formula is intended for a fixed-rate loan with equal, end-of-period payments that fully repay principal over the chosen term. It does not model variable rates, irregular payment dates, deferred payments, balloon payments, interest-only periods, skipped installments, or extra payments. Ask the lender for the payment schedule and current payoff figures when exact contract amounts are needed.

Frequently Asked Questions

What does quarterly loan amortization mean?
It means repaying a loan through scheduled installments every three months. Each installment pays accrued interest and, for an amortizing loan, reduces some principal.

How do I calculate a quarterly loan payment?
Divide APR by 400 for the quarterly rate, multiply the term in years by four for the payment count, and use the level-payment formula shown above. Round the installment to cents when estimating total payments.

Is quarterly interest the same as annual interest divided by four?
In this calculator, yes: it treats the APR as a nominal annual rate and uses APR ÷ 4 as the quarterly rate. A contract using effective rates or a different accrual method may not follow that assumption.

Does quarterly amortization reduce principal faster than monthly amortization?
Not necessarily. The result depends on payment size, payment dates, rate conversion, and how often principal is paid. A valid comparison must use the same starting balance and term and account for each schedule’s timing.

Why does my lender’s figure differ from this estimate?
Possible reasons include a different APR convention, exact day-count calculations, fees, payment dates, rounding rules, or a rate that changes over time. Check the loan disclosure or ask the lender how its schedule is calculated.

This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.

Related

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

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 | $ | round(p * (apr / 400) / (1 - (1 + apr / 400) ^ -(yrs * 4)), 2) | 2
out int | Total interest | $ | pmt * yrs * 4 - p | 2