Creating an error-free stock statement is straightforward if you follow a systematic approach.
Stock DP Allocation=Net Eligible Stock×(100%−Stock Margin %)Stock DP Allocation equals Net Eligible Stock cross open paren 100 % minus Stock Margin % close paren
Total Value of Stock−Sundry Creditors for Goods=Net StockTotal Value of Stock minus Sundry Creditors for Goods equals Net Stock Excel Formula: =B10-B11 :
: Evaluated strictly at raw material cost plus verified manufacturing expenses accumulated up to the reporting date.
Canara Bank NF 902 Stock Statement Form | PDF | Money - Scribd canara bank stock statement form nf 902 excel format
Funded Stock Value+Funded Debtor Value=Calculated Drawing PowerFunded Stock Value plus Funded Debtor Value equals Calculated Drawing Power
: =Eligible Stock DP + Eligible Debts DP .
: Data on actual production and sales achieved during the month. Receivables & Creditors
: =SUM(Raw_Material_Cell, WIP_Cell, Finished_Goods_Cell) - Creditors_Cell Step 2: Apply the Stock Margin Creating an error-free stock statement is straightforward if
Ensure that the sales and purchase figures implied by your stock variations align closely with your monthly GSTR-1 and GSTR-3B filings. Tax auditors and bank inspectors cross-verify these numbers.
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
Form NF 902 requires you to declare your current insurance policy number, expiry date, and insured amount. Ensure your asset value never exceeds your insurance coverage limit.
A well-designed Excel template for Form NF 902 automates calculations and reduces human error. The format is traditionally divided into four core sections. 1. Basic Borrower Information : Data on actual production and sales achieved
Add:
This is the most critical block in the Excel sheet. It automatically applies bank margins to arrive at the final eligible drawing limit.
Canara Bank Stock Statement Form NF 902: Download & Excel Format Guide
This is the most critical operational component of the Excel sheet. It applies the bank's approved margins to your net stock and eligible debtors. Designing the Drawing Power Formula in Excel
Securing a working capital facility, such as a Cash Credit (CC) or Overdraft (OD) limit, is a major milestone for growing businesses. However, maintaining access to these funds requires consistent compliance. For Canara Bank borrowers, the most critical ongoing compliance requirement is the regular submission of the .
A typical NF 902 form in Excel will include several tables and sections that need to be filled out. The most critical sections, based on a sample statement, are outlined below.