Halcrow Yolles purchased equipment for new highway construction in Manitoba, Canada, costing $430,000 Canadian. The estimated salvage at the end of the expected life of 6 years is $50,000. Various acceptable depreciation methods are being studied currently. Determine the depreciation for year 2 using the DDB(Double Declining Balance), 150% DB(Declining Balance), and SL(Straight Line Depreciation) methods. Calculate the depreciation value in a certain year using DDB, 150% DB and Straight Line methods Determine the depreciation by hand. The depreciation using SL method is determined to be $ . The depreciation using DDB method is determined to be $ . The depreciation using 150% DB method is determined to be $.   Calculate depreciation values using Excel functions Determine the depreciation using spreadsheet functions.

Halcrow Yolles purchased equipment for new highway construction in Manitoba, Canada, costing $430,000 Canadian. The estimated salvage at the end of the expected life of 6 years is $50,000. Various acceptable depreciation methods are being studied currently. Determine the depreciation for year 2 using the DDB(Double Declining Balance), 150% DB(Declining Balance), and SL(Straight Line Depreciation) methods.

Calculate the depreciation value in a certain year using DDB, 150% DB and Straight Line methods