Heavy general purpose trucks are often used in pipeline operations. They are built to hold up when carrying or pulling substantial loads, and yet still be suitable for regular highway use. A new truck with appropriate options is purchased for $55,000. It is estimated to have a useful life of 5 years and a salvage value of $3,400 at that time. Part a Your Answer Correct Answer (Used) Your answer is partially correct. Develop a table showing the depreciation and book value for each year using the Excel DDB worksheet function. Year Depreciation Book Value $ 1 22000 $ 33000 $ 2 13200 $ 19800 3 $ 7920 $ 11880 4 $ 4752 $ 7128 $ 5 3728 $ 3400 Carry all interim calculations to 5 decimal places and then round your final answers to 2 decimal places. The tolerance is +2.00. e Textbook and Media Hint Solution Attempts: 3 of 3 used Part b Develop a table showing the double declining balance depreciation and book value for each year using the Excel VDB worksheet function, not switching to straight-line depreciation. Year Depreciation Book Value 1 $ $ 2 $ $ 3 $ $ 4 $ $ 5 $ $ Carry all interim calculations to 5 decimal places and then round your final answers to 2 decimal places. The tolerance is +2.00