burrocrat
Well-known member
Burro, the market has basically skyrocketed since the 2008 crash. It's hard to beat a market that is that hot. The real question is how well you do when the market is not -- like in 2008. I noticed you left that one off the charts. That one would be the real teller because losses hurt you more than gains help. That leaves us with 2011 & 2015 as the not-so-hot years. You underperformed the market in 2011 but more than made up for that this year. I'd take that.
As for your numbers, it looks like you just computed a simple average. If you compute an annualized return the numbers are a little different but still not bad. I've included that output below together with my returns to show you how well you are doing:
[TABLE="width: 300"]
[TR]
[TD][/TD]
[TD]C Fund[/TD]
[TD]Burro[/TD]
[TD]Cactus[/TD]
[/TR]
[TR]
[TD]2015[/TD]
[TD="align: right"]2.27%[/TD]
[TD="align: right"]9.27%[/TD]
[TD="align: right"]9.66%[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD="align: right"]13.78%[/TD]
[TD="align: right"]10.47%[/TD]
[TD="align: right"](7.39%)[/TD]
[/TR]
[TR]
[TD]2013[/TD]
[TD="align: right"]32.45%[/TD]
[TD="align: right"]5.06%[/TD]
[TD="align: right"]17.29%[/TD]
[/TR]
[TR]
[TD]2012[/TD]
[TD="align: right"]16.97%[/TD]
[TD="align: right"]16.36%[/TD]
[TD="align: right"]2.75%[/TD]
[/TR]
[TR]
[TD]2011[/TD]
[TD="align: right"]2.11%[/TD]
[TD="align: right"](3.12%)[/TD]
[TD="align: right"](2.9%)[/TD]
[/TR]
[TR]
[TD]3 year[/TD]
[TD="align: right"]15.51%[/TD]
[TD="align: right"]8.24%[/TD]
[TD="align: right"]6%[/TD]
[/TR]
[TR]
[TD]5 year[/TD]
[TD="align: right"]12.81%[/TD]
[TD="align: right"]7.41%[/TD]
[TD="align: right"]3.51%[/TD]
[/TR]
[/TABLE]
ok i read the link to the explanations of cagr and understand the 'why', but still not the 'how'. can you tell me exactly the syntax of the formulas in cells C7 and C8? (burro 3 year and burro 5 year formulas). i am missing something from the examples about PV and FV i think, what are those values?