Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formulae. Question 5...

Transcribed Image Text:

Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formulae. Question 5 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 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 Year Cost Depreciation Accumulated Book value expense Depreciation 1 2 3 4 3 points 3 points 3 points 3 points Instructions: Complete all cells shaded green. All answers must be determined using EXCEL formulae. Question 5 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 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 Year Cost Depreciation Accumulated Book value expense Depreciation 1 2 3 4 3 points 3 points 3 points 3 points