\begin{tabular}{|l|r|r|r|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ B } \\ \cline { 2 - 3 } & & \multicolumn{1}{c|}{ C } \\ \hline 1 & & E \\ \hline 2 & Sullivan Ranch Corporation has purchased a new tractor. The following information is given: \\ \hline 3 & & \\ \hline 4 & Cost: & $150,000 \\ \hline 5 & Estimated Residual: & $10,000 \\ \hline 6 & Estimated Life in years: & 4 \\ \hline 7 & Estimated Life in hours: & 1200 \\ \hline 8 & Actual Hours: & \\ \hline 9 & Year 1 & 360 \\ \hline 10 & Year 2 & 270 \\ \hline 11 & Year 3 & 350 \\ \hline 12 & Year 4 & 220 \\ \hline 13 & & \\ \hline 14 & Required: & \\ \hline \end{tabular} 3. Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB function to calculate Depreciation Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate