LVLT growth model

May 7th, 2008 by · 3 Comments

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:

Interactive Model

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:

Non-interactive model

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 the Discussion!

3 Comments So Far

  • Travis299 says:

    OUTSTANDING & thanks for all of your time!

  • thejuice212 says:

    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.

  • douglass530 says:


    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!

Leave a Comment

You may Log In to post a comment, or fill in the form to post anonymously.

  • Ramblings’ Jobs

    Post a Job - Just $99/30days
  • Event Calendar