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):
||EBIT / Enterprise Value
||Pre-Tax Return on Tangible Capital
- The EBIT / Enterprise Value of 10.4% is High.
- The Pre-Tax Return on Tangible Capital Value of 89.3% is Very High.
- Near-term Financial Health appears to be Excellent. The Current Ratio is 3.17.
- A stock review of MSFT is available as part of our subscriber content.
Using data from quarter ended 2013-12-31.
|MarketCap||=||StockPrice * Shares|
|=||37.90 * 8,395|
|ExcessCash||=||Cash - MAX(0; (CurrentLiabilities - CurrentAssets + Cash))|
|=||83,944 - MAX(0; (33,742 - 106,870 + 83,944))|
|EnterpriseValue||=||MarketCap + TotalDebt - ExcessCash|
|=||318,170 + 22,976 - 73,128|
|TangibleInvestedCapital||=||TotalAssets - Goodwill - Intangibles - CurrentLiabilities + ShortTermDebt - ExcessCash - MinorityInterest|
|=||153,543 - 14,680 - 2,945 - 33,742 + 2,300 - 73,128 - 0|
|EarningsYield||=||(OperatingEarnings - MinorityInterest) / EnterpriseValue|
|=||(27,988 - 0) / 268,018|
|PreTaxReturnOnTangibleCapital||=||OperatingEarnings / TangibleInvestedCapital|
|=||27,988 / 31,348|
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