can you please show on Excel?

thank you

Year Cash Flow Year 1 Year 2 Year 3 $325,000 $450,000 $400,000 $475,000 Year 4 Which of the following is the correct calculation of project Sigma's IRR? 32.65% 36.49% 38,41% 46.09% If this is an independent project, the IRR method states that the firm should If the project's cost of capital were to increase, how would that affect the IRR? The IRR would decrease The IRR would increase The IRR would not change. The internal rate of return (IRR) refers to the compound annual rate of return that a project generates based on its up-front cost and subsequent cash flows. Consider the case of Blue Llama Mining Company: Blue Llama Mining Company is evaluating a proposed capital budgeting project (project Sigma) that will require an initial Investment of $750,000 Blue Lama Mining Company has been basing capital budgeting decisions on a project's NPV; however, its new CFO wants to start using the IRR method for capital budgeting decisions. The CFO says that the IRR is a better method because returns in percentage formare easier to understand and compare to required returns. Blue Llama Mining Company's WACC IS 10%, and project Sigma has the same risk as the firm's average project. The project is expected to generate the following net cash flows: Year Cash Flow Year 1 $325,000 Year 2 $450,000 Year 3 $400,000 Year 4 $475,000