Investors are always looking for ways to identify deep value stocks and their are many investment philosophies to help them with their goals. Among them, one of the most famous models of value investing is the Benjamin Graham NCAV Screener. Benjamin Graham is considered to be the father of value investing and is the author … Read more
Investors use many valuation metrics while screening stocks for possible investments. This includes valuation ratios such as Price to Earnings ratio, price to book value, price to sales, price to cash flow and many others. While all these valuations metrics are good, one that has been attracting many investors is the Free Cash Flow Yield. … Read more
While there are many methods to arrive at the intrinsic value of the stock for value investing, one approach is the Earnings Power Value, or EPV. A Columbia University Professor Bruce Greenwald developed this approach. In this article we will learn about the Earnings power Value method to value investing and we will also build … Read more
Magic formula investing is a well-known investment technique popularized by Joel Greenblatt in his book “The Little Book That Still Beats the Market”. This is a value investing approach that outlines how investors can systematically apply a formula to buy stocks in good companies at affordable prices. In magic formula investing, we rank companies by … Read more
We know that a company’s balance sheet provides a snapshot of a company’s financial position at a particular time. By looking at the balance sheet of a company, an investor can get lots of simple yet valuable insights. This includes things such as the company’s cash positions, its assets, its debt obligations, and more. However, … Read more
In this article, we will learn about how to value stocks with DCF model in excel. The Discounted Cash Flow Model, or popularly known as the DCF Model, is one of the more widely used equity valuation models in the investment industry. The underlying principle behind the DCF valuation model is that a business is … Read more
The biggest challenge any value investor faces is to screen the best stocks for investment and filter out the bad ones. While there are many strategies that investors use to identify value stocks, one recommended strategy is the Piotroski’s F-score strategy that focuses on identifying winning stocks. In this article, we will learn about what … Read more
Dupont analysis in Excel with MarketXLS Dupont analysis is a way to look at two ratios, ROA and ROE. Mainly, we decompose these ratios and look at different parts of these, so maybe we can get a better understanding of what is going on in the firm. Scientists at Dupont Corporation first used Dupont analysis in the … Read more
In the previous article, we learnt about how you can use our stock screeners to prioritize and research stocks. In this article we will focus on our first screener ‘In-depth Research of a Stock’ that to conduct research on a shortlisted stock. This screener is that it brings all the fundamental analysis data for all the … Read more
The MarketXLS stock screeners are designed to help you prioritize and research stocks in the most efficient way. If you want to learn how the stock screeners work, you should read our articles Stock Screeners by MarketXLS and Stock Screener: In-depth Research of a Stock. In this article, we will focus on our stock screener … Read more
