NCAV Screener

NCAV Screener

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 moreNCAV Screener

Earnings Power Value Spreadsheet Using MarketXLS

Earnings Power Value

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 moreEarnings Power Value Spreadsheet Using MarketXLS

Magic Formula Investing Screener in Excel

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 moreMagic Formula Investing Screener in Excel

Balance Sheet Ratios in Excel using MarketXLS

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 moreBalance Sheet Ratios in Excel using MarketXLS

Calculate Piotroski F-score in Excel using MarketXLS

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 moreCalculate Piotroski F-score in Excel using MarketXLS

Dupont Analysis in Excel with MarketXLS Template

dupont analysis in Excel

Dupont analysis in Excel with MarketXLSDupont 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 1920’s. … Read moreDupont Analysis in Excel with MarketXLS Template

Stock Screener: In-depth Research of a Stock

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 moreStock Screener: In-depth Research of a Stock

Stock Screener: Comparing Stocks for Fundamentals History

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 moreStock Screener: Comparing Stocks for Fundamentals History