Monitoring inventory levels helps the bank evaluate the operational stability of the borrowing entity.
If you want to tailor this spreadsheet to your specific business, tell me: What is your amount?
| Do's | Don'ts | | :--- | :--- | | , typically by the 7th of the following month. | Don't use inconsistent units of measurement within the same statement (e.g., mixing kg and quintals for similar items). | | Do ensure the closing stock figures are supported by physical stock records and valuations. | Don't include slow-moving or obsolete stock at full value without proper provisioning. | | Do declare if any stock is hypothecated to another bank or financial institution. | Don't misrepresent figures , as this statement serves as a legally binding declaration to the bank. | | Do maintain a clear segregation between raw materials, work-in-progress, and finished goods. | Don't ignore the bank's note regarding old pharmaceutical or chemical goods; they require special mention. | | Do keep a signed copy of the submitted statement for your records. | Don't forget to get the statement certified by an authorized person with their signature and stamp. | canara bank stock statement form nf 902 excel format
Certified that:
: Formulas instantly calculate totals, deduct margins, and compute your precise Drawing Power. Monitoring inventory levels helps the bank evaluate the
It informs the bank about the current value of raw materials, work-in-progress, and finished goods, which acts as security for the loan.
This section lists raw materials, semi-finished goods, and finished goods. Excel formulas must calculate the net value after deducting unpaid stocks to avoid double financing. Rate per Unit Total Value Less: Unpaid Stock / Sundry Creditors Net Value of Stock Raw Materials Data Data =Qty*Rate Data =Total-Unpaid Semi-Finished Data Data =Qty*Rate Data =Total-Unpaid Finished Goods Data Data =Qty*Rate Data =Total-Unpaid =SUM(...) =SUM(...) =SUM(...) 3. Book Debts / Sundry Debtors (Receivables) | Don't use inconsistent units of measurement within
If the bank requires a 40% margin on eligible book debts, you can borrow against 60% of the value. : =Eligible_Debtors_Cell * 0.60 Step 4: Cap the Drawing Power at the Sanctioned Limit
Details of the godown or warehouse where the goods are stored. Part B: Declarations and Financial Data: