6. A four-year financial project has estimates of net cash flows shown below:
Year Net Cash Flow
It will cost $65,000 to implement the project, all of which must be invested in the beginning of the project. After the fourth year, the project will have no residual value.
Using the most likely estimates of cash flows, conducted a discounted cash flow assuming a 20% hurdle rate with no inflation. Using Excel or pencil and paper, what is the discounted profitability index of the project?© BrainMass Inc. brainmass.com June 4, 2020, 4:34 am ad1c9bdddf
PROFITABILITY INDEX COMPUTATION:
PRESENT VALUE OF THE CASH FLOWS FROM YEAR 1 TO YEAR 4:
PV FOR YEAR 1 16666.67
pv FOR YEAR 2 17361.11
PV FOR YEAR 3 17361.11
PV FOR YEAR 4 16878.86
INITIAL OUTLAY: 65000
According to Keown et al. ...
This report requires the computation of profitability index of a proposed project, given the expected future cash flows during the life of the project, the discount rate, and the initial cash outlay or the cost needed for the project's implementation. Using the PI formula, the computed profitability index is 1.05. Since this is greater than 1.00, the decision is to accept the proposed project.