Visualizing the Magic Formula using a scatter plot for companies less than 2 billion.
The X-Axis represents EV/EBIT as a measure of “cheap companies”. The Y-axis attempts to rank “good companies” using the average ROIC over the past 4 years.
The upper left quadrant clusters good (high ROIC) and cheap companies (low EV/EBIT) and with the same color. The lower left is cheap companies but not as “good” (high ROIC) as the upper left quad.
Plug and play to find companies reducing shares outstanding from 2015 to the MRQ or total liabilities. Industry, financial strength, revenue growth, exchange, market size are also options.
var divElement = document.getElementById(‘viz1522336597706’); var vizElement = divElement.getElementsByTagName(‘object’)[0]; vizElement.style.width=’100%’;vizElement.style.height=(divElement.offsetWidth*0.75)+’px’; var scriptElement = document.createElement(‘script’); scriptElement.src = ‘https://public.tableau.com/javascripts/api/viz_v1.js’; vizElement.parentNode.insertBefore(scriptElement, vizElement);
Supporting Data, Export to Excel at bottom
var divElement = document.getElementById(‘viz1522336647098’); var vizElement = divElement.getElementsByTagName(‘object’)[0]; vizElement.style.width=’100%’;vizElement.style.height=(divElement.offsetWidth*0.75)+’px’; var scriptElement = document.createElement(‘script’); scriptElement.src = ‘https://public.tableau.com/javascripts/api/viz_v1.js’; vizElement.parentNode.insertBefore(scriptElement, vizElement);
Article by Shadow Stock
