Canara Bank Stock Statement Form Nf 902 Excel Format | Plus
You can download a ready-to-use Excel template from our resource section. (On your actual site, insert a download link button here. For reference, users can search "NF 902 Excel Format RBI Guidelines" or request from branch.)
Print out the completed sheet, sign it, and apply your company seal.
Canara Bank Form NF 902 Stock Statement as on [DD/MM/YYYY] Party Name: ___________________ Account No.: ___________________ Limit Sanctioned: _______________
This area handles financial deductions to establish the safe credit ceiling your business can pull against. canara bank stock statement form nf 902 excel format
Total Value of Stock (₹): _________________ Less: Stock not to be financed (₹): _________________ Net Stock considered for Drawing Power (₹): _________________
Copy the quantities and values into the respective Raw Material, WIP, or Finished Goods columns.
Use a formula to deduct the bank's margin (e.g., Total Net Stock * 0.75 ) to find your permissible drawing limit. You can download a ready-to-use Excel template from
A robust Excel template for the Canara Bank Stock Statement should be divided into four distinct sections or tabs. 1. General Information Header This section captures basic account details. Name of the Borrowing Unit Cash Credit / Overdraft Account Number Sanctioned Limit Amount Statement for the Month Ended (DD/MM/YYYY) 2. Stock and Inventory Schedule
Do you need help writing specific for asset depreciation or aging buckets?
After filling out the form, you need to submit it to the bank or depository participant. You can submit the form: Canara Bank Form NF 902 Stock Statement as
(Note: Canara Bank typically applies a 25% margin on stock, meaning you get 75% DP).
This section tracks physical goods. You must categorize items to allow the bank to apply the appropriate margin:
| 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 | ₹ ... | |
Continue with:
Ensure the automated Excel formulas generate a DP value that covers your current outstanding balance to avoid account tagging issues. Common Mistakes to Avoid