Canara Bank Stock Statement Form Nf 902 Excel Format [patched] • Newest & Popular

: A legal statement confirming the goods are the absolute property of the borrower, are fully insured, and have no prior charges. Steps to Create an Excel Stock Statement

: Regular submission (usually monthly) is mandatory to ensure the loan is backed by physical assets. Financial Transparency

: It ensures the loan is backed by sufficient inventory.

The , also known as the OCC Stock Statement Cum MSOD , is a mandatory monthly or quarterly document for borrowers holding an Open Cash Credit (OCC) account. It details the borrower's inventory and sales to help the bank calculate the current Drawing Limit based on the value of hypothecated goods . Key Sections of Form NF 902

: Section to deduct stocks purchased on credit, goods hypothecated to other banks, or slow-moving items from the total value. Drawing Limit Calculation canara bank stock statement form nf 902 excel format

AI responses may include mistakes. For financial advice, consult a professional. Learn more

Use the formula =SUM(Range) to calculate the total gross value of the stock.

: Final figures used for the drawing power calculation.

For businesses that rely on Canara Bank for stock or inventory loans (often against the security of raw materials, finished goods, or consumable stores), the Form NF 902 is a critical document. Submitting an accurate, timely, and compliant stock statement is not just a formality—it is the key to unlocking working capital, renewing credit limits, and maintaining a healthy banking relationship. : A legal statement confirming the goods are

: =Eligible Stock DP + Eligible Debts DP .

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

List your stock items systematically. Ensure your valuation matches your stock register. Use the classic formula in your Excel cells:

It helps the bank monitor the and ensure the stock coverage is adequate against the sanctioned limit. The , also known as the OCC Stock

Clean, error-free, mathematically correct Excel sheets speed up credit department verification and prevent processing delays. Structure and Components of Form NF 902

Create an "Age in Days" column. Use a formula if you have receipt dates: =IF(TODAY() - Receipt_Date > 90, "Slow/Non-moving", "Fast Moving") Most banks will exclude or heavily discount stock older than 90–180 days from drawing power.

A typical NF 902 form in Excel will include several tables and sections that need to be filled out. The most critical sections, based on a sample statement, are outlined below.

: Always deduct unpaid stock (Sundry Creditors). Failing to do so violates banking compliance and constitutes over-reporting.

In simple terms, this form is your declaration to the bank about: