Debtors DP Allocation=Eligible Debtors (Within Age Limit)×(100%−Debtors Margin %)Debtors DP Allocation equals Eligible Debtors (Within Age Limit) cross open paren 100 % minus Debtors Margin % close paren
(Note: Canara Bank typically applies a 25% margin on stock, meaning you get 75% DP).
A standard Canara Bank stock statement Excel template is divided into five core sections. Understanding these fields helps you fill out the sheet accurately. 1. Header Information Name of the Borrower / Business Entity Credit Facility Account Number Statement Date (usually the last day of the previous month) Name of the Branch 2. Stock and Inventory Details
1 | Steel Rods | MT | 10 | 50,000 | 5,00,000 | Own | Warehouse A | - 2 | Cement Bags | Bags| 500 | 400 | 2,00,000 | Consignment| Site B | New stock canara bank stock statement form nf 902 excel format
: Details of unpaid dues to suppliers, which must be deducted to find the net paid stock.
| Sr. No. | Particulars | Opening Balance | Stock "In" | Stock "Out" | Closing Stock | | :--- | :--- | :--- | :--- | :--- | :--- | | a. | Raw Materials & Consumable Store | | | | | | b. | Stock in Process | | | | 18,71,500 | | | | 18,33,252 | 18,31,572 | 18,69,820 | |
. While the bank primarily distributes this in PDF format, many businesses recreate it in to automate calculations for Drawing Power (DP). US Legal Forms Purpose and Importance Drawing Power Calculation 5. Drawing Power (DP) Calculation Matrix
No. Traders, distributors, and even service providers holding consumable inventory for working capital loans from Canara Bank must file Form NF 902.
The Canara Bank Stock Statement Form NF 902 is more than just a compliance formality; it is a snapshot of your business health. By migrating this process to a structured , you not only save time but also gain better visibility into your working capital cycle. Whether you download a template or build your own, ensuring the formulas correctly reflect the bank's margin requirements is key to maintaining a healthy relationship with your banker.
(Note: This is a formatted template. Please verify the format with your local branch manager, as regional variations sometimes exist. If the link is not active, you can create your own in Excel by replicating the headers: Date, Particulars of Stock, Quantity, Value, Receivables, Total Value, Margin %, and Drawing Power.) Particulars of Stock
Outline the for uploading this data to Canara Bank's corporate net banking portal.
This figure is deducted from your gross stock value to ensure the bank does not finance inventory that you have not yet paid for. 5. Drawing Power (DP) Calculation Matrix