360 payments of $1,580.17 per month repay $250,000.00 by November 2056 with $318,861.22 of interest, 56.1% of everything paid. The first payment is $1,354.17 interest and $226.00 principal; principal first exceeds interest in payment 233.
Principal and interest in each payment
InterestPrincipal
Principal and interest paid each calendar year
PrincipalInterest
Balance owed
Amortization schedule Rows: 360
No.
Date
Payment
Principal
Interest
Interest to date
Balance
1
Saturday, 12 December 2026
$1,580.17
$226.00
$1,354.17
$1,354.17
$249,774.00
2
Tuesday, 12 January 2027
$1,580.17
$227.23
$1,352.94
$2,707.11
$249,546.77
3
Friday, 12 February 2027
$1,580.17
$228.46
$1,351.71
$4,058.82
$249,318.31
4
Friday, 12 March 2027
$1,580.17
$229.70
$1,350.47
$5,409.29
$249,088.61
5
Monday, 12 April 2027
$1,580.17
$230.94
$1,349.23
$6,758.52
$248,857.67
6
Wednesday, 12 May 2027
$1,580.17
$232.19
$1,347.98
$8,106.50
$248,625.48
7
Saturday, 12 June 2027
$1,580.17
$233.45
$1,346.72
$9,453.23
$248,392.04
8
Monday, 12 July 2027
$1,580.17
$234.71
$1,345.46
$10,798.68
$248,157.32
9
Thursday, 12 August 2027
$1,580.17
$235.98
$1,344.19
$12,142.87
$247,921.34
10
Sunday, 12 September 2027
$1,580.17
$237.26
$1,342.91
$13,485.78
$247,684.07
11
Tuesday, 12 October 2027
$1,580.17
$238.55
$1,341.62
$14,827.40
$247,445.53
12
Friday, 12 November 2027
$1,580.17
$239.84
$1,340.33
$16,167.73
$247,205.69
13
Sunday, 12 December 2027
$1,580.17
$241.14
$1,339.03
$17,506.76
$246,964.55
How it's calculated S
Rate per payment period
i=126.5%=0.541667%
Payment
A=(1+i)360−1Li(1+i)360=1,580.17
n = 360 months × 12 ÷ 12 = 360 payments. Shown rounded to cents; the schedule uses the unrounded payment and the last payment clears any sub-cent residual.
Total interest
interest=568,861.22−250,000=318,861.22
All payments minus the loan: 360 payments, the last on 2056-11-12.
Effective annual rate
(1+i)12−1=6.6972%
About the 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.
How to calculate an amortization schedule
Work out the fixed payment A = L × i × (1 + i)ⁿ ÷ ((1 + i)ⁿ − 1), then charge each period's interest on the balance and apply the rest to principal. A fixed-rate 250,000 loan at 6.5% for 30 years costs 1,580.17 a month.
The first payments, worked by hand
Here L is the loan, i the rate per period and n the number of payments. Monthly, i = 6.5% ÷ 12 = 0.541667% and n = 360. Each row repeats three steps: interest = balance × i, principal = payment − interest, new balance = balance − principal.
Payment 2: interest 1,352.94; principal 227.23; balance 249,546.77.
Payment 3: interest 1,351.71; principal 228.46; balance 249,318.31.
The payment stays the same, but each month a little more of it goes to principal. Principal first exceeds interest at payment 233, in year 20. Over all 360 payments, interest totals 318,861.22, 56.1% of everything paid.
Biweekly vs accelerated biweekly payments
The same 250,000 at 6.5% over 30 years, with interest charged at the annual rate ÷ payments per year:
Payment scenario
Payment amount
Payment count
Total interest
Default
1580.17
360
318861.22
Biweekly
728.97
780
318593.16
Accelerated biweekly
790.09
628
245426.40
"Default" is the monthly schedule. A regular biweekly payment is sized to finish on the original 30-year term, so it saves only 268.06.
The accelerated version pays half the monthly payment every two weeks. Twenty-six halves make 13 monthly payments a year instead of 12, which ends the loan after 628 payments, about 24.2 years, and saves 73,434.82 of interest.
15-year vs 30-year loan
At the same 6.5%, a 15-year term on 250,000 costs 2,177.77 a month and 141,998.31 of interest. That is 597.60 more a month than the 30-year loan, for 176,862.91 less interest. Principal overtakes interest at payment 53 instead of 233.
Extra payments
Adding 200 to every monthly payment sends it straight to principal. The 30-year loan then ends after 265 payments instead of 360, and interest falls to 221,243.10, a saving of 97,618.12.
Canadian mortgages and other compounding rules
Most US loans charge the annual rate ÷ payments per year. A rate compounded m times a year instead gives a periodic rate of (1 + rate ÷ m)^(m ÷ p) − 1 for p payments a year.
Canada's Interest Act (section 6) requires a mortgage to state its rate calculated yearly or half-yearly, not in advance. For 5% compounded half-yearly, the monthly rate is 1.025^(1/6) − 1 = 0.412392%.
On 300,000 over 25 years, that gives 1,744.81 a month, against 1,753.77 if the 5% compounded monthly. The half-yearly loan costs 8.96 less a month and 2,686.55 less interest over the term.
Multiplying the rounded payment by the count. 1,580.17 × 360 = 568,861.20, but the payments total 568,861.22, because the schedule uses the unrounded 1,580.1701.
Expecting regular biweekly payments to save much. Only the accelerated version, with its extra monthly payment a year, shortens the loan noticeably.
Comparing payments of different frequencies. A 728.97 payment every two weeks is not a cheaper version of a 1,580.17 monthly payment; compare yearly totals or total interest.
Using the wrong compounding. Computing a Canadian 5% mortgage of 300,000 over 25 years at 5% ÷ 12 overstates the payment by 8.96 a month.
Applying a fixed schedule to an adjustable rate. The schedule holds the rate fixed for the whole term.
What to enter
The term must come to whole months. Weekly and biweekly schedules also need whole payment periods, so use whole years with them.
Accelerated biweekly pays half the monthly payment every two weeks; accelerated weekly pays a quarter every week.
Yearly totals follow calendar years, so a first payment on 1 November puts only two payments in the first year.
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.
About this calculator
A=(1+i)n−1Li(1+i)n,i={j/p(1+j/m)m/p−1compounding with each paymentcompounding m times a year
For planning only. Lenders, tax authorities and markets apply their own rounding, fees and rules; confirm figures with them before you commit.
Checked against references
This calculator includes 6 worked examples with independently sourced answers. They run in the test suite, and you can run them here too.
Put this calculator on your site
Paste this where you want the calculator to appear. It is free to use, it stays in step with corrections made here, and the credit line below it links back so your readers can find the full version.