Lab 20 Instructions way to depreciate the crane is using straight line method. Fill out the depreciation schedule for the crane. The lab folder has links to several additional documents described below: 1. Depreciation Schedule example - this MS Excel file is an example of how to complete the lab assignment. It is depreciation using each of the methods. If you have read the chapter and watched the in class problem videos you have a pretty good idea of how to do this. You can look at this document to give you guidance on what your schedules should look like. 2. Lab 20 Depreciation Schedule Template - This MS Excel file is a fill in the blank set of schedules that you will complete and upload. You do not need to use formulas to complete the cells. You can just type in the correct numbers. This is not an excel project. If you don't know how to use MS Excel, you can print it out and write in the answers and upload a photo of the schedule Use the information below to complete the loveline Construction Depreciation Schedule. When you are done, upload the schedule using the link in Blackboard. On January 1, 2016, lavelina Construction purchased pieces of heavy equipment to build roads. You have a new crane, pavement roller and bulldozer. Set up the depreciation schedules for each piece of equipment using the following ustimates Pavement roller The pavement roller cost $625,000 and it is believed the roller will have about 200,000 miles of pavement rolling of useful life. The company thinks the roller will be worth about $25,000 when it is done using the roller. The roller is used up as it rolls pavement so it will be depreciated by pavement mileage rolled. The contracts that Javelina Construction has lined up for the next several years show that they will be rolling 40,000 miles in 2016, 47,500 miles in 2017, 57,000 miles in 2018, and 60,500 in 2019. Use units of production to depreciate the roller. Bulldozer The bulldozer's total cost is $850,000. It is estimated that the dozer will no longer be useful to lavelina Construction after 4 years of service. At the end of the 4 years, the buildozer will probably be worth $150,000 The best way to depreciate the bulldozer is using double declining balance method. Fill out the depreciation schedule for the bulldozer Crane The cranw's total cost is $100,000, it is estimated that the crane will no longer be useful to lovelina Construction after years of service. At the end of the years, the rate will probably be worth 520,000. The