calculate-loan

01 Loan payments

Custom Amortization Schedule Calculator: Build Your Own

Calculator No. 01-21879 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A custom amortization schedule calculator lets you enter your own loan amount, interest rate, and term to generate a full payment-by-payment breakdown showing principal, interest, and remaining balance for each period. You can also add extra payments, change payment frequency, or model different start dates to see how those choices affect total interest and payoff time. The result is a table you can use for planning, budgeting, or comparing loan scenarios before you commit.

Formula

The standard amortization formula calculates a fixed monthly payment that pays off the loan over the term. The formula is:

PMT = P × (r / (1 − (1 + r)^(−n)))

Where:

  • P = loan amount (principal) in dollars
  • r = monthly interest rate = annual rate (APR) ÷ 12 ÷ 100 (e.g., 8% APR → 0.08/12 = 0.0066667)
  • n = total number of payments = years × 12
  • PMT = monthly payment in dollars, rounded to the nearest cent

Each payment is split into interest and principal. The interest for a period is the current balance times the monthly rate. The principal is the payment minus that interest. The balance is the previous balance minus the principal paid. Repeating this for each period builds the full schedule.

Worked Example

Using the defaults from the calculator: loan amount $20,000, APR 8%, term 5 years.

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Number of payments n = 5 × 12 = 60
  3. Payment = 20000 × (0.0066667 / (1 − (1 + 0.0066667)^(−60)))
  4. Compute (1.0066667)^(−60) ≈ 0.671216
  5. 1 − 0.671216 = 0.328784
  6. 0.0066667 / 0.328784 = 0.020276
  7. 20000 × 0.020276 = 405.52 (rounded to cents)

So the monthly payment is $405.52. Total paid over 60 months = 405.52 × 60 = $24,331.20. Total interest = $24,331.20 − $20,000 = $4,331.20. The calculator shows exactly these numbers.

Assumptions

  • Fixed interest rate for the entire term (no adjustable rates).
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR ÷ 12.
  • No fees, taxes, insurance, PMI, or escrow are included unless you add them manually.
  • The payment is rounded to the cent, and totals use that rounded payment.

How to Build a Custom Schedule

To create your own schedule, you need three inputs: loan amount, annual interest rate, and term. With those, you can generate the payment and then the full table. Here are the steps:

  1. Calculate the monthly payment using the formula above.
  2. For each month, compute interest = balance × monthly rate.
  3. Principal = payment − interest.
  4. New balance = previous balance − principal.
  5. Repeat until the balance reaches zero (the last payment may be slightly different due to rounding).

You can do this in a spreadsheet with a simple formula like =PPMT(rate, period, nper, pv) for principal and =IPMT(...) for interest, or use an online calculator that generates the table automatically.

Common Mistakes and Misconceptions

A frequent error is confusing the annual rate with the monthly rate. Always divide the APR by 12 (and by 100 to convert from percent to decimal). Another mistake is rounding the payment too early in the calculation, which can make the final balance not exactly zero. The schedule should adjust the last payment to clear the remaining balance.

People also assume that paying “extra” always saves the same amount of interest. In reality, the timing matters: an extra payment made early in the loan reduces more interest than the same extra payment made later, because the balance is higher earlier. Also, some lenders apply extra payments to future payments rather than to principal, so check how your lender applies them.

Another misconception is that a lower monthly payment always means a better deal. A longer term lowers the payment but increases total interest. For example, a $20,000 loan at 8% for 5 years costs $4,331 in interest, while the same loan for 10 years (payment $242.66) costs $9,119 in interest. The calculator lets you compare such scenarios.

How to Use the Schedule for Planning

Once you have your schedule, you can use it to see how much of each payment goes to interest versus principal. Early payments are mostly interest; later payments are mostly principal. This is useful for tax planning if you itemize deductions (though check current tax rules), or for deciding whether to refinance or pay off early.

You can also model extra payments. For example, adding $50 per month to the $405.52 payment on the $20,000 loan would pay it off in about 54 months instead of 60, saving roughly $500 in interest. The exact savings depend on when you make the extra payment and how the lender applies it.

Limitations of the Calculator

This calculator assumes a fixed rate and level payments. It does not handle variable rates, interest-only periods, balloon payments, or fees rolled into the loan. It also does not include taxes, insurance, or PMI, which can significantly affect your actual monthly outlay. For a mortgage, your real payment often includes escrow for property tax and insurance, so the schedule here underestimates the total monthly cost.

Also, the formula assumes payments are made on the same day each month. If you pay early or late, the interest accrues differently. Some lenders use daily interest, which can slightly change the schedule.

Frequently Asked Questions

How do I add extra payments to the schedule?

To model extra payments, you can adjust the payment amount in each period. In a spreadsheet, you would replace the standard payment with your increased payment for certain months, then recalculate interest on the new balance. Many online calculators have an “extra payment” field that does this automatically, showing the new payoff date and total interest.

What is the difference between APR and interest rate?

The interest rate is the cost of borrowing the principal, expressed as a yearly percentage. APR (annual percentage rate) includes the interest rate plus certain fees and costs, so it gives a more complete picture of the loan’s cost. For this calculator, we use the APR as the rate, but if you have a loan with fees, the actual interest rate may be lower than the APR.

Can I use this calculator for a car loan or personal loan?

Yes, the amortization formula works for any fixed-rate, fixed-term loan, including auto loans, personal loans, and student loans. Just enter the loan amount, APR, and term. The schedule will show the monthly payment and interest breakdown. For loans with simple interest (common in auto loans), the calculation is the same as long as payments are made on time.

Why does my last payment differ from the others?

Because the payment is rounded to the cent, the final payment often needs to be slightly larger or smaller to bring the balance to exactly zero. This is normal. Some lenders adjust the payment amount to make the final payment identical, but most simply apply the remaining balance as the last payment.

What happens if I miss a payment?

Missing a payment can trigger late fees and may increase your interest costs if the lender capitalizes the missed interest. The amortization schedule assumes you pay on time every month. If you miss a payment, the lender may recalculate the schedule, and your loan may go into default if you miss too many. Always contact your lender if you anticipate a missed payment.

How do I calculate the schedule for a biweekly payment plan?

Biweekly payments mean you pay half the monthly payment every two weeks, which results in 26 half-payments per year (equal to 13 full payments). This extra payment reduces principal faster. To model it, you can use a calculator that supports payment frequency, or you can approximate by adding one extra monthly payment per year to your standard schedule.

This calculator provides an estimate based on the inputs you provide. Your lender’s official amortization schedule and loan disclosure will give the exact figures, including any fees or adjustments.

Related

Formula used
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

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →