No idea how to do this

Ch 9 depreciation disx-Excel . Insert Page Layout Formulas Data Review ViewT Tell me what you want to d.o... File Wrap Text General Norm Copy Format Painter BIU Conditional Foabletas | Good c-A- EE Merge & Center s-96 , Formatting. Table- Clipboard Font ent Number P15 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: 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 $ 150,000 10,000 270 350 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 16 Sullivan Ranch Corporation Depreciation Schedule Straight-line method 18 19 Sheet