25. What is the IRR of the above project? Note: this can be solved on financial calculator but is time consuming, tedious, and more prone to human error. In excel, one can link all rate cells together so when one rate cell changes, they all change (when solving for PV of NWC, Salvage, and OCFs). That way we can "goal seek" an NPV cell to zero by changing the one rate cell through which all other rate cells are linked. Enter answer... Question 25 1 pts What is the IRR of the above project? Note: this can be solved on financial calculator but is time consuming, tedious, and more prone to human error. In excel, one can link all rate cells together so when one rate cell changes, they all change (when solving for PV of NWC, Salvage, and OCFs). That way we can "goal seek" an NPV cell to zero by changing the one rate cell through which all other rate cells are linked. take Question 24 1 pts Putting it all together. Additions and changes to the previous problem are noted in red. NPV = PV (OCF8) + PV (after tax salvage) + PV (NWC) - PV (Investment) A $4 million investment today, in a project to last 10 years, is believed to result in the following incremental cash flows: annual increase in sales of $2,100,000 operating expenses will be 50% of sales . there is a $30,000 NWC investment associated with this project that is fully recovered at the end of the project's life assets purchased for this project are depreciated to zero value using straight-line over the project's complete life market value of assets at end of life are expected to be $50,000 firm's marginal tax rate is 32% required return on the project is 12% compounded annually What is the NPV of this project? Enter answer in dollars, rounded to the nearest dollar. . . 748,094