1. Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depreciation. Finance Depreciation Schedules - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In ces Calibri - 11 - AN Ba Paste Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Font Styles Sullivan Ranch Corporation has purchased a new tractor. The following B D E F Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 2 3 Cost: S 150.000 4 Estimated Residual: $ 10,000 5 Estimated Life in years 4 6 Estimated Life in hours: 1200 7 Actual Hours: 8 Year! 360 9 Year 2 270 10 Year 3 350 11 Year 4 220 12 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 Prey 1 of 1 !!! Next A1 fx 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 15 16 SULLIVAN RANCH CORPORATION 17 Depreciation Schedule-Straight Line Method 18 End of year amounts Accumulated 19 Depreciation Year Expense Book Value Depreciation 20 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 Book Value Depreciation 31 1 32 2 33 3 Sheet1 es READY E L 100% A1 Sullivan Ranch Corporation has purchased a new tractor. The following B E F -9 D End of year amounts Depreciation Accumulated Expense Depreciation 30 Year Book Value 31 32 33 34 35 36 1 2 3 4 Total 37 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (Ex) 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 SULLIVAN RANCH CORPORATION 41 Depreciation Schedule-Double-Declining-Balance Method 42 End of year amounts Year Depreciation Accumulated Book Value Expense Depreciation 1 45 2 3 47 4 Total 43 44 46 48 49 Sheet1 1 READY E 100%