Total 36 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (h) to 37 calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 38 39 40 41 42 End of year amounts Depreciation Accumulated Depreciation 43 Year Book Value Ex 45 46 47 48 49 2 Total 51 52 X Sulivan Ranch Corporation has puchusel s new trcter. The taliowing e new ratox. The fellaw ing s 150000 % 10,0 Extimated Residual Actual Houn II Year 4