Need help filling out the schedule of depreciationexpense! Thank you!

You must enable macros in order fo Please visit the Microsoft Office Support sit Contact the World Campus Helpdesk s in order for this assignment to function. e Support site for documentation and instructions. us Helpdesk if you continue to have trouble. . Assignment number six Scroll down for units-of Our company purchased a vehicle on 01/01/2016. The following information is available for this purchase: Cost of equipment Residual value $ $ Useful life 49,000.00 5,000.00 4 years, or 74,000 miles Actual usage 2016 2017 2018 2019 22,000 miles 8,000 miles 30,000 miles 14,000 miles - Straigh Date 01-01-2016 12-31-2016 12-31-2017 12-31-2018 12-31-2019 Asset Cost Note* You may have more rows than needed in the Depreciation per mile = Uni 9000 Required: Complete the schedule of depreciation expense, accumulated depreciation, and book value for the following depreciation methods: 1. Straight-line 2. Units of production 3. Double-decining balance Note* complete the schedule to the right Date 01-01-2016 12-31-2016 12-31-2017 12-31-2018 12-31-2019 Asset Cost *Round depreciation expense to two decimal places Double-de Date 01-01-2016 12-31-2016 12-31-2017 12-31-2018 12-31-2019 Asset Cost Use the area below to show your w (*Note: Your instructor may use this area to help review a Scroll down for units-of production and double-declining-balance Straight-Line Depreciation Depreciation for the year Depreciable Depreciation Depreciation Cost Rate Expense Accumulated Depreciation Book Value 48258 4900 ore rows than needed in the depreciation schedules. 21494 7666 29735 13965 Round depreciation per mile to four decimal places Units-of-production Depreciation for the year Depreciation Number of Depreciation Per miles Miles Expense * 8399 Accumulated Depreciation Book Value Accumulated Depreciation Book value Ending nse to two decimal places Double-declining-balance method Depreciation for the year Book value DDB Depreciation Beginning Rate Expense show your work and calculations. area to help review and resolve any incorrect answers)