1. Prepare depreciation schedules using Straight-Line, Units-of-Production, and Double-Declining Balance Depreciation.

PLEASE PUT THE ACTUAL FORMULA AND NOT JUST THE ANSWER. MY ASSIGNMENT REQUIRES THE FORMULA. THANK YOU, I WILL THUMBS UPPLEASE PUT THE ACTUAL FORMULA AND NOT JUST THE ANSWER. MY ASSIGNMENT REQUIRES THE FORMULA. THANK YOU, I WILL THUMBS UP

1. Prepare depreciation schedules using Straight-Line, Units-of-Production, and Double-Declining Balance Depreciation. X H5 ? x Finance Depreciation Schedules - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri 11 AA % Paste B IU- Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A A1 X f Sullivan Ranch Corporation has purchased a new tractor. The following E B C D 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 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 360 9 Year 2 270 10 Year 3 350 11 Year 4 220 12 13 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. 14 15 H5 Finance Depreciation Schedules - Excel ? x FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AA % Paste B I U Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 fx Sullivan Ranch Corporation has purchased a new tractor. The following A B D E F 14 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 1 21 22 2 3 4 Total 23 24 XH Finance Depreciation Schedules - Excel 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AA % Paste BIU- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 3 X fo Sullivan Ranch Corporation has purchased a new tractor. The following A B D E F 22 3 23 4 24 Total 25 Prepare the following Activity-Based 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 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to LUlar 36 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 Year Book Value Expense Depreciation 1 43 44 2 45 46 47 3 4 Total 48 49 50 Sheet1 II. READY 1 + 100%