Time based IRR Calculation

Hi All,

I've list of transactions and data is day wise. I need to calculate IRR on time basis . I want calculate IRR on day basis and at the end the summarized level IRR i.e Quarterly, Yearly. Also I want to calculate Asset wise and fund wise IRR.

Can anyone have idea about how to do it? For your reference please find the below screenshot.

Many Thanks

Ashutosh

Accepted answers

All comments

anirudh

Hi Ashutosh,

Have you tried applying the IRR function

https://help.anaplan.com/irr-3e65abd3-a8d8-4cb7-af34-937232ae79c5

Looks like the IRR with dates function is what you are looking for. Make sure to dimension the module with Anaplan time

Ashutosh

Hi @anirudh . Thank u for Response. Yes I am using the day as time scale and calculating IRR. But I am not able to limit the dates. So IRR is not calculating as expected. As you see below.

Let me know if any other inputs requried.

Thanks in Advance

Ashutosh

CommunityMember113484

Hi - can you share the blueprint view with formulas?

Thanks

CommunityMember82902

I read this as you need a moving IRR based on transactions to date.

I have had the same issue and solved it by having 2 lists ( 1 transactions list and 1 a monthly period list). each time period is mapped to a transaction and a monthly period in my source module with time dimension

Then I have created module without time dimension using both lists (blue print attached)

then using the 2 cumulates i can determine which cashflows and relevant dates to bring against each transaction. Then use the IRR with dates calculation to provide am IRR by transaction using the monthly period list. ( see screen shot of IRR calculated by transaction)

In calculation module you can then lookup the transaction number mapped to a time period to provide IRR by time period ( see IRR by period in attached)

IRR moving logic.docx

hopefully this works for you

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…