Please show all work, if you did it in Excel please show the formulas, thank you. The correct answers are shown in the picture.

Question Help Rebel Systems purchased a new mining equipment for its mining activities in Northen Nevada The table on the right lists the relevant initial costs for this purchase. The service life of the equipment is 4 years and its salvage value for depreciation purposes is expected to be about 27% of the price Cost Item Price Training Cost $165 000 $15,000 $16,000 Installation a. What is the cost basis of the equipment? b. What are the annual depreciations of the equipment if 0) the SL method is used? (i) the MACRS GDS method is used? (ii) the 150% DB method is used? (iv) the 200% DB method is used? c. Calculate the book values of the equipment at the end of 2 years using all the methods above Answers (a) The cost basis of the equipment is $ 196000 (Round to the nearest dollar) (b) Annual depreciaitions and book values (Round to the nearest dollar) Year SL MACRS-GDS 150% DB 200% DB 37863 s 28008 s73500$ 58000 25 378634800 45938S 49000 3 s37863' s34280s28711, s24500" 4 37863 s 12240 17944 12250 $ 49000 , Book values at end of 2 years S 119992 s 7656 s 1202