When comparing IRR values in Clarity they are not matching the Excel or other online calculations.
Clarity calculations are actually based on daily periods. However, these are aggregated to monthly when doing the actual calculations.
If using Annual periods in Clarity, in order to get the correct number in Excel, you must change the plan to monthly period in TSV and use each period in excel.
In Clarity, when using detailed plans, make sure both the cost plan and the benefit plan are done in monthly periods.
Make sure you are using the plan of record and have the benefit plan associated.
Release : All Supported Releases
Component : CA PPM FINANCIAL MANAGEMENT
Here is an example
1) Annual cost plan but need to change the plan TSV to monthly.
Cost plan is for year 0 and benefit plan is for following 2 years.
Annual Benefit Plan:
Broken into Monthly:
Example of Excel
Excel = 5.27%
Clarity = 5.27%
If you have plans where benefits are expected while costs are still being expended (plans overlap)
Make sure in Excel that for these overlapping periods you enter the net values into the period(s).