please answer all parts using excel and show all work/formulas

Internal rate of return. For each of the projects shown in the following table, calculate the internal rate of retum (IRR). Then indicate, for each project, the maximum cost of capital that the firm could have and still find the IRR 3 4 5 6 7 Year - 8 Project A Project B Project C Project D Initial investment -$ 90,000-$ 490,000-$ 20,000-$ 240,000 Cash inflows 1 $ 20.000 $ 150,000 $ 7,500 $ 120.000 2 25.000 150.000 7,500 100.000 3 30.000 150.000 7.500 80.000 4 35.000 150.000 7.500 60.000 5 40.000 7.500 9 81 10 11 12 14 13 5 14 Solution 15 16 17 CF 18 19 20 Project A 90,000 CF s 20,000 CF 2 S 25,000 CF3 S 30,000 CF 4 s 35,000 CF S 40,000 IRR If the firm's cost of capital is below 21 22 the project would be acceptable. 23 24 37 30 25 26 0127 28 104 29 105 Project B CF CF CF CF CF. $ 490,000 $ 150,000 $ 150,000 $ 150,000 $ 150,000 101 26 27 CF 28 29 30 Project B $ 490,000 CF $ 150,000 CF2 $ 150,000 $ 150,000 CF $ 150,000 S IRR If the firm's cost of capital is below CF3 31 32 CFS 33 34 the project would be acceptable. 35 36 37 CF 3B 39 40 Project C 20,000 CF S 7,500 CF2 S 7,500 S 7,500 s 7,500 S 7,500 IRR If the firm's cost of capital is below 41 CF 3 CF 4 CF 42 + 43 44 the project would be acceptable. 45 146 47 9448 31 49 ST 50 Project D CF $ 240,000 CF1 $ 120,000 CF 2 $ 100,000 CF3 80,000 CF4 60,000 CF IRR If the firm's cost of capital is below 50 51 100 52 S S S 11 53 04 54 the project would be acceptable. 55 58 459 06 60 60 61 57 Requirements 1 In cell E23, by using cell references to the given data and the function IRR, calculate the internal rate of return for project A. 2 In cell F24, by using cell reference to the calculated data, provide the maximum cost of capital for project A to be acceptable. 3 In cell E33, by using cell references to the given data and the function {RR, calculate the internal rate of return for project B. 4 In cell F34. by using cell reference to the calculated data, provide the maximum cost of capital for project B to be acceptable. 5 In cell E43, by using cell references to the given data and the function IRR, calculate the internal rate of return for project C. 6 In cell F44. by using cell reference to the calculated data, provide the maximum cost of capital for project C to be acceptable. 7 In cell E53, by using cell references to the given data and the function IRR, calculate the internal rate of return for project D. 8 In cell F54, by using cell reference to the calculated data, provide the maximum cost of capital for project D to be acceptable. 9 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 3062 90 63 33 34 64 35 36 165 50 3 66 0067 101 102 68 10369