pleaseeee help

due tonight!!

Question 11 (Mandatory) (ou points) On January 1, 2020 XXZ company buys a Jaguar XJS for $115,000 with an estimated salvage/residual value of $35,000. The asset is expected to last 5 years or 110,000 miles until it reaches it salvage value. You have been asked to calculate a depreciation table for each of the following 3 types of depreciation. - Yoy must submit an MS Excel table that shows the following headings fo each of the three types of depreciation. Consider creating a new tab for each of the three types of depreciation, A) DDB, B) Straight Line C) Units of Production (Miles driven) Column 1 -- Year Column 2 -- Book Value @. Beginning of Year Column 3-Depreciation Rate Column 4 - Annual Depreciation Expense Column 5-Accumulated Depreciation Column 6-Book Value at End of Year Tab 1 ) Double Declining Balance: Tab 2) Straight Line: Tab 3) Units of Production: Yr1 20,000 miles, Yr2 25,000 miles Yr 335,000 miles, Yr 4 15,000 miles, Yr 5 15,000 miles