Amortization Schedule Calculator

Generate a dated loan payment schedule with extra payments and CSV export.

Fixed nominal annual rate; fees entered separately.
Rounded to whole payment periods; must include at least one payment.
Payment dates, extra payments and currency
Enter 0 to skip.
Count from the first scheduled payment (1).
Try a worked example

Loads example values in place of your current inputs. Choose one, then calculate. Examples are hypothetical; your inputs stay in this browser.

  • $12,000 over one year at 0%: $1,000 regular monthly payment plus $200 extra pays off in 10 payments, with no interest.
  • Hypothetical $12,000 over one year at 12% nominal annual interest: about $1,066.19 per month before fees, with 12 dated payments.
  • $12,000 over two years at 0%: eight $1,500 quarterly payments, first due 2026-04-30 and last due 2028-01-31.

Choose the loan tool for your task

Start with a loan principal and payment date to generate a dated repayment schedule and CSV.

These tools calculate scenarios from your assumptions; none compares lender offers or recommends a loan.

About this tool

Generate a dated amortization schedule from your loan balance, nominal annual interest rate and term. Choose monthly, fortnightly, weekly, quarterly, semiannual or annual payments, add extra principal, and download a CSV payment table.

How the calculation works

For principal P, periodic interest r and N payments: payment = P × r / [1 − (1 + r)^−N]. When r = 0, payment = P/N. Period interest = opening balance × r; principal repaid = payment − interest. Extra payments reduce principal and the final payment is capped at the amount owed.

Monthly loan payment formula

For a fixed-rate loan repaid monthly, divide the nominal annual interest rate (as a decimal) by 12 to get r. Multiply the term in years by 12 to get N, the number of monthly payments. If the rate is zero, simply divide the amount borrowed by N.

For example, borrow $12,000 at 6% for one year with no fees or extra payments. The monthly rate is 0.06 ÷ 12 = 0.005. The payment is $12,000 × 0.005 ÷ [1 − (1.005)⁻¹²] = $1,032.80, rounded to cents.

The first month’s interest is $12,000 × 0.005 = $60.00. Of that first payment, $972.80 pays down principal, leaving a balance of $11,027.20.

Formula reference: OpenStax, Contemporary Mathematics §6.8: Calculating Loan Payments.

Worked example

A $12,000 loan over one year at zero interest with monthly payments is $1,000 per month. Add $200 principal each month and repayment finishes in ten payments, with $12,000 repaid and no interest.

Compare payment frequencies at zero interest

A hypothetical $12,000 loan over two years, with no interest, fees or extra payments, starting January 31, 2026. This isolates payment count and calendar timing; it is not a comparison of lender offers.
FrequencyPaymentsPayment amount (USD)First due date
Monthly24$500.002026-02-28
Quarterly8$1,500.002026-04-30
Semiannual4$3,000.002026-07-31
Annual2$6,000.002027-01-31

Semiannual payments and semiannual compounding are different

Semiannual payments mean two payments per year, six months apart. In this calculator, the periodic rate for that schedule equals the entered nominal annual rate divided by two. The table applies interest once per payment period.

A mortgage with monthly payments and interest quoted with semiannual compounding needs a different rate conversion. Selecting semiannual payments here does not model that mortgage convention. Match both the payment timing and rate convention to the loan agreement.

Calculate compound interest on savings and regular deposits

Read and export the payment table

Each dated row separates the payment into interest and principal, then shows the remaining balance. Extra principal reduces the balance after interest is calculated; the last payment is capped at the amount still owed. A zero balance ends the schedule.

The Payment schedule CSV has six columns when the one-time extra is zero. Enter a one-time extra to add two columns showing the recurring and one-time principal actually applied on each payment. Choose Full worksheet CSV to keep the currency, entered loan inputs, rounded period count, assumptions, totals, payment-year summary and dated schedule together in one spreadsheet. Copy and print also include the loan setup shown above the summary. Exported currency values are rounded individually, so adding displayed rows can differ slightly from totals calculated at full precision. This is a mathematical estimate; lender fees, holiday adjustments and daily interest accrual are not included.

Read the yearly summary before opening every payment

The summary groups the existing schedule into one payment-year at a time: 12 monthly payments, four quarterly payments, two semiannual payments, or the selected frequency. Each row gives its first and last due date, payment count, principal repaid, interest, total paid and ending balance. It does not regroup the schedule into calendar or tax years.

An early payoff can leave a partial final group. In the zero-interest example, a $12,000 balance with a $1,000 regular monthly payment and $200 extra principal finishes in ten payments. Its single summary row contains those ten payments, $12,000 principal, no interest and a zero ending balance. Choosing a larger extra payment does not change the displayed regular payment formula.

For the quarterly zero-interest example starting January 31, 2026, the first due date is April 30, 2026 and the eighth is January 31, 2028. Dates preserve the original day where possible and clamp shorter months. Actual lender accrual and holiday rules can differ. Use the full schedule or its CSV to inspect individual dates; this is an estimate, not a statement or tax document.

How payment frequency changes the interest schedule

Compare two schedules for a $12,000 loan at a 6% fixed nominal annual rate. Both use a two-year term, a January 31, 2026 balance date and no extra payments or fees. The examples use the same assumptions apart from payment frequency.

Monthly payments start February 28, 2026. With 24 payments of about $531.85, the first payment includes $60.00 of interest. The first 12 payments include $561.67 of interest and the next 12 include $202.67. Total interest is $764.34.

Semiannual payments start July 31, 2026. With four payments of about $3,228.32, the first payment includes $360.00 of interest. The first two payments include $633.95 of interest and the next two include $279.35. Total interest is $913.30.

Open the Yearly summary to compare the grouped totals, then expand the full dated schedule for individual payments. The example uses the nominal rate divided by payments per year. Daily accrual, lender rounding and other rate conventions can give different results.

Open the monthly interest schedule example

Open the semiannual interest schedule example

Assumptions and limitations

The nominal annual rate is divided by the selected payments per year: 1, 2, 4, 12, 26 or 52. Term rounds to a whole payment count and must include at least one payment. The start date is the balance date; the first payment falls one payment interval later. Monthly, quarterly, semiannual and annual dates preserve the original day where possible, clamping to the last day of shorter months. Weekly and fortnightly payments advance 7 and 14 days. Interest retains full precision. CSV result amounts round to two decimal places; on-screen amounts use the selected currency precision.

This table is a mathematical estimate, not a lender statement. Actual accrual, holiday adjustments, rounding, fees and local compounding conventions can differ. Export includes only the schedule you requested; nothing is uploaded. Periodic accelerated-mortgage conventions are not implied by choosing weekly payments.

Sources and editorial responsibility

Maintained by Renvoro Pty Ltd. Sources inform the methods and assumptions shown here; outputs have the limitations described on this page.

Guide updated 2026-11-19. Calculation method and source dates remain separate.

Method reviewed 2026-10-16. Calculation standards · Report an issue