As my inaugural post, I am providing my detailed model of LVLT revenues, costs, earnings, and cashflow. It is a multi-page spreadsheet, and is more comprehensive than anything I find in analyst reports etc. I don’t claim perfection, if you find an error or have a suggestion for improvement please let me know.
My model allows the study of each business unit independently, calculating the total gross margin from the individual components. For historical data, I work backwards from the actual results using various assumptions in order to give a consistent context to the same numbers going forward.
Best usage is with Internet Explorer with Office installed, because you can change assumptions etc on the page just like a real spreadsheet. A drawback however is that the size and format of the embedded spreadsheet is a bit uglier and the column headings are hard to read. Here is that link:
You can view the same model in Firefox or other browsers, without Office. It will not be interactive (meaning you have to live with my assumptions), but it is easier to read. Here is a link to that one:
Remember that in both cases, there are multiple sheets, click on the sheet name at the bottom to switch back and forth. All sheets are interconnected.
If you haven't already, please take our Reader Survey! Just 3 questions to help us better understand who is reading Telecom Ramblings so we can serve you better!
Categories: Financials · Internet Backbones
Join Our LinkedIn Group
OUTSTANDING & thanks for all of your time!
Toes; just a really great job on the site and of course the model. ill go over it in detail in the future. Thanks for setting this up. I hope when i click on the google ads youre getting a few bucks too. thejuice.
Toes:
I have been waiting impatiently for almost ten years for someone to get his, or her arms around this pig. you have done it, and it is much appreciated. Bravo!
Steve.