NEED CALCULATIONS NOT JUST NUMBERS PLEASE

Sullivan Ranch Corporation has purchased a new tractor. The following information is given: Cost: $ 150,000 1 Estimated Residual: $ 10,000 Estimated Life in years: 4 Estimated Life in hours: 1200 Actual Hours: 3 Year 1 360 3 Year 2 270 0 Year 3 350 Year 4 220 1 Prepare the following Straight line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the 3 Depreciation Expense for Years 1-4 in the Depreciation expense column. Enter formulas or absolute cell references for the remaining cells. SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Accumulated Book Value Expense Depreciation Year