Loan Repayment Schedule Calculator

Loan Repayment Schedule Calculator

Leading AI Skill PRO

Enter Calculation

Formula

A=Rnd(P·i(1+i)n(1+i)n−1)where{P=Loan amount×Unitf=Payments per yearik={Initial rate (%)100f,k≤f·Initial yearsRate thereafter (%)100f,otherwiseN=f(12Term (yrs)+Extra months)12n=N−f·Grace periodGrace unitRnd=Rounding of fractions\begin{gathered} A = \mathrm{Rnd}\!\left(P\cdot\frac{i\,(1+i)^{n}}{(1+i)^{n}-1}\right) \\[1.5em] \text{where}\quad \left\{ \begin{aligned} P &= \text{Loan amount} \times \text{Unit} \\ f &= \text{Payments per year} \\ i_k &= \begin{cases} \dfrac{\text{Initial rate (\%)}}{100\,f}, & k \le f\cdot\text{Initial years} \\[0.5em] \dfrac{\text{Rate thereafter (\%)}}{100\,f}, & \text{otherwise} \end{cases} \\ N &= \dfrac{f\left(12\,\text{Term (yrs)}+\text{Extra months}\right)}{12} \\ n &= N - \dfrac{f\cdot\text{Grace period}}{\text{Grace unit}} \\ \mathrm{Rnd} &= \text{Rounding of fractions} \end{aligned} \right. \end{gathered}
Usage stats

Advertisement

Results

Payment per period
$920
Number of payments: 120
Loan amount $100,000
First payment $920
Last payment $971.06
Total amount repaid $111,808.06
Total interest paid $11,808.06
# Payment Interest Principal Balance
1 920 166.67 753.33 99,246.67
2 920 165.41 754.59 98,492.08
3 920 164.15 755.85 97,736.23
4 920 162.89 757.11 96,979.12
5 920 161.63 758.37 96,220.76
6 920 160.37 759.63 95,461.12
7 920 159.1 760.9 94,700.23
8 920 157.83 762.17 93,938.06
9 920 156.56 763.44 93,174.62
10 920 155.29 764.71 92,409.91
11 920 154.02 765.98 91,643.93
12 920 152.74 767.26 90,876.67
13 920 151.46 768.54 90,108.13
14 920 150.18 769.82 89,338.31
15 920 148.9 771.1 88,567.21
16 920 147.61 772.39 87,794.82
17 920 146.32 773.68 87,021.15
18 920 145.04 774.96 86,246.18
19 920 143.74 776.26 85,469.93
20 920 142.45 777.55 84,692.38
21 920 141.15 778.85 83,913.53
22 920 139.86 780.14 83,133.39
23 920 138.56 781.44 82,351.94
24 920 137.25 782.75 81,569.19
25 920 135.95 784.05 80,785.14
26 920 134.64 785.36 79,999.78
27 920 133.33 786.67 79,213.12
28 920 132.02 787.98 78,425.14
29 920 130.71 789.29 77,635.85
30 920 129.39 790.61 76,845.24
31 920 128.08 791.92 76,053.32
32 920 126.76 793.24 75,260.07
33 920 125.43 794.57 74,465.51
34 920 124.11 795.89 73,669.61
35 920 122.78 797.22 72,872.4
36 920 121.45 798.55 72,073.85
37 920 120.12 799.88 71,273.97
38 920 118.79 801.21 70,472.76
39 920 117.45 802.55 69,670.22
40 920 116.12 803.88 68,866.34
41 920 114.78 805.22 68,061.11
42 920 113.44 806.56 67,254.55
43 920 112.09 807.91 66,446.64
44 920 110.74 809.26 65,637.38
45 920 109.4 810.6 64,826.78
46 920 108.04 811.96 64,014.82
47 920 106.69 813.31 63,201.52
48 920 105.34 814.66 62,386.85
49 920 103.98 816.02 61,570.83
50 920 102.62 817.38 60,753.45
51 920 101.26 818.74 59,934.7
52 920 99.89 820.11 59,114.59
53 920 98.52 821.48 58,293.12
54 920 97.16 822.84 57,470.27
55 920 95.78 824.22 56,646.06
56 920 94.41 825.59 55,820.47
57 920 93.03 826.97 54,993.5
58 920 91.66 828.34 54,165.16
59 920 90.28 829.72 53,335.43
60 920 88.89 831.11 52,504.33
61 943 131.26 811.74 51,692.59
62 943 129.23 813.77 50,878.82
63 943 127.2 815.8 50,063.01
64 943 125.16 817.84 49,245.17
65 943 123.11 819.89 48,425.28
66 943 121.06 821.94 47,603.35
67 943 119.01 823.99 46,779.36
68 943 116.95 826.05 45,953.3
69 943 114.88 828.12 45,125.19
70 943 112.81 830.19 44,295
71 943 110.74 832.26 43,462.74
72 943 108.66 834.34 42,628.4
73 943 106.57 836.43 41,791.97
74 943 104.48 838.52 40,953.45
75 943 102.38 840.62 40,112.83
76 943 100.28 842.72 39,270.11
77 943 98.18 844.82 38,425.29
78 943 96.06 846.94 37,578.35
79 943 93.95 849.05 36,729.3
80 943 91.82 851.18 35,878.12
81 943 89.7 853.3 35,024.82
82 943 87.56 855.44 34,169.38
83 943 85.42 857.58 33,311.8
84 943 83.28 859.72 32,452.08
85 943 81.13 861.87 31,590.21
86 943 78.98 864.02 30,726.19
87 943 76.82 866.18 29,860
88 943 74.65 868.35 28,991.65
89 943 72.48 870.52 28,121.13
90 943 70.3 872.7 27,248.43
91 943 68.12 874.88 26,373.55
92 943 65.93 877.07 25,496.49
93 943 63.74 879.26 24,617.23
94 943 61.54 881.46 23,735.77
95 943 59.34 883.66 22,852.11
96 943 57.13 885.87 21,966.24
97 943 54.92 888.08 21,078.16
98 943 52.7 890.3 20,187.85
99 943 50.47 892.53 19,295.32
100 943 48.24 894.76 18,400.56
101 943 46 897 17,503.56
102 943 43.76 899.24 16,604.32
103 943 41.51 901.49 15,702.83
104 943 39.26 903.74 14,799.09
105 943 37 906 13,893.09
106 943 34.73 908.27 12,984.82
107 943 32.46 910.54 12,074.28
108 943 30.19 912.81 11,161.47
109 943 27.9 915.1 10,246.37
110 943 25.62 917.38 9,328.99
111 943 23.32 919.68 8,409.31
112 943 21.02 921.98 7,487.33
113 943 18.72 924.28 6,563.05
114 943 16.41 926.59 5,636.46
115 943 14.09 928.91 4,707.55
116 943 11.77 931.23 3,776.32
117 943 9.44 933.56 2,842.76
118 943 7.11 935.89 1,906.87
119 943 4.77 938.23 968.63
120 971.06 2.42 968.63 0

Report an error on this page

What this calculator does

The Loan Repayment Schedule Calculator works out your periodic payment and produces a complete amortization table showing the interest portion, principal portion, and remaining balance for every payment. It supports two common repayment methods, optional rate changes part-way through the loan, and an initial grace (deferment) period during which only interest is charged. The underlying math is standard amortization and applies to any currency.

How to use it

Enter the loan amount (choose plain currency units or the x10,000 "man-yen" unit), select the repayment method, frequency, and rounding rule, then enter the interest rate and term. For a fixed-rate loan, set the "rate thereafter" equal to the initial rate. Leave the start year blank if you only want period numbers instead of calendar dates.

The formula explained

For the equal total payment method, each constant-rate phase uses $$A = \frac{B \cdot i}{1 - (1 + i)^{-n}}$$ where \(B\) is the current balance, \(i\) is the per-period rate (annual rate / 100 / payments per year), and \(n\) is the number of remaining payments. Each period the interest equals \(B \cdot i\) and the rest reduces principal. For the equal principal method, the principal portion stays constant at \(P/n\) while interest declines, so total payments fall over time. The final payment is adjusted to clear any rounding remainder so the balance closes at exactly zero.

Advertisement
Stacked bar showing equal payments split into shrinking interest and growing principal over time
Equal-total payments keep each installment the same while interest falls and principal repayment rises.

Worked example

Borrow 10,000,000 at a fixed 2% over 10 years, paid monthly. Per-period rate \(i = 0.02/12 = 0.00166667\) and \(N = 120\). Payment $$A = \frac{10{,}000{,}000 \times 0.00166667}{1 - 1.00166667^{-120}} \approx 92{,}013 \text{ per month}$$ Total repaid is about 11,041,560, so total interest is roughly 1,041,560.

Line chart comparing flat equal-total payments versus declining equal-principal payments
Equal-total payments stay constant; equal-principal payments start higher and decline over the term.

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-160 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

FAQ

Why does the last payment differ? Rounding each payment leaves a small residual, which the final payment absorbs so the balance reaches zero.

What is a grace period? During the grace period you pay interest only; principal repayment begins afterward and is amortized over the remaining payments.

Is this accurate for my lender? Results are informational. Banks differ in rounding and day-count conventions, so your actual schedule may vary slightly.

Last updated:

Most popular in Financial

View all Financial calculators