Starting PeriodEnding Period
Loan (PV) N (Instalments) N/PA (I)nterest PMT (Payments) FV (Residual)
15000.00 36 12 15.0000099436118 519.98 0.00
Starting Period 1 Ending Period 36
Loan at Start 15000.00 Value of loan at end 0.00
Principal reduction 15000.00 Total Payments 18719.28
Interest expense 3719.28 Clearance ratio 2.773225
Interest Rate=15.0000099436118, Number of Payments per year = 12
InsBalance BeginInterestPaymentBalance End
1 (Yr 1)15000.00187.50519.9814667.52
2 14667.52183.34519.9814330.88
3 14330.88179.14519.9813990.04
4 13990.04174.88519.9813644.94
5 13644.94170.56519.9813295.52
6 13295.52166.19519.9812941.73
7 12941.73161.77519.9812583.52
8 12583.52157.29519.9812220.84
9 12220.84152.76519.9811853.62
10 11853.62148.17519.9811481.81
11 11481.81143.52519.9811105.35
12 11105.35138.82519.9810724.19
13 (Yr 2)10724.19134.05519.9810338.26
14 10338.26129.23519.989947.51
15 9947.51124.34519.989551.87
16 9551.87119.40519.989151.29
17 9151.29114.39519.988745.70
18 8745.70109.32519.988335.04
19 8335.04104.19519.987919.25
20 7919.2598.99519.987498.26
21 7498.2693.73519.987072.01
22 7072.0188.40519.986640.43
23 6640.4383.01519.986203.46
24 6203.4677.54519.985761.02
25 (Yr 3)5761.0272.01519.985313.05
26 5313.0566.41519.984859.49
27 4859.4960.74519.984400.25
28 4400.2555.00519.983935.27
29 3935.2749.19519.983464.48
30 3464.4843.31519.982987.81
31 2987.8137.35519.982505.18
32 2505.1831.31519.982016.51
33 2016.5125.21519.981521.74
34 1521.7419.02519.981020.78
35 1020.7812.76519.98513.56
36 513.566.42519.980.00