Level 3 Communications interactive model


My LVLT model has been available for download as a PDF file for years (found here) however it’s based on my input. I’ve set up a test page where you can test your own assumptions by applying your own input in highlighted grey areas on the first tab titled “Level 3 Model Assumptions” . The first (grey background) column are ratios you feel should be appropriate. The remaining columns for CNS rev growth, capex & margins apply to each year. To start over just refresh this page. FV is noted to the left. The “Summary” tab at the bottom will reflect your assumptions.

Present Fair Value (FV) is discounted from 2019 results. Any changes in revenue growth for any year will effect FV since they are cumulative. Changes in 2019 capex & margins will affect FV; other years are for completing the summary tab at the bottom.

The link is at: https://iiex.sharepoint.com/Pages/LVLT_Interactive_Model.aspx

Advertisements

About IIEX

Click "About" in the menu at the top for more information about the author. We also have a page at "Seeking Alpha" ( http://seekingalpha.com/author/david-klein ). Please Click on and read the "Disclaimer" in the menu at the top. Have a question? Contact us at iiex@live.com.
This entry was posted in LVLT, Stocks and tagged , , , , , . Bookmark the permalink.

One Response to Level 3 Communications interactive model

  1. IIEX says:

    $LVLT – Added a detailed quarterly income statement tab that reflects the choices made. http://bit.ly/1hfz0oX

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s