FV, IRR, XIRR Return Varying Results – Why?

I need to present to others a proposal on investing in some equities and bond funds and discovered that different functions return different results using the same parameters. FV, XIRR, and IRR, and the differences are not small. Here’s a test spreadsheet I made that demonstrates the problem. https://drive.google.com/file/d/16SKB2BRc_1Dq05vHyN4yyKNBNTI_Rn-q/view?usp=sharing

Anyone have some feedback? Background info and questions are in the spreadsheet. Thanks, guys and gals. David

By: David de Luna

Leave a Reply

Your email address will not be published. Required fields are marked *