Depreciation (full years) Complete the amounts in the cells with borders in columns E through I. For#1,2,4,5, and 6, enter the answer in column E and COPY that entry to columns F through I. For#1,2,4,5, and 6, use dollar signs for absolute references only where they are required. For #3, enter a separate formula in each column. Think about this one! The only number that may be typed into any cell is "2". Otherwise, use cell references. Cost $10,000.00 Useful Life in Years 5 Year 1 Purchase Date January 1 Residual $1,000.00 | Depreciation Expense End Year End Year End Year End Year 4 End Year 5 Asset Method 1. Machine A Straight-line using formulas, no functions 2. Machine A Straight-line using the SLN function 3. Machine B Double-declining balance using formulas, no functions HH Machine B Double-declining balance using the DDB function 5. Machine Sum-of-years' digits using formulas, no functions 6. Machine C Sum-of-years' digits using the SYD function