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 3 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 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. Crane - Depreciable cost Cost - Residual value = $ Useful Life 4 Years Straight-Line Depreciation Schedule - Crane Depreciation for the Year Asset Depreciable Depreciation Date Cost Cost Rate 1/1/16 $100,000 Depreciation Expense Accumulated Depreciation Book Value 100,000 $ 12/31/16 $ o 12/31/17 -0 12/31/18 -0 12/31/19 o Roller Depreciation per unit (Cost - Residual value) /Useful life in unita (5) miles rolled per mile rolled Units-of-Production Depreciation Schedule - Pavement Roller Depreciation for the Year Depreciation Number Depreciation of Units Expense Asset Cost $625.000 per Unit Accumulated Depreciation Date 1/1/16 12/31/16 Book Value 625,000 5 $ 12/31/17 0 12/31/18 - 0 12/31/10 -0 RE He Dozer Depreciable cost Cost - Residual value = $ TV Dozer - Depreciable cost Cost-Residual value = $ Useful Life = 4 Years Double-Declining-Balance Depreciation Schedule - Dozer Depreciation for the Year Asset Book Value DDB Depreciation Date Cost Rate Expense 771/16 $850,000 12/31/16 Accumulated Depreciation Book Value 850,000 $ 12/31/17 12/31/18 12/31/19