Canara Bank Stock Statement Form Nf 902 Excel Format ((hot)) May 2026

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.

Excluded Categories: Stocks that cannot be used to calculate DP, such as obsolete items, goods older than six months, or items purchased on credit (Sundry Creditors). canara bank stock statement form nf 902 excel format

Excel Tip: Include columns for Opening Stock + Purchases - Sales = Closing Stock to ensure data consistency. A Comprehensive Guide to the Canara Bank Stock

Name of the borrower, account number, and the statement date. Itemized Inventory: Columns for Quantity, Rate, and Total Value. The "Ageing" Analysis: Closing Stock (Qty) = Opening + Purchases –

. While the bank primarily distributes this in PDF format, many businesses recreate it in to automate calculations for Drawing Power (DP). US Legal Forms Purpose and Importance Drawing Power Calculation

Step 3: Add Formulas

• Closing Stock (Qty) = Opening + Purchases – Sales
  (Formula in G2: =D2+E2-F2)
• Closing Stock Value (₹) = Closing Qty × Rate
  (Formula in I2: =G2*H2)
• Deficit = If Stock Pledged > Closing Value, show difference
  (Formula in K2: =IF(J2>I2, J2-I2, 0))