please show how to work in excel spreadsheet. This must be completed with excel so I can learn how to input things into excel for class and test purposes moving forward.

8.7 A regional airport is considering installing a new baggage handling 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 (n) 0 Vendor A -$500,000 $48,170 Vendor B -$600,000 $65,880 Vendor B --Vendor A - $100,000 $17710 1-15 IRR 5% 7 % 15.73% PI (4%) 1.07 1.22 1.97 Which of the following statements is correct? (a) Vendor B is preferred as its PI 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%