Amortization Schedule Calculator — Calculate monthly loan payment and total interest

This Amortization Schedule Calculator estimates the fixed principal-and-interest payment for a loan, then breaks each payment into interest, principal, remaining balance, total interest, payoff date, and optional extra-payment savings. It is built for fixed-rate loans such as mortgages, auto loans, personal loans, and student-style installment loans where payments are made at regular intervals.

How to use

Enter the Loan amount as the starting principal that will actually be repaid through the loan. Use the Annual interest rate (%) field for the nominal rate applied to the balance, not automatically the APR if your APR includes financed fees or other disclosure costs. Enter Loan term (years) as the full repayment length, such as 30 for a 30-year mortgage or 5 for a 60-month auto loan. Choose Payment frequency to match the contract: monthly is 12 payments per year, biweekly is 26, weekly is 52, quarterly is 4, and annual is 1.

Use Extra principal per payment only when you want to test voluntary prepayment. Enter 0 for the standard schedule. If you enter an extra amount, the calculator keeps the scheduled payment visible, adds the extra amount to each regular payment, and compares the interest result against the same loan without extra principal. Choose a Start date when you want the schedule rows and payoff date labeled; changing the date does not change the interest math unless the payment frequency changes.

After every input change, review the Scheduled payment first, then Total paid and Total interest. The schedule table shows the audit trail. In the first row, interest should equal the loan amount multiplied by the periodic rate. Principal should equal payment minus interest. Remaining balance should equal prior balance minus principal. Scroll the schedule to inspect later rows. If a field is blank, negative where it should not be, or outside the supported range, the calculator will show an inline error instead of a misleading result.

Formula

For a fixed-rate amortizing loan, let $P$ be principal, $r$ be the periodic interest rate, and $n$ be the total number of payments. The scheduled payment is: $$M = P \times \frac{r(1+r)^n}{(1+r)^n-1}$$ where $r = \frac{\text{annual rate}}{\text{payments per year}}$ and $n = \text{years} \times \text{payments per year}$. If $r=0$, use: $$M = \frac{P}{n}$$ For each row of the amortization schedule: $$\text{interest}_t = \text{balance}_{t-1} \times r$$ $$\text{principal}_t = \text{payment}_t - \text{interest}_t$$ $$\text{balance}_t = \text{balance}_{t-1} - \text{principal}_t$$ Extra principal is added after calculating the scheduled payment. The final payment is reduced when needed so the balance ends at zero rather than below zero.

Step by step

Worked audit for the default loan: principal $P=250,000$, annual rate 6.5%, monthly payments, and a 30-year term. The monthly periodic rate is $0.065 / 12 = 0.0054166667$. The number of payments is $30 \times 12 = 360$. Applying the fixed-payment formula gives a scheduled principal-and-interest payment of about $1,580.17.

First payment audit: interest is $250,000 \times 0.0054166667 = $1,354.17. Principal repaid is $1,580.17 - $1,354.17 = $226.00. The remaining balance is about $250,000 - $226.00 = $249,774.00. The next month’s interest is calculated on $249,774.00, not the original $250,000, so the interest portion falls slightly and the principal portion rises slightly.

If the borrower makes no extra payments, the calculator repeats that process for 360 rows and adjusts rounding at the final row. Total principal repaid equals the original $250,000. Total paid is approximately the scheduled payment multiplied by 360, subject to final-cent rounding, and total interest is total paid minus $250,000. If an extra $100 is entered, each regular payment applies $100 more to principal until payoff, reducing later interest because the outstanding balance falls faster.

Detailed calculation guide

AI Overview: An amortization schedule shows how a fixed loan payment gradually pays interest first and principal over time. This calculator converts the annual rate into a periodic rate, computes the scheduled payment, then builds a row-by-row schedule so you can compare total interest, payoff date, and the impact of extra principal payments.

Featured snippet: An amortization schedule is a payment table for an installment loan. Each row lists the payment date, payment amount, interest charged for the period, principal repaid, and remaining balance. For fixed-rate loans, the payment usually stays level while the interest share falls as the balance declines.

The Amortization Schedule Calculator — Calculate monthly loan payment and total interest is designed for a practical borrowing question: what will this loan really cost if the rate, term, and payment frequency stay fixed? Monthly payment is only one part of the answer. A longer term can make the required payment look comfortable while moving thousands of dollars into future interest. A shorter term can raise the payment but reduce lifetime cost. The schedule makes that tradeoff visible instead of hiding it behind a single payment number.

The calculation starts with the starting principal, also called the loan amount. The annual interest rate is converted to a rate per payment period. For a monthly loan, the periodic rate is the annual nominal rate divided by 12. For a biweekly loan, it is divided by 26. The term is converted into the number of scheduled payments. The standard fixed-payment formula then finds the payment that would reduce the balance to zero by the end of the term. After that, the schedule calculates interest as current balance times periodic rate, principal as payment minus interest, and new balance as old balance minus principal.

This tool separates the scheduled payment from extra principal. The scheduled payment is the amount required by the formula before voluntary prepayment. If you enter an extra payment, the calculator adds that amount to each payment until the balance is paid off, then adjusts the final payment so the ending balance does not go negative. The interest saved figure compares the extra-payment scenario with the same loan using no extra principal.

  • Common Mistakes

Using APR as if it always equals the note rate is a common source of confusion. APR is meant to express a broader annualized cost and may include certain finance charges or fees. The amortization formula here uses the periodic interest rate applied to the outstanding principal. If your lender quotes both a note rate and an APR, use the note rate for the payment schedule unless your loan documents state otherwise.

Another mistake is forgetting to divide the annual rate by the number of payments per year. A 6 percent annual rate is not 6 percent per month. For monthly payments, the periodic rate is 0.5 percent. That small conversion has a large effect over hundreds of payments.

Borrowers also compare loans by monthly payment alone. That can be misleading. A lower payment created by a longer term may increase total interest even when the interest rate is unchanged. The schedule and total interest output are included so you can compare affordability and lifetime cost together.

Mortgage users sometimes treat the principal-and-interest payment as the whole housing payment. It usually is not. Property taxes, homeowners insurance, mortgage insurance, HOA dues, escrow changes, late charges, and servicing fees can all sit outside this calculator. For auto loans, registration, insurance, dealer add-ons, and some origination fees may be separate from the amortized balance.

Some borrowers assume an extra payment automatically reduces principal. That is the best-case modeling assumption, but servicing practices vary. Extra funds may need to be marked principal-only, and some contracts specify how partial payments, late fees, or suspense balances are handled. The calculator can model the economics, but the loan agreement controls the operational treatment.

  • Assumptions

This calculator assumes a fixed rate, regular payment interval, fully amortizing loan, and no skipped payments. It assumes interest is charged once per payment period on the outstanding balance. It assumes extra payments, if entered, are applied directly to principal. In real lending systems, prepayments may be processed on a particular date, and some lenders require the borrower to designate the extra amount as principal-only.

The final payment may be smaller than the regular payment because the calculator adjusts for the remaining cents of balance and accumulated interest. That is normal. Lenders also round each payment to cents, which can create small differences from one amortization system to another. A one- or two-cent difference over a long schedule is not usually a formula error; it is often a rounding policy difference.

  • Limitations

Do not use this as a binding payoff quote. A lender payoff quote may include accrued daily interest through a specific payoff date, unpaid fees, escrow items, prepayment penalties where permitted, or servicing adjustments. The calculator is for planning, education, and side-by-side comparison.

It is not built for adjustable-rate mortgages, variable-rate student loans, interest-only loans, construction loans, balloon loans, lines of credit, revolving credit cards, or loans with negative amortization. Those products require different schedules because the rate, payment, draw balance, or required principal reduction can change over time.

It also does not decide whether a loan is affordable. Affordability depends on income stability, reserves, debt-to-income ratio, taxes, insurance, inflation, household obligations, and the opportunity cost of using cash for prepayment instead of savings, investing, or higher-interest debt payoff.

  • Practical Applications

Use the calculator before shopping to estimate a payment range that fits your budget. A homebuyer can compare a 15-year and 30-year mortgage. A car buyer can test whether a longer auto loan simply moves cost into interest. A borrower refinancing a personal loan can compare the new term against the old payoff path. A student learning finance can audit how each payment shifts from interest-heavy to principal-heavy over time.

The extra-payment field is useful for prepayment planning. You can test a fixed monthly extra amount, compare interest saved, and see whether the payoff date moves forward enough to justify the cash flow. For example, adding $100 per month to a mortgage may save meaningful interest over decades, but the same $100 may have a different priority if you carry credit card debt at a much higher rate.

Loan comparisons are strongest when the principal is held constant and only one variable changes at a time. Change the term to isolate term risk. Change the rate to isolate rate sensitivity. Change extra principal to isolate prepayment effects. This keeps the comparison clean enough to explain to another borrower, advisor, or lender.

  • Tips

Enter the principal that is actually amortized. If fees are financed into the loan, include them in the loan amount. If fees are paid in cash at closing, do not add them to principal, though you should still consider them when comparing total borrowing cost.

Use the same payment frequency that your lender uses. Biweekly payments are not automatically the same as paying half the monthly payment twice a month. A true biweekly schedule has 26 payments per year, while twice-monthly payments have 24. This calculator includes common frequencies, but your loan agreement controls the actual schedule.

When testing extra payments, confirm how your lender applies them. The best-case assumption is principal-only application with no prepayment charge. If a lender advances your due date instead, places funds in suspense, or applies the extra amount to fees first, the real interest savings may be lower.

  • Interpretation

The scheduled payment answers the required-payment question. Total paid answers how much cash leaves your pocket for principal and interest under the entered scenario. Total interest answers the cost of borrowing, excluding non-interest fees. Payoff date answers when the balance reaches zero if every payment is made as modeled. Interest saved answers how much interest is avoided by extra principal compared with the same loan without extra payments.

Early rows usually show high interest because the outstanding balance is high. Later rows show more principal because the balance has fallen, so each period accrues less interest. That shift is the core behavior of amortization. The payment may feel unchanged, but the economics inside the payment change every period.

  • Related Formulas

The periodic interest formula is interest equals balance times periodic rate. The principal portion is payment minus interest. The new balance is previous balance minus principal paid. Total interest is the sum of all period interest amounts or, equivalently for a no-extra fixed schedule, total payments minus original principal.

The zero-rate case is a special formula: payment equals principal divided by number of payments. This matters for promotional loans, family loans, or educational examples where the interest rate is 0 percent. A calculator that does not handle the zero-rate case can accidentally divide by zero.

  • Best Practices

Compare at least three scenarios: the lender’s quoted term, a shorter term, and the quoted term with a realistic extra payment. Keep the rate constant when you want to isolate the term effect. Keep the term constant when you want to isolate the rate effect. Change one input at a time when teaching or auditing the formula.

Check the first row manually. Multiply the starting balance by the periodic rate. Subtract that interest from the payment to get principal. Subtract principal from the starting balance. If the first row is sensible, the remaining schedule is usually a repeated application of the same logic.

Use total interest as a second decision metric, not a replacement for payment affordability. A very low-interest loan may be rational to keep if the cash is needed for emergency reserves. A high-interest loan may deserve faster payoff even if the payment is already manageable.

Keep a copy of official loan disclosures beside your calculator scenario. If the lender’s quoted payment differs materially, look for financed fees, payment timing, rate locks, mortgage insurance, escrow, odd first-period interest, or different compounding assumptions before assuming either number is wrong.

  • When NOT to use this calculator

Do not use it for a variable-rate loan where future rates are unknown. Do not use it for a credit card payoff plan where interest compounds daily and the minimum payment changes. Do not use it for an interest-only period followed by amortization unless you model the amortizing phase separately with the balance at conversion. Do not use it when taxes, insurance, or escrow are the main question.

Do not use it as legal, tax, investment, or lending advice. For regulated credit disclosures, rely on the lender’s official Loan Estimate, Closing Disclosure, retail installment contract, promissory note, or payoff statement. For major borrowing decisions, consider reviewing the documents with a qualified financial, housing, or legal professional.

  • Real-world examples

A $250,000 mortgage at 6.5 percent for 30 years produces a much lower payment than a 15-year mortgage, but the long term creates far more interest. A $35,000 auto loan at 7.9 percent over 72 months may look easier than a 48-month term, yet the longer repayment period keeps the balance high for longer. A $12,000 personal loan at 11 percent over 36 months can be compared with a 24-month payoff to see whether the higher payment is worth the interest reduction.

A borrower making extra payments should focus on both the interest saved and the payoff date. If the payoff date changes only slightly, the extra cash may have better uses. If the payoff date moves forward by years and the interest saved is large, principal prepayment may be a strong planning option, subject to liquidity needs and loan terms.

  • Comparison / educational intent

Compared with a simple loan payment calculator, an amortization calculator shows the mechanics behind the payment. Compared with a payoff calculator, it starts from the original term and scheduled repayment structure. Compared with an APR comparison, it focuses on principal-and-interest cash flows and does not incorporate all disclosure finance charges. Those distinctions matter because different calculators answer different questions.

The best use of this calculator is not to chase one perfect number. It is to build intuition. Change the term and watch total interest move. Change the rate and watch the first-year interest portion move. Add extra principal and watch the payoff date accelerate. Once you understand those relationships, loan offers become easier to evaluate and lender disclosures become easier to question intelligently.

For education, the schedule also explains why amortization can feel slow at first. The borrower is not being charged interest twice; interest is simply calculated on a large early balance. The table makes that visible, and visibility is useful. It helps borrowers ask better questions about affordability, total borrowing cost, refinancing claims, and whether a lower monthly payment is actually a better deal.

Beginner monthly mortgage estimate

Scheduled payment about $1,580.17; total interest about $318,861 over 360 monthly payments.

This shows the classic fixed-rate mortgage pattern: the payment is stable, but early rows are interest-heavy because the balance is still high.

Intermediate auto loan comparison

Scheduled payment about $613.35; total interest about $9,161 over 72 monthly payments.

The total interest output helps compare whether a shorter auto loan with a higher payment may be worth the reduced borrowing cost.

Advanced extra-principal mortgage scenario

Scheduled payment remains about $1,580.17, but total interest falls and payoff occurs earlier when the extra $100 is applied to principal.

Extra payments do not change the formula payment; they accelerate balance reduction and reduce future interest.

Edge case 0 percent loan

Scheduled payment is $333.33 with $0.00 total interest, subject to final-cent rounding.

With a zero periodic rate, the calculator uses principal divided by number of payments rather than the interest-bearing annuity formula.

Real-world biweekly repayment check

A biweekly scheduled payment is calculated from 26 periods per year, and the extra $25 per payment reduces interest versus no extra principal.

This scenario highlights why payment frequency matters: 26 biweekly periods is not the same as 12 monthly periods.

Frequently asked questions

How do you calculate a monthly loan payment?

Use the standard amortization formula with the loan amount, monthly interest rate, and total number of monthly payments. Divide the annual rate by 12, multiply the term in years by 12, and apply $M = P \times r(1+r)^n / ((1+r)^n-1)$.

Why does more of my early payment go to interest?

Interest is calculated on the outstanding balance, and that balance is largest at the beginning of the loan. As principal is repaid, each later period accrues less interest, so a larger share of the same payment goes toward principal.

What is the difference between interest rate and APR?

The interest rate is the rate used to calculate interest on the principal balance. APR is a broader disclosure measure that may include certain fees or finance charges, so it is not always the exact rate used in an amortization schedule.

Does making extra payments reduce total interest?

Yes, if the extra amount is applied to principal. Reducing principal earlier lowers the balance used for future interest calculations, which can shorten the payoff date and reduce lifetime interest.

Can I use this for a mortgage payment?

You can use it for the principal-and-interest part of a fixed-rate mortgage. It does not include property taxes, homeowners insurance, mortgage insurance, HOA dues, escrow changes, or closing costs.

Can I use this for an auto loan?

Yes, for a fixed-rate auto loan with regular installment payments. Enter the amount financed as the loan amount and use the contract interest rate. Dealer fees, insurance, registration, and optional products may not be included unless financed.

What happens if the interest rate is 0 percent?

The calculator uses the zero-rate formula: payment equals principal divided by the number of payments. There is no interest portion, so every payment reduces principal except for final rounding adjustments.

Why is the final payment sometimes different?

Currency payments are rounded to cents, while formulas may produce fractions of a cent. The final payment is adjusted so the remaining balance reaches exactly zero instead of leaving a tiny balance or overpaying.

Is a biweekly loan the same as two payments per month?

No. Biweekly means 26 payments per year because payments occur every two weeks. Twice-monthly means 24 payments per year. The difference can change both payoff timing and total interest.

Can this calculator handle variable-rate loans?

Not by itself. Variable-rate loans need a schedule that changes the rate at reset dates and may recalculate payments. This calculator assumes one fixed rate for the entire repayment period.

What is negative amortization?

Negative amortization occurs when the payment does not cover the interest that accrues, so the unpaid interest increases the balance. This calculator flags scenarios where the modeled payment would not cover periodic interest.

Should I pay extra principal or invest the money?

That depends on the loan rate, investment risk, taxes, liquidity needs, emergency savings, and other debts. The calculator can show interest savings, but it does not decide the best use of cash for your full financial situation.

Related calculators

Browse all calculators in this category

Editorial review

Author: JD

Sources

Enable JavaScript to use interactive calculators.