Content
Content
Stocks
Stocks

Single Stock Statistics Calculator

You need to have a MagicDiligence Membership to use the Statistics Calculator. You can log in here. Guests can run 5 stocks a day, and paid members have unlimited usage.

Get the FREE report, 5 Quick and Easy Tips for Improving Your Stock Picks, by signing up for our FREE newsletter!

Below is an example of the output, for Microsoft (MSFT):

Ticker:      

Microsoft Corporation


$46.62
$391.6 Billion
8.1%
84.4%
2.50
Logo

Instant Diligence

  • The EBIT / Enterprise Value of 8.1% is Average.
  • The Pre-Tax Return on Tangible Capital Value of 84.4% is Very High.
  • Near-term Financial Health appears to be Excellent. The Current Ratio is 2.50.
  • A stock review of MSFT is available as part of our subscriber content.

Calculations

Using data from quarter ended 2014-06-30.

MarketCap=StockPrice * Shares
=46.62 * 8,399
=391,561

ExcessCash=Cash - MAX(0; (CurrentLiabilities - CurrentAssets + Cash))
=85,709 - MAX(0; (45,625 - 114,246 + 85,709))
=68,621

EnterpriseValue=MarketCap + TotalDebt - ExcessCash
=391,561 + 22,645 - 68,621
=345,585

TangibleInvestedCapital=TotalAssets - Goodwill - Intangibles - CurrentLiabilities + ShortTermDebt - ExcessCash - MinorityInterest
=172,384 - 20,127 - 6,981 - 45,625 + 2,000 - 68,621 - 0
=33,030

EarningsYield=(OperatingEarnings - MinorityInterest) / EnterpriseValue
=(27,886 - 0) / 345,585
=0.081 (8.1%)

PreTaxReturnOnTangibleCapital=OperatingEarnings / TangibleInvestedCapital
=27,886 / 33,030
=0.844 (84.4%)

Get our stock reviews and other Magic Formula focused content delivered FREE to your inbox. Sign up for the MagicDiligence Newsletter! For a limited time, you'll also get the FREE report, 5 Quick and Easy Tips for Improving Your Stock Picks!
Get Your FREE Report Now

We will NEVER give out your email address. Period.

Joel Greenblatt and MagicFormulaInvesting.com are not associated in any way with this website. Neither Mr. Greenblatt or MagicFormulaInvesting.com endorse this website's investment opinions, strategy, or products. Investment recommendations on this website are not chosen by Mr. Greenblatt, nor are they based on Mr. Greenblatt's proprietary investment model, and are not chosen by MagicFormulaInvesting.com. Magic Formula® is a registered trademark of MagicFormulaInvesting.com, which has no connection to this website. The information on this website is for informational purposes only and solely represents the views and opinions of the author. No warranty is provided or implied as to the accuracy, completeness, or timeliness of this information. This information may not be construed as investment advice of any kind, nor can it be relied upon as the basis for stock trades. Alexander Online Properties LLC, the proprietor of this website, is not responsible in any way for losses or damages resulting from the use of this information. Alexander Online Properties LLC is not a registered investment advisor. All logos are trademarked properties of their respective companies.

© 2008-2014 Alexander Online Properties LLC