In Excel - Canara Bank Stock Statement Format

F23: Margin @ [25%] (as per bank) G23: =G22*25%

F22: Net Realizable Stock Value G22: =G20-G21 canara bank stock statement format in excel

A8: Sl. No. B8: Item Description C8: Category (Raw/Finished) D8: Quantity (Unit) E8: Rate (₹ per unit) F8: Value (₹) G8: Remarks Step 3 – Totals Section Place these formulas below the table: F23: Margin @ [25%] (as per bank) G23: