Please do question in excel and not on paper, thanks!

ul 41 42 6. 43 Calculate the closing book inventory given the following information: 44 Retail 45 opening inventory $150,000.00 4.46 gross purchases $125,000.00 47 returns to vendors $20,000.00 48 net purchases 49 transfers in $35,000.00 er 50 transfers out $5,000.00 51 net transfers || 52 additional markup $2,000.00 53 total merch handled 54 net sales $112,000.00 55 markdowns $18,000.00 es 56 markdown cancellations $3,000.00 57 net markdowns $15,000.00 58 employee discounts $2,000.00 59 total retail deductions 60 closing book inventory a A OO