How to build an XIRR calculator, which is a cash flow calculator

#1

How to build an XIRR calculator, which is a cash flow calculator?

0 Likes

#2

Hi,

We have a inbuild function known as XIRR(), which returns the internal rate of return (IRR) for a series of cash flows that occur at irregular intervals.
You can follow the below mentioned Steps for your requirement -

Steps

  1. Have data recorded in sheet in two columns - dates (date picker) & amount (decimal)
  2. Create a new formula column, say formuladate, in the same sheet and use the formula - (dates /86400/1000)+25569
  3. Now in a control in your app, where you can want to display XIRR - use the formula -
    XIRR(LOOKUP( [DatesValues.amount]) ,LOOKUP( [DatesValues.formuladate]) , 0.1)

Hope this helps!

0 Likes