Hi,
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
Effective Interest Rate
SAP Function – Year Sheet
Effective Interest Rate
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,
Eli
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
🙂
I thought so… it’s not the first time already.
I’m taking a vacation out of moderation activity 🙂