Loan Net 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.
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.
Net amount advanced
25,000.00
Loan Payment Calculator
Payment
158.02
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
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.