please do AW for all caterpillar, deere, and case. I cant figure out how to do the pv formula on excel so showing what formuals you put in excel what also be really helpful. thank you

Three mutually exclusive earth-moving pieces of equipment are being considered for several large building projects in India over the next five years. The estimated cash flows for each alternative are given below. The construction company's MARR is 18% per year. Which of the three alternatives, if any, should be adopted? Assume repeatability is appropriate for this comparison. Caterpillar D eere Case Capital investment $20,000 $26,000 $17,500 Net annual revenue $7,500 $9,500 $5.000 Salvage value $4,500 $5,000 $3,750 Useful life 4 years 3 years 5 years The AW of the Caterpillar is $ . (Round to the nearest dollar.) Enter your answer in the answer box and then click Check