Please answer the question by filling in the blanks using excel formulas in respect to the excel form pictured below. ( please match cell number and letter to the pictures sent ) Thank you and I greatly appreciate it.

Clipboard Font Styles C20 V > fx B E A B D 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 2 3 Cost: $ 150,000 4 Estimated Residual: $ 10,000 5 Estimated Life in years: 4 6 Estimated Life in hours: 1200 7 Actual Hours: 8 Year 1 360 Year 2 270 10 Year 3 350 11 Year 4 220 12 9 13 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. 14 15 16 17 18 SULLIVAN RANCH CORPORATION Depreciation Schedule Straight Line Method End of year amounts Depreciation Accumulated Expense Depreciation 19 Year Book Value 21 1 2 3 Sheet1 fx B E A B D 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 2 3 Cost: $ 150,000 4 Estimated Residual: $ 10,000 5 Estimated Life in years: 4 6 Estimated Life in hours: 1200 7 Actual Hours: 8 Year 1 360 Year 2 270 10 Year 3 350 11 Year 4 220 12 9 13 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. 14 15 16 17 18 SULLIVAN RANCH CORPORATION Depreciation Schedule Straight Line Method End of year amounts Depreciation Accumulated Expense Depreciation 19 Year Book Value 21 1 2 3 Sheet1