25% (The bank finances 75% of your net stock value).
This is the most critical part of the Excel sheet. It applies bank-approved margins (typically 25% for stock and 40% for debtors) to find your loan availability. Asset Type Bank Margin % (B) Eligible Value [A × (100% - B)] Eligible Debtors ( Total Value $105,000 (Total DP)
A typical NF 902 statement is divided into two primary sections: Part A: Stock Statement
| Commodity | No. of Units Placed In | No. of Units Taken Out | Final Stock (Units) | Weight/Quantity | Rate per Unit | Total Value (Rs.) | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | Example: 30/40 MM CHIPS | 0 | 96 | 25 | 0 | 0 | 0 | | Example: 40/60 MM CHIPS | 88 | 94 | 18 | 0 | 0 | 0 | | | | | | | | 18,71,500 | canara bank stock statement form nf 902 excel format
The bank uses this information to monitor your performance, verify the collateral securing your loan, and calculate your —the amount of money you can borrow against your stock and receivables. A well-maintained and accurate stock statement is essential for ensuring a smooth credit flow and a healthy relationship with the bank.
To automate your Form NF 902 template, use these standard Excel formulas: Step 1: Calculate Net Paid Stock
: =SUM(Raw_Material_Cell, WIP_Cell, Finished_Goods_Cell) - Creditors_Cell Step 2: Apply the Stock Margin 25% (The bank finances 75% of your net stock value)
: The stock and debtor values in Form NF 902 must match your monthly trial balance and inventory ledgers perfectly.
The critical calculation where the bank's margin (e.g., 25%) is applied to the net value of your hypothecated stock. How to Get Started You can typically download the NF 902 form from the official Canara Bank website
: It serves as a legal declaration of the physical goods and invoices backing the bank's funds. Asset Type Bank Margin % (B) Eligible Value
Drawing Power is the actual amount of money you are allowed to withdraw from your CC account at any given time. It is directly tied to the margins stipulated in your Canara Bank sanction letter. Standard Margin Example
Canara Bank NF 902 Stock Statement Form | PDF | Money - Scribd
Continue with: