PLEASE INCLUDE THE FORMULAS. Thank you
1. Prepare depreciation schedules using Straight-Line, Units of Production, and Double Declining Balance Depreciation 6 X Sign In A WS. Finance Depreciation Schedules - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Calibri 11 96 Paste BIU- Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Font Styles AI 1 Sullivan Ranch Corporation has purchased a new tractor. The following B D E F 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 2 3 Cost: S 150.000 4 Estimated Residual: $ 10,000 $ Estimated Life in years: 6. Estimated Life in hours: 1200 7 Actual Hours: Year 1 360 9 Year 2 270 10 Year 3 350 11 Year 4 12 220 KB ? Finance Depreciation Schedules - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In X Calibri Paste B IU- - 11 -A % A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Font Styles X 1 Sullivan Ranch Corporation has purchased a new tractor. The following Clipboard A1 > B D E F 13 12 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (EX) 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 IS 16 17 18 SULLIVAN RANCH CORPORATION Depreciation Schedulo-Straight Line Method End of year amounts Depreciation Accumulated Expense Depreciation 19 Year Book Value 20 21 22 23 24 1 2 3 4 Total 25 - Finance Depreciation Schedules - Excel FILE ? HOME INSERT 5 X PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In A X Pa Calibri - 11 Paste B IU- FL - Clipboard -AA % Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles fax Sullivan Ranch Corporation has purchased a new tractor. The following Font A AI X F B D E 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 34 4 35 Total 36 33 34 35 36 3 4 Total Year Prepare the following Double Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (Ex) 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 SULLIVAN RANCH CORPORATION 41 Depreciation Schedule-Double Declining-Balance Method 42 End of year amounts 43 Depreciation Accumulated Expense Depreciation Book Value 44 1 45 2 46 3 47 4 48 Total 49 50 S1 52
