Total Computed DP=Stock DP Allocation+Debtors DP AllocationTotal Computed DP equals Stock DP Allocation plus Debtors DP Allocation

: Total value of eligible stock minus the prescribed margin (e.g., 25%) to determine the net drawing limit. Downloading & Preparation

Located at the top of the form, this section sets the context for the bank officials: Name of the Borrower / Business Unit Cash Credit (CC) / Overdraft (OD) Account Number

Apply the bank's specific margin percentages to determine your Drawing Power. Understanding Drawing Power (DP) and Bank Margins

This is the most critical operational component of the Excel sheet. It applies the bank's approved margins to your net stock and eligible debtors. Designing the Drawing Power Formula in Excel

: The stock value reported must be fully covered by an active bank-hypothecated insurance policy. Ensure your policy expiry date and covered value are noted on the form.

Note: Your final Drawing Power is always capped at your maximum Sanctioned Limit. Step-by-Step Guide to Creating the Excel Formulas

form is more than just paperwork; it’s the key to maintaining your liquidity. US Legal Forms What exactly is the NF 902? The NF 902 is an OCC Stock Statement cum MSOD

Corporate borrowers may have access to Canara Bank’s digital platforms (e.g., – Canara Bank Digital Interface). Under "Trade Finance" or "Stock Statement Upload," you can often download a pre-formatted Excel template.

Ultimate Guide to Canara Bank Stock Statement Form NF 902 (Excel Format)

| Sl. No. | Description of Goods | Unit | Quantity | Rate per Unit (₹) | Value (₹) | Particulars of Stock (Own/Consignment/Joint) | Location / Godown | Remarks | |---------|----------------------|------|----------|-------------------|-----------|-----------------------------------------------|-------------------|---------|

Canara Bank generally requires the NF 902 form to be submitted by the 10th or 15th of every month for the previous month's data. Late submissions trigger penal interest. How to Get the NF 902 Excel Format

Clean, error-free, mathematically correct Excel sheets speed up credit department verification and prevent processing delays. Structure and Components of Form NF 902

If you cannot find an official version, you can build a compliant NF 902 Excel file using the structure described above. Use Excel’s SUM , SUMIF , and IF functions to automate totals and drawing power.

Ultimate Guide to Canara Bank Stock Statement Form NF 902 Excel Format