plz answer with excel functions

E1 A firm's inventory was destroyed by fire on August 14 of the current year. Fortunately, the firm had insurance to cover the loss. However, most of the inventory records were also destroyed in the fire. 4. The average gross margin percentage is 40%, beginning inventory was $200,000, and $1,000,000 of purchases had been made through August 13. 5 The firm had recorded sales of $1,200,000 through that date. 6 Estimate the cost of the inventory lost in the fire. 52