excel will do

A company has the following mutually exlcusive projects to choose from: 1 Year Cash Flow A Cash Flow B 0 -55,000 -24,000 14,800 13,700 2 23.100 11,100 3 27,700 12,600 4 46,400 5,900 The required return is 14%. a. Using payback, which project will you choose? b. Using NPV, which project will you choose? C. Using IRR, which project will you choose? d. Using profitability index, which project will you choose? e. Based on all the previous answers, which project will you choose