Loan Repayment Month Calculator

Formatting only. This does not change the calculation.
The nominal annual rate (APR before fees), not the monthly rate.
The instalment you can afford or have been quoted. Used only when solving for the rate, the term or the loan amount.
Months to repay
59
Loan Payment Calculator
Payment
500.00
Total interest
4,234.87
Total of payments
29,234.87
Number of payments
59
Payoff time
4.917 years
Rate per period
0.541667 %
Interest per unit borrowed
0.1694
Interest saved by extra payments
0
Payments saved
0
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. Solving 25000 = 500 x (1 - (1+i)^-n) / i for n gives n = 58.469, so 59 payments are needed.
  2. Rate per period = 6.5% / 12 = 0.541667%
  3. Payment = P i / (1 - (1+i)^-n) = 500
  4. Over 59 payments the total paid is 29234.87, of which 4234.87 is interest.
Amortisation scheduletable
periodpaymentinterestprincipalbalance
1500135.42364.5824,635.42
2500133.44366.5624,268.86
3500131.46368.5423,900.32
4500129.46370.5423,529.78
5500127.45372.5523,157.23
6500125.43374.5722,782.66
7500123.41376.5922,406.07
8500121.37378.6322,027.44
9500119.32380.6821,646.76
10500117.25382.7521,264.01
11500115.18384.8220,879.19
12500113.1386.920,492.29
1350011138920,103.29
14500108.89391.1119,712.18
15500106.77393.2319,318.95
16500104.64395.3618,923.59
17500102.5397.518,526.09
18500100.35399.6518,126.44
1950098.18401.8217,724.62
2050096.01403.9917,320.63
2150093.82406.1816,914.45
2250091.62408.3816,506.07
2350089.41410.5916,095.48
2450087.18412.8215,682.66
2550084.95415.0515,267.61
2650082.7417.314,850.31
2750080.44419.5614,430.75
2850078.17421.8314,008.92
2950075.88424.1213,584.8
3050073.58426.4213,158.38
3150071.27428.7312,729.65
3250068.95431.0512,298.6
3350066.62433.3811,865.22
3450064.27435.7311,429.49
3550061.91438.0910,991.4
3650059.54440.4610,550.94
3750057.15442.8510,108.09
3850054.75445.259,662.84
3950052.34447.669,215.18
4050049.92450.088,765.1
4150047.48452.528,312.58
4250045.03454.977,857.61
4350042.56457.447,400.17
4450040.08459.926,940.25
4550037.59462.416,477.84
4650035.09464.916,012.93
4750032.57467.435,545.5
4850030.04469.965,075.54
4950027.49472.514,603.03
5050024.93475.074,127.96
5150022.36477.643,650.32
5250019.77480.233,170.09
5350017.17482.832,687.26
5450014.56485.442,201.82
5550011.93488.071,713.75
565009.28490.721,223.03
575006.62493.38729.65
585003.95496.05233.6
59234.871.27233.60
Yearly summarytable
yearinterestprincipalendingBalance
11,492.294,507.7120,492.29
21,190.374,809.6315,682.66
3868.285,131.7210,550.94
4524.65,475.45,075.54
5159.335,075.540

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