Updated Level 3 Model and Projections for Q3 2008

July 31st, 2008 by Rob Powell · 4 Comments

I have updated my financial model for Level 3 Communications (LVLT), and along with it come some basic projections for the Q3 and Q4.  Along with those numbers comes the assumption that Level 3 will show sales growth in the third and fourth quarters and that SG&A will continue to drop as a percentage of revenue, both as indicated by management.

There are two versions:

  • The Interactive Model - for those with IE and the Office plugin (get it here).  The assumptions can be changed and the effects seen on each following sheet.
  • The Noninteractive Model - for those with Firefox or other browsers etc.  This is read only, unfortunately.

For those less interested in playing with the numbers, and more interested in projections, here they are.  Core Revenue should be about $975-980M in Q3, and jump to $1010-1030M in Q4.  Total revenues should drop slightly to $1080-1090M in Q3, then finally exceed $1100M in Q4.  Ebitda for Q3 should come in around $255M, and for Q4 should surge to around $280M.   Free cashflow is relatively certain to be positive for both quarters, since working capital should swing back as it does every year.  I do not expect substantial changes to gross margins, and while I expect SG&A to drop only slightly each quarter, as a percentage of revenue it drops more quickly due to revenue growth as we go forward.

Now What?

Print it! Print it!
Email it! Email it!
 Subscribe via RSS
 Subscribe via Email
 Subscribe to Comments

Join the Discussion!

4 Comments


Leave a Reply