Inventory Table in Ms-Excel

In this video we can discuss about Inventory Table (Stock Items)

Ex Problem:-

Item Name = Lux
opening Stock=85
Purchase price=8/-
Sales price=13/-
Sales Quantity=47

Closing stock =?
Profit on each one =?
Net profit =?
Close stock value=?