An Update to TheJuice’s LVLT Model

Ramblings' Choice

Resources

Community

An Update to TheJuice’s LVLT Model

March 3rd, 2009 by thejuice212 · Leave a Comment

Hello everyone! Attached are the updated Level 3 Communications (NASDAQ:LVLT - chart, news, filings) models based on data for the recently filed 10k. What I’ve done is include the three main models I will use this year to track our performance. The first model is my perception of Q1 results. As you can see I’m thinking we are going to see a drop in top-line but continued strength in sga/cogs improvements.

<a href="http://spreadsheets.google.com/pub?key=pGPzzGG6YFREOaWxPxqr2TA&output=html&gid=2&single=true&widget=true" onclick="javascript:_gaq.push(['_trackEvent','outbound-article','spreadsheets.google.com/pub?key=pGPzzGG6YFREOaWxPxqr2TA&output=html&gid=2&single=true&widget=true']);">Link to document</a>

The next model is my update on the FY09 results. This is going to be all over the place but after reading the 10k and chatting with some folks this represents my best estimate. Feel free to throw darts as some of the rev growth is back-end loaded which assumes revs pick up just a tad in Q3/Q4 (not much mind you).

<a href="http://spreadsheets.google.com/pub?key=pGPzzGG6YFREOaWxPxqr2TA&output=html&gid=3&single=true&widget=true" onclick="javascript:_gaq.push(['_trackEvent','outbound-article','spreadsheets.google.com/pub?key=pGPzzGG6YFREOaWxPxqr2TA&output=html&gid=3&single=true&widget=true']);">Link to document</a>

Finally, here’s the ev/ebitdas model. Not much to say here, other than the obvious, we need to show some growth to get our premium multiple back!

<a href="https://spreadsheets.google.com/pub?key=pGPzzGG6YFREOaWxPxqr2TA&output=html&gid=4&single=true&range=K1:Q31" onclick="javascript:_gaq.push(['_trackEvent','outbound-article','spreadsheets.google.com/pub?key=pGPzzGG6YFREOaWxPxqr2TA&output=html&gid=4&single=true&range=K1:Q31']);">Link to document</a>

Please shoot me any suggestions, corrections or questions.