2 Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formulae. Question 5 M 3 4 A corporation purchased a new truck. The following information is provided: 5 6 Cost: 7 Estimated residual: $150,000 $10,000 B Estimated life in years: 9 10 11 12 13 141 Prepare the Double Declining Balance depreciation schedule by using the DDB Function (fx) to calculate the depreciation expense for Years 1 through 4. Please use formulas or cell references for ALL cells. Depreciation schedule Double Declining Balance method 15 16 Year: Cost Depreciation Accumulated Book value 17 expense Depreciation 18 1 3 points 19 2 3 points 20 3 3 points 21 22 4 3 points 23 24 Note: points will only be assigned where the answer is determine using EXCEL formulae or cell references. 25 26