Loan 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.
Anything other than the payment treats the payment below as the known quantity and solves the same annuity equation for the missing one.
The instalment you can afford or have been quoted. Used only when solving for the rate, the term or the loan amount.
Commercial, land and construction loans are commonly written on a long amortisation but fall due earlier, with the remaining balance repaid in one balloon payment. Leave at 0 for a fully amortising loan.
A percentage of the loan withheld at closing. Enter the figure your lender quotes - fee schedules differ by lender and by programme.
Guaranty, packaging, survey or documentation fees withheld from the advance rather than paid separately.
Which figure this calculator leads with. Everything else is still computed.
Payment
158.02
Loan Payment Calculator
Total interest
31,883.81
Total of payments
56,883.81
Number of payments
360
Payoff time
30 years
Rate per period
0.541667 %
Interest per unit borrowed
1.2754
Interest saved by extra payments
0
Payments saved
0
Loan amount
25,000.00
Annual interest rate
6.5 %
Months to repay
360
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

3 steps
  1. Rate per period = 6.5% / 12 = 0.541667%
  2. Payment = P i / (1 - (1+i)^-n) = 158.02
  3. Over 360 payments the total paid is 56883.81, of which 31883.81 is interest.
Amortisation scheduletable
periodpaymentinterestprincipalbalance
1158.02135.4222.624,977.4
2158.02135.2922.7324,954.67
3158.02135.1722.8524,931.82
4158.02135.0522.9724,908.85
5158.02134.9223.124,885.75
6158.02134.823.2224,862.53
7158.02134.6723.3524,839.18
8158.02134.5523.4724,815.71
9158.02134.4223.624,792.11
10158.02134.2923.7324,768.38
11158.02134.1623.8624,744.52
12158.02134.0323.9924,720.53
13158.02133.924.1224,696.41
14158.02133.7724.2524,672.16
15158.02133.6424.3824,647.78
16158.02133.5124.5124,623.27
17158.02133.3824.6424,598.63
18158.02133.2424.7824,573.85
19158.02133.1124.9124,548.94
20158.02132.9725.0524,523.89
21158.02132.8425.1824,498.71
22158.02132.725.3224,473.39
23158.02132.5625.4624,447.93
24158.02132.4325.5924,422.34
25158.02132.2925.7324,396.61
26158.02132.1525.8724,370.74
27158.02132.0126.0124,344.73
28158.02131.8726.1524,318.58
29158.02131.7326.2924,292.29
30158.02131.5826.4424,265.85
31158.02131.4426.5824,239.27
32158.02131.326.7224,212.55
33158.02131.1526.8724,185.68
34158.02131.0127.0124,158.67
35158.02130.8627.1624,131.51
36158.02130.7127.3124,104.2
37158.02130.5627.4624,076.74
38158.02130.4227.624,049.14
39158.02130.2727.7524,021.39
40158.02130.1227.923,993.49
41158.02129.9628.0623,965.43
42158.02129.8128.2123,937.22
43158.02129.6628.3623,908.86
44158.02129.5128.5123,880.35
45158.02129.3528.6723,851.68
46158.02129.228.8223,822.86
47158.02129.0428.9823,793.88
48158.02128.8829.1423,764.74
49158.02128.7329.2923,735.45
50158.02128.5729.4523,706
51158.02128.4129.6123,676.39
52158.02128.2529.7723,646.62
53158.02128.0929.9323,616.69
54158.02127.9230.123,586.59
55158.02127.7630.2623,556.33
56158.02127.630.4223,525.91
57158.02127.4330.5923,495.32
58158.02127.2730.7523,464.57
59158.02127.130.9223,433.65
60158.02126.9331.0923,402.56
61158.02126.7631.2623,371.3
62158.02126.5931.4323,339.87
63158.02126.4231.623,308.27
64158.02126.2531.7723,276.5
65158.02126.0831.9423,244.56
66158.02125.9132.1123,212.45
67158.02125.7332.2923,180.16
68158.02125.5632.4623,147.7
69158.02125.3832.6423,115.06
70158.02125.2132.8123,082.25
71158.02125.0332.9923,049.26
72158.02124.8533.1723,016.09
73158.02124.6733.3522,982.74
74158.02124.4933.5322,949.21
75158.02124.3133.7122,915.5
76158.02124.1333.8922,881.61
77158.02123.9434.0822,847.53
78158.02123.7634.2622,813.27
79158.02123.5734.4522,778.82
80158.02123.3934.6322,744.19
81158.02123.234.8222,709.37
82158.02123.0135.0122,674.36
83158.02122.8235.222,639.16
84158.02122.6335.3922,603.77
85158.02122.4435.5822,568.19
86158.02122.2435.7822,532.41
87158.02122.0535.9722,496.44
88158.02121.8636.1622,460.28
89158.02121.6636.3622,423.92
90158.02121.4636.5622,387.36
91158.02121.2636.7622,350.6
92158.02121.0736.9522,313.65
93158.02120.8737.1522,276.5
94158.02120.6637.3622,239.14
95158.02120.4637.5622,201.58
96158.02120.2637.7622,163.82
97158.02120.0537.9722,125.85
98158.02119.8538.1722,087.68
99158.02119.6438.3822,049.3
100158.02119.4338.5922,010.71
101158.02119.2238.821,971.91
102158.02119.0139.0121,932.9
103158.02118.839.2221,893.68
104158.02118.5939.4321,854.25
105158.02118.3839.6421,814.61
106158.02118.1639.8621,774.75
107158.02117.9540.0721,734.68
108158.02117.7340.2921,694.39
109158.02117.5140.5121,653.88
110158.02117.2940.7321,613.15
111158.02117.0740.9521,572.2
112158.02116.8541.1721,531.03
113158.02116.6341.3921,489.64
114158.02116.441.6221,448.02
115158.02116.1841.8421,406.18
116158.02115.9542.0721,364.11
117158.02115.7242.321,321.81
118158.02115.4942.5321,279.28
119158.02115.2642.7621,236.52
120158.02115.0342.9921,193.53

First 120 of 360 rows.

Yearly summarytable
yearinterestprincipalendingBalance
11,616.77279.4724,720.53
21,598.05298.1924,422.34
31,578.1318.1424,104.2
41,556.78339.4623,764.74
51,534.06362.1823,402.56
61,509.77386.4723,016.09
71,483.92412.3222,603.77
81,456.29439.9522,163.82
91,426.81469.4321,694.39
101,395.38500.8621,193.53
111,361.82534.4220,659.11
121,326.05570.1920,088.92
131,287.85608.3919,480.53
141,247.13649.1118,831.42
151,203.64692.618,138.82
161,157.26738.9817,399.84
171,107.77788.4716,611.37
181,054.98841.2615,770.11
19998.63897.6114,872.5
20938.52957.7213,914.78
21874.361,021.8812,892.9
22805.941,090.311,802.6
23732.911,163.3310,639.27
24655.021,241.229,398.05
25571.91,324.348,073.71
26483.21,413.046,660.67
27388.551,507.695,152.98
28287.61,608.643,544.34
29179.861,716.381,827.96
3064.891,827.960

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