NPV, with rankings Botany Bay, Inc., a maker of casual clothing, is considering four projects shown in the following table, Because of the company's risk profile, it has a high 149% cost of capital a. Calculate the NPV of each project, using a cost of capital of 14.9% b. Rank acceptable projects by NPV c. Calculato the IRR of each project and use it to determine the highest cost of capital at which will of the projects would be acceptable (Click on the icon here spreadsheet.) in order to copy the contents of the data table below into a Project A $50,000 Project B $99,900 Project C $80,500 Project D $180,600 Initial investment (CF) Year (1) 1 2 3 $20,700 $20,700 $20,700 Cash inflows (CF) $36,800 $20,300 $51,300 $39,500 $52,000 $60,600 $99,000 $80,400 $60,800 a. Calculate the NPV of each project, using a cost of capital of 14.9%. The NPV of project Ais $. (Round to the nearest cent.) Is project A acceptable? (Select the best answer below.) O A. Yes OB. No The NPV of project B is $. (Round to the nearest cent.) ) Is project B acceptable? (Select the best answer below.) . No OB. Yes The NPV of project C is $ (Round to the nearest cent) Is project C acceptable? (Select the best answer below.) O A. No O B. Yes The NPV of project D is $ (Round to the nearest cent.) Is project D acceptable? (Select the best answer below.) OA. Yes OB. No b. Rank acceptable projects by NPV. is ranked number 1 (Select from the drop-down menu.) V is ranked number 2 (Select from the drop-down menu.) V is ranked number 3. (Select from the drop-down menu.) 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. The IRR of project Als % (Round to two decimal places.) The IRR of project Bis 1% (Round to two decimal places.) The IRR of project is % (Round to two decimal places) The IRR of project Dis % (Round to two decimal places.) What is the highest cost of capital at which all of the projects would be acceptable? O A. 17.87% OB. 17.26% OC. 11.67% D. 19.27%