Skip to Content
Author's profile photo Gustavo Vazquez

SAP Effective Interest Rate vs Ms Excel IRR XIRR



SAP Effective Interest Rate is MS Excel XIRR function according to SAP Note 839381 . This document is how you can validate these two functions.


In the Excel attached (no macros) there is a calculation process in SAP , XIRR and IRR .


Some points to keep in mind.


  • You can convert from XIRR to IRR only if you calculate if your base is days (interest days) not years (periods)
  • XIRR calculates on act/365
  • IRR calculates on act/360
  • You can iterate values in Excel with Data -> Whatif Analysis -> Goal Seek . This is used to get IRR for NPV = 0
  • Use SAP function EFFEKTIVZINS_BERECHNEN to calculate XIRR in SAP, only cashflow is needed.
  • Look at formulas in Excel. Look for comments in cells.


This document does not support Excel files, so I uploaded it in xml files and attached images for SAP function


SAP Function – Days Sheet


01-06-2016 09-18-12 a.m..png


01-06-2016 09-18-35 a.m..png

Effective Interest Rate

01-06-2016 09-19-00 a.m..png


SAP Function – Year Sheet


01-06-2016 09-22-09 a.m..png


01-06-2016 09-22-28 a.m..png


Effective Interest Rate

01-06-2016 09-23-07 a.m..png


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Eli Klovski
      Eli Klovski

      Hi Gustavo,

      Nice job. However, in a view of new platform, I'd suggest you not to split blogs any more in to parts. Currently, it is very difficult edging to impossible to 'link' between the parts, unlike what was available under old SCN design. It would be better, therefore, to post your theme in a one post.

      Kind regards,


      Author's profile photo Gustavo Vazquez
      Gustavo Vazquez
      Blog Post Author

      Hi Eli,

      The title is OK but content is not; I didn't write it.
      I'd love to go on tourism to South Africa but I wrote about XIRR function in Excel

      Tags are ok,

      Kind Regards

      Author's profile photo Eli Klovski
      Eli Klovski

      I thought so... it's not the first time already.
      I'm taking a vacation out of moderation activity ?

      Author's profile photo Uri Dembo
      Uri Dembo


      Where can I find the Excel you mention?