The bank uses this information to monitor your performance, verify the collateral securing your loan, and calculate your —the amount of money you can borrow against your stock and receivables. A well-maintained and accurate stock statement is essential for ensuring a smooth credit flow and a healthy relationship with the bank.
If the margin is 25%, the bank finances 75% of the value. Excel Formula: =Net_Stock_Cell * 0.75
:If the margin is 40%, the bank finances 60% of the value. Excel Formula: =Eligible_Debtors_Cell * 0.60 Determine Total Drawing Power : canara bank stock statement form nf 902 excel format
Banks offer working capital loans against the security of your business assets. Because stock levels and debtor balances change daily, Canara Bank requires a monthly declaration to verify that the value of your collateral sufficiently covers the loan amount you have drawn. Key Benefits of Using an Excel Format for NF 902
Segregated by quantity and value.
Using an automated Excel template simplifies this process, eliminates manual calculation errors, and ensures timely submission to avoid penal interest. What is Canara Bank Form NF 902?
Borrowers enjoying working capital limits like Cash Credit (CC) or Overdraft (OD) against inventory and receivables must submit a stock statement periodically. At Canara Bank, this official declaration is known as . Submitting this form in an Excel format automates calculations, reduces errors, and ensures seamless compliance with banking norms. What is Canara Bank Form NF 902? The bank uses this information to monitor your
This comprehensive guide explains everything you need to know about the NF 902 form, its structure, how to fill it out in Excel, and how it impacts your borrowing capacity. What is Canara Bank Form NF 902?