Skip to Content
0

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

Oct 18, 2016 at 02:34 PM

383

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Juliane Frye
Oct 19, 2016 at 07:47 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0