Canara Bank Stock Statement Form Nf 902 Excel Format

To develop an accurate Excel-based stock statement, ensure your file includes the following sections based on the official NF 902 structure :

"Excellent work, Arjun," Mr. Rao said, adjusting his glasses. "Most people forget to exclude stocks older than 90 days or forget to subtract their creditors. Your Excel sheet makes our audit much easier."

Statement for the month/period ended (e.g., As of 31st May 2026 ) Sanctioned Limit amount 2. Stock and Inventory Details (The Asset Value)

The statement must include a declaration that the stocks are the absolute property of the borrower and are fully insured. Important Deadlines and Compliance canara bank stock statement form nf 902 excel format

The Canara Bank stock statement form NF 902 is a document that allows customers to report their stock holdings, including shares, debentures, and other securities, to the bank. The form is designed to help the bank maintain accurate records of its customers' investments and provide them with a clear picture of their portfolio. The NF 902 form is typically required by the bank from its customers who have a significant investment portfolio or engage in frequent buying and selling of securities.

Late submission often triggers an increase in interest rate (e.g., +2% p.a.) or a flat penalty per day of delay. In some cases, the bank may freeze the drawing power until compliance.

=IF(AND(Stock_Type="Finished Goods", Age<90), Total_Value*0.75, IF(Stock_Type="Raw Material", Total_Value*0.80, 0)) (Note: Margin percentages vary per sanction letter; always refer to your loan agreement.) To develop an accurate Excel-based stock statement, ensure

Arjun opened his laptop and searched for the specific document his branch manager, Mr. Rao, had requested: Form NF 902

Do you need a for calculating the Drawing Power within this form?

: Must be signed by authorized personnel; for larger limits, a Chartered Accountant certificate may be required for book debt verification. Your Excel sheet makes our audit much easier

What are the specific stated in your Canara Bank sanction letter?

The final section where the bank's margin (typically 25%) is deducted from the net stock value to arrive at the DP. How to Prepare the Statement in Excel

While banks historically accepted handwritten or typed PDFs, using an Excel spreadsheet for your NF 902 submission is highly recommended for several reasons:

40% (The bank finances 60% of your eligible book debts). The Math Behind Drawing Power