A $200,000 loan at 6% for 15 years costs $1,687.71 a month and $103,788 in interest; stretch it to 30 years and the payment drops to $1,199.10 but interest more than doubles to $231,676. Your numbers depend on rate, term and any extra payments — the schedule below shows each month.
How to use this amortization calculator
Enter the loan amount, the annual interest rate and the term in years (add months if your loan has an odd term, such as 5 years and 6 months). You can type the amount the way you write it: 200000, 200,000, $200k or 1.5m all work. Pick the month of your first payment in Start date to see the exact payoff month and a dated schedule.
Open Extra payments & comparison to add an extra amount every month, once a year, or up to three one-time lump sums, each from the month you choose. The result shows the interest saved, the months saved and a side-by-side comparison with and without the extra payments, or a 15-year versus 30-year comparison when you add no extra.
Switch the mode to Find payoff time from a payment if you know what you can pay each month and want to know how long the loan will take. The yearly schedule is open by default; the full monthly schedule sits below it and can be downloaded as a CSV file. The same math works for a mortgage, a personal loan or a car loan amortization.
Amortization formula: how each payment is split
A fully amortizing loan has one fixed payment M that covers the interest of the month and repays part of the principal, so the balance reaches exactly zero on the last payment:
M = P × r × (1 + r)n ÷ ((1 + r)n − 1)
P is the loan amount, r is the monthly rate (the annual rate divided by 12) and n is the number of monthly payments. At a 0% rate the payment is simply P ÷ n. Each month the interest is the remaining balance times r, and whatever is left of the payment reduces the balance. Early on a larger share of each payment is interest; near the end most of it is principal, as the Consumer Financial Protection Bureau explains.
Month 1 of a $200,000 loan
Monthly rate r = 6% ÷ 12 = 0.005. Number of payments n = 15 × 12 = 180. M = 200,000 × 0.005 × 1.005180 ÷ (1.005180 − 1) = $1,687.71. Month 1: interest = 200,000 × 0.005 = $1,000.00; principal = 1,687.71 − 1,000.00 = $687.71; balance = $199,312.29. Over 180 months you pay $303,788.46: $200,000 principal and $103,788.46 interest (34% of the total).
Some loans repay the same amount of principal every month instead (common in Korea, Japan and Vietnam). Choose Equal principal under Repayment method: each payment is the principal part, P ÷ n, plus that month's interest, so the first payment is the largest and the payment falls every month. On $200,000 at 6% for 30 years the first payment is $1,555.56, the last is $558.33 and the total interest is $180,500.00, against $231,676.38 with equal payments. The equal principal payment schedule page explains the method in more detail.
Example: $200,000 at 6% for 15 vs 30 years
| 15 years | 30 years | |
|---|---|---|
| Monthly payment | $1,687.71 | $1,199.10 |
| Number of payments | 180 | 360 |
| Total interest | $103,788.46 | $231,676.38 |
| Total paid | $303,788.46 | $431,676.38 |
The 30-year loan lowers the payment by $488.61 a month, but you pay $127,887.92 more interest because the balance stays high for longer.
How much do extra payments save?
Every extra dollar goes straight to principal, so the next month's interest is smaller and the loan ends sooner. On a $200,000 loan at 6% for 15 years, paying $200 more every month from the first payment ends the loan after 152 payments instead of 180 and saves $18,230.42 in interest. Adding $100 a month saves $10,028.47 and 15 months.
On the same $200,000 at 6% over 30 years, extra payments from the first month:
| Extra per month | Paid off after | Total interest | Interest saved |
|---|---|---|---|
| $0 | 360 months | $231,676.38 | — |
| $50 | 324 months | $203,797.07 | $27,879.31 |
| $100 | 295 months | $182,537.97 | $49,138.41 |
| $200 | 252 months | $151,875.87 | $79,800.51 |
| $500 | 179 months | $102,534.54 | $129,141.83 |
To plan a mortgage payoff date or compare paying off early with investing, use the mortgage payoff calculator. If you make a large lump sum and want a lower payment rather than a shorter loan, ask your lender whether you can recast your mortgage after a lump sum.
Is there a prepayment penalty?
Usually not for small extra payments. The CFPB notes that a prepayment penalty typically applies only if you pay off the entire mortgage balance within a specific number of years (usually three or five), and sometimes if you pay off a large amount at once; extra principal paid in small chunks normally does not trigger it. Check your loan documents before a large prepayment.
Biweekly vs monthly payments
With accelerated biweekly payments you pay half of the monthly payment every two weeks. That is 26 half-payments a year, the same as 13 monthly payments instead of 12, so the extra payment each year goes to principal and the loan ends several years early. Plain biweekly payments that only split the annual total into 26 parts save very little. This calculator works with monthly payments; to model a biweekly plan, enter one twelfth of a monthly payment as Extra per month, or use the biweekly mortgage calculator.
How to build an amortization schedule in Excel or Google Sheets
The payment is =PMT(6%/12, 180, -200000), which returns 1,687.71. For month k, =IPMT(6%/12, k, 180, -200000) gives the interest and =PPMT(6%/12, k, 180, -200000) the principal; the balance is the previous balance minus that principal. Extra payments are easier to handle row by row: interest = previous balance × 0.5%, principal = payment − interest + extra. Or click Download CSV under the schedule and open the file in your spreadsheet.
Balloon loans: what is left at the end
A balloon loan uses a long amortization to set a low payment but ends early, leaving a large balance to pay in one sum. The yearly schedule above shows the balance you would still owe at any year. To calculate the balloon amount directly, use the balloon payment calculator.
Monthly payment table: $100,000–$500,000 at 5%, 6% and 7%
| Loan | 5% · 15 yr | 5% · 30 yr | 6% · 15 yr | 6% · 30 yr | 7% · 15 yr | 7% · 30 yr |
|---|---|---|---|---|---|---|
| $100,000 | $790.79 | $536.82 | $843.86 | $599.55 | $898.83 | $665.30 |
| $200,000 | $1,581.59 | $1,073.64 | $1,687.71 | $1,199.10 | $1,797.66 | $1,330.60 |
| $300,000 | $2,372.38 | $1,610.46 | $2,531.57 | $1,798.65 | $2,696.48 | $1,995.91 |
| $400,000 | $3,163.17 | $2,147.29 | $3,375.43 | $2,398.20 | $3,595.31 | $2,661.21 |
| $500,000 | $3,953.97 | $2,684.11 | $4,219.28 | $2,997.75 | $4,494.14 | $3,326.51 |
Principal and interest only. Enter your own rate above for an exact figure.
What this calculator does not include
The payment here is principal and interest only. A mortgage payment usually also includes property tax, homeowners insurance and, with a small down payment, mortgage insurance (PMI), often collected through escrow; for those, use the mortgage calculator with taxes and insurance. The calculator assumes a fixed rate for the whole term, so it does not model adjustable-rate loans. The rate you enter is the interest rate, not the APR: the APR also includes fees and points, so it is usually higher than the rate used to compute the payment.
How we calculate
Interest is computed on the exact balance every month and nothing is rounded between payments; amounts are rounded to the cent only when they are shown. This matches calculator.net to the cent on the cases we cross-checked. The last payment repays whatever balance is left, so it can be a few cents different. Extra payments are applied after the regular payment of the same month and are cut on the last payment so the balance never goes below zero. Payment #1 falls in the start month, so a 180-payment loan starting in January 2027 is paid off in January 2042 (the last row of the schedule is December 2041). In the payoff-time mode, a final payment under $1 is added to the previous payment. The engine is checked against 67 test cases, written independently of the code.
Frequently asked questions
How much interest will I pay on a $200,000 loan at 6% for 30 years? $231,676.38 in total interest, with a monthly payment of $1,199.10. The same loan over 15 years costs $103,788.46 in interest.
How much do extra payments shorten my loan? On $200,000 at 6% for 15 years, $200 more each month pays the loan off after 152 payments instead of 180 and saves $18,230.42 in interest. Enter your own amount under Extra payments to see your numbers.
Can I calculate the loan term from a fixed monthly payment? Yes. Choose "Find payoff time from a payment": $1,500 a month on $200,000 at 6% pays the loan off in 221 months, with a final payment of $407.70.
What is a balloon payment and how is it calculated? It is the balance still owed when a loan ends before it is fully amortized, paid in one sum. Read it from the yearly schedule at the year the loan ends, or use the balloon payment calculator.
Are biweekly payments better than monthly? Accelerated biweekly payments (half the monthly payment every two weeks) add the equivalent of one monthly payment a year, so you pay less interest and finish years earlier. Splitting the same yearly total into 26 payments saves very little.
Does this include taxes, insurance and escrow? It covers principal and interest only. To add property tax, insurance and PMI, use the mortgage calculator with taxes and insurance.
How do I make an amortization schedule in Excel? Use =PMT(6%/12,180,-200000) for the payment (1,687.71), then IPMT and PPMT for the interest and principal of each month. Or download the CSV from this page.
Use this amortization engine via API or embed
The same engine is available to AI assistants and scripts through our MCP server and API, with the inputs above as parameters and the results as plain numbers.
Central bank policy rates today
The latest official policy rates of major central banks, updated automatically — the benchmark that bank deposit and loan rates follow.
- Federal Reserve · United States
- 3.75–4.00%
- As of
- 2026-11-12
- Change in 1 year
- 0 pp
Latest change Up +25 bp Federal Reserve changed its rate on 2026-09-17: from 3.50–3.75% to 3.75–4.00%.
| Central bank | Policy rate | As of | Change in 1 year |
|---|---|---|---|
| Banco Central do Brasil (Selic) · Brazil | 13.75% | 2026-11-15 | −1.25 pp |
| Banco de México · Mexico | 6.25% | 2026-11-10 | −1.00 pp |
| Federal Reserve · United States | 3.75–4.00% | 2026-11-12 | 0 pp |
| ECB | 2.50% | 2026-11-16 | +0.50 pp |
| Sveriges Riksbank · Sweden | 2.00% | 2026-11-16 | +0.25 pp |
| Saudi Central Bank (SAMA) · Saudi Arabia | 4.50% | 2026-10-29 | 0 pp |
| Reserve Bank of Australia · Australia | 4.60% | 2026-10-31 | +1.00 pp |
| Central Bank of the Republic of Türkiye · Türkiye | 36.00% | 2026-11-06 | −3.50 pp |
| Bank of Russia · Russia | 14.00% | 2026-11-10 | −2.50 pp |
| People’s Bank of China · China | 3.00% | 2026-11-10 | 0 pp |
| Bank of Canada · Canada | 2.50% | 2026-11-12 | +0.25 pp |
| Reserve Bank of India · India | 5.50% | 2026-10-19 | 0 pp |
| Bank of England · United Kingdom | 4.00% | 2026-11-15 | 0 pp |
| Bank of Japan · Japan | 1.25% | 2026-11-10 | +0.75 pp |
| Bank of Korea · South Korea | 3.00% | 2026-11-02 | +0.50 pp |
Federal Reserve: key rates and overnight market rates
The rates that frame monetary policy and the overnight market rate they steer, each with the date of its latest published value.
| Rate | Level | As of | Change in 1 year |
|---|---|---|---|
| Federal funds target range | 3.75–4.00% | 2026-11-12 | 0 pp |
| Effective federal funds rate (EFFR) | 3.88% | 2026-11-12 | +0.01 pp |
| Secured Overnight Financing Rate (SOFR) | 3.90% | 2026-11-12 | −0.08 pp |
Each rate keeps the date of its own latest published value; overnight market rates are published on the next business day.
Latest figure: 2026-11-12 Data last updated 2026-11-16 · current
Source: Banco Central do Brasil ODbL; Bank for International Settlements (BIS) Terms of permitted use of BIS statistics; Federal Reserve Bank of New York New York Fed Terms of Use; Board of Governors of the Federal Reserve System Public domain (U.S. government work); European Central Bank ECB reuse policy; Sveriges Riksbank Riksbank open data terms; The World Bank Group CC BY 4.0; Reserve Bank of Australia 2026 RBA copyright terms (Cash Rate); Bank of Canada Bank of Canada terms of use; Bank of England Open Government Licence v3.0
The one-year change is computed by CalculatorLib from these data. The EFFR and SOFR are subject to the Terms of Use posted at newyorkfed.org. The New York Fed is not responsible for publication of the EFFR and SOFR by CalculatorLib, does not sanction or endorse any particular republication, and has no liability for your use.
Source details and methodology
- Banco Central do Brasil
- Bank for International Settlements (BIS) — Central bank policy rates
- Federal Reserve Bank of New York — Reference rates (EFFR, SOFR)
- Board of Governors of the Federal Reserve System
- European Central Bank
- Sveriges Riksbank
- The World Bank Group — World Development Indicators (FR.INR.LEND, FR.INR.RINR)
- Reserve Bank of Australia 2026
- Bank of Canada
- Bank of England
Sources
- Consumer Financial Protection Bureau: How does paying down a mortgage work?
- Consumer Financial Protection Bureau: What is a prepayment penalty?
Drafted with AI assistance and checked against 67 test cases, including calculator.net cross-checks.