please solve using excel

87 A rogional airport is considering installing a new baggage haodling system. Two different vendors submitted bids on the system. The airport is to replace its cur- rent system. The cash flows that describe each baggage handling system with respect to the current system are given below. Years (1) Vendor A Vender B Vendor B. Vendor A 0 $600,000 $100,000 1-15 -$500,000 $48,170 5% $65.880 $17.710 IRR 7% 15.73% PI (1%) 1.07 1.22 1.97 Which of the following statements is correct? (a) Vendor B is preferred as its P1 is higher than that of Vendor A. (b) Vendor B is preferred as long as the airport's interest rate is more than 5%. (c) Vendor B is preferred as long as the airport's interest rate is less than 7%. (d) Vendor A is preferred if the airport's interest rate is more than 15.73%