Finance Depreciation Schedules - Excel ? 0 - 5X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A % Paste BIU - A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Clipboard Font Styles C12 X V A B C D E F 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 1237 38 39 40 41 42 43 44 45 46 47 48 49 Prepare the following Double-DecliningBalance 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