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:
F20: Total Stock Value G20: =SUM(F9:F19) F21: Less: Stock not considered (e.g., obsolete) G21: [User entry] canara bank stock statement format in excel
F22: Net Realizable Stock Value G22: =G20-G21 A8: Sl