Note: The form usually requires a reconciliation between the book value (as per Tally/Books) and the market value, whichever is lower.
Eligible Debtors=Total Debtors−Debtors Older than 90 DaysEligible Debtors equals Total Debtors minus Debtors Older than 90 Days
Excel formulas automatically compute totals, reduce manual errors, and calculate the Drawing Power (DP) instantly.
25% (The bank finances 75% of your net stock value). canara bank stock statement form nf 902 excel format
The is the standard "OCC Stock Statement cum MSOD" used by borrowers with Cash Credit facilities to report monthly inventory and sales. While the official form is often distributed as a PDF, it is frequently converted into Excel format to automate the calculation of Drawing Power (DP). Standard Report Structure (NF 902)
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?
=IF(AND(Stock_Type="Finished Goods", Age<90), Total_Value*0.75, IF(Stock_Type="Raw Material", Total_Value*0.80, 0)) (Note: Margin percentages vary per sanction letter; always refer to your loan agreement.) Note: The form usually requires a reconciliation between
: Includes an age analysis of book debts (receivables) and details of sundry creditors for purchases. Calculations & Declarations
The most practical method to manage this process is by creating or obtaining a dynamic, self-calculating .
This header section identifies your business and your specific credit account. Name of the Borrower / Business Entity Account Number (CC/OD Account) Name of the Branch The is the standard "OCC Stock Statement cum
If you want, I can:
Funded Stock Value+Funded Debtor Value=Calculated Drawing PowerFunded Stock Value plus Funded Debtor Value equals Calculated Drawing Power
A legally compliant must contain the following columns and sections. Most banks provide a sample format, but if you are creating your own, ensure these fields are present: