topic Calculating the IRR for a subset of cashflow in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/34401#M3358
<P>Is it possible to use the IRR function to calculate only a subset of the cashflow?</P>
<P> </P>
<P>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. </P>
<P> </P>
<P>In excel you can simply have the formula as IRR($H2:I2) and apply that across the entire row.</P>Tue, 30 Oct 2018 05:49:52 GMTbill.liao2018-10-30T05:49:52ZCalculating the IRR for a subset of cashflow
https://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/34401#M3358
<P>Is it possible to use the IRR function to calculate only a subset of the cashflow?</P>
<P> </P>
<P>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. </P>
<P> </P>
<P>In excel you can simply have the formula as IRR($H2:I2) and apply that across the entire row.</P>Tue, 30 Oct 2018 05:49:52 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/34401#M3358bill.liao2018-10-30T05:49:52ZRe: Calculating the IRR for a subset of cashflow
https://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/35241#M3359
<P>Hi <LI-USER uid="10654"></LI-USER>,</P><P>You're in luck!</P><P>Anaplan makes this function available to you as well: <A href="https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/IRR.html?Highlight=irr" target="_self">IRR function documentation and example</A>.</P><P>Also:</P><UL><LI><A href="https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Financial_Functions.htm?Highlight=irr" target="_self">Here</A> is a list of financial functions in Anaplan.</LI><LI>And <A href="https://help.anaplan.com/anapedia/Content/Calculation_Functions/Function%20Usage/Excel%20Comparison.htm?Highlight=irr" target="_self">here </A>is a list of all Excel functions and their Anaplan equivalents.</LI></UL><P>Let us know if this doesn't address your need.</P><P>Cheers,</P><P>Kevin</P>Tue, 07 Aug 2018 11:04:11 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/35241#M3359kjacokes2018-08-07T11:04:11ZRe: Calculating the IRR for a subset of cashflow
https://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/35328#M3360
Hi Kevin,<BR /><BR />Thanks for the reply! I am aware of the IRR function and have been using it.<BR /><BR />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.Thu, 09 Aug 2018 13:41:50 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/35328#M3360bill.liao2018-08-09T13:41:50ZRe: Calculating the IRR for a subset of cashflow
https://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/35381#M3361
<P>Hi, you can set the 0 the values that are outside the period you want.</P><P> </P><P>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:</P><P>IF Valid Period then cash flow else 0</P><P> </P><P>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"</P>Mon, 13 Aug 2018 07:08:59 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Calculating-the-IRR-for-a-subset-of-cashflow/m-p/35381#M3361nathan_rudman2018-08-13T07:08:59Z