Prepare the depreciation schedule, using the declining-balance method (twice the straight-line rate). Note: Input all amounts as positive values. Leave no cells blank - be certain to enter "O" wherever required. Chevrolet Colorado Residual value $ 32,000 $ 6,400 Estimated life 5 years Accumulated Cost of Chevy depreciation at Book value at truck beginning of year beginning of year Depreciation expense for year Accumulated depreciation at end of year Book value at end of year End of year 1 $ 32,000 $ 0 $ 32,000 $ 12,800 $ 12,800 $ 19,200 End of year 2 $ 32,000 $ 12,800 $ 19,200 $ 7,680 $ 20,480 $ 11,520 End of year 3 $ 32,000 $ 20,480 $ 11,520 $ 4,608 $ 25,088 $ 6,912 End of year 4 $ 32,000 $ 25,088 $ 6,912