: Usually 40% (=Eligible Debts * 0.40) . Eligible Debts Value for DP : =(Eligible Debts - Margin) .
Let’s look at a practical example of how Excel calculates this automatically: Asset Item Gross Value Bank Margin Bank Finance % Eligible DP ₹1,00,000 ₹75,000 Eligible Debtors ( ₹30,000 Total Drawing Power ₹1,05,000
Dedicate rows 1 through 5 to corporate header details: , and Godown Storage Locations . Data Architecture Matrix
Certified that:
: Usually 25% (=Net Stock Value * 0.25) . Eligible Stock Value for DP : =(Net Stock Value - Margin) .
: Borrowers must specify the location/address where the stock is stored. Part B: Production and Sales Statement
Provides detailed, item-level stock:
This table tracks the volume and financial weight of item categories moving through the company.
: Ensure debtors older than 90 days are strictly filtered out of the eligible DP section.
: Business name, address, and the specific date (e.g., "Statement as of October 31, 2023"). Stock Inventory Table : Commodity Description : Specific item names. canara bank stock statement form nf 902 excel format
Name of the raw materials, WIP, or finished goods. Quantity: Number of units. Weight/Units: Kilograms, meters, units, etc.
Use a formula to deduct the bank's margin (e.g., Total Net Stock * 0.75 ) to find your permissible drawing limit.
A standard, bank-compliant Excel sheet for Form NF 902 is divided into four main sections. You can set up your spreadsheet using the following structure: 1. Basic Information Header Field Name Description Your registered business name. Account Number Your Canara Bank CC/OD account number. Statement Date The last working day of the reporting month. Sanctioned Limit The maximum loan amount approved by the bank. 2. Stock and Inventory Breakdown (Section A) This section calculates the value of your physical stock. : Usually 40% (=Eligible Debts * 0
Run a stock valuation report from your accounting software (Tally, Zoho Books, SAP) as of the last day of the month.