ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
Enter values Loan summary
5
 Loan amount ₦ 7,000,000.00 Scheduled payment ₦ 77,714.35
6
 Annual interest rate 0.06
Scheduled number of payments
120.00
7
 Loan period in years 10.00
Actual number of payments
120.00
8
Number of payments per year
12.00 Total early payments ₦ -
9
 Start date of loan 1/8/2024 Total interest ₦ 2,325,722.16
10
 Optional extra payments
11
12
Lender name:
13
14
15
16
Pmt. No.Payment Date Beginning Balance Scheduled Payment Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest
17
18
12/8/2024 ₦ 7,000,000.00 ₦ 77,714.35 ₦ 77,714.35 ₦ 42,714.35 ₦ 35,000.00 ₦ 6,957,285.65 ₦ 35,000.00
19
23/8/2024 ₦ 6,957,285.65 ₦ 77,714.35 ₦ 77,714.35 ₦ 42,927.92 ₦ 34,786.43 ₦ 6,914,357.73 ₦ 69,786.43
20
34/8/2024 ₦ 6,914,357.73 ₦ 77,714.35 ₦ 77,714.35 ₦ 43,142.56 ₦ 34,571.79 ₦ 6,871,215.16 ₦ 104,358.22
21
45/8/2024 ₦ 6,871,215.16 ₦ 77,714.35 ₦ 77,714.35 ₦ 43,358.28 ₦ 34,356.08 ₦ 6,827,856.89 ₦ 138,714.29 1250000
22
56/8/2024 ₦ 6,827,856.89 ₦ 77,714.35 ₦ 77,714.35 ₦ 43,575.07 ₦ 34,139.28 ₦ 6,784,281.82 ₦ 172,853.58 5750000
23
67/8/2024 ₦ 6,784,281.82 ₦ 77,714.35 ₦ 77,714.35 ₦ 43,792.94 ₦ 33,921.41 ₦ 6,740,488.88 ₦ 206,774.99
24
78/8/2024 ₦ 6,740,488.88 ₦ 77,714.35 ₦ 77,714.35 ₦ 44,011.91 ₦ 33,702.44 ₦ 6,696,476.97 ₦ 240,477.43 233143.0541
25
89/8/2024 ₦ 6,696,476.97 ₦ 77,714.35 ₦ 77,714.35 ₦ 44,231.97 ₦ 33,482.38 ₦ 6,652,245.00 ₦ 273,959.82
26
910/8/2024 ₦ 6,652,245.00 ₦ 77,714.35 ₦ 77,714.35 ₦ 44,453.13 ₦ 33,261.23 ₦ 6,607,791.88 ₦ 307,221.04
27
1011/8/2024 ₦ 6,607,791.88 ₦ 77,714.35 ₦ 77,714.35 ₦ 44,675.39 ₦ 33,038.96 ₦ 6,563,116.49 ₦ 340,260.00
28
1112/8/2024 ₦ 6,563,116.49 ₦ 77,714.35 ₦ 77,714.35 ₦ 44,898.77 ₦ 32,815.58 ₦ 6,518,217.72 ₦ 373,075.58
29
121/8/2025 ₦ 6,518,217.72 ₦ 77,714.35 ₦ 77,714.35 ₦ 45,123.26 ₦ 32,591.09 ₦ 6,473,094.45 ₦ 405,666.67
30
132/8/2025 ₦ 6,473,094.45 ₦ 77,714.35 ₦ 77,714.35 ₦ 45,348.88 ₦ 32,365.47 ₦ 6,427,745.58 ₦ 438,032.14
31
143/8/2025 ₦ 6,427,745.58 ₦ 77,714.35 ₦ 77,714.35 ₦ 45,575.62 ₦ 32,138.73 ₦ 6,382,169.95 ₦ 470,170.87
32
154/8/2025 ₦ 6,382,169.95 ₦ 77,714.35 ₦ 77,714.35 ₦ 45,803.50 ₦ 31,910.85 ₦ 6,336,366.45 ₦ 502,081.72
33
165/8/2025 ₦ 6,336,366.45 ₦ 77,714.35 ₦ 77,714.35 ₦ 46,032.52 ₦ 31,681.83 ₦ 6,290,333.93 ₦ 533,763.55
34
176/8/2025 ₦ 6,290,333.93 ₦ 77,714.35 ₦ 77,714.35 ₦ 46,262.68 ₦ 31,451.67 ₦ 6,244,071.25 ₦ 565,215.22
35
187/8/2025 ₦ 6,244,071.25 ₦ 77,714.35 ₦ 77,714.35 ₦ 46,494.00 ₦ 31,220.36 ₦ 6,197,577.25 ₦ 596,435.58
36
198/8/2025 ₦ 6,197,577.25 ₦ 77,714.35 ₦ 77,714.35 ₦ 46,726.47 ₦ 30,987.89 ₦ 6,150,850.79 ₦ 627,423.47
37
209/8/2025 ₦ 6,150,850.79 ₦ 77,714.35 ₦ 77,714.35 ₦ 46,960.10 ₦ 30,754.25 ₦ 6,103,890.69 ₦ 658,177.72
38
2110/8/2025 ₦ 6,103,890.69 ₦ 77,714.35 ₦ 77,714.35 ₦ 47,194.90 ₦ 30,519.45 ₦ 6,056,695.79 ₦ 688,697.17
39
2211/8/2025 ₦ 6,056,695.79 ₦ 77,714.35 ₦ 77,714.35 ₦ 47,430.87 ₦ 30,283.48 ₦ 6,009,264.92 ₦ 718,980.65
40
2312/8/2025 ₦ 6,009,264.92 ₦ 77,714.35 ₦ 77,714.35 ₦ 47,668.03 ₦ 30,046.32 ₦ 5,961,596.89 ₦ 749,026.98
41
241/8/2026 ₦ 5,961,596.89 ₦ 77,714.35 ₦ 77,714.35 ₦ 47,906.37 ₦ 29,807.98 ₦ 5,913,690.53 ₦ 778,834.96
42
252/8/2026 ₦ 5,913,690.53 ₦ 77,714.35 ₦ 77,714.35 ₦ 48,145.90 ₦ 29,568.45 ₦ 5,865,544.63 ₦ 808,403.41
43
263/8/2026 ₦ 5,865,544.63 ₦ 77,714.35 ₦ 77,714.35 ₦ 48,386.63 ₦ 29,327.72 ₦ 5,817,158.00 ₦ 837,731.14
44
274/8/2026 ₦ 5,817,158.00 ₦ 77,714.35 ₦ 77,714.35 ₦ 48,628.56 ₦ 29,085.79 ₦ 5,768,529.44 ₦ 866,816.93
45
285/8/2026 ₦ 5,768,529.44 ₦ 77,714.35 ₦ 77,714.35 ₦ 48,871.70 ₦ 28,842.65 ₦ 5,719,657.74 ₦ 895,659.57
46
296/8/2026 ₦ 5,719,657.74 ₦ 77,714.35 ₦ 77,714.35 ₦ 49,116.06 ₦ 28,598.29 ₦ 5,670,541.67 ₦ 924,257.86
47
307/8/2026 ₦ 5,670,541.67 ₦ 77,714.35 ₦ 77,714.35 ₦ 49,361.64 ₦ 28,352.71 ₦ 5,621,180.03 ₦ 952,610.57
48
318/8/2026 ₦ 5,621,180.03 ₦ 77,714.35 ₦ 77,714.35 ₦ 49,608.45 ₦ 28,105.90 ₦ 5,571,571.58 ₦ 980,716.47
49
329/8/2026 ₦ 5,571,571.58 ₦ 77,714.35 ₦ 77,714.35 ₦ 49,856.49 ₦ 27,857.86 ₦ 5,521,715.09 ₦ 1,008,574.33
50
3310/8/2026 ₦ 5,521,715.09 ₦ 77,714.35 ₦ 77,714.35 ₦ 50,105.78 ₦ 27,608.58 ₦ 5,471,609.31 ₦ 1,036,182.90
51
3411/8/2026 ₦ 5,471,609.31 ₦ 77,714.35 ₦ 77,714.35 ₦ 50,356.30 ₦ 27,358.05 ₦ 5,421,253.00 ₦ 1,063,540.95
52
3512/8/2026 ₦ 5,421,253.00 ₦ 77,714.35 ₦ 77,714.35 ₦ 50,608.09 ₦ 27,106.27 ₦ 5,370,644.92 ₦ 1,090,647.22
53
361/8/2027 ₦ 5,370,644.92 ₦ 77,714.35 ₦ 77,714.35 ₦ 50,861.13 ₦ 26,853.22 ₦ 5,319,783.79 ₦ 1,117,500.44
54
372/8/2027 ₦ 5,319,783.79 ₦ 77,714.35 ₦ 77,714.35 ₦ 51,115.43 ₦ 26,598.92 ₦ 5,268,668.36 ₦ 1,144,099.36
55
383/8/2027 ₦ 5,268,668.36 ₦ 77,714.35 ₦ 77,714.35 ₦ 51,371.01 ₦ 26,343.34 ₦ 5,217,297.35 ₦ 1,170,442.70
56
394/8/2027 ₦ 5,217,297.35 ₦ 77,714.35 ₦ 77,714.35 ₦ 51,627.86 ₦ 26,086.49 ₦ 5,165,669.48 ₦ 1,196,529.19
57
405/8/2027 ₦ 5,165,669.48 ₦ 77,714.35 ₦ 77,714.35 ₦ 51,886.00 ₦ 25,828.35 ₦ 5,113,783.48 ₦ 1,222,357.54
58
416/8/2027 ₦ 5,113,783.48 ₦ 77,714.35 ₦ 77,714.35 ₦ 52,145.43 ₦ 25,568.92 ₦ 5,061,638.05 ₦ 1,247,926.45
59
427/8/2027 ₦ 5,061,638.05 ₦ 77,714.35 ₦ 77,714.35 ₦ 52,406.16 ₦ 25,308.19 ₦ 5,009,231.89 ₦ 1,273,234.64
60
438/8/2027 ₦ 5,009,231.89 ₦ 77,714.35 ₦ 77,714.35 ₦ 52,668.19 ₦ 25,046.16 ₦ 4,956,563.69 ₦ 1,298,280.80
61
449/8/2027 ₦ 4,956,563.69 ₦ 77,714.35 ₦ 77,714.35 ₦ 52,931.53 ₦ 24,782.82 ₦ 4,903,632.16 ₦ 1,323,063.62
62
4510/8/2027 ₦ 4,903,632.16 ₦ 77,714.35 ₦ 77,714.35 ₦ 53,196.19 ₦ 24,518.16 ₦ 4,850,435.97 ₦ 1,347,581.78
63
4611/8/2027 ₦ 4,850,435.97 ₦ 77,714.35 ₦ 77,714.35 ₦ 53,462.17 ₦ 24,252.18 ₦ 4,796,973.80 ₦ 1,371,833.96
64
4712/8/2027 ₦ 4,796,973.80 ₦ 77,714.35 ₦ 77,714.35 ₦ 53,729.48 ₦ 23,984.87 ₦ 4,743,244.32 ₦ 1,395,818.83
65
481/8/2028 ₦ 4,743,244.32 ₦ 77,714.35 ₦ 77,714.35 ₦ 53,998.13 ₦ 23,716.22 ₦ 4,689,246.19 ₦ 1,419,535.05
66
492/8/2028 ₦ 4,689,246.19 ₦ 77,714.35 ₦ 77,714.35 ₦ 54,268.12 ₦ 23,446.23 ₦ 4,634,978.07 ₦ 1,442,981.28
67
503/8/2028 ₦ 4,634,978.07 ₦ 77,714.35 ₦ 77,714.35 ₦ 54,539.46 ₦ 23,174.89 ₦ 4,580,438.61 ₦ 1,466,156.17
68
514/8/2028 ₦ 4,580,438.61 ₦ 77,714.35 ₦ 77,714.35 ₦ 54,812.16 ₦ 22,902.19 ₦ 4,525,626.45 ₦ 1,489,058.37
69
525/8/2028 ₦ 4,525,626.45 ₦ 77,714.35 ₦ 77,714.35 ₦ 55,086.22 ₦ 22,628.13 ₦ 4,470,540.23 ₦ 1,511,686.50
70
536/8/2028 ₦ 4,470,540.23 ₦ 77,714.35 ₦ 77,714.35 ₦ 55,361.65 ₦ 22,352.70 ₦ 4,415,178.58 ₦ 1,534,039.20
71
547/8/2028 ₦ 4,415,178.58 ₦ 77,714.35 ₦ 77,714.35 ₦ 55,638.46 ₦ 22,075.89 ₦ 4,359,540.12 ₦ 1,556,115.09
72
558/8/2028 ₦ 4,359,540.12 ₦ 77,714.35 ₦ 77,714.35 ₦ 55,916.65 ₦ 21,797.70 ₦ 4,303,623.47 ₦ 1,577,912.79
73
569/8/2028 ₦ 4,303,623.47 ₦ 77,714.35 ₦ 77,714.35 ₦ 56,196.23 ₦ 21,518.12 ₦ 4,247,427.23 ₦ 1,599,430.91
74
5710/8/2028 ₦ 4,247,427.23 ₦ 77,714.35 ₦ 77,714.35 ₦ 56,477.22 ₦ 21,237.14 ₦ 4,190,950.02 ₦ 1,620,668.05
75
5811/8/2028 ₦ 4,190,950.02 ₦ 77,714.35 ₦ 77,714.35 ₦ 56,759.60 ₦ 20,954.75 ₦ 4,134,190.42 ₦ 1,641,622.80
76
5912/8/2028 ₦ 4,134,190.42 ₦ 77,714.35 ₦ 77,714.35 ₦ 57,043.40 ₦ 20,670.95 ₦ 4,077,147.02 ₦ 1,662,293.75
77
601/8/2029 ₦ 4,077,147.02 ₦ 77,714.35 ₦ 77,714.35 ₦ 57,328.62 ₦ 20,385.74 ₦ 4,019,818.40 ₦ 1,682,679.48
78
612/8/2029 ₦ 4,019,818.40 ₦ 77,714.35 ₦ 77,714.35 ₦ 57,615.26 ₦ 20,099.09 ₦ 3,962,203.14 ₦ 1,702,778.58
79
623/8/2029 ₦ 3,962,203.14 ₦ 77,714.35 ₦ 77,714.35 ₦ 57,903.34 ₦ 19,811.02 ₦ 3,904,299.81 ₦ 1,722,589.59
80
634/8/2029 ₦ 3,904,299.81 ₦ 77,714.35 ₦ 77,714.35 ₦ 58,192.85 ₦ 19,521.50 ₦ 3,846,106.96 ₦ 1,742,111.09
81
645/8/2029 ₦ 3,846,106.96 ₦ 77,714.35 ₦ 77,714.35 ₦ 58,483.82 ₦ 19,230.53 ₦ 3,787,623.14 ₦ 1,761,341.63
82
656/8/2029 ₦ 3,787,623.14 ₦ 77,714.35 ₦ 77,714.35 ₦ 58,776.24 ₦ 18,938.12 ₦ 3,728,846.90 ₦ 1,780,279.74
83
667/8/2029 ₦ 3,728,846.90 ₦ 77,714.35 ₦ 77,714.35 ₦ 59,070.12 ₦ 18,644.23 ₦ 3,669,776.79 ₦ 1,798,923.98
84
678/8/2029 ₦ 3,669,776.79 ₦ 77,714.35 ₦ 77,714.35 ₦ 59,365.47 ₦ 18,348.88 ₦ 3,610,411.32 ₦ 1,817,272.86
85
689/8/2029 ₦ 3,610,411.32 ₦ 77,714.35 ₦ 77,714.35 ₦ 59,662.29 ₦ 18,052.06 ₦ 3,550,749.02 ₦ 1,835,324.92
86
6910/8/2029 ₦ 3,550,749.02 ₦ 77,714.35 ₦ 77,714.35 ₦ 59,960.61 ₦ 17,753.75 ₦ 3,490,788.42 ₦ 1,853,078.66
87
7011/8/2029 ₦ 3,490,788.42 ₦ 77,714.35 ₦ 77,714.35 ₦ 60,260.41 ₦ 17,453.94 ₦ 3,430,528.01 ₦ 1,870,532.60
88
7112/8/2029 ₦ 3,430,528.01 ₦ 77,714.35 ₦ 77,714.35 ₦ 60,561.71 ₦ 17,152.64 ₦ 3,369,966.30 ₦ 1,887,685.24
89
721/8/2030 ₦ 3,369,966.30 ₦ 77,714.35 ₦ 77,714.35 ₦ 60,864.52 ₦ 16,849.83 ₦ 3,309,101.78 ₦ 1,904,535.08
90
732/8/2030 ₦ 3,309,101.78 ₦ 77,714.35 ₦ 77,714.35 ₦ 61,168.84 ₦ 16,545.51 ₦ 3,247,932.93 ₦ 1,921,080.58
91
743/8/2030 ₦ 3,247,932.93 ₦ 77,714.35 ₦ 77,714.35 ₦ 61,474.69 ₦ 16,239.66 ₦ 3,186,458.25 ₦ 1,937,320.25
92
754/8/2030 ₦ 3,186,458.25 ₦ 77,714.35 ₦ 77,714.35 ₦ 61,782.06 ₦ 15,932.29 ₦ 3,124,676.19 ₦ 1,953,252.54
93
765/8/2030 ₦ 3,124,676.19 ₦ 77,714.35 ₦ 77,714.35 ₦ 62,090.97 ₦ 15,623.38 ₦ 3,062,585.22 ₦ 1,968,875.92
94
776/8/2030 ₦ 3,062,585.22 ₦ 77,714.35 ₦ 77,714.35 ₦ 62,401.43 ₦ 15,312.93 ₦ 3,000,183.79 ₦ 1,984,188.85
95
787/8/2030 ₦ 3,000,183.79 ₦ 77,714.35 ₦ 77,714.35 ₦ 62,713.43 ₦ 15,000.92 ₦ 2,937,470.36 ₦ 1,999,189.77
96
798/8/2030 ₦ 2,937,470.36 ₦ 77,714.35 ₦ 77,714.35 ₦ 63,027.00 ₦ 14,687.35 ₦ 2,874,443.36 ₦ 2,013,877.12
97
809/8/2030 ₦ 2,874,443.36 ₦ 77,714.35 ₦ 77,714.35 ₦ 63,342.13 ₦ 14,372.22 ₦ 2,811,101.23 ₦ 2,028,249.33
98
8110/8/2030 ₦ 2,811,101.23 ₦ 77,714.35 ₦ 77,714.35 ₦ 63,658.85 ₦ 14,055.51 ₦ 2,747,442.38 ₦ 2,042,304.84
99
8211/8/2030 ₦ 2,747,442.38 ₦ 77,714.35 ₦ 77,714.35 ₦ 63,977.14 ₦ 13,737.21 ₦ 2,683,465.24 ₦ 2,056,042.05
100
8312/8/2030 ₦ 2,683,465.24 ₦ 77,714.35 ₦ 77,714.35 ₦ 64,297.03 ₦ 13,417.33 ₦ 2,619,168.22 ₦ 2,069,459.38