Bank Loan Schedule & Ledger Calculation
Loan Schdule- Prime Finance & Investment Ltd.
Total Loan Ammount
Tenor
Rate of Interest (annually)
Rate of Interest (monthly)
Number of Inatallment
Date
27/01/2019
27/02/2019
27/03/2019
27/04/2019
27/05/2019
27/06/2019
27/07/2019
27/08/2019
27/09/2019
27/10/2019
27/11/2019
27/12/2019
27/01/2020
27/02/2020
27/03/2020
27/04/2020
27/05/2020
27/06/2020
27/07/2020
27/08/2020
27/09/2020
27/10/2020
27/11/2020
27/12/2020
27/01/2021
27/02/2021
27/03/2021
27/04/2021
27/05/2021
27/06/2021
No of Installment-
Tk.
Opening Balance
Installment
Amount to be paid
64,157,-,157,-,157,-,157,-,378,-,590,-,792,-,984,-,165,-,337,-,498,-,649,-,789,-,918,-,037,-,144,-,241,-,326,-,399,-,461,-,512,-,550,-,576,-,591,-,592,-,582,-,559,-,523,-,474,-,412,156.672
801,-,-,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,495.841
Interest Rate-
Interest to be
Paid
801,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,151.958
64,157,-%-
Principal Paid
778,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,010,-,023,-,036,-,048,-,062,-,075,343.883
57
Closing Balance
64,157,-,157,-,157,-,378,-,590,-,792,-,984,-,165,-,337,-,498,-,649,-,789,-,918,-,037,-,144,-,241,-,326,-,399,-,461,-,512,-,550,-,576,-,591,-,592,-,582,-,559,-,523,-,474,-,412,-,336,812.789
27/07/2021
27/08/2021
27/09/2021
27/10/2021
27/11/2021
27/12/2021
27/01/2022
27/02/2022
27/03/2022
27/04/2022
27/05/2022
27/06/2022
27/07/2022
27/08/2022
27/09/2022
27/10/2022
27/11/2022
27/12/2022
27/01/2023
27/02/2023
27/03/2023
27/04/2023
27/05/2023
27/06/2023
27/07/2023
27/08/2023
27/09/2023
27/10/2023
27/11/2023
27/12/2023
-
39,336,-,248,-,145,-,029,-,899,-,755,-,596,-,423,-,235,-,033,-,815,-,582,-,334,-,070,-,791,-,495,-,183,-,855,-,510,-,149,-,770,-,374,-,961,-,530,-,081,-,614,-,129,-,625,-,102,-,560,983.547
1,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,580,-,494,154.085
-
491,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,512.294
1,088,-,102,-,116,-,130,-,144,-,158,-,173,-,187,-,202,-,217,-,232,-,248,-,263,-,279,-,295,-,311,-,328,-,344,-,361,-,378,-,395,-,413,-,430,-,448,-,466,-,485,-,503,-,522,-,541,-,560,983.547
38,248,-,145,-,029,-,899,-,755,-,596,-,423,-,235,-,033,-,815,-,582,-,334,-,070,-,791,-,495,-,183,-,855,-,510,-,149,-,770,-,374,-,961,-,530,-,081,-,614,-,129,-,625,-,102,-,560,983.547
(0.000)
Ledger
Prime Finance & Investment Ltd
Financial Year : 2019 - 2020
Opening Balance-
1
65,028,-,028,-,041,-,207,-,422,-,228,-,463,-,468,-,224,-,990,-,764,-,956,-,730,995.036
Installment to be
paid
2
1,642,-,663,-,685,-,712,-,692,-,737,-,741,-,657,-,703,-,752,-,773,-,808,-,862,-,791,485.578
Acual paid
Difference
Interest Rate
3
4 = 2-3
5
400,-,-,-,600,-,580,-,800,000.000
1,000,-,496.000
11,007,949.000
1,242,-,-,038,-,-,692,-,905.606
(3,058,-,657,-,703,-,-,193,-,808,-,862,-,783,536.578
-
Interest to be
paid
6=1*5
812,-,-,-,-,-,-,-,-,-,-,-,-,-,494,117.474
Ledger Bal
Difference
Principal Paid
Closing Balance
7=2-6-4
8
(412,862.050)
(12,862.050)
(166,-,901.352
(805,-,-,994,210.808
(755,861.557)
(765,-,123.801
(191,566.152)
(774,456.729)
(784,-,513,831.526
65,028,-,028,-,041,-,207,-,422,-,228,-,463,-,468,-,224,-,990,-,764,-,956,-,730,-,515,-,516,033.000
(900.526)
Jan-19
Feb-19
Mar-19
Apr-19
May-19
June'19
July'19
August'19
September'19
October'19
November'19
December'19
January'20
February'20
March'20
April'20
May '20
June'20