Calculating the IRR for a subset of cashflow

Is it possible to use the IRR function to calculate only a subset of the cashflow?

For example, in Jul 18 I'm looking to calculate the IRR of the cashflow from the beginning to Jul 18 and then on Aug 18 it will be from the beginning to Aug 18.

In excel you can simply have the formula as IRR($H2:I2) and apply that across the entire row.

Accepted answers

All comments

kjacokes

Hi @bill.liao,

You're in luck!

Anaplan makes this function available to you as well: IRR function documentation and example.

Also:

Here is a list of financial functions in Anaplan.
And here is a list of all Excel functions and their Anaplan equivalents.

Let us know if this doesn't address your need.

Cheers,

Kevin

bill.liao

Hi Kevin,

Thanks for the reply! I am aware of the IRR function and have been using it.

The issue though is related to the fact that for the Excel IRR function you can select any part of the cashflow (up to previous period, current period, etc) whereas for Anaplan there is no option to select just a part of a cashflow.

nathan_rudman

Hi, you can set the 0 the values that are outside the period you want.

let's say you have a line item called "cash flow" with all the cash flows for all periods. Create a second line item called "Specific Period Cash Flow" and a third one "Valid Period" (as a boolean). The formula of "Specific Period Cash Flow" should be:

IF Valid Period then cash flow else 0

The only other way to play with Time and IRR is to use the IRR date settings (cash flow, date, dimension) but for that you need to have your cash flows as "transactions"

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…