please answer the questions and show how the steps in excel.

1.Complete the above tables by formatting the cells using Excel to calculate the ending inventory using the three cost inventory methods

2. Calculate the cost of goods sold and ending inventory under the three inventory methods and record in a clearly labeled table

3. Explain the impact of ending inventory and cost goods sold on the balance sheet and the income statement under the three inventory methods.

4. Explain LIFO in terms of what is allowed under US GAAP Vs IFRS.

price value units units price 180 6 3104 date operation units 1 Beg. Bal 2 purchase 5 sale/40 7 sale/80 10 purchase 12lsale/440 17 sale/5 20l purchase 23 sale/75 27 purchase 29 sale/30 TIN 170 IIIII 260 purchase price date value units price value units price valu operation units 1 Beg. Bal 2 purchase 180 slsale/40 7 sale/80 TIL 10 purchase 12 sale/440 17 sale/5 2o purchase 23 sale/75 27 purchase 2601 29 sale/30 Perpetual Inventory System-LIFO purchase date units price value units price valu operation units Beg Bal 100 5 sale/40 z sale/80 10 purchase 12/sale/440 17 sale/S III 20 purchase 170 purchase 260 8 29 sale/30