1. Prepare depreciation schedules using Straight-Line, Units-of-Production, and Double-Declining Balance Depreciation. All answers must be entered as a formula. Click OK to begin OK Finance Depredation Si VIEW DATA REVEW FORMULAS INSERT PAGE LAYOUT HOME LE Calibri % A A 11 Cell Cells AAlignment Number Conditional Format as Editing ste BIU Formatting Table Styles Styles pboard Font 1 Sullivan Ranch Corporation has purchased a new tractor. The following f B C D E F Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $ 150,000 Cost Estimated Residual: Estimated Life in years: Estimated Life in hours: Actual Hours: 10,000 4 1200 Year 1 360 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 for the remaining cells. 14 15 16 SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method 17 18 End of year amounts 19 Depreciation Year Accumulated Depreciation Expense 20 Book Value 1 21 2 22 Sheet1 11 % A A Calibri A- Alignment Number Conditional Format as Formatting Table Styles Cell Editing Cells BIU Styles Font hoard Sullivan Ranch Corporation has purchased a new tractor. The following X E C B Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Accumulated Depreciation Depreciation Year Book Value Expense 0 1 1 2 2 4 24 Total 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 25 Use absolute cell references when appropriate. 27 SULLIVAN RANCH CORPORATION Depreciation Schedule-Units-of-Production Method 28 29 End of year amounts Depreciation Expense 30 Accumutated Depreciation Year Book Value 31 1 32 33 Sheet1 4 DA FORMULAS PAGE LAYOUT INSERT HOME LE % 11 A A Calibri Editing Cells A Alignment Number Conditional Format as Cell N ste Formatting Table Styles Styles B IU Font pboard Sullivan Ranch Corporation has purchased a new tractor. The following F C Accumulated Depreciation Book Value Year Depreciation Expense 1 2 4 5 Total 6 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to 7 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 Depreciation Schedule-Double-Declining-Balance Method 41 42 End of year amounts Depreciation Expense 43 Accumulated Depreciation Year Book Value 44 1 45 2 46 47 40 Total 49 50 Sheet1
