Skip to Content
avatar image
Former Member

NPV , IRR and ROI Calculation doesn't match with EXCEL formula

Dear Experts,

Could you please provide details of the NPV and IRR calculation in PPM Financial Planning ? I have used Planned Cost and Planned Revenue view type as NPV item. Also the RPM_IRATE is defined in Reference Interest Rates.

Also the master switch is enabled. If it is somehow different that excel formula then I need to identify the enhancement points.

Regards,

AP

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 19, 2016 at 07:47 AM

    Hi AP,

    You can find the formula for the calculation under the following link:

    http://help.sap.com/saphelp_ppm610/helpdata/en/f3/4da851a2c94520e10000000a423f68/frameset.htm

    Regards,

    Juliane

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Juliane,

      Thanks for your reply. Could you please give an example if you have ? I have gone through that link, which is not matching if I do that in excel,

      Could you please confirm that the NPV, IRR calculation formula is same as standard excel formula ? I have found one class /RPM/CL_KPI_API where you can check CALCULATE_NPV and CALCULATE_IRR method.

      My requirement is if it is not matching with standard NPV calculation then I may need to go to excel for calculation and put the value manually.

      Regards,

      AP