Hii thank you in advance! please share me the exel file so i can see the solutions :)

In 2015, ABC Company had sales revenue of P4,800,000 for a line of fancy pencil cases. Pertinent data for the year included: Inventory, December 10,000 units @ P 60.00 31,2014 January Purchases 15,000 units P 70.00 Ma Purchases October Purchases Sales 20,000 units P 75.00 18,000 units P 80.00 40,000 units @ P 120.00 ABC Company falls under the 30% government tax bracket. 1) How much ending inventory (in units) does the company have as of December 31,2015? 2) What is the Company's cost of goods sold for 2015 using FIFO method? 3) What is the Company's cost of goods sold for 2015 using LIFO method? 4) What is the resulting ending inventory (in pesos) under the LIFO method? 5) What is the resulting ending inventory (in pesos) under the FIFO method? 6) Suppose the company utilizes the weighted average cost method, how much net income after tax would they realize? 7) In the FIFO method, how much net income after tax would they realize? 8) How much tax savings will be realized by the company if they shift from FIFO to LIFO inventory costing method? 9) How much tax savings will be realized by the company if they shift from FIFO to Weighted Average inventory costing method