Valuation based on landed cost or market value (whichever is lower).
Alternatively, you can access standard banking formats through online corporate treasury portals or verified financial document repositories. Once your layout is ready, simply map your formulas using the guide above, save the file as a reusable master template, and update the numbers at the close of every month. If you want to tailor this template further, let me know: canara bank stock statement form nf 902 excel format
: Must be signed by authorized personnel; for larger limits, a Chartered Accountant certificate may be required for book debt verification. Valuation based on landed cost or market value
The Excel sheet uses built-in formulas to calculate your Drawing Power based on standard bank margins. While margins can vary based on your specific sanction letter, the standard template uses these benchmarks: If you want to tailor this template further,
Statement date (usually the last working day of the previous month). Name of the host Canara Bank branch. 2. Stock and Inventory Breakdown
Ensure the month-end date matches your accounting records.
Clear identification of items (raw materials, work-in-progress, finished goods).