I want to know how they got the answers, please show all your work. If you use Excel please show all the formulas, thank you. Correct answers are shown in the pictures.

Here's a better picture.

A piece of construction equipment (asset class 15.0) was purchased by the Jones Construction Company The cost basis was $260,000 a. Determine the GDS and ADS depreciation deductions for this property. b. Compute the difference in PW of the two sets of depreciation deductions in Part (a) if,-11% per year Click the icon to view the partial listing of depreciable assets used in business Click the icon to view the GDS Recovery Rates (k) Click the icon to ve the interest and annuity table for discrete compounding when the MARR s 1 1% per year. The GDS depreciation deductions, $ 52,000 83,200 49,920 29,952 29,952 14,976 Year 2 3 6 Determine the ADS depreciation deductions for this property, (Round to the nearest dollar) Year The ADS depreciation deductions, $ 667 43,333 43,333 43,333 43,333 43 333 21,66 2 4 6 b. The PW of the set of GDS depreciation deductions is s 196, 400 (Round to the nearest hundreds.) The PW of the set of ADS depreciation deductions is S 174,200. (Round to the nearest hundreds.) The difference in PW of the two sets of depreciation deductions is S 22.200 (Round to the nearest hundreds.) ADS 10 Descriptions of Assets Class Life GDS Asset Class 00.11 00.12 00.22 00.23 00.241 00.242 00.26 01.1 10.0 13.2 13.3 15.0 22.3 24.4 28.0 30.1 32.2 34.0 36.0 37.11 37.2 48.12 49.13 49.21 79.0 Office furniture and equipment Information systems, including computers Automobiles, taxis Buses Light general purpose trucks Heavy general purpose trucks Tractor units for use over the road Agriculture Mining Production of petroleum and natural gas Petroleum refining Construction Manufacture of carpets Manufacture of wood products and furniture Manufacture of chemicals and allied products Manufacture of rubber products Manufacture of cement Manufacture of fabricated metal products Manufacture of electronic components, products, and systems Manufacture of motor vehicles Manufacture of aerospace products Telephone central office equipment Electric utility steam production plant Gas utility distribution facilities Recreation 4 10 10 16 10 20 12 15 20 12 12 10 18 12 10 18 28 35 10 10 20 20 35 Print Done GDS Recovery Rates (r) for the Six Personal Property Classes Recovery Period (and Property Class) Svear7-yearyearil13-year 20-year Year 3-year 0.3333 0.4445 0.1481 00741 5- 0.2000 0 3200 0.1920 0.1152 0.1152 0.0576 0.0375 0.1000 0 1800 0.1440 0.2449 0.1749 0.1249 0.0893 0.0892 0.0893 0.0446 0.0950 0.0855 0.0770 0.0693 2 0.0668 0.0618 0.0571 0.0528 0.0489 0.0452 00447 0.0447 0.0446 0.0446 0.0446 0.0446 0.0446 0.0446 0.0446 0.0446 0.0446 0.0446 4 0.0922 0.0737 00655 00655 0.0656 0.0655 0.0328 6 0.0590 0.0590 0.0591 0.0590 0.0591 0.0590 0.0591 10 12 13 0.0591 16 17 18 19 20 21