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.
: Goods currently on the factory floor. Finished Goods : Items fully processed and ready for sale.
: Automatically pulled from the debtor section.
:Filter out old invoices based on your sanction criteria (e.g., excluding debtors older than 90 days). Excel Formula: =SUM(Debtors_Under_90_Days_Cells)
: Columns for Opening Stock, Stock "In" (purchases), Stock "Out" (sales), and Final Closing Stock. canara bank stock statement form nf 902 excel format
: 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
: Breakdown of Raw Materials, Stock-in-Process, Finished Goods, and Consumable Spares.
Creating an error-free stock statement is straightforward if you follow a systematic approach.
: Values to be deducted for calculating drawing limits, such as: Stocks purchased on credit (Trade Creditors). Slow-moving or obsolete stocks. Goods in transit or held in outstation godowns. The Canara Bank stock statement form NF 902
Open a new Excel workbook. Label the main tab NF 902 Monthly Statement .
Do you need a for calculating the Drawing Power within this form?
:If the margin is 40%, the bank finances 60% of the value. Excel Formula: =Eligible_Debtors_Cell * 0.60 Determine Total Drawing Power :
Visit your nearest Canara Bank branch or ask your Relationship Manager for the official Excel reference format. : Goods currently on the factory floor
| A | B | C | D | E | F | G | |---|---|---|---|---|---|---| | | Particulars / Item Name | Unit | Opening Stock (Qty) | Purchases (Qty) | Sales (Qty) | Closing Stock (Qty) |
: Usually 25% (=Net Stock Value * 0.25) . Eligible Stock Value for DP : =(Net Stock Value - Margin) .
The gross amount owed to your business.