Canara Bank Stock Statement Form Nf 902 Excel Format — !!top!!

: Data on actual production and sales achieved during the month. Receivables & Creditors

Manually filling out a paper-based NF 902 form is time-consuming and prone to mathematical errors. Utilizing an Excel template provides distinct operational advantages:

: A summary that subtracts margins (e.g., 20-25%) and excluded categories (like stocks purchased on credit) from the total value to determine the bank's maximum allowable credit. canara bank stock statement form nf 902 excel format

: Ineligible; excluded from calculations. 4. Drawing Power (DP) Calculation Table

: Automatically deduct the bank-mandated margin (e.g., Total Value * 0.75 for a 25% margin). Submission & Resources NF 902 Stock Statement | PDF | Money - Scribd : Data on actual production and sales achieved

The is more than a compliance document – it is a tool for financial discipline. By creating a robust, formula-driven Excel template, you not only please your bank manager but also gain real-time insight into your inventory turnover, slow-moving stock, and actual drawing power.

: Detailed listing of raw materials, stock-in-process, finished goods, and consumable spares. : Ineligible; excluded from calculations

: Stock bought on credit must be deducted to avoid double financing. 3. Sundry Debtors (Receivables) Schedule

S.No | Item | Unit | Open | Purchase | Sale | Close | Rate | Close Value | Pledged 1 | Steel Coils | Kgs | 500 | 300 | 400 | 400 | 150 | 60,000 | 60,000 2 | Cement bags | Nos | 200 | 100 | 50 | 250 | 400 | 1,00,000 | 1,00,000 | | | | | | | | 1,60,000 | 1,60,000

Total Value of Stock (₹): _________________ Less: Stock not to be financed (₹): _________________ Net Stock considered for Drawing Power (₹): _________________