Net present value Using a cost of capital of 11%, calculate the net present value for the project shown in the following table and indicate whether it is acceptable, Data table in order to copy the contents of the data table below (Click on the icon here into a spreadsheet.) Initial investment (CF) Year (1) 1 2 3 4 - 1,154,000 Cash inflows (CF) $76,000 $136,000 $190,000 $250,000 $315,000 $375,000 $277,000 $105,000 $40,000 $23,000 5 6 7 8 9 10 NPV, with rankings Botany Bay, Inc., a maker of casual clothing, is considering four projects shown in the following table, E. Because of past financial difficulties, the company has a high cost of capital at 14.8%. a. Calculate the NPV of each project, using a cost of capital of 14.8%. 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. Data table (Click on the icon here e in order to copy the contents of the data table below into a spreadsheet.) Project A $49,200 Project D $180,300 Initial investment (CF) Year (t) 1 Project B Project C $99,600 $79,700 Cash inflows (CFt) $35,600 $20,700 $51,100 $40,900 $51,500 $61,000 2 3 $19,100 $19,100 $19,100 $99,400 $79,200 $59,100