: Details quantities and market values of Raw Materials, Work-in-Process (WIP), and Finished Goods.

Dedicate rows 1 through 5 to corporate header details: , and Godown Storage Locations . Data Architecture Matrix

Submit the form before the 10th or 15th of every subsequent month (check your specific sanction terms) to avoid a penal interest rate of 1% to 2% on your utilization.

If you want to tailor this spreadsheet to your specific business, tell me: What is your amount?

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

To ensure your digital layout matches the bank's requirements exactly, ask your or Relationship Manager to email you the official layout specifications for Form NF 902. You can easily replicate their exact row and column structure right into your Excel spreadsheet.

: Typically excluded from Drawing Power calculations as they are deemed high-risk. 4. Drawing Power (DP) Computation Table

Usually 30% to 40% (meaning the bank finances 60% to 70% of eligible book debts). How Drawing Power is Calculated in Excel

Goods paid for but not yet physically received. 3. Aging of Book Debts (Receivables)

: Do not include dead, damaged, or slow-moving stock in your inventory values.