Sullivan Ranch Corporation has purchased a new tractor. The following information is given: S 150,000 10,000 Cost: Estimated Residual: Estimated Life in years Estimated Life in hours: Actual Hours 1200 Year 1 Year 2 Year 3 Year 4 360 270 350 220 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 for the remaining cells. IVAN RANCH CORPORAT Depreciation Accumulated De Year Book Value Ex ation Tota Prepare the following U Use absolute cell references when a n deprec iation schedule by entering formulas. ppropriate VAN RANCH CORPORAT Depreciation Accumulated Year Book Value atio Tota Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to c Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells IVAN RANCH CORPORAT Depreciation Accumulated De Year Book Value Ex ation Total