Open a new Excel sheet and create the following headers:
You can copy and paste this directly onto your website, blog, LinkedIn, or share it with clients.
: You only need to update the quantities, rates, and debtor balances each month.
: Eligibility depends on your specific sanction terms. canara bank stock statement form nf 902 excel format
: Usually 25% (=Net Stock Value * 0.25) . Eligible Stock Value for DP : =(Net Stock Value - Margin) .
Keeps your monthly data structured uniformly, making historical comparisons easier for your finance team.
Debtors DP Allocation=Eligible Debtors (Within Age Limit)×(100%−Debtors Margin %)Debtors DP Allocation equals Eligible Debtors (Within Age Limit) cross open paren 100 % minus Debtors Margin % close paren Open a new Excel sheet and create the
While PDF is accepted, Excel is preferred because it allows the bank to quickly check calculations.
This is the core mathematical engine of the Excel sheet. It applies the bank’s mandated "margins" to your net eligible assets:
: Breakdowns for raw materials (imported/indigenous), stock-in-process, finished goods, and consumable spares. Calculation of Drawing Limit : Usually 25% (=Net Stock Value * 0
: Age-wise breakup of book debts (within/beyond 90 days) and sundry creditors.
Canara Bank Form NF 902 Stock Statement as on [DD/MM/YYYY] Party Name: ___________________ Account No.: ___________________ Limit Sanctioned: _______________
: Typically excluded from Drawing Power calculations as they are deemed high-risk. 4. Drawing Power (DP) Computation Table