please use the information from the first picture to complete the depreciation schedule template

Use the information below to complete the Javelina Construction Depreciation Schedule. When you are done, upload the schedule using the link in Blackboard. On January 1, 2016, Javelina Construction purchased 3 pieces of heavy equipment to build roads. You have a new crane, pavement roller and a bulldozer. Set up the depreciation schedules for each piece of equipment using the following estimates: Crane The crane's total cost is $100,000. It is estimated that the crane will no longer be useful to Javelina Construction after 4 years of service. At the end of the 4 years, the crane will probably be worth $20,000. The best way to depreciate the crane is using straight line method. Fill out the depreciation schedule for the crane. 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, 42,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 Javelina Construction after 4 years of service. At the end of the 4 years, the bulldozer 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. F G H D Crane - Depreciable cost = Cost - Residual values Useful Life 4 Years Straight-Line Depreciation Schedule - Crane Depreciation for the Year Depreciable Depreciation Cost Rate Asset Cost $100,000 Depreciation Expense Accumulated Depreciation Date 1/1/16 Book Value 100,000 $ $ 12/31/16 12/31/17 12/31/18 12/31/19 Roller - Depreciation per unit - (Cost-Residual value) /Useful life in units miles rolled per mille rolled Units-of-Production Depreciation Schedule - Pavement Roller Depreciation for the Year Depreciation Number Depreciation per Unit of Units Expense Asset Cost 5625,000 Accumulated Depreciation Date 1/1/16 12/31/16 Book Value 625,000 $ $ 12/31/17 12/31/18 12/31/19 Dozer Depreciable cost Cost-Residual values Useful Life 4 Years Double-Declining Balance Depreciation Schedule - Dorer Depreciation for the Year Asset Book Value DOB Depreciation Date Coat Rate Expense 11/16 $0.000 12/31/16 Accumulated Depreciation Book Value 850.000 $ 1201/17 12/31/18 12/31/10