1. Depreciation Methods A company wants to buy a new refrigerated truck for $5,000,000. The truck can be used for 4 years, then it has a market value of $360,000. You are asked to calculate the depreciation for each year for each of the four classic depreciation methods: a) straight line b) Declining balance of 150% c) Units of production method (given: use in year 1: 450,000 km, year 2: 410,000 km, year 3: 380,000 km, year 4: 330,000 km)

Please solve in Excel and show the formulas.