: Your Final Drawing Power is the lesser of your Total Calculated DP or your Sanctioned Limit. Step-by-Step Guide to Creating the Excel Formulas
To build your own automated Form NF 902 in Excel, use these standard formulas to ensure accuracy:
The is a standardized stock statement form primarily used by businesses holding a Cash Credit (CC) account with Canara Bank. canara bank stock statement form nf 902 excel format
=MIN(Sanctioned_Limit_Cell, (Stock_Drawing_Value + Debtors_Drawing_Value)) Important Rules for Submitting Form NF 902
Many branches prefer email submissions, making Excel files more convenient. Structure of the NF 902 Stock Statement The form is generally divided into several key parts: Part A: Description of Stock : Your Final Drawing Power is the lesser
: Ensure debtors older than 90 days are strictly filtered out of the eligible DP section.
: Includes columns for commodity description, opening stock, units added ("in"), units removed ("out"), and final closing stock. Structure of the NF 902 Stock Statement The
Typically 25% (meaning the bank finances 75% of your paid stock value).
: Automatically deduct the bank-mandated margin (e.g., Total Value * 0.75 for a 25% margin). Submission & Resources NF 902 Stock Statement | PDF | Money - Scribd