Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depreciation.

All answers must be inserted as equations.

\begin{tabular}{|l|lllll} A & B & C & D & E \\ \hline \end{tabular} 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references Prepare the following Units-of-Production depreciation schedule by entering formulas. Ice ahcolite rell references when annronriate Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells