Giới thiệu Amortization schedule calculator
An amortization schedule splits every loan payment into interest and principal. Each period's interest is the balance times the rate per period, and the rest of the fixed payment reduces the balance, so the interest share falls with every payment. The payment is L × i × (1 + i)^n ÷ ((1 + i)^n − 1), where L is the loan, i the rate per period and n the number of payments.
With the defaults, 250,000 at 6.5% for 30 years, the payment is 1,580.17 a month and interest totals 318,861.22. The first payment is 1,354.17 of interest and only 226.00 of principal; principal overtakes interest at payment 233. Paying half the monthly amount every two weeks (accelerated biweekly) ends the loan after 628 payments, about 24.2 years, and saves 73,434.82 of interest.
The rate is fixed and every payment is the same, apart from a last payment that clears the remaining cents. Biweekly and weekly rates are the annual rate ÷ 26 or ÷ 52 unless you choose another compounding under More options.
Câu hỏi
How do you calculate an amortization schedule?
Work out the fixed payment, then repeat three steps for every period: interest = balance × periodic rate, principal = payment − interest, new balance = balance − principal. For 250,000 at 6.5% over 30 years the payment is 1,580.17; month 1 interest is 250,000 × 6.5% ÷ 12 = 1,354.17, principal is 226.00 and the balance falls to 249,774.00. Excel's PMT, IPMT and PPMT functions give the same figures.
Why does most of an early mortgage payment go to interest?
Interest is charged on the balance still owed, and the balance is largest at the start. On 250,000 at 6.5% over 30 years, 1,354.17 of the first 1,580.17 payment is interest. The principal part grows each month and first exceeds the interest part at payment 233, in year 20. Extra payments move that point earlier because they cut the balance directly.
Do biweekly payments save interest?
Only the accelerated kind saves much. A biweekly payment sized to finish on the original 30-year term, 728.97 on 250,000 at 6.5%, saves 268.06 against monthly payments. Paying half the monthly payment, 790.09, every two weeks makes 26 half-payments, the same as 13 monthly payments a year; that ends the loan after about 24.2 years and saves 73,434.82.
How much interest does a 15-year loan save over a 30-year loan?
Borrowing 250,000 at 6.5%, a 30-year loan costs 1,580.17 a month and 318,861.22 of interest; over 15 years the payment rises to 2,177.77 and interest falls to 141,998.31, a saving of 176,862.91 at the same rate. Fifteen-year rates are lower in practice: Freddie Mac's survey of September 24, 2026, averaged 6.42% for 15-year and 7.03% for 30-year fixed loans.
How are Canadian mortgage payments calculated?
Canada's Interest Act (section 6) requires a mortgage to state its rate calculated yearly or half-yearly, not in advance, so the monthly rate is the equivalent of the half-yearly rate: (1 + 5% ÷ 2)^(1/6) − 1 = 0.41239% for a 5% mortgage. On 300,000 over 25 years that gives 1,744.81 a month, against 1,753.77 if the 5% compounded monthly. Choose "Twice a year (Canada)" under More options.
“Amortization schedule calculator” chính xác đến mức nào?
Độ chính xác phụ thuộc vào dữ liệu nhập và giả định của phương pháp. Phép tính thập phân dùng 50 chữ số có nghĩa, nhưng ước lượng, phương pháp số và dữ liệu nguồn có thể kém chính xác hơn; làm tròn khi hiển thị không loại bỏ các giới hạn đó. Ví dụ có lời giải đã đối chiếu với nguồn độc lập: 6. Ví dụ, “200,000 at 6% for 15 years” được kiểm tra bằng Calculator.net amortization calculator, published default output: 1,687.71 a month, 103,788.46 total interest.
Phương pháp này lấy từ đâu?
Microsoft Excel PMT function (payment for a loan); Interest Act (Canada), R.S.C. 1985, c. I-15, section 6 — mortgage interest compounded half-yearly or yearly; Freddie Mac Primary Mortgage Market Survey (weekly 30-year and 15-year fixed rates); Consumer Financial Protection Bureau — How does paying down a mortgage work?.