NPV, with rankings Botany Bay, Inc. a maker of casual clothing, is considering four projects shown in the following table, Because of past financial difficulties the company has a high cost of capital at 14.7% a. Calculate the NPV of each project, using a cost of capital of 14.7% b. Rank acceptable projects by NPV. C. Calculate the IRR of each project and use it to determine the highest cost of capital at which all of the projects would be acceptable. spreadsheet.) data table below into a Project A $49,900 Project B $100,900 Project C $80,000 Project D $181,000 Initial investment (CF) Year (1) 1 2 3 $19,800 $19,800 $19,800 Cash inflows (CF) $36,500 $20,100 $51,300 $39,500 $51,600 $59,300 $100,300 $80,500 $60,500