You must list the total amount owed to suppliers for the raw materials purchased. Because these goods are not yet paid for, the bank will deduct unpaid stock from your total inventory value to avoid double-financing. 4. Book Debts / Sundry Debtors This section outlines the money your customers owe you.
Ensure your stock insurance policy is current and the "Bank Clause" is noted in the policy documents.
📥 [Click here to download NF 902 Excel Format] (Insert your actual download link)
Total Drawing Power=Stock DP+Debtors DPTotal Drawing Power equals Stock DP plus Debtors DP
To build your own automated Form NF 902 in Excel, use these standard formulas to ensure accuracy:
: Usually 25% (=Net Stock Value * 0.25) . Eligible Stock Value for DP : =(Net Stock Value - Margin) .
| A | B | C | D | E | F | G | |---|---|---|---|---|---|---| | | Particulars / Item Name | Unit | Opening Stock (Qty) | Purchases (Qty) | Sales (Qty) | Closing Stock (Qty) |
: Always deduct Sundry Creditors. If you have not paid your suppliers for the raw materials, the bank will not finance those items.
You must list the total amount owed to suppliers for the raw materials purchased. Because these goods are not yet paid for, the bank will deduct unpaid stock from your total inventory value to avoid double-financing. 4. Book Debts / Sundry Debtors This section outlines the money your customers owe you.
Ensure your stock insurance policy is current and the "Bank Clause" is noted in the policy documents.
📥 [Click here to download NF 902 Excel Format] (Insert your actual download link) canara bank stock statement form nf 902 excel format
Total Drawing Power=Stock DP+Debtors DPTotal Drawing Power equals Stock DP plus Debtors DP
To build your own automated Form NF 902 in Excel, use these standard formulas to ensure accuracy: You must list the total amount owed to
: Usually 25% (=Net Stock Value * 0.25) . Eligible Stock Value for DP : =(Net Stock Value - Margin) .
| A | B | C | D | E | F | G | |---|---|---|---|---|---|---| | | Particulars / Item Name | Unit | Opening Stock (Qty) | Purchases (Qty) | Sales (Qty) | Closing Stock (Qty) | Book Debts / Sundry Debtors This section outlines
: Always deduct Sundry Creditors. If you have not paid your suppliers for the raw materials, the bank will not finance those items.
