PLS DO IN EXCEL FORMAT IN TABLE

PLS DO EXCEL FORMAT IN TABLE

A company is considering investing in a new project that requires an initial investment of $1,000,000. The projected cash flows from the project are as follows: Year 1: $300,000 Year 2: $400,000 Year 3: $500,000 Year 4: $600,000 The company's required rate of return for similar projects is 12%. What is the Net Present Value (NPV) of the project? What is the Internal Rate of Return (IRR) of the project? YOU MUST SHOW CALCULATIONS TO BACK UP YOUR SELECTION. (A) $100,000//12% (B) $250,000//10% (C) $250,000//14% (D) $350,000//14% (E) $50,000//%14