mcelhinney
New Member
- Joined
- Apr 18, 2018
- Messages
- 2
Hi, I'm trying to figure out why XIRR and IRR are showing different returns in this case (simple bond math). These are the cash flows:
4/30/2018: -1,000
5/1/2018: 100
5/1/2019: 100
5/1/2020: 100
5/1/2021: 100
5/1/2022: 100+1,000
IRR returns 10%, which makes sense. XIRR returns 13%. Could someone help me create an XIRR function for this that will return 10%, the correct percent for this yield?
Thanks in advance!
4/30/2018: -1,000
5/1/2018: 100
5/1/2019: 100
5/1/2020: 100
5/1/2021: 100
5/1/2022: 100+1,000
IRR returns 10%, which makes sense. XIRR returns 13%. Could someone help me create an XIRR function for this that will return 10%, the correct percent for this yield?
Thanks in advance!