Quarterly Loan Payment Amortization Schedule

A quarterly loan payment amortization schedule shows each three-month payment split between interest and principal, along with the remaining balance after each payment. Enter the loan amount, annual APR, and term in years to estimate the regular quarterly payment and total interest over the loan.

Formula

The schedule uses a fixed-rate, level-payment loan formula with quarterly periods. First convert the annual percentage rate to a quarterly rate, then calculate the payment that repays the principal and accumulated interest over all quarters:

• Quarterly rate: r = APR / 400, where APR is the annual rate entered as a percentage and r is a decimal per quarter.
• Number of payments: n = years × 4.
• Quarterly payment: A = P × r / [1 − (1 + r)⁻ⁿ].
• Total interest: I = A × n − P.

P is the starting loan principal in dollars, A is the unrounded formula payment (displayed to cents), and I is estimated total interest. In the total-interest output, the displayed payment rounded to cents is multiplied by the number of payments, so the estimate follows the shown regular payment. A real lender may apply different rounding or final-payment adjustments.

Worked Example

Using the calculator defaults: P = $20,000, APR = 8%, and a five-year term.

1. Quarterly rate: 8 / 400 = 0.02, or 2% per quarter.
2. Number of payments: 5 × 4 = 20.
3. Payment: $20,000 × 0.02 / [1 − (1.02)⁻²⁰] = $1,223.12 per quarter, rounded to cents.
4. Total paid using the displayed payment: $1,223.12 × 20 = $24,462.40.
5. Estimated total interest: $24,462.40 − $20,000 = $4,462.40.

The schedule’s first payment is not all principal. At the start, interest for the quarter is approximately $20,000 × 0.02 = $400. The remaining $823.12 reduces principal, leaving about $19,176.88. Subsequent interest is calculated on the lower balance, so the interest portion generally declines and the principal portion rises.

How to Read a Quarterly Amortization Schedule

A full schedule normally has one row per payment period and fields such as payment number or date, opening balance, payment amount, interest, principal repaid, and closing balance. For each row, interest is calculated on the opening balance for that quarter; principal paid is the payment minus that interest; and the closing balance is the opening balance minus principal paid.

For a fixed-rate loan with payments made on schedule, the balance should trend toward zero over the stated term. The final row can differ by a few cents because of rounding. This calculator reports the regular payment and aggregate interest rather than generating all row dates; actual dates and accrued interest depend on the lender’s contract and payment-processing conventions.

When Quarterly Payments Apply

Quarterly payment frequency means four scheduled payments per year, typically separated by three months. It is not the same as making monthly payments grouped into four-payment batches: the time between payments affects how much interest accrues before each payment. Check the loan documents for payment frequency and how the annual rate is converted to a periodic rate.

The calculation is useful for estimating a loan whose contract calls for quarterly installments, or for comparing the mathematical effect of different inputs on the same type of loan. Enter the principal actually being amortized, the stated annual APR, and the term in years. The APR must represent a nominal annual rate compatible with quarterly periods in this formula. If the lender quotes a different rate convention, use the contract’s payment figures or ask how to convert it before relying on an estimate.

Common Mistakes and Calculation Limits

• Using the monthly rate: Dividing APR by 12 gives a monthly rate. This quarterly formula divides APR by 4, represented as APR / 400 when APR is entered in percent.
• Confusing years and payment count: A five-year quarterly loan has 20 scheduled payments, not five or 60.
• Treating APR as a decimal input: Enter 8 for 8%, not 0.08. The calculator converts the percentage internally.
• Assuming every loan has equal payments: Variable rates, irregular dates, interest-only periods, balloon balances, skipped payments, and extra principal payments change the schedule.
• Ignoring rounding: A lender may carry more decimal places internally and adjust a final installment. Displayed estimates can therefore differ slightly.

The formula does not establish whether a particular contract uses nominal APR divided by four, daily accrual, or another method. It also does not include origination or other fees, taxes, insurance, escrow, or late charges. If fees are financed into the principal, include them in the loan amount only when that matches the contract’s balance; otherwise, keep them separate.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal, made at the end of each quarter, and begin one full quarter after the starting balance is established.
• Interest compounds quarterly at APR / 4 for this estimate.
• Fees, taxes, insurance, PMI, escrow, and payment-date variations are not included.

Frequently Asked Questions

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

How many payments are in a five-year quarterly loan?
There are four payments per year, so five years contains 20 quarterly payments, assuming the schedule has no skipped or additional installments.

Does a quarterly payment include both principal and interest?
For a standard amortizing loan, yes. Each payment covers interest accrued for the period and applies the remainder to principal. The proportions change as the balance falls.

Is a quarterly payment one-fourth of a monthly payment?
No. The payment frequency and interest-accrual period differ. A quarterly payment is calculated using a quarterly rate and a total number of quarterly periods; it is not simply four monthly payments combined.

Why might my lender’s schedule differ?
The lender may use different accrual dates, rate conventions, fees, payment timing, or rounding rules. Compare the contract’s principal, APR, payment dates, and stated method with the calculator assumptions.

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

Related

• Extra Payment Amortization Calculator in Excel
• Excel Amortization Formula With Extra Payments
• Excel Amortization Payment Formula and Example

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