Please do it on excel and show your formulas!!

There was no beginning inventory at the beginning of 2018. Sales and purchases are the same numbers for a particular year regardless of the inventory method being used. 1 Periodic FIFO 2018 2 Periodic FIFO 2019 3 Periodic LIFO 2018 4 Periodic LIFO 2019 5 Periodic Weighted Average 2018 6 Periodic Weighted Average 2019 \begin{tabular}{|l|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular}