Hello experts,
I am trying to create a worksheet where I can enter a series of cash flows for two projects as one list and be able to calculate the XIRR for both of them separately.
I tried to search around online but I am not able to understand or able to calculate the right answer to my formula. Hoping some of the experts here can help improve my knowledge in this area.
Column A to:C - show the dates and amount into the different project. I will keep on adding the rows here when there is a new investment.
There would be another column or different tab with the column E to F showing the symbol and current amount
I have used {=XIRR(IF($C$2:$C$10=F2,$B$2:$B$10,0),A2:A10)}.
What I would like to add in my XIRR formula is the current amount of "20000" referencing to Cell F2 in the "values" of XIRR formula and add a today() date in the "dates" of XIRR formula.
1. I would like to combine a range (B2:B10) outflow and cell (F2) current amount into a new range which can be used in a If formula
2. Add a today() date to represent the current amount that I would get if I stop this project.
I spend a lot of hours trying different formula but I keep getting a error. Sorry for asking a noob question but I would like appreciate your expert help here. Thanks.
I am trying to create a worksheet where I can enter a series of cash flows for two projects as one list and be able to calculate the XIRR for both of them separately.
I tried to search around online but I am not able to understand or able to calculate the right answer to my formula. Hoping some of the experts here can help improve my knowledge in this area.
Column A to:C - show the dates and amount into the different project. I will keep on adding the rows here when there is a new investment.
There would be another column or different tab with the column E to F showing the symbol and current amount
I have used {=XIRR(IF($C$2:$C$10=F2,$B$2:$B$10,0),A2:A10)}.
What I would like to add in my XIRR formula is the current amount of "20000" referencing to Cell F2 in the "values" of XIRR formula and add a today() date in the "dates" of XIRR formula.
1. I would like to combine a range (B2:B10) outflow and cell (F2) current amount into a new range which can be used in a If formula
2. Add a today() date to represent the current amount that I would get if I stop this project.
I spend a lot of hours trying different formula but I keep getting a error. Sorry for asking a noob question but I would like appreciate your expert help here. Thanks.
