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

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

**Chirag**#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

- Have data recorded in sheet in two columns -
**dates**(date picker) &**amount**(decimal) - Create a new formula column, say
**formuladate**, in the same sheet and use the formula - (**dates**/86400/1000)+25569 - 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