Canara Bank Stock Statement Form Nf 902 Excel Format |verified| Jun 2026

| Item No. | Description of Goods | Quantity | Unit | Purchase Price (Rs.) | Market Price (Rs.) | Total Value (Rs.) | Margin % | Eligible Stock Value (Rs.) | |----------|----------------------|----------|------|----------------------|--------------------|-------------------|-----------|----------------------------|

Group your inventory into broad, identifiable categories.

: Check the Downloads section on the Canara Bank Official Website for the most recent official NF 902 PDF. Editable Formats :

: Detailed breakdown of raw materials, work-in-progress (WIP), and finished goods. canara bank stock statement form nf 902 excel format

When downloading and using the Excel template, ensure the following columns are accurately filled:

Receipts/purchases brought into the facility during the month. Consumption/dispatches moving out of the facility. Closing volumetric stock and individual item unit rates. Part B: The Production and Sales Review

: Raw materials (imported/indigenous), stock-in-process, and finished goods. | Item No

If the bank requires a 25% margin, you can borrow against 75% of the asset value. : =Net_Paid_Stock_Cell * 0.75 Step 3: Apply the Debtors Margin

To build or fill out your NF 902 Excel template accurately, follow this logical flow: Step 1: Input Inventory Costing

: Includes an age analysis of book debts (receivables) and details of sundry creditors for purchases. Calculations & Declarations Editable Formats : : Detailed breakdown of raw

| Particulars | Amount (₹) | Remarks | | :--- | :--- | :--- | | | ₹ 18,71,500 | | | Less: Excluded Category (e.g., Stocks Purchased on Credit) | ₹ 27,53,261 | Negative? -> Report figure likely an example; in actual practice, value under this head is deducted | | Less: Margin (e.g., 25%) | ₹ ... | | | Net Drawing Power | ₹ ... | |

: Set the cell formula to subtract creditors from your gross stock. =Gross_Stock_Cell - Creditors_Cell

Form NF 902 is the official stock statement template used by Canara Bank. Borrowers use it to declare the value of their inventory (raw materials, work-in-progress, finished goods) and book debts (debtors) to the bank. Why Banks Require Form NF 902

If your loan facility includes drawing power against book debts, you must list your outstanding invoices. Canara Bank requires an aging breakdown because older debts are considered riskier: