Canara Bank Stock Statement Form Nf 902 Excel Format -

. In the world of Canara Bank, this wasn't just a piece of paper; it was the "Inventory and Receivables" declaration that proved his business was healthy. He didn't want a static PDF. He needed a dynamic Excel format so he could: Auto-calculate the total value of raw materials. unpaid stocks to find the "Eligible Stock." Apply the margin (usually 25%) to see his drawing power. 💻 The Digital Transformation

If the margin is 25%, the bank finances 75% of the value. Excel Formula: =Net_Stock_Cell * 0.75

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

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

This section lists raw materials, semi-finished goods, and finished goods. Excel formulas must calculate the net value after deducting unpaid stocks to avoid double financing. Rate per Unit Total Value Less: Unpaid Stock / Sundry Creditors Net Value of Stock Raw Materials Data Data =Qty*Rate Data =Total-Unpaid Semi-Finished Data Data =Qty*Rate Data =Total-Unpaid Finished Goods Data Data =Qty*Rate Data =Total-Unpaid =SUM(...) =SUM(...) =SUM(...) 3. Book Debts / Sundry Debtors (Receivables) canara bank stock statement form nf 902 excel format

What are the stated in your sanction letter?

To automate your Form NF 902 template, use these standard Excel formulas: Step 1: Calculate Net Paid Stock

: The complete amount owed by customers. Debts Older than 90 Days : Ineligible for DP calculation.

: Raw materials (imported/indigenous), stock-in-process, and finished goods. He needed a dynamic Excel format so he

: Ensure that the total value of the stock declared in Form NF 902 does not exceed the total sum insured under your active insurance policies. The policy must also display Canara Bank as the primary hypothecation beneficiary. How to Get the Official Format

Print out the completed sheet, sign it, and apply your company seal.

: Ensure the figures in your Excel sheet match your physical inventory count and align with your financial ledger for that month.

The form is divided into two primary sections to provide a complete financial snapshot of your inventory: Part A: Stock Statement & Drawing Limit Commodity Details Excel Formula: =Net_Stock_Cell * 0

This header section establishes the identity of the account. It includes: Name of the borrowing unit Cash Credit / Overdraft account number Statement date (usually the last working day of the month) Sanctioned limit amount 2. Stock and Inventory Details

Usually 25% (meaning the bank finances 75% of stock value).

Valuation based on landed cost or market value (whichever is lower).

: 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