put the input please

1. Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depreciation. IS 5 X FILE Sign in X Finance Depreciation Schedules - Excel ? HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 -A A % BIU A Alignment Number Conditional Format as Cell Cells Formatting Table Styles Font Styles Sullivan Ranch Corporation has purchased a new tractor. The following Paste Clipboard A1 - F B E F 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 2 3 Cost: $ 150,000 4 Estimated Residual: $ 10,000 $ Estimated Life in years: 6 Estimated Life in hours: 1200 7 Actual Hours: R Year 1 360 Year 2 220 10 Year 3 350 11 Year 4 220 12 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (IX) to calculate the 13 Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 15 16 17 18 SULLIVAN RANCH CORPORATION Depreciation Schedule Straight Line Method End of year amounts Depreciation Accumulated Expense Depreciation 19 Year Book Value 20 21 1 2 3 Sheet1 - - 5. Finance Depreciation Schedules - Excel 6 x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri -111 A % BB Paste BIU- A Alignment Number Conditional Format as Cell Cells Formatting Table Styles Clipboard Font Styles A1 F Sullivan Ranch Corporation has purchased a new tractor. The following B D E F Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the 13 Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 14 IS 16 SULLIVAN RANCH CORPORATION 17 Depreciation Schedule Straight Line Method 18 End of year amounts 19 Year Depreciation Accumulated Expense Book Value 20 Depreciation 1 21 2 22 3 23 4 24 Total 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate, 27 SULLIVAN RANCH CORPORATION 28 Depreciation Schedule-Units-of-Production Method 29 End of year amounts 30 Year Depreciation Accumulated Expense 31 Depreciation Book Value 1 32 2 33 3 Sheet1 READY DIE Attemptio. + ? 3 5 Sign In Paste 1 Finance Depreciation Schedules - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Calibri - 11 - A A % Da BIU A Alignment Number Conditional Format as Cell Cells Formatting Table Styles Clipboard Font Styles fe Sullivan Ranch Corporation has purchased a new tractor. The following B D 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. E 26 Use absolute cell references when appropriate. 27 SULLIVAN RANCH CORPORATION 28 Depreciation Schedule-Units-of-Production Method End of year amounts 30 Year Depreciation Accumulated Expense Book Value 31 Depreciation 1 32 2 33 3 34 4 35 Total 36 F 29 37 40 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 38 39 SULLIVAN RANCH CORPORATION 41 Depreciation Schedule-Double-Declining-Balance Method 42 End of year amounts 43 Year Depreciation Accumulated Expense Book Value Depreciation 44 45 2 Sheet1 READY Attemptio Finance Depreciation Schedules - Excel ? 3 FILE - 5 HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Sign in Calibri - 11 Paste BIU. Clipboard A A % -A Alignment Number Conditional Format as Cell Cells Formatting Table Styles Styles for Sullivan Ranch Corporation has purchased a new tractor. The following Font A1 C D E F 33 34 35 36 B 3 4 Total 37 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 38 39 40 41 42 43 44 SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts Year Depreciation Accumulated Expense Book Value Depreciation 1 2 3 4 Total 45 46 47 48 49 50 51 52 Sheet1 READY Attempto) 11: 100%