We all very much appreciate all your hard work!
I "asume" you will also include the two typos I reported above...
Nov 13, 2010
Compare_Portfolios tab, cell P68
Nov 17, 2010
Returns_72_09 tab, cell AS100
Here is another one...
Today, Jan 09, 2011
cell L67 =AVERAGE(L$118:L$143)
cell M67 =AVERAGE(M$118:M$143)
cell N67 =AVERAGE(N$118:N$143)
cell O67 =AVERAGE(O$118:O$143)
cell P67 =AVERAGE(OFFSET(P$118,P$62,0,P$61,1):OFFSET(P$118,P$62,0,P$61,1))
I think the formula in P67 should be =AVERAGE(P$118:P$143)
I have search this forum many times trying to find another typo reported about this spreadsheet... I can not find it. I think the typo was if year 1 had a negative return? Do you see this typo?
As Merton Miller, a Nobel laureate at the University of Chicago, puts it, "I'll never understand why they call bonds 'fixed' income."