Canara Bank Stock Statement Form Nf 902 Excel Format |work| Jun 2026
=IF(AND(Stock_Type="Finished Goods", Age<90), Total_Value*0.75, IF(Stock_Type="Raw Material", Total_Value*0.80, 0)) (Note: Margin percentages vary per sanction letter; always refer to your loan agreement.)
: 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
: Details of outstanding book debts and sundry creditors to help the bank assess liquidity. Submission Requirements
: The form requires confirmation that the declared stock is fully insured against fire and other risks. specific local Canara Bank branch contact to confirm their preferred submission method?
: Usually 40% (=Eligible Debts * 0.40) . Eligible Debts Value for DP : =(Eligible Debts - Margin) . canara bank stock statement form nf 902 excel format
: A signed statement confirming the goods are the borrower's property, are fully insured, and are held in trust for the bank. How to Prepare the Statement in Excel
Net Eligible Stock=Total Value of Stock−Sundry Creditors for Paid Stock EligibilityNet Eligible Stock equals Total Value of Stock minus Sundry Creditors for Paid Stock Eligibility
This is the most critical operational component of the Excel sheet. It applies the bank's approved margins to your net stock and eligible debtors. Designing the Drawing Power Formula in Excel
: Data on actual production and sales achieved during the month. Receivables & Creditors specific local Canara Bank branch contact to confirm
Platforms like US Legal Forms and DocHub offer fillable PDF versions that can be edited online or converted.
Arjun opened his laptop and searched for the specific document his branch manager, Mr. Rao, had requested: Form NF 902
: Monthly breakdown of opening stock, stock "in," stock "out," and final closing stock.
This is the core section, detailing the goods held as collateral. : A signed statement confirming the goods are
Exclude damaged, expired, or non-moving inventory from your valuations.
user wants a long article about "canara bank stock statement form nf 902 excel format". This seems to be about a specific stock statement form used by Canara Bank, possibly for inventory or stock financing. I need to provide a comprehensive guide. To do this, I'll need to search for information about this form, its purpose, how to download it, and specifically the Excel format. I'll also need to understand the context of stock statements in banking. I'll search using a variety of relevant keywords to cover different aspects. search results show some relevant items. Result 0 from the first search seems to be a Scribd document titled "MAY 2021 STOCK STATEMENT CANARA BANK" which might contain the form. Result 1 from the second search is a CAclubindia discussion about stock statement format for Canara Bank CC account. Result 2 from the third search is a general stock statement format. There's also a result for "Stock audit report format" for Canara Bank. I'll open these to gather more details. Scribd document shows a sample stock statement with the header "Canara Bank OCC Stock Statement NF 902". It includes details like commodity, units, rate, total value, and sections for raw materials, stock in process, etc. The CAclubindia discussion confirms that the format is available on the Canara Bank website. There's also a stock audit report format link. I should also search for "Canara Bank stock statement form NF 902 download" and "Canara Bank NF 902 Excel". search results didn't yield a direct download link for the Excel format. However, the Scribd document (result 0 from the first search) provides a sample of the stock statement. I'll use that as a primary source. I'll also search for general stock statement formats for banks in Excel to provide a template guide. 5, "Stock Statement : Meaning, Format & Preparation Guide 2025", looks promising for general guidance. I'll open it. guide provides a good overview of stock statements. I'll also search for "Canara Bank stock statement format NF 902 Excel template free download". search results do not show a direct link for the Excel format. However, I have enough information to write a comprehensive article. I will structure the article to cover: the purpose of NF 902, how to download the Excel format (with steps), how to fill the form, key components, tips for accuracy, common mistakes, and a call to action. I'll cite the relevant sources, such as the Scribd document for the form structure and the Bankbapu guide for general stock statement guidance. I'll also note that while a direct Excel download isn't publicly available, the form can be obtained from the bank. I'll now write the article. ability to download and properly fill out the is a critical task for any business with a Cash Credit (CC) account. This document is not just a formality; it is the primary tool the bank uses to assess your inventory's value and determine your eligible credit limit.
To build a robust automated template, incorporate these essential Excel functions: