3 Year Amortization Table Calculator and Loan Schedule

This 3 year amortization table calculator estimates the monthly payment and total interest for a fixed-rate loan paid monthly over three years. Enter the loan amount and annual APR to see the payment and a month-by-month schedule showing how each payment is split between interest and principal.

Formula

The calculator uses the standard level-payment amortization formula. It assumes the same payment is made at the end of each month and interest accrues monthly at the APR divided by 12.

Monthly payment: M = round(P × r ÷ [1 − (1 + r)⁻ⁿ], 2). Here, P is the starting loan principal in dollars, r is the monthly rate as a decimal (APR ÷ 1,200), and n is the number of monthly payments (term in years × 12). M is the monthly payment in dollars, rounded to the nearest cent.

Total interest: I = M × n − P. I is the estimated interest paid in dollars across the full schedule. Because the payment is rounded to cents before the total is calculated, the result reflects that rounded payment.

The table’s month-by-month allocation follows the same monthly pattern: interest for a period equals the opening balance multiplied by r; principal repaid equals M minus that interest; and the next balance equals the opening balance minus principal repaid. Small differences can arise in a real loan if the lender adjusts the final payment to clear a rounding balance.

Worked Example

Using the calculator’s default values: P = $20,000, APR = 8%, and term = 3 years.

1. Convert the annual APR to a monthly decimal: r = 8 ÷ 1,200 = 0.0066666667.
2. Convert the term to payments: n = 3 × 12 = 36.
3. Substitute into the payment formula: M = round[20,000 × 0.0066666667 ÷ (1 − (1.0066666667)⁻³⁶), 2].
4. The monthly payment is $626.72.
5. Total of the rounded payments is $626.72 × 36 = $22,561.92. Subtracting the $20,000 principal gives estimated total interest of $2,561.92.

Assumptions

• The APR is fixed for the entire three-year term.
• Payments are equal, made monthly at the end of each period, with the first payment one month after the loan begins.
• Interest compounds monthly at APR ÷ 12; the calculation does not model daily accrual or irregular payment dates.
• Fees, taxes, insurance, PMI, escrow, late charges, and lender-specific final-payment adjustments are not included.

How to Read a 3 Year Amortization Table

A 3 year amortization table has 36 monthly rows, one for each scheduled payment. Each row normally shows the payment number or date, opening balance, payment, interest charge, principal repaid, and closing balance. At the start, interest is calculated on nearly the full amount borrowed; as the balance falls, the interest portion generally declines and more of the fixed payment reduces principal.

For the example, the first month’s estimated interest is $20,000 × 0.0066666667, or about $133.33. Subtracting that from the $626.72 payment leaves about $493.39 going to principal, so the next balance is approximately $19,506.61. Later rows repeat the calculation using the new opening balance. The final row should bring the loan close to zero, subject to cent rounding and the lender’s actual payment convention.

When to Use This Calculator

Use this estimate to understand the basic payment structure of a loan with a three-year repayment period, or to make a draft schedule for a fixed-rate balance. It can help you see how the payment is divided over time and how the stated APR and term affect the arithmetic. Enter the principal and APR supplied in the loan disclosure or quote; the default values are examples, not a statement about available rates or loan terms.

This calculator computes the payment and total interest, rather than printing all 36 rows as separate outputs. To build a full table in a spreadsheet, place the starting principal in the first opening-balance cell. For each month, calculate interest as opening balance × APR ÷ 1,200, principal as payment − interest, and closing balance as opening balance − principal; use that closing balance as the next month’s opening balance. Keep unrounded values during intermediate calculations if matching a lender’s detailed schedule is important, while recognizing that lenders may use different rounding and accrual rules.

Common Mistakes and Limits

Do not enter 8 for an 8% APR as though it were a monthly rate: this calculator expects annual APR in percent and converts it internally to a monthly rate. Also make sure the term is entered in years; entering 36 would mean 36 years, not 36 months. The default term is three years, which converts to 36 payments.

Amortization describes principal and interest under a defined set of assumptions; it does not establish the complete amount due under a contract. A variable rate, payment date changes, fees added to the balance, extra payments, skipped payments, or a different day-count method can change the schedule. Extra principal payments in particular shorten the payoff path and make the standard 36-payment table inapplicable. The calculation is estimate arithmetic for education, not financial advice; the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What does a 3 year amortization table show?
It lays out 36 scheduled monthly payments and shows, for each one, how much goes to interest and principal and what balance remains.

How many payments are in a three-year schedule?
With monthly payments and no skipped periods, three years contains 36 payments.

Does the calculator include fees?
No. It estimates payments and interest from the principal, APR, and term only; fees and other charges must be checked in the lender’s disclosure.

Why does the principal portion increase over time?
With a fixed payment and declining balance, the interest charge usually falls each month. The remaining portion of the payment therefore goes increasingly toward principal.

Will the final payment match this estimate exactly?
Not necessarily. Actual accrual dates, rounding practices, and contract terms may leave a small difference or change the final amount.

Can I use this for a variable-rate loan?
Only as a snapshot using one assumed APR. If the rate changes, later interest and payment amounts may differ from this fixed-rate estimate.

Final Thoughts

A three-year amortization estimate turns a principal amount and APR into a monthly payment, total interest, and a clear explanation of the balance’s decline. Compare the assumptions with the loan documents before relying on a schedule; the result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Qualified Income Trust Form: What It Is and How It Works
• Qualified Income Trust Account: Medicaid Income Cap
• Qualified Income Trust: Medicaid Income Cap Calculator

in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 3 | 0.0833 | 50
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2