Canara Bank Stock Statement Form Nf 902 Excel Format [best] Direct

If downloading a pre-made template online, always double-check the hidden formulas to ensure the math accurately reflects your specific sanction letter margins before sending it to the bank.

Note: If your calculated Drawing Power (₹1,05,000) is lower than your sanctioned limit (e.g., ₹2,00,000), you can only draw up to ₹1,05,000. If your DP is higher than your sanctioned limit, your withdrawals remain strictly capped at your sanctioned limit. Important Rules and Common Mistakes to Avoid

It also includes : if there are multiple godowns, details must be provided godown-wise, and pharmaceutical/chemical goods over 6 months old or expiring within 6 months must be furnished separately.

If the bank requires a 25% margin, you can borrow against 75% of the asset value. : =Net_Paid_Stock_Cell * 0.75 Step 3: Apply the Debtors Margin canara bank stock statement form nf 902 excel format

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

Many branches prefer email submissions, making Excel files more convenient. Structure of the NF 902 Stock Statement The form is generally divided into several key parts: Part A: Description of Stock

While the bank often provides physical copies, many businesses use an for faster calculation. You can create or find templates that include these columns: Item Description : Name and grade of the commodity. Quantity : Number of units/weight in stock. Rate : Current market value or cost price per unit. Total Value : Auto-calculated (Quantity × Rate). Important Rules and Common Mistakes to Avoid It

With the form signed and stamped, Arjun’s drawing power was updated. By the afternoon, the funds he needed to purchase a new high-speed sewing machine were available in his account. 🛠️ Key Components of an NF 902 Excel Sheet

Monthly data updates are faster, allowing you to copy-paste data from previous months. Accuracy: Reduces manual calculation errors.

After filling out the form, you need to submit it to the bank or depository participant. You can submit the form: Many branches prefer email submissions, making Excel files

: Ineligible; excluded from calculations. 4. Drawing Power (DP) Calculation Table

Ultimate Guide to Canara Bank Stock Statement Form NF 902 (Excel Format)

| H | I | J | K | L | |---|---|---|---|---| | | Closing Stock Value (₹) | Stock Pledged to Bank (₹) | Deficit (if any) | Remarks |

Visit your home branch and ask the relationship manager or loan officer for the . Many branches maintain a soft copy on their internal system and can email it to you.

Banks typically charge a penal interest rate (usually 1% to 2% per annum) over and above your regular interest rate if the statement is not submitted by the due date (usually the 7th or 10th of the following month).