The only data I see that you are missing is 'minority interest' & 'preferred stock'. You would add those two items in the same way as total liabilities because they are debts, not often included in Total Liabilities but sometimes are, that a business would need to pay just like a debt if they purchased the entire business. Therefore:
EV = Market Capitalization + Total Liabilities + Minority Interest + Preferred stock – Excess Cash & Equivalents.
Your Excess Cash & Equiv. is correct.
So now we come to an important question; that of Market Capitalization. If the Market Cap. of a company is currently 'X', how do we know if that is in rational judgment? The biggest problem I have with EV is its use of Market Capitalization as the starting point to finding its value. If we declare Market Cap as a rational expression of the true asset value of a business then we also affirm that the business is being priced efficiently. Since the main job of the value investor is to find price inefficiencies, I suggest, rather than using Market Cap as your starting point, you should use either Book Value or Tangible Book Value (preferably) as your starting point.
Let's look at an example:
Gannett (NYSE: GCI)
Market Capitalization: $3.56B
Book Value Equity: $1.38B
Cash & Equivalents: 123.77M
Goodwill: $2.87B
Total Liabilities: $5.73B
Minority Interest: $214M
Preferred Stock: $0
Total Shares Out: 236.24M
TCL is smaller than TCA so 0 is greater.
Current Share Price: $15.08 p/s
If we beleived that the investing world for the most part was of a rational mind then we'd use Market Cap as our starting point.
$3.56B + $5.73B + $214M – $123.77M = $9.38B / 236.24M = $39.71 Per Share
Now, a more rational expectation in my opinion is to start with the Book Value of Equity and deduct goodwill:
$1.38B + $5.73 + $214M – $2.87B – 123.77M = $4.33B / 236.24 = $18.33 Per Share
Note: I would also deduct items that carry no value that are often found on the balance sheet; but you need to read the SEC filings with a fine toothed comb to find out what these items are. For example: 'other assets' could consists of $10 Million worth of toothpicks in which case their value would most likely be useless unless the purchasing business operates in the toothpick business.
In any event, this is the way I use Enterprise Value and it makes the most sense to me.
Jim