Liberty Broadband valuation spreadsheet

Use this link to access my Google Drive spreadsheet.  It may or may not be helpful in figuring out whether one should buy CHTR or LBRDA/B/K.  Please be careful because the spreadsheet may contain errors…

Here are some issues to watch out for:

  1. The value of TruePosition is uncertain.  I assumed $300M.  See my post on TruePosition and on the Broadband spin.
  2. The present value of the deferred tax liabilities is uncertain.  It might be reasonable to assume that $1 due in the future is worth $0.20 today.  I think that Malone will not dispose of his Charter or TWC shares in a tax-inefficient manner any time soon.  He could conceivably hold onto Charter for decades.  He may very well swap TWC shares with TWC for shares in the TWC+Comcast spinoff that will be managed by Charter.  So, I think that he will defer the taxes on TWC shares for a very, very long time.
  3. I have no idea what the cost basis is for the TWC shares.  I suspect that it is something extremely low.  However, Broadband’s financial statements in the S-1 spinoff filing shows that Broadband’s deferred tax liabilities are extremely low.  In any case, the DTLs on the TWC shares aren’t particularly significant.
  4. EDIT (8/26/2014): I don’t think I handled the call options that were sold on the TWC shares correctly.
  5. I ignore all of Liberty Broadband’s other assets and liabilities.  I don’t think that they are material compared to what TruePosition is worth.
  6. I may have performed the rights offering calculation incorrectly.
  7. I may have handled the diluted share count incorrectly.

*Disclosure:  I already own LMCA.  My plan is to hold onto my shares of the parent and the spinoff.

Advertisements

9 thoughts on “Liberty Broadband valuation spreadsheet

  1. Nice work- How did you determine TruePosition’s valuation at $300mm? Seems high given that it has been losing contracts and may also lose another big contract soon.

  2. Pingback: LMCA and LBRDA valuation spreadsheets | Glenn Chan's Random Notes on Investing

  3. Pingback: Thoughts on the Charter / Time Warner merger | Glenn Chan's Random Notes on Investing

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