F20: Total Stock Value G20: =SUM(F9:F19) F21: Less: Stock not considered (e.g., obsolete) G21: [User entry]
F23: Margin @ [25%] (as per bank) G23: =G22*25% canara bank stock statement format in excel
F24: Drawing Power G24: =G22-G23 A26: Declaration: A27: I/We hereby certify that the above stock statement is true and correct. A28: Authorized Signatory A29: Date: A30: Seal/Stamp: 📥 Ready-to-use Excel Template (Copy-paste this table) Copy the block below and paste into Excel starting at A1 : F20: Total Stock Value G20: =SUM(F9:F19) F21: Less: