<?xml version="1.0" encoding="UTF-8" standalone="yes"?><oembed><version><![CDATA[1.0]]></version><provider_name><![CDATA[Glenn Chan&#039;s Random Notes on Investing]]></provider_name><provider_url><![CDATA[https://glennchan.wordpress.com]]></provider_url><author_name><![CDATA[GlennC]]></author_name><author_url><![CDATA[https://glennchan.wordpress.com/author/glennchan/]]></author_url><title><![CDATA[Liberty Broadband valuation&nbsp;spreadsheet]]></title><type><![CDATA[link]]></type><html><![CDATA[<p><a href="https://docs.google.com/spreadsheets/d/1g1ZIuZWFOS5ep6CsKR0el-Icz6c1R_tGUpip0bsJVtA/edit?usp=sharing">Use this link to access my Google Drive spreadsheet</a>.  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&#8230;</p>
<p><!--more--></p>
<p>Here are some issues to watch out for:</p>
<ol>
<li>The value of TruePosition is uncertain.  I assumed <strong>$300M</strong>.  See my post on <a title="(LMCA) Is there hidden value in TruePosition?" href="https://glennchan.wordpress.com/2014/06/30/lmca-is-there-hidden-value-in-trueposition/">TruePosition</a> and on <a title="(LMCA) Liberty Broadband spin-off" href="https://glennchan.wordpress.com/2014/07/28/lmca-liberty-broadband-spin-off/">the Broadband spin</a>.</li>
<li>The present value of the deferred tax liabilities is uncertain.  It might be reasonable to assume that $1 due in the future is worth <strong>$0.20</strong> 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.</li>
<li><em>I have no idea what the cost basis is for the TWC shares</em>.  I suspect that it is something extremely low.  However, Broadband&#8217;s financial statements in the <a href="http://www.sec.gov/Archives/edgar/data/1611983/000104746914006379/a2220790zs-1.htm">S-1 spinoff filing</a> shows that Broadband&#8217;s deferred tax liabilities are extremely low.  In any case, the DTLs on the TWC shares aren&#8217;t particularly significant.</li>
<li>EDIT (8/26/2014): I don&#8217;t think I handled the call options that were sold on the TWC shares correctly.</li>
<li>I ignore all of Liberty Broadband&#8217;s other assets and liabilities.  I don&#8217;t think that they are material compared to what TruePosition is worth.</li>
<li>I may have performed the rights offering calculation incorrectly.</li>
<li>I may have handled the diluted share count incorrectly.</li>
</ol>
<p><em>*Disclosure:  I already own LMCA.  My plan is to hold onto my shares of the parent and the spinoff.</em></p>
]]></html></oembed>