Prepare depreciation schedules using Excel - Thanks in advance

G H I J K L M N O P Prepare depreciation schedules using Straight-line, Units-of-production, and double-declining balance depreciation. Make use of Excel capabilities by using as many formulas and functions as possible. Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 1 150,000 10,000 Reference or given data section. 1,200 2 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 11 Year 4 12 360 270 350 220 Prepare a straight-line depreciation schedule using Excel formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. Sample header for schedule in answer section Sullivan Ranch Corporation Depreciation Schedule Straight-line method End of year amounts F G H I J K L M N O P Prepare a units of production depreciation schedule using Excel formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. Prepare a double declining depreciation schedule using Excel formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value