Question

Internal rate of return For the project shown in the following table. B. calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the first could have and still find the IRR acceptable. The project's IRR is %. (Round to two decimal places.) i Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial Investment (CF) $110,000 Year (1) Cash inflows (CF) $25,000 $45,000 3 $15,000 4 $50,000 5 $20,000 2 Print Done nnmur hair on

Answer 1

D B9 F EIRR(B3:B8) Α. B С 1 2 year Cash flows 3 0 $ (110,000.00) 4 1 $ 25,000.00 5 2 $ 45,000.00 6 3 $ 15,000.00 7 4 $ 50,000.00 5 $ 20,000.00 9 IRR 12.73% 10 11 Maximum cost of capital 12 od 12.73%