Subscribe Now!
MD Tools
MagicDiligence Screens
Single Stock Stats Calculator
Links
Magic Formula Screen
Contact MagicDiligence
Single Stock Statistics Calculator
You need to have a MagicDiligence account to use the Statistics Calculator. Please log in. Free members can run 5 stocks a day, and paid members have unlimited usage. Sign up here or learn about the MagicDiligence Membership!
Below is a sample of the output for Microsoft (MSFT).
Results for ticker 'MSFT' (Microsoft Corporation):
| Earnings Yield: | 11.7% |
| Tangible Return on Capital: | 154.9% |
MagicDiligence Research for 'MSFT':
Research Available for MSFT! (full membership required - upgrade here)
Instant Diligence:
The Earnings Yield of 11.7% is High.
The Tangible Return on Capital of 154.9% is Very High.
Near-term Financial Health appears to be Excellent. The current ratio is 2.86.
Calculations:
(for quarter ended 2011-12-31)
| Market Cap | = | Stock_Price * Shares |
|---|---|---|
| = | 31.44 * 8465.00 | |
| = | 266139.00 |
| Excess Cash | = | Cash - MAX(0; (Current Liabilities - Current Assets + Cash)) |
|---|---|---|
| = | 51736.00 - MAX(0; (25373.00 - 72513.00 + 51736.00)) | |
| = | 47140.00 |
| Enterprise Value | = | Market Cap + Total Debt - Excess Cash |
|---|---|---|
| = | 266139.00 + 11932.00 - 47140.00 | |
| = | 230931.00 |
| Tangible Invested Capital | = | Total Assets - Goodwill - Intangibles - Current Liabilities + Short Term Debt - Excess Cash - Minority Interest |
|---|---|---|
| = | 112243.00 - 19670.00 - 2581.00 - 25373.00 + 0.00 - 47140.00 - 0.00 | |
| = | 17479.00 |
| Earnings Yield | = | (Operating Earnings - Minority Interest) / Enterprise Value |
|---|---|---|
| = | (27077.00 - 0.00) / 230931.00 | |
| = | 0.117 (11.7%) |
| MFI Return on Capital | = | Operating Earnings / Tangible Invested Capital |
|---|---|---|
| = | 27077.00 / 17479.00 | |
| = | 1.549 (154.9%) |
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 advice, 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. 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. 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 is not a registered investment advisor.
© 2008-2011 Alexander Online Properties