no 3! need the working according to formula! not excel sheet.

2) Which of the following statements is MOST correct? A) It a project's internal rate of return (IRR) exceeds the required return, then the project's net present value (NPV) must be negative. B) If Project A has a higher IRR than Project B, then Project A must also have a higher NPV. (C) The IRR calculation implicitly assumes that all cash flows are reinvested at a rate of return equal to the TRR. D) A project with a NPV = 0 is not acceptable. 3) DYI Construction Co. is considering a new inventory system that will cost $750,000. The system is expected to generate positive cash flows over the next four years in the amounts of $350,000 in year one, $325,000 in year two, $150,000 in year three, and $180,000 in year four. DYI's required rate of return is 8%. What is the payback period of this project? A) 4.00 years B) 3.09 years C) 2.91 years D) 2.50 years A no need to ulehent 4) DYI Construction Co. is considering a new inventory system that will cost $750,000. The system is expected to generate positive cash flows over the next four years in the amounts of $350,000 in year one, $325,000 in year two, $150,000 in year three, and $180,000 in year four. DYI's required rate of return is 89 What is the net present value of this project? A) $104,089 150 + sopo 132500 B) $100,328 C) $96,320 170 17.03 D) $87,417 $104084.4