Canara Bank Stock Statement Form Nf 902 Excel Format
To develop an accurate Excel-based stock statement, ensure your file includes the following sections based on the official NF 902 structure :
Submit the form before the 10th or 15th of every subsequent month (check your specific sanction terms) to avoid a penal interest rate of 1% to 2% on your utilization.
The form is typically divided into two major parts to provide a complete picture of the business's current working capital position: Canara Bank Stock Statement NF-902 Form | PDF - Scribd
: Clean, digital formatting ensures quick verification and hassle-free approval by your Canara Bank Relationship Manager. Structure of the NF 902 Excel Template canara bank stock statement form nf 902 excel format
| Item No. | Description of Goods | Quantity | Unit | Purchase Price (Rs.) | Market Price (Rs.) | Total Value (Rs.) | Margin % | Eligible Stock Value (Rs.) | |----------|----------------------|----------|------|----------------------|--------------------|-------------------|-----------|----------------------------|
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.
Note: Your actual Drawing Power can never exceed your Sanctioned Limit. If your calculated DP is ₹50 Lakhs but your sanctioned limit is ₹40 Lakhs, your usable limit remains ₹40 Lakhs. Consequences of Delayed or Incorrect Submission To develop an accurate Excel-based stock statement, ensure
: Details of outstanding book debts (often required to be listed by age, such as those over 90 days). How to Obtain the Format Bank Stock Statement Format Guide | PDF - Scribd
Typically 25% (meaning the bank finances 75% of your paid stock value).
Net Eligible Stock=Gross Stock Value−Sundry CreditorsNet Eligible Stock equals Gross Stock Value minus Sundry Creditors | Description of Goods | Quantity | Unit
: Goods received ("In") and goods sold ("Out") during the period. Closing Stock
This is the core mathematical engine of the Excel sheet. It applies the bank-approved bank margins to your eligible assets.