Hey Björn,
You shall use the xIRR function to understand the impact of currency development on the overall IRR by following method:
- For the underlying asset's performance: Calculate the IRR using the cashflows converted to the common currency by using the currency exchange, assuming no currency changes. This will provide the IRR solely based on the asset's performance.
- For the currency impact: Calculate the IRR using the difference between the actual cashflows and the cashflows that would result from applying the currency changes. This will give you the IRR attributed solely to currency development.
You can refer to this link to understand more about xIRR function:
