please use the tamplete to fill out the information

Depreciation You are thinking of buying a van that will be used only for business. The cost of the van is estimated at $36,500. You would spend an additional $2,500 to have the van painted. In addition, you want the back seat of the van removed so that she will have lots of room to transport your miser inventory as well as your catering supplies. The cost of taking out the fuck seat and installing shelving units is estimated at $1,500. You expect the van to fast about 5 years, and you expect to drive it for 200.000 miles. The annual cost of vehicle insurance will be $2,400. You estimate that at the end of the 5-year useful life the van will sell for $7,500. Assume that you will buy the van on August 15, 2022, and it will be ready for use on September 1, 2022. You are concerned about the impact of the san's cost on your income statement and balance sheet. You will need to calculate the van's depreciation Required 1. Determine the cost of the van 2. Prepare three depreciation tables: one for straight line drareciation, one for double-declining balance depreciation, and one for units of activity depreciation. For units-of-activity, you estinate you will drive the van as follows: 15.000 milies in 2022: 50.000 miles in 2023 50,000 miles in 2024: 45,000 miles in 2025: 40,000 miles in 2026. Recall that your business has December 31 year-end 3. What impact will the three methods of depreciation have on your business balance sheet at December 21, 20227 What impact will the three methods have on your income statement in 2022 4 What impact will the three methods of depreciation have on your income statement over the van's total 5-year useful life? 5. What method of depreciation would you use and why? TEMPLATES Deonciation alox Year Depreciable Cost X Rate Annual Depreciation Expense Accumulated Depreciation Book Value