Canara Bank Stock Statement Form Nf 902 Excel Format |top| -

: Lists outstanding book debts, often categorized by age (e.g., those more than 6 months old). Usage & Review

The Stock Statement Form NF 902 is not a mere operational document; it is a under your loan agreement. Section 2(b) of the Securitisation and Reconstruction of Financial Assets and Enforcement of Security Interest (SARFAESI) Act, 2002, allows banks to enforce security based on information provided in such statements.

: Built-in Excel dates categorize your debtors automatically, separating eligible debts from ineligible ones.

: Borrowers must specify the location/address where the stock is stored. Part B: Production and Sales Statement 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.

: Breakdown of raw materials, work-in-progress (WIP), finished goods, and stores/spares.

: A formal sign-off by the borrower certifying that the figures match the company's books of accounts. Why You Need an Excel Format for NF 902 : Lists outstanding book debts, often categorized by age (e

Here’s a simplified visual of how the Excel should look:

Use one worksheet for the inventory table and a separate summary sheet for calculations. Freeze the header row for easy data entry. Enable for the "Classification" column (allow only Raw Material, WIP, Finished Goods, Consumables).

This is perhaps the most critical part for your financial standing. The bank uses this to calculate your eligible limit by deducting ineligible stocks from your total value. Steel Sheets] Cost Price Work-in-Progress [e.g.

Valued at cost or market price (whichever is lower).

This table tracks your physical goods. You must list the value of your items and specify their valuation basis (Cost Price or Market Price, whichever is lower). Item Category Description Valuation Basis Total Value (A) Raw Materials [e.g., Steel Sheets] Cost Price Work-in-Progress [e.g., Half-assembled units] Cost Price Finished Goods [e.g., Packaged machinery] Market Price $23,000 3. Book Debts (Debtors) Schedule