PLEASE ANSWER IN FORMULA FORMAT. FOR EACH BOX. LIKE WHAT NUMBERS YOU ADD AND THE COLUMN YOU GOT THE NUMBERS FROM. LIKE D5+D6(D8). THANKS.

1 Sullivan Ranch C ation has purchased a new tractor.The following information is given: 3 Cost: 4 Estimated Residual: 5 Estimated Life in years 6 Estimated Life in hours 7 Actual Hours: 8 Year 1 9 Year 2 10 Year 3 $ 150,000 S 10,000 4 1200 360 270 350 220 Year 4 12 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the 15Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 14 15 16 17 18 SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Accumulated Depreciation 19 Year Book Value Expense 20 21 2 23 24 4 Total 25 Prepare the following Activity-Based depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. 27 28 29 SULLIVAN RANCH CORPORATION Depreciation Schedule-Units-of-Production Method End of year amounts Depreciation Expense Accumulated Depreciation 30 Year Book Value 31 32 2 34 35 36 4 Total Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) 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 SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts Depreciation Expense Accumulated Depreciation 43 Year Book Value 45 46 47 48 49 50 51 52 2 4 Total