B A D E F 3 Cost: 4 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 2 $ 150,000 4 Estimated Residual: $ 10,000 5 Estimated Life in years: 6 Estimated Life in hours: 1200 7 Actual Hours: 8 Year 1 360 Year 2 270 10 Year 3 350 11 Year 4 12 Prepare the following Straight line depreciation schedule by using the excel SIN FUNCTION (x) to calculate the Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 9 220 13 14 15 16 17 18 SULLIVAN RANCH CORPORATION Depreciation Schedule Straight Line Method End of year amounts Depreciation Accumulated Expense Depreciation Book Value 19 Year 20 21 22 1 2 3 Sheet1 !!! LI READY 100% Hint Attempts. 2/3