Hello I need help with the completion of this assignment,

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

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 37,000.00 4,000.00 5 years, or 83,000 miles Actual usage 2016 2017 2018 2019 2020 12,000 miles 14,000 miles 8,000 miles 25,000 miles 24,000 miles Straigh Date 01-01-2016 12-31-2016 12-31-2017 12-31-2018 12-31-2019 12-31-2020 Asset Cost Note* You may have more rows than needed in the Depreciation per mile = Uni 24000 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 12-31-2020 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 12-31-2020 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 36529 3700 ore rows than needed in the depreciation schedules. 11944 13269 7065 24552 Round depreciation per mile to four decimal places Units-of-production Depreciation for the year Depreciation Number of Depreciation Per miles Miles Expense * 23904 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)