Amortization Calculator

Amortization Calculator

Leading AI Skill PRO

Enter Calculation

Extra payments & comparison
Compare with

Formula

M=P·r(1+r)n(1+r)n−1where{P=Loan Amountr=Annual Rate (%)1200n=12×Years+Months\begin{gathered} M = P \cdot \frac{r\,(1+r)^{n}}{(1+r)^{n}-1} \\[1.5em] \text{where}\quad \left\{ \begin{aligned} P &= \text{Loan Amount} \\ r &= \dfrac{\text{Annual Rate (\%)}}{1200} \\ n &= 12 \times \text{Years} + \text{Months} \end{aligned} \right. \end{gathered}
Usage stats

Advertisement

Results

Monthly Payment
$1,687.71
Paid off in Nov 2041 · Total interest $103,788.46

Estimates principal & interest only; excludes taxes, insurance, PMI and fees. Not financial advice.

34% of everything you pay goes to interest.

Adding an extra $100.00 a month saves $10,028.47 in interest and pays the loan off 15 months sooner.

Total months 180
Total interest $103,788.46
Total cost (principal + interest) $303,788.46
Loan payoff date Nov 2041
Principal share of total paid 65.84%
Loan amount $200,000.00
Interest rate 6%
First payment month Nov 2026

Side-by-side comparison

Your loan 30 years
Monthly payment $1,687.71 $1,199.10
Total interest $103,788.46 $231,676.38
Paid off in Nov 2041 Nov 2056

Principal vs. interest

Principal Interest

Loan balance over time

Balance

How your payment is calculated

r = 6% ÷ 12 = 0.005

M = P × r × (1 + r)^n ÷ ((1 + r)^n − 1)

M = $200,000.00 × 0.005 × 1.005^180 ÷ (1.005^180 − 1) = $1,687.71

Month 1: $200,000.00 × 0.005 = $1,000.00 → $1,687.71 − $1,000.00 = $687.71 → $199,312.29

No rounding between periods; amounts are rounded to the cent only for display. Payment #1 is due in the start month.

Annual amortization schedule

Year Interest Principal Extra End balance
2026 $1,996.56 $1,378.87 $198,621.13
2027 $11,684.18 $8,568.38 $190,052.75
2028 $11,155.70 $9,096.86 $180,955.89
2029 $10,594.63 $9,657.93 $171,297.96
2030 $9,998.95 $10,253.61 $161,044.35
2031 $9,366.53 $10,886.03 $150,158.31
2032 $8,695.10 $11,557.46 $138,600.85
2033 $7,982.26 $12,270.30 $126,330.55
2034 $7,225.46 $13,027.10 $113,303.45
2035 $6,421.98 $13,830.59 $99,472.86
2036 $5,568.94 $14,683.63 $84,789.23
2037 $4,663.28 $15,589.28 $69,199.95
2038 $3,701.77 $16,550.80 $52,649.15
2039 $2,680.95 $17,571.61 $35,077.54
2040 $1,597.17 $18,655.39 $16,422.15
2041 $454.99 $16,422.15 $0.00
Monthly amortization schedule
# Date Payment Principal Interest Extra Balance
1 Nov 2026 $1,687.71 $687.71 $1,000.00 $199,312.29
2 Dec 2026 $1,687.71 $691.15 $996.56 $198,621.13
3 Jan 2027 $1,687.71 $694.61 $993.11 $197,926.53
4 Feb 2027 $1,687.71 $698.08 $989.63 $197,228.45
5 Mar 2027 $1,687.71 $701.57 $986.14 $196,526.87
6 Apr 2027 $1,687.71 $705.08 $982.63 $195,821.79
7 May 2027 $1,687.71 $708.60 $979.11 $195,113.19
8 Jun 2027 $1,687.71 $712.15 $975.57 $194,401.04
9 Jul 2027 $1,687.71 $715.71 $972.01 $193,685.33
10 Aug 2027 $1,687.71 $719.29 $968.43 $192,966.05
11 Sep 2027 $1,687.71 $722.88 $964.83 $192,243.16
12 Oct 2027 $1,687.71 $726.50 $961.22 $191,516.67
13 Nov 2027 $1,687.71 $730.13 $957.58 $190,786.53
14 Dec 2027 $1,687.71 $733.78 $953.93 $190,052.75
15 Jan 2028 $1,687.71 $737.45 $950.26 $189,315.30
16 Feb 2028 $1,687.71 $741.14 $946.58 $188,574.17
17 Mar 2028 $1,687.71 $744.84 $942.87 $187,829.32
18 Apr 2028 $1,687.71 $748.57 $939.15 $187,080.76
19 May 2028 $1,687.71 $752.31 $935.40 $186,328.45
20 Jun 2028 $1,687.71 $756.07 $931.64 $185,572.38
21 Jul 2028 $1,687.71 $759.85 $927.86 $184,812.52
22 Aug 2028 $1,687.71 $763.65 $924.06 $184,048.87
23 Sep 2028 $1,687.71 $767.47 $920.24 $183,281.40
24 Oct 2028 $1,687.71 $771.31 $916.41 $182,510.10
25 Nov 2028 $1,687.71 $775.16 $912.55 $181,734.93
26 Dec 2028 $1,687.71 $779.04 $908.67 $180,955.89
27 Jan 2029 $1,687.71 $782.93 $904.78 $180,172.96
28 Feb 2029 $1,687.71 $786.85 $900.86 $179,386.11
29 Mar 2029 $1,687.71 $790.78 $896.93 $178,595.33
30 Apr 2029 $1,687.71 $794.74 $892.98 $177,800.59
31 May 2029 $1,687.71 $798.71 $889.00 $177,001.88
32 Jun 2029 $1,687.71 $802.70 $885.01 $176,199.18
33 Jul 2029 $1,687.71 $806.72 $881.00 $175,392.46
34 Aug 2029 $1,687.71 $810.75 $876.96 $174,581.71
35 Sep 2029 $1,687.71 $814.81 $872.91 $173,766.90
36 Oct 2029 $1,687.71 $818.88 $868.83 $172,948.02
37 Nov 2029 $1,687.71 $822.97 $864.74 $172,125.05
38 Dec 2029 $1,687.71 $827.09 $860.63 $171,297.96
39 Jan 2030 $1,687.71 $831.22 $856.49 $170,466.74
40 Feb 2030 $1,687.71 $835.38 $852.33 $169,631.36
41 Mar 2030 $1,687.71 $839.56 $848.16 $168,791.80
42 Apr 2030 $1,687.71 $843.75 $843.96 $167,948.05
43 May 2030 $1,687.71 $847.97 $839.74 $167,100.07
44 Jun 2030 $1,687.71 $852.21 $835.50 $166,247.86
45 Jul 2030 $1,687.71 $856.47 $831.24 $165,391.39
46 Aug 2030 $1,687.71 $860.76 $826.96 $164,530.63
47 Sep 2030 $1,687.71 $865.06 $822.65 $163,665.57
48 Oct 2030 $1,687.71 $869.39 $818.33 $162,796.18
49 Nov 2030 $1,687.71 $873.73 $813.98 $161,922.45
50 Dec 2030 $1,687.71 $878.10 $809.61 $161,044.35
51 Jan 2031 $1,687.71 $882.49 $805.22 $160,161.86
52 Feb 2031 $1,687.71 $886.90 $800.81 $159,274.95
53 Mar 2031 $1,687.71 $891.34 $796.37 $158,383.61
54 Apr 2031 $1,687.71 $895.80 $791.92 $157,487.82
55 May 2031 $1,687.71 $900.27 $787.44 $156,587.54
56 Jun 2031 $1,687.71 $904.78 $782.94 $155,682.77
57 Jul 2031 $1,687.71 $909.30 $778.41 $154,773.47
58 Aug 2031 $1,687.71 $913.85 $773.87 $153,859.62
59 Sep 2031 $1,687.71 $918.42 $769.30 $152,941.20
60 Oct 2031 $1,687.71 $923.01 $764.71 $152,018.20
61 Nov 2031 $1,687.71 $927.62 $760.09 $151,090.57
62 Dec 2031 $1,687.71 $932.26 $755.45 $150,158.31
63 Jan 2032 $1,687.71 $936.92 $750.79 $149,221.39
64 Feb 2032 $1,687.71 $941.61 $746.11 $148,279.78
65 Mar 2032 $1,687.71 $946.31 $741.40 $147,333.47
66 Apr 2032 $1,687.71 $951.05 $736.67 $146,382.42
67 May 2032 $1,687.71 $955.80 $731.91 $145,426.62
68 Jun 2032 $1,687.71 $960.58 $727.13 $144,466.04
69 Jul 2032 $1,687.71 $965.38 $722.33 $143,500.66
70 Aug 2032 $1,687.71 $970.21 $717.50 $142,530.45
71 Sep 2032 $1,687.71 $975.06 $712.65 $141,555.39
72 Oct 2032 $1,687.71 $979.94 $707.78 $140,575.45
73 Nov 2032 $1,687.71 $984.84 $702.88 $139,590.61
74 Dec 2032 $1,687.71 $989.76 $697.95 $138,600.85
75 Jan 2033 $1,687.71 $994.71 $693.00 $137,606.14
76 Feb 2033 $1,687.71 $999.68 $688.03 $136,606.46
77 Mar 2033 $1,687.71 $1,004.68 $683.03 $135,601.78
78 Apr 2033 $1,687.71 $1,009.70 $678.01 $134,592.07
79 May 2033 $1,687.71 $1,014.75 $672.96 $133,577.32
80 Jun 2033 $1,687.71 $1,019.83 $667.89 $132,557.49
81 Jul 2033 $1,687.71 $1,024.93 $662.79 $131,532.57
82 Aug 2033 $1,687.71 $1,030.05 $657.66 $130,502.52
83 Sep 2033 $1,687.71 $1,035.20 $652.51 $129,467.32
84 Oct 2033 $1,687.71 $1,040.38 $647.34 $128,426.94
85 Nov 2033 $1,687.71 $1,045.58 $642.13 $127,381.36
86 Dec 2033 $1,687.71 $1,050.81 $636.91 $126,330.55
87 Jan 2034 $1,687.71 $1,056.06 $631.65 $125,274.49
88 Feb 2034 $1,687.71 $1,061.34 $626.37 $124,213.15
89 Mar 2034 $1,687.71 $1,066.65 $621.07 $123,146.50
90 Apr 2034 $1,687.71 $1,071.98 $615.73 $122,074.52
91 May 2034 $1,687.71 $1,077.34 $610.37 $120,997.18
92 Jun 2034 $1,687.71 $1,082.73 $604.99 $119,914.45
93 Jul 2034 $1,687.71 $1,088.14 $599.57 $118,826.31
94 Aug 2034 $1,687.71 $1,093.58 $594.13 $117,732.73
95 Sep 2034 $1,687.71 $1,099.05 $588.66 $116,633.68
96 Oct 2034 $1,687.71 $1,104.55 $583.17 $115,529.13
97 Nov 2034 $1,687.71 $1,110.07 $577.65 $114,419.07
98 Dec 2034 $1,687.71 $1,115.62 $572.10 $113,303.45
99 Jan 2035 $1,687.71 $1,121.20 $566.52 $112,182.25
100 Feb 2035 $1,687.71 $1,126.80 $560.91 $111,055.45
101 Mar 2035 $1,687.71 $1,132.44 $555.28 $109,923.01
102 Apr 2035 $1,687.71 $1,138.10 $549.62 $108,784.91
103 May 2035 $1,687.71 $1,143.79 $543.92 $107,641.13
104 Jun 2035 $1,687.71 $1,149.51 $538.21 $106,491.62
105 Jul 2035 $1,687.71 $1,155.26 $532.46 $105,336.36
106 Aug 2035 $1,687.71 $1,161.03 $526.68 $104,175.33
107 Sep 2035 $1,687.71 $1,166.84 $520.88 $103,008.49
108 Oct 2035 $1,687.71 $1,172.67 $515.04 $101,835.82
109 Nov 2035 $1,687.71 $1,178.53 $509.18 $100,657.29
110 Dec 2035 $1,687.71 $1,184.43 $503.29 $99,472.86
111 Jan 2036 $1,687.71 $1,190.35 $497.36 $98,282.51
112 Feb 2036 $1,687.71 $1,196.30 $491.41 $97,086.21
113 Mar 2036 $1,687.71 $1,202.28 $485.43 $95,883.93
114 Apr 2036 $1,687.71 $1,208.29 $479.42 $94,675.63
115 May 2036 $1,687.71 $1,214.34 $473.38 $93,461.30
116 Jun 2036 $1,687.71 $1,220.41 $467.31 $92,240.89
117 Jul 2036 $1,687.71 $1,226.51 $461.20 $91,014.38
118 Aug 2036 $1,687.71 $1,232.64 $455.07 $89,781.74
119 Sep 2036 $1,687.71 $1,238.80 $448.91 $88,542.93
120 Oct 2036 $1,687.71 $1,245.00 $442.71 $87,297.94
121 Nov 2036 $1,687.71 $1,251.22 $436.49 $86,046.71
122 Dec 2036 $1,687.71 $1,257.48 $430.23 $84,789.23
123 Jan 2037 $1,687.71 $1,263.77 $423.95 $83,525.46
124 Feb 2037 $1,687.71 $1,270.09 $417.63 $82,255.38
125 Mar 2037 $1,687.71 $1,276.44 $411.28 $80,978.94
126 Apr 2037 $1,687.71 $1,282.82 $404.89 $79,696.12
127 May 2037 $1,687.71 $1,289.23 $398.48 $78,406.89
128 Jun 2037 $1,687.71 $1,295.68 $392.03 $77,111.21
129 Jul 2037 $1,687.71 $1,302.16 $385.56 $75,809.05
130 Aug 2037 $1,687.71 $1,308.67 $379.05 $74,500.38
131 Sep 2037 $1,687.71 $1,315.21 $372.50 $73,185.17
132 Oct 2037 $1,687.71 $1,321.79 $365.93 $71,863.38
133 Nov 2037 $1,687.71 $1,328.40 $359.32 $70,534.99
134 Dec 2037 $1,687.71 $1,335.04 $352.67 $69,199.95
135 Jan 2038 $1,687.71 $1,341.71 $346.00 $67,858.23
136 Feb 2038 $1,687.71 $1,348.42 $339.29 $66,509.81
137 Mar 2038 $1,687.71 $1,355.16 $332.55 $65,154.65
138 Apr 2038 $1,687.71 $1,361.94 $325.77 $63,792.71
139 May 2038 $1,687.71 $1,368.75 $318.96 $62,423.96
140 Jun 2038 $1,687.71 $1,375.59 $312.12 $61,048.36
141 Jul 2038 $1,687.71 $1,382.47 $305.24 $59,665.89
142 Aug 2038 $1,687.71 $1,389.38 $298.33 $58,276.51
143 Sep 2038 $1,687.71 $1,396.33 $291.38 $56,880.18
144 Oct 2038 $1,687.71 $1,403.31 $284.40 $55,476.86
145 Nov 2038 $1,687.71 $1,410.33 $277.38 $54,066.53
146 Dec 2038 $1,687.71 $1,417.38 $270.33 $52,649.15
147 Jan 2039 $1,687.71 $1,424.47 $263.25 $51,224.68
148 Feb 2039 $1,687.71 $1,431.59 $256.12 $49,793.09
149 Mar 2039 $1,687.71 $1,438.75 $248.97 $48,354.35
150 Apr 2039 $1,687.71 $1,445.94 $241.77 $46,908.40
151 May 2039 $1,687.71 $1,453.17 $234.54 $45,455.23
152 Jun 2039 $1,687.71 $1,460.44 $227.28 $43,994.80
153 Jul 2039 $1,687.71 $1,467.74 $219.97 $42,527.06
154 Aug 2039 $1,687.71 $1,475.08 $212.64 $41,051.98
155 Sep 2039 $1,687.71 $1,482.45 $205.26 $39,569.52
156 Oct 2039 $1,687.71 $1,489.87 $197.85 $38,079.66
157 Nov 2039 $1,687.71 $1,497.32 $190.40 $36,582.34
158 Dec 2039 $1,687.71 $1,504.80 $182.91 $35,077.54
159 Jan 2040 $1,687.71 $1,512.33 $175.39 $33,565.21
160 Feb 2040 $1,687.71 $1,519.89 $167.83 $32,045.33
161 Mar 2040 $1,687.71 $1,527.49 $160.23 $30,517.84
162 Apr 2040 $1,687.71 $1,535.12 $152.59 $28,982.72
163 May 2040 $1,687.71 $1,542.80 $144.91 $27,439.92
164 Jun 2040 $1,687.71 $1,550.51 $137.20 $25,889.40
165 Jul 2040 $1,687.71 $1,558.27 $129.45 $24,331.13
166 Aug 2040 $1,687.71 $1,566.06 $121.66 $22,765.08
167 Sep 2040 $1,687.71 $1,573.89 $113.83 $21,191.19
168 Oct 2040 $1,687.71 $1,581.76 $105.96 $19,609.43
169 Nov 2040 $1,687.71 $1,589.67 $98.05 $18,019.76
170 Dec 2040 $1,687.71 $1,597.61 $90.10 $16,422.15
171 Jan 2041 $1,687.71 $1,605.60 $82.11 $14,816.55
172 Feb 2041 $1,687.71 $1,613.63 $74.08 $13,202.92
173 Mar 2041 $1,687.71 $1,621.70 $66.01 $11,581.22
174 Apr 2041 $1,687.71 $1,629.81 $57.91 $9,951.41
175 May 2041 $1,687.71 $1,637.96 $49.76 $8,313.45
176 Jun 2041 $1,687.71 $1,646.15 $41.57 $6,667.31
177 Jul 2041 $1,687.71 $1,654.38 $33.34 $5,012.93
178 Aug 2041 $1,687.71 $1,662.65 $25.06 $3,350.28
179 Sep 2041 $1,687.71 $1,670.96 $16.75 $1,679.32
180 Oct 2041 $1,687.71 $1,679.32 $8.40 $0.00

Report an error on this page

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.

Diagram of monthly payment formula components with loan principal, interest rate, and number of payments
The amortization formula converts loan amount, monthly rate, and number of payments into a fixed monthly payment.

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.

Amortization schedule bar chart showing principal increasing and interest decreasing over the loan term
Early payments go mostly to interest; over time more of each payment reduces the principal.

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.

Advertisement

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.

Line graph comparing monthly payment across different interest rates and loan terms
Higher rates raise the payment while longer terms lower it but add total interest.

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.

Advertisement

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%.

Federal Reserve
Central bankPolicy rateAs ofChange in 1 year
Banco Central do Brasil (Selic) · Brazil13.75%2026-11-15−1.25 pp
Banco de México · Mexico6.25%2026-11-10−1.00 pp
Federal Reserve · United States3.75–4.00%2026-11-120 pp
ECB2.50%2026-11-16+0.50 pp
Sveriges Riksbank · Sweden2.00%2026-11-16+0.25 pp
Saudi Central Bank (SAMA) · Saudi Arabia4.50%2026-10-290 pp
Reserve Bank of Australia · Australia4.60%2026-10-31+1.00 pp
Central Bank of the Republic of Türkiye · Türkiye36.00%2026-11-06−3.50 pp
Bank of Russia · Russia14.00%2026-11-10−2.50 pp
People’s Bank of China · China3.00%2026-11-100 pp
Bank of Canada · Canada2.50%2026-11-12+0.25 pp
Reserve Bank of India · India5.50%2026-10-190 pp
Bank of England · United Kingdom4.00%2026-11-150 pp
Bank of Japan · Japan1.25%2026-11-10+0.75 pp
Bank of Korea · South Korea3.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.

RateLevelAs ofChange in 1 year
Federal funds target range3.75–4.00%2026-11-120 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
Effective federal funds rate (EFFR)

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

Interest rates in United States: all figures and history

Sources

Drafted with AI assistance and checked against 67 test cases, including calculator.net cross-checks.

Last updated:

Most popular in Financial

View all Financial calculators