I entered the xirr function to calculate a projected CAGR but it didn't work.
I was instructed to install and activate the Analysis Tool Pak Add-in. I
installed it and see it on the data tab, but the formula still does not work
properly. I have the formula entered as followed: =XIRR(C2:E2,C1:E1) where
c2-e2 are the values and c1-e1 are the dates viewed in mm/dd/yy format. All
I get is the #NUM! error in that field. How do I fix this problem? Also, I
was reading that here on the forum that there must be a negative number. If
so, won't this affect my outcome? I'm a real novice at this so I don't quite
understand.