Determine depreciation using three methods. 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 ? REVIEW VIEW Sign In Finance Depreciation Schedules - Excel FILE HOME INSERT PAGE LAYOUT Calibri -11 - Paste 4B " BIU Clipboard K Font A1 X fx B FORMULAS % DATA Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Sullivan Ranch Corporation has purchased a new tractor. The following 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: E 2 3 Cost: $ 150,000 4 Estimated Residual: $ 10,000 5 Estimated Life in years: 4 6 Estimated Life in hours: 1200 7 Actual Hours: 8 Year 1 9 Year 2 10 Year 3 11 Year 4 12 360 270 350 220 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 17 18 19 20 21 HDBTK D2222 SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Year Depreciation Expense 1 2 3 Sheet1 READY Attempt(s) Accumulated Depreciation Book Value + 100% Hint Show Me Finance Depreciation Schedules - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA ? REVIEW VIEW Sign In Calibri 11 ' ' % , Paste Clipboard BIU -A- Alignment Number Formatting Font Conditional Format as Cell Table Styles Styles Cells A1 x fx Sullivan Ranch Corporation has purchased a new tractor. The following A 10 Year 3 11 Year 4 12 B C 350 220 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. 28 29 30 56% 222222222222 17 20 24 SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight Line Method End of year amounts Depreciation Year Expense 1 2 3 4 Total Accumulated Depreciation 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. SULLIVAN RANCH CORPORATION Depreciation Schedule-Units-of-Production Method End of year amounts Depreciation Year Expense Accumulated Depreciation READY Attempt(s) www Sheet1 www B Book Value Book Value + 100% Hint Show Me Finance Depreciation Schedules - Excel ? REVIEW VIEW Sign In FILE HOME INSERT PAGE LAYOUT FORMULAS DATA Calibri 11 = % , Paste Clipboard 1 B I U A- Alignment Number Conditional Format as Formatting Table Styles Cell Cells Font Styles v fx Sullivan Ranch Corporation has purchased a new tractor. The following 24 A B 1 2 3 4 Total C D 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. 28 29 30 34 35 22222222222-23736 SULLIVAN RANCH CORPORATION Depreciation Schedule-Units-of-Production Method End of year amounts Year Depreciation Expense Accumulated Depreciation 1 2 3 4 Total E Book Value F Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to 37 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 READY Attempt(s) Sheet1 SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method 100% Hint Show Me Finance Depreciation Schedules - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA ? - REVIEW VIEW x Calibri 11 ' ' = % Paste BIU Alignment Number Conditional Format as Cell Formatting Table Styles Cells Clipboard Font Styles 1 fx Sullivan Ranch Corporation has purchased a new tractor. The following A B D E F 33 3 34 4 Total 35 36 37 Sign In 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 43 Year Depreciation Expense Accumulated Book Value Depreciation 44444 44 1 45 2 46 3 47 4 48 Total 49 50 51 52 READY Attempt(s) Sheet1 Hint 100% Show Me