Canara Bank Stock Statement Form Nf 902 Excel Format

: Subtracts "Excluded Categories" (like stocks purchased on credit or slow-moving items) and applies a bank-mandated margin (typically 25%) to the total value.

The sum of the funded stock value and funded debtor value. Step-by-Step: How to Calculate Drawing Power in Excel

Typically 30% to 40% (meaning the bank finances 60% to 70% of your eligible book debts).

The Canara Bank stock statement form NF 902 is essential for several reasons: canara bank stock statement form nf 902 excel format

Instead of recreating the document every month, you simply update the raw numbers in your saved Excel template, saving hours of administrative work.

To create an efficient Excel template for your monthly submissions, follow these structural steps: Stock Statements to Bank - Dhruva Industrial Consultants

Total Value of Inventory−Sundry Creditors for Goods=Net Paid StockTotal Value of Inventory minus Sundry Creditors for Goods equals Net Paid Stock : Subtracts "Excluded Categories" (like stocks purchased on

Do not include damaged, slow-moving, or obsolete inventory. Banks conduct periodic audits and will penalize discrepancies.

: Details quantities and market values of Raw Materials, Work-in-Process (WIP), and Finished Goods.

Usually 25% (meaning the bank finances 75% of stock value). The Canara Bank stock statement form NF 902

Stock must be valued at cost price or market price, whichever is lower .

: Ensure debtors older than 90 days are strictly filtered out of the eligible DP section.

Ensure the insurance policy for the stock is active, covers the total stock value declared, and names Canara Bank as the hypothecation beneficiary.

Detail how to handle within the NF 902 format.