K
Kevin H. Stecyk
Hi,
I am using the following equation as my Profitability Index:
{=IF(ISERROR(-NPV(Rate, IF(SIGN(CF)=1, CF, 0))/NPV(Rate, IF(SIGN(CF)=-1, CF,
0))),
"Not Applic.",
-NPV(Rate, IF(SIGN(CF)=1, CF, 0))/NPV(Rate, IF(SIGN(CF)=-1, CF, 0)))}
Rate=discount rate
CF=cash flow
I am simply taking NPV of positive values divided by NPV of negative values.
And if there is an error, a "Not Applic" note is displayed.
This is for a large project that spans more than one year during its
construction. So NPV of negative values is necessary.
Although the current equation works, is there a more elegant way of writing
this equation? Perhaps something that doesn't use formula arrays.
Thank you.
Best regards,
Kevin
I am using the following equation as my Profitability Index:
{=IF(ISERROR(-NPV(Rate, IF(SIGN(CF)=1, CF, 0))/NPV(Rate, IF(SIGN(CF)=-1, CF,
0))),
"Not Applic.",
-NPV(Rate, IF(SIGN(CF)=1, CF, 0))/NPV(Rate, IF(SIGN(CF)=-1, CF, 0)))}
Rate=discount rate
CF=cash flow
I am simply taking NPV of positive values divided by NPV of negative values.
And if there is an error, a "Not Applic" note is displayed.
This is for a large project that spans more than one year during its
construction. So NPV of negative values is necessary.
Although the current equation works, is there a more elegant way of writing
this equation? Perhaps something that doesn't use formula arrays.
Thank you.
Best regards,
Kevin