# NPV, IRR and PI calculation on excel.

Fijisawa, Inc., is considering a major expansion of its product line and has estimated the following free cash flows associated with such an expansion. The initial outlay associated with the expansion would be $1,950,000, and the project would generate free cash flows of $450,000 per year for six years. The appropriate required rate of return is 9 percent.

a.Calculate the net present value.

b. Calculate the profitability index.

c. Calculate the internal rate of return.

d. Should this project be accepted?

How do I set this up in Excel

© BrainMass Inc. brainmass.com June 3, 2020, 10:47 pm ad1c9bdddfhttps://brainmass.com/business/capital-budgeting/npv-irr-and-pi-calculation-on-excel-249688

#### Solution Summary

This solution shows the calculation of NPV, PI, and IRR in excel. A final decision of whether to accept the project is also included.

$2.19