Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formulae. Question 4 A corporation purchased a new truck. The following information is provided: Cost: Estimated residual: Estimated life in years: $150,000 $10,000 4 Prepare the Straight Line depreciation schedule by using the SLN Function (fx) to calculate the depreciation expense for Years 1 through 4. Please use formulas or cell references for ALL cells. Depreciation schedule Straight line method Year Cost Depreciation Accumulated Book value. expense Depreciation 1 3 points 2 3 points 3 3 points 4 3 points Note: points will only be assigned where the answer is determine using EXCEL formulae or cell references.