please show the excel functions used

Ant Problem 10-14 Internal rate of return. For each of the projects shown in the following table, calculate the internal rate of return (IRR). Then indicate, for each project, the maximum cost of capital that the firm could have and still find the IRR Project A Project B Project C Project D Initial investment -$ 90,000-$ 490,000-$ 20,000 -S 240,000 Year Cash inflows $ 20,000 $ 150,000 $ 7,500 $ 120,000 25.000 150,000 7.500 100,000 30.000 150,000 7.500 80.000 35.000 150,000 7.500 60.000 40,000 7.500 Solution Project A CF 90,000 20.000 Problem 10-14 A1 x & fx A B C 150,000 35,000 40,000 60,000 7,500 7,500 Solution CF1 Project A CF. -S 90,000 20,000 CF $ 25,000 CF3 $ 30,000 CF4 $ 35,000 CFS S 40.000 IRR If the firm's cost of capital is below the project would be acceptable. Project B CF CF1 -S 490,000 $ 150,000 S 150.000 CF Problem 10-14 Project C CF $ 20,000 CF1 $ 7,500 CF2 $ 7,500 CF $ 7,500 CF4 $ 7,500 CFS S 7,500 IRR If the firm's cost of capital is below the project would be acceptable. Project D CFS $ 7,500 IRR If the firm's cost of capital is below the project would be acceptable. CF CF1 Project D -$ 240,000 $ 120,000 CF 2 $ 100,000 $ 80,000 $ 60,000 CFS IRR If the firm's cost of capital is below CF3 CF 4 the project would be acceptable