Squint said:The screenshot is from Excel. We are not part of the inner circle so we didn't have anything more to go on than any other member of the public.
Congrats on "cracking the code". Given how many hints have been dropped, I'm surprised that more people haven't attempted to do so.
As somebody who is not a member of the inner circle, I'd say that you qualify as an impartial observer...I'd therefore be interested in knowing whether you have found this approach useful or not, and in what way(s).
P.S. It looks to as if your modeling might be improved by including some "dummy" values for the initial CTL/ATL/TSB, i.e., as of 1/1/2006. Either that, or you need to include data from, say, the last quarter of 2005 in the calculations.