Quarterly Amortization Table Calculator and Formula

A quarterly amortization table calculator estimates each payment-period payment, interest charge, principal reduction, and remaining balance when payments are made every three months. Enter the loan amount, annual APR, and term in years to see the equivalent monthly-payment amount and total interest for comparison; a true quarterly schedule uses four payments per year and is explained below.

Formula

The calculator uses a standard level-payment loan formula with monthly periods. It calculates monthly payment, not quarterly payment: the required calculator fields specify annual APR and term in years and define the payment as monthly. For principal P, monthly rate r, and total monthly payments n:

Monthly payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

Total interest = (monthly payment × n) − P

• P is the loan principal in dollars.
• r is the monthly interest rate as a decimal, calculated as APR ÷ 1,200.
• n is the number of monthly payments, calculated as years × 12.
• APR is the annual percentage rate entered as a percentage, such as 8 for 8%.

As the calculator rounds the monthly payment to cents for display, its total-interest output uses that displayed payment multiplied by the full number of months, then subtracts the original principal. A quarterly loan instead has four payment periods each year and requires the applicable quarterly rate and payment formula; it will not produce the same schedule as this monthly calculation.

Worked Example

Using the default inputs—$20,000 principal, 8% APR, and a five-year term:

1. Monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
2. Number of monthly payments: 5 × 12 = 60.
3. Monthly payment before rounding: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.53.
4. Total of displayed payments: $405.53 × 60 = $24,331.80.
5. Total interest: $24,331.80 − $20,000 = $4,331.80.

The displayed monthly payment is $405.53. These figures illustrate the monthly formula in the calculator; they are not a quarterly amortization table.

Assumptions

• The interest rate stays fixed for the modeled term.
• Payments are equal, made at the end of each monthly period.
• Interest accrues monthly at APR ÷ 12.
• Fees, taxes, insurance, PMI, escrow, and additional payments are not included.

How a Quarterly Amortization Table Works

An amortization table splits every scheduled payment into interest and principal and tracks the balance after each payment. With quarterly payments, there are normally four rows per year. At the start of a period, interest is calculated on the outstanding balance; the rest of the payment reduces principal. As principal falls, the interest portion generally falls too, leaving more of a level payment to reduce principal.

For a fixed-rate loan with end-of-quarter payments, define q as the periodic quarterly rate and N as the total number of quarterly payments. A level quarterly payment is:

Payment = P × q ÷ [1 − (1 + q)^−N]

If an agreement specifies nominal APR divided into four periods, then q = APR ÷ 4 as a decimal, and N = years × 4. For example, at an 8% nominal APR, that convention gives a 2% quarterly rate. But contracts can define rate conversion and payment timing differently; use the lender’s stated periodic rate and schedule rather than assuming every quoted APR is divided by four.

For each quarter, the table typically calculates interest as beginning balance × quarterly rate, principal paid as payment − interest, and ending balance as beginning balance − principal paid. The ending balance becomes the next quarter’s beginning balance. The last payment may need a small adjustment because amounts are rounded to cents.

When to Use a Quarterly Schedule

A quarterly table is useful when the loan agreement calls for payments every three months, or when you need to understand how such a schedule reduces principal over time. It can also help compare payment frequency, provided the rate convention, payment dates, fees, and total term are held consistent. Do not treat a quarterly payment as simply three monthly payments combined: the timing of cash flows and interest accrual can change the result.

Before building or interpreting a schedule, identify these details from the loan documents:

• Starting principal and any amount financed beyond the original advance.
• Annual rate and the method used to convert it to a quarterly periodic rate.
• Whether the rate is fixed or can change during the term.
• Payment amount, due dates, term, and whether payments occur at the beginning or end of periods.
• How the final payment and rounding differences are handled.

Reading Results and Avoiding Errors

The payment is the scheduled amount for each period, not the total paid across a year. Multiply a quarterly payment by four for a simple annual cash-payment total, while remembering that the interest and principal mix changes from quarter to quarter. Total interest is the sum of interest charges over the schedule; it is not the same as APR and does not include costs omitted from the calculation.

Common errors include entering 8 instead of 0.08 in a formula that expects a decimal rate, using 12 periods per year for quarterly payments, or entering a term in years where a formula expects the number of periods. Another frequent misunderstanding is that a quoted APR always gives the exact periodic rate by simple division. The contract’s rate-conversion method controls the schedule, and fees or other charges may affect a disclosed APR without being part of the periodic interest calculation shown here.

Rounding every row can make the final balance differ by a few cents from a calculation performed with unrounded values. A lender’s payment history or disclosure may also use actual dates, daily accrual, variable rates, fees, or payment adjustments that a basic fixed-rate formula does not model.

Limits and Alternatives

This page’s calculator is a monthly-payment estimate because its specified inputs and formula are monthly. It cannot display quarter-by-quarter balances, and changing the output label alone would not make it a quarterly calculator. For a quarterly table, use a calculation that accepts the quarterly periodic rate and number of quarterly periods, then apply the period-by-period interest and balance steps described above. If the contract gives a payment schedule, that schedule is the relevant reference for the actual account.

The formulas assume regular equal payments and a fixed rate. They do not model irregular payment dates, rate changes, skipped or late payments, extra principal, or fees. For an adjustable-rate or otherwise nonstandard loan, each period may require updated inputs or rules from the agreement. This result is an estimate; the lender’s disclosure gives the exact figures.

Frequently Asked Questions

How do I calculate a quarterly loan payment?
Use the principal, the contract’s quarterly periodic rate, and the total number of quarterly payments in P × q ÷ [1 − (1 + q)^−N]. Confirm how the loan defines the periodic rate and payment timing.

How many payments are there in a five-year quarterly loan?
With four payments each year and a regular five-year term, there are 5 × 4 = 20 quarterly payments.

Is APR divided by four for quarterly payments?
That is one possible nominal-rate convention, but it is not safe to assume it applies to every loan. Check the contract for the periodic rate or rate-conversion method used to calculate interest.

Is quarterly amortization the same as paying monthly?
No. Quarterly payments occur less often, and interest accrues over different payment periods. Even with the same principal and quoted annual rate, payment amounts and total interest can differ.

Why does the final amortization payment change slightly?
Rounding interest and payments to cents each period can leave a small residual balance. A final payment may be adjusted to clear it; actual contract calculations may also account for dates or other terms.

Related

• Qualified Income Offset: Meaning and Partnership Calculator
• Qualified Income Deduction Phaseout: 2025 Limits
• Qualified Income: Meaning, Examples, and Tax Rules

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 | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2