1. Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depr 5 ? 9 X FILE HOME Sign In r Aa Colors A Fonts Finance Depreciation Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Width: Automatic Height: Automatic Margins Orientation Size Print Breaks Background Print Scale: Area Titles 100% Page Setup Scale to Fit Themes Effects Sheet Arrange Options Themes F A B D E 16 SULLIVAN RANCH CORPORATION 17 Depreciation Schedule-Straight Line Method 18 End of year amounts Depreciation Accumulated 19 Year Book Value Expense 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 Depreciation Accumulated 30 Year Book Value Expense Depreciation 31 1 32 2 33 3 34 4 35 Total 36 ...........!! n.lundu ILMIATION... 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 SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts Depreciation Accumulated Book Value Expense Depreciation 43 Year 44 1 2 45 46 47 3 4 Total 48 49 50 51 52