Payment Payoff Calculator

Formatting only. This does not change the calculation.
The nominal annual rate (APR before fees), not the monthly rate.
Added to the term in years, for terms such as 5 years and 6 months. To state a tenure purely in months, set the years to 0 and enter the whole tenure here.
Additional principal paid on top of the scheduled payment.
Months to repay
138
Loan Payment Calculator
Payment
158.02
Total interest
10,540.08
Total of payments
35,540.08
Number of payments
138
Payoff time
11.5 years
Rate per period
0.541667 %
Interest per unit borrowed
0.4216
Interest saved by extra payments
21,343.73
Payments saved
222
Loan amount
25,000.00
Annual interest rate
6.5 %
Fees deducted at closing
0.00
Net amount advanced
25,000.00
APR
6.5 %
Worked out from Standard annuity-immediate payment formula, PMT = P i / (1 - (1+i)^-n) and 4 other sources.

How this is worked out

4 steps
  1. Rate per period = 6.5% / 12 = 0.541667%
  2. Payment = P i / (1 - (1+i)^-n) = 158.02
  3. Over 138 payments the total paid is 35540.08, of which 10540.08 is interest.
  4. The extra payment closes the loan 222 payments early and saves 21343.73 in interest.
Amortisation scheduletable
periodpaymentinterestprincipalbalance
1258.02135.42122.624,877.4
2258.02134.75123.2724,754.13
3258.02134.08123.9424,630.19
4258.02133.41124.6124,505.58
5258.02132.74125.2824,380.3
6258.02132.06125.9624,254.34
7258.02131.38126.6424,127.7
8258.02130.69127.3324,000.37
9258.02130128.0223,872.35
10258.02129.31128.7123,743.64
11258.02128.61129.4123,614.23
12258.02127.91130.1123,484.12
13258.02127.21130.8123,353.31
14258.02126.5131.5223,221.79
15258.02125.78132.2423,089.55
16258.02125.07132.9522,956.6
17258.02124.35133.6722,822.93
18258.02123.62134.422,688.53
19258.02122.9135.1222,553.41
20258.02122.16135.8622,417.55
21258.02121.43136.5922,280.96
22258.02120.69137.3322,143.63
23258.02119.94138.0822,005.55
24258.02119.2138.8221,866.73
25258.02118.44139.5821,727.15
26258.02117.69140.3321,586.82
27258.02116.93141.0921,445.73
28258.02116.16141.8621,303.87
29258.02115.4142.6221,161.25
30258.02114.62143.421,017.85
31258.02113.85144.1720,873.68
32258.02113.07144.9520,728.73
33258.02112.28145.7420,582.99
34258.02111.49146.5320,436.46
35258.02110.7147.3220,289.14
36258.02109.9148.1220,141.02
37258.02109.1148.9219,992.1
38258.02108.29149.7319,842.37
39258.02107.48150.5419,691.83
40258.02106.66151.3619,540.47
41258.02105.84152.1819,388.29
42258.02105.0215319,235.29
43258.02104.19153.8319,081.46
44258.02103.36154.6618,926.8
45258.02102.52155.518,771.3
46258.02101.68156.3418,614.96
47258.02100.83157.1918,457.77
48258.0299.98158.0418,299.73
49258.0299.12158.918,140.83
50258.0298.26159.7617,981.07
51258.0297.4160.6217,820.45
52258.0296.53161.4917,658.96
53258.0295.65162.3717,496.59
54258.0294.77163.2517,333.34
55258.0293.89164.1317,169.21
56258.0293165.0217,004.19
57258.0292.11165.9116,838.28
58258.0291.21166.8116,671.47
59258.0290.3167.7216,503.75
60258.0289.4168.6216,335.13
61258.0288.48169.5416,165.59
62258.0287.56170.4615,995.13
63258.0286.64171.3815,823.75
64258.0285.71172.3115,651.44
65258.0284.78173.2415,478.2
66258.0283.84174.1815,304.02
67258.0282.9175.1215,128.9
68258.0281.95176.0714,952.83
69258.0280.99177.0314,775.8
70258.0280.04177.9814,597.82
71258.0279.07178.9514,418.87
72258.0278.1179.9214,238.95
73258.0277.13180.8914,058.06
74258.0276.15181.8713,876.19
75258.0275.16182.8613,693.33
76258.0274.17183.8513,509.48
77258.0273.18184.8413,324.64
78258.0272.18185.8413,138.8
79258.0271.17186.8512,951.95
80258.0270.16187.8612,764.09
81258.0269.14188.8812,575.21
82258.0268.12189.912,385.31
83258.0267.09190.9312,194.38
84258.0266.05191.9712,002.41
85258.0265.01193.0111,809.4
86258.0263.97194.0511,615.35
87258.0262.92195.111,420.25
88258.0261.86196.1611,224.09
89258.0260.8197.2211,026.87
90258.0259.73198.2910,828.58
91258.0258.65199.3710,629.21
92258.0257.57200.4510,428.76
93258.0256.49201.5310,227.23
94258.0255.4202.6210,024.61
95258.0254.3203.729,820.89
96258.0253.2204.829,616.07
97258.0252.09205.939,410.14
98258.0250.97207.059,203.09
99258.0249.85208.178,994.92
100258.0248.72209.38,785.62
101258.0247.59210.438,575.19
102258.0246.45211.578,363.62
103258.0245.3212.728,150.9
104258.0244.15213.877,937.03
105258.0242.99215.037,722
106258.0241.83216.197,505.81
107258.0240.66217.367,288.45
108258.0239.48218.547,069.91
109258.0238.3219.726,850.19
110258.0237.11220.916,629.28
111258.0235.91222.116,407.17
112258.0234.71223.316,183.86
113258.0233.5224.525,959.34
114258.0232.28225.745,733.6
115258.0231.06226.965,506.64
116258.0229.83228.195,278.45
117258.0228.59229.435,049.02
118258.0227.35230.674,818.35
119258.0226.1231.924,586.43
120258.0224.84233.184,353.25

First 120 of 138 rows.

Yearly summarytable
yearinterestprincipalendingBalance
11,580.361,515.8823,484.12
21,478.851,617.3921,866.73
31,370.531,725.7120,141.02
41,254.951,841.2918,299.73
51,131.641,964.616,335.13
61,000.062,096.1814,238.95
7859.72,236.5412,002.41
8709.92,386.349,616.07
9550.082,546.167,069.91
10379.582,716.664,353.25
11197.632,898.611,454.64
1226.81,454.640

Results are general information, not financial, tax, legal, medical or engineering advice.