I just got around to calculating my rate of return for 2014. The asset allocation I have been aiming for is about 70% equity/30% fixed income. (This is a bit conservative for our age, a bit aggressive for our desired retirement time frame.) I have these categories further broken down into sub-categories, but this general split should be what drives the majority of our returns. As a benchmark, I looked at other 70/30 investments. For example, if you take a mathematical split between Fidelity's Total Market index fund and their Total Bond Market index fund, you would expect a 10.49% return in 2014. But Fidelity's own "Asset Manager" fund-of-funds with that split actually only returned 5.61%, and their "Freedom 2025" target retirement date fund whose sub-categories match our preferences, returned 5.63%.
So, I was pretty pleased to run Excel's XIRR function and determine we made a 7.83% return across all our retirement accounts in 2014. Worse than ideal but better than the professionals? I think we'll stick with the same asset allocation this year, and re-evaluate around my birthday this summer.
Any other numbers nerds want to run theirs and share their thoughts about how they compared to benchmarks and how they'd hope to improve? White Coat Investor's excellent tutorial on using this Excel function is here: http://whitecoatinvestor.com/how-to-...xirr-function/
So, I was pretty pleased to run Excel's XIRR function and determine we made a 7.83% return across all our retirement accounts in 2014. Worse than ideal but better than the professionals? I think we'll stick with the same asset allocation this year, and re-evaluate around my birthday this summer.
Any other numbers nerds want to run theirs and share their thoughts about how they compared to benchmarks and how they'd hope to improve? White Coat Investor's excellent tutorial on using this Excel function is here: http://whitecoatinvestor.com/how-to-...xirr-function/
Comment