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