1. Prepare the following deprecistion schedule using the SLN function. You must use absolute cell references (\$) if a cell reference is repeated multiple times across different cells' formulas. 2. Prepare the following deprecistion schedule using the units of production method. Use the formula from the Chapter 8 notes. You must use absolute cell references (\$) if a cell reference is repeated multiple times across different cells' formulas. \begin{tabular}{l|l|l|l|l} \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} 3. Prepare the following depreciation schedule using the Excel DoB function. You must use absolute cell references (\$) if a cell reference is repeated multiple times across different cells' formulas