Canara Bank Stock Statement Form Nf 902 Excel Format (PLUS ✭)

A Comprehensive Guide to the Canara Bank Stock Statement Form (NF 902) in Excel Format

In the realm of business banking and working capital management, the Stock Statement is a critical document. For borrowers dealing with Canara Bank, this document is officially known as Form NF 902.

Drawing Power (DP) Calculation: Total value of eligible stock minus the prescribed margin (e.g., 25%) to determine the net drawing limit. Downloading & Preparation canara bank stock statement form nf 902 excel format

Row 1-5: Bold header with branch address, loan a/c number, and statement period. Row 7: Column headers – Sl No, Item Description, HSN Code, UOM, Qty, Rate, Value, Stock Type, Aging (Days), Remarks. Rows 8-25: Inventory data with alternating row colors for readability. Row 26: TOTAL : =SUM(Value_Range). Row 28: Less: Obsolete/Stock > 90 days : manually entered or extracted via SUMIF. Row 29: Eligible Stock Value : formula. Row 30: Margin @ 25% : =Eligible*0.25. Row 31: Drawing Power : =Eligible - Margin. Row 33-40: Declarations – "We hereby certify that the stock is insured...", signature line, date, place. Row 41: Prepared by and Checked by with date stamps. A Comprehensive Guide to the Canara Bank Stock

6. Conclusion

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 Excel format, 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. Downloading & Preparation Row 1-5: Bold header with