Calculating the IRR for a subset of cashflow

Options
bill.liao
bill.liao Member, ALL USERS, GroupMember Posts: 3 New Contributor
in Planning & Modeling

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.

Tagged:

Comments

  • bill.liao
    bill.liao Member, ALL USERS, GroupMember Posts: 3 New Contributor
    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.

Categories