Canara Bank Stock Statement Form Nf 902 Excel Format

: Automated math eliminates manual computation mistakes.

As a business owner or financial manager, maintaining accurate and up-to-date stock statements is crucial for financial management, tax compliance, and informed decision-making. Canara Bank, one of India's leading public sector banks, provides its customers with a standardized stock statement form, NF 902, to report their stock holdings. In this article, we will discuss the Canara Bank stock statement form NF 902, its importance, and provide a step-by-step guide on how to prepare and submit it in Excel format.

: Usually 40% (=Eligible Debts * 0.40) . Eligible Debts Value for DP : =(Eligible Debts - Margin) .

: Fully eligible for Drawing Power in most CC accounts. canara bank stock statement form nf 902 excel format

Always submit the statement by the 7th of every month (or as specified in your loan agreement) to avoid penalty interest.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

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. : Automated math eliminates manual computation mistakes

What are the stated in your sanction letter?

Disclaimer: This article is for informational purposes only. Banking norms and formats change over time. Always refer to the latest directive from your Canara Bank branch or the official Canara Bank website (canarabank.com) for the most current requirements.

Do not include damaged, slow-moving, or obsolete inventory. Banks conduct periodic audits and will penalize discrepancies. In this article, we will discuss the Canara

Let’s look at a practical example of how Excel calculates this automatically: Asset Item Gross Value Bank Margin Bank Finance % Eligible DP ₹1,00,000 ₹75,000 Eligible Debtors ( ₹30,000 Total Drawing Power ₹1,05,000

: Dead stock, rejected materials, and slow-moving inventory must be excluded.

This article is for informational purposes only. Always use the official NF 902 Excel template provided by your Canara Bank branch, as forms may be updated.

If you're a business owner with a working capital loan from Canara Bank, you're likely familiar with the monthly hustle of submitting stock statements. The

The final section where the bank's margin (typically 25%) is deducted from the net stock value to arrive at the DP. How to Prepare the Statement in Excel