Please show all the formulas used and the calculations and not only an excel table

8.26 Zerex Paving Company purchased a hauling truck on January 1, 2009, at a cost of $32,000. The truck has a useful life of eight years with an estimated salvage value of $5000. The straight-line method is used for book purposes. For tax purposes the truck would be depreciated as Class 10 property with a declining balance rate of 30%. Determine the annual depreciation amount to be taken over the useful life of the hauling truck for both book and tax purposes deprecatio amount to be taken over the use