On January 3, 2014, Trusty Delivery Service purchased a truck at a cost of $90,000. Before placing the truck in service, Trusty spent $3,000 painting it, $1,500 replacing tires, and $4,500 overhauling the engine. The truck should remain in service for five years and have a residual value of $9,000. The truck's annual mileage is expected to be 22,500 miles in each of the first four years and 10,000 miles in the fifth year - 100,000 miles in total. In deciding which depreciation method to use, Mikail Johnson, the general manager, requests a depreciation schedule for each of the depreciation methods (straight-line, units-of-production, and double-declining-balance).
Prepare a depreciation schedule for each depreciation method showing asset cost depreciation cost , accumulated depreciation and asset book value.