Spreadsheet: 183180d1348736756-data-validation-offset-formula-lc-report-draft
Sheet: Summary

 | Schedule of Facilities from BSI
Description | Credit Limit | Sub Limit | Used | Balance |  |  |  | Schedule Of Facilities Bank Sedarat Iran (BSI)
 |  |  |  |  |  |  |  | Discription | Credit Limit | Sub Limit | Used | Balance
Cheque Discounting | 2200000
Total Limit | 2200000 |  | 2199806 |  |  |  |  | Cheque Discounting | 2200000 | 2200000
 | Schedule of Facilities from NBF
Description | Credit Limit | Sub Limit | sublimit | Used | Balance |  |  | Schedule Of Facilities National Bank OF Fujariah (NBF)
L/C (Import /Sight) | 5500000 |  |  |  |  |  |  | Discription | Credit Limit | Sub Limit | Used | Balance
L/C (Import /sight) |  | 4000000 |  | 0 |  |  |  | LC | 5500000
L/C (Import /Usance) |  |  |  |  |  |  |  | Import/Sight |  | 4000000
L/C (Local-Sight /Usance) |  | 2000000 |  | 510000 |  |  |  | Import/Usance |  | 2000000
Trust Receipt Loans (Sub Limit of L/C) | 4500000
Cash Advance |  |  | 800000 |  |  |  |  | TR | 4500000
Direct Import |  |  | 500000 | 0 |  |  |  | Cash Advance |  | 800000
Local Delivery |  |  | 1000000 |  |  |  |  | Direct Import |  | 500000
TR loan against LC |  |  | 4500000 |  |  |  |  | Local Dilivery |  | 1000000
TR-Acceptance |  |  | 4000000 |  |  |  |  | TR Loan Against LC |  | 4500000
TR-Collections |  |  | 4500000 |  |  |  |  | TR Acceptance |  | 4500000
TR-Past Dues |  |  |  |  |  |  |  | TR-Collection |  | 4500000
Past dues items-PDPD |  |  |  |  |  |  |  | TR-Past Dues
 |  |  |  |  |  |  |  | Past Dues Items-PDPD
Check Discounting | 1750000 |  |  | 0 |  |  |  | Check Discounting
Total Limit | 5500000
 |  |  |  |  |  |  |  | Total
 | Schedule of Facilities from Barclays
Description | Credit Limit | Sub Limit |  | Used | Balance |  |  | Schedule Of Facilities Abu Dhabi Commercial Bank (ADCB)
Total Facility | 7000000 |  | sublimit |  |  |  |  | Discription | Credit Limit | Sub Limit | Used | Balance
L/C Usance/Acceptance |  | 5000000 | 500000 |  |  |  |  | LC | 4000000
Trust receipt Loans (Sub Limit of T/R) |  |  | 4500000 |  |  |  |  | Import/Sight |  | 4000000
Check discounting |  | 2000000 |  | 1999151 |  |  |  | Import/Usance |  | 4000000
 |  |  |  |  |  |  |  | Local/Sight |  | 4000000
Total Limit |  |  |  |  |  |  |  | Local/Usance |  | 4000000
 |  |  |  |  |  |  |  | TR | 3000000
 | Schedule of Facilities from ADCB |  |  |  |  |  |  | Local/Collection |  | 3000000
Description | Credit Limit | Sub Limit | Used | Balance |  |  |  | CAD |  | 3000000
 |  |  |  |  |  |  |  | TR-CAD |  | 3000000
LC (WAKALA/MURABAHA) |  | 4000000 |  |  |  |  |  | TR |  | 3000000
LOCAL/SIGHT |  |  | 0
LOCAL/USANCE |  |  | 816000
FOREIGN-SIGHT |  |  | 0
FOREIGN-USNACE |  |  | 31736.38 |  |  |  |  | Total
TR
LOCAL/COLLECTION |  | 3000000
CAD |  |  | 0
TR CAD
TR |  |  | 411460.58
Total Limit | 4000000
 | Schedule of Facilities from HSBC
Description | Credit Limit | Sub Limit | Used | Balance
LC/TR (Local) |  | 2500000
LC/TR (Import) |  | 1000000
LC USANCE
Total Limit | 3500000
 | Schedule of Facilities from UAB
Description | Credit Limit | Sub Limit | Used | Balance
LC Sight/Acceptances |  | 3000000 | 213528.87
TR |  | 2000000
EX LOCAL TR |  | 3000000
EX LOCAL TR |  | 1000000
local LC |  | 1000000
Meduim Term Loan (Mechinery) |  | 9000000 | 9000000
DISCOUNTING |  | 1000000 | 999290
Total Limit | 3000000
 | Schedule of Facilities from ENBD
Description | Credit Limit | Sub Limit | Used | Balance
LC Sight/Acceptances |  | 4000000 | 0
IMPORT LC USANCE |  | 4000000 | 0
local LC USANCE |  | 4000000
TR UNDER LC |  | 1000000
TR COLLECTION |  | 2000000 | 1995565
DISCOUNTING |  | 1000000 | 0
Total Limit | 4000000