ThanksThe 25 years you refer in that example was only to see the magnification over time that small changes to the imputation system made.
I don't forecast 25 years in advance for valuation. I do consider if the business is cyclical into the future so as to not be potentially misled by current numbers - but that's really about the extent of the forecasting. The rest is competitive advantage, how sustainable that is and how much can the business be expanded within that advantage.
I assume Buffets reasoning for coughing up for Coke was the durability of its competitive advantage and its world scale for expansion.
Perhaps I am reading your message wrong, but I think I know what you mean, because it sounds exactly what I am trying to achieve... however, I'm yet to find a way to represent my thinking on competitive advantage and earnings cycles in a mathematical fashion that seems to make complete sense.
Part of me thinks that there must be a better way to represent earnings power than is represented in the text books as standard DCF practice* . Am I correct in saying that your method diverged from this over the course of your journey this far? Picking a forecast cash flow for year 1, 2, 3, 4 and so on however far you want to go into the future seems a bit counter-intuitive to me. Your posts read to me that you do something different to this (although it's hard to discern how far different).
*Standard text book is similar to the 25 years spread sheet you posted.