How to build an XIRR calculator, which is a cash flow calculator?
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 -
- 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!