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. [Read more →]