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 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 moreDupont Analysis in Excel with MarketXLS Template

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