where 
the following table shows the entries and the function in the spreadsheet enter the following in one cell irr a1 a6 and in another cell enter irr b1 b6 in the spreadsheet project a results in an irr of 17 and project b results in an irr of 5 given that the company s cost of capital is 10 management should proceed with project a and reject project b because the internal rate of return is higher than the project s cost 