I want to make a template, so please show cell references/formulas. Thanks!

I'm unsure if you need the top half as I broke it all up into 2 questions. But if need be, here it is:

Change in Balance Sheet Accounts Worksheet \begin{tabular}{r|r|r|r|} \hline Beginning Inventory & \multicolumn{1}{|c|}{PurchasesofInventory} & CostofGoodsSold & \multicolumn{1}{c|}{EndingInventory} \\ \cline { 1 - 4 } 110,000 & 450,000 & 449,950 & \\ \hline 790,000 & 8,250,000 & & 750,000 \\ \hline & 3,000,000 & 2,900,000 & 1,450,000 \\ \hline & & 1,750,000 & 430,000 \\ \hline \end{tabular} \begin{tabular}{r|r|r|r|} \hline BeginningAccountsPayable & PurchasesofInventory & PaymentsforInventory & \multicolumn{1}{c|}{EndingAccountsPayable} \\ \hline 75,000 & 45,000 & 50,000 & \\ \hline 55,000 & 3,000,000 & & 65,000 \\ \cline { 2 - 3 } 115,000 & & 795,000 & 105,000 \\ \hline & 10,000,000 & 11,000,000 & 4,000,000 \\ \hline \end{tabular}