I'm glad you're doing well. Your formula looks correct.

1000 previous valuation+500 purchased-300 sold=1200 current inventory

You already understand the Fifo/lifo system as a means of...