Margin of safety analysis of stocks with formula in Excel (with MarketXLS)

Let us find out if there is a fast and easy way to screen stocks that are underpriced by the market using margin of safety analysis of stocks. Margin of safety analysis of stocks Key Concepts Before we get down to the analysis, let us understand the key concepts we will use to perform this … Read moreMargin of safety analysis of stocks with formula in Excel (with MarketXLS)

Covered Call Income Generation (With Excel Template)

Covered Call Income Generation

Investors who generally follow a buy and hold strategy can make an extra income by adding options to their portfolio. In this article, we will learn about the covered call income generation strategy and how investors who are long underlying stocks can generate additional income with minimal risk. At the end of the article, you … Read moreCovered Call Income Generation (With Excel Template)

Altman’s Z score in Excel Calculator (Includes MarketXLS Template)

What is Altman’s Z score and what it is used for? In this article, I will provide you with a quick introduction to Altman Z score for public companies and how to calculate Altman z score in Excel using MarketXLS functions. Altman’s Z score is probably one of the more famous credit scoring models have … Read moreAltman’s Z score in Excel Calculator (Includes MarketXLS Template)

Warren Buffet Investment Portfolio Through The Last 50 Years

In 2014 Berkshire Hathaway Inc. celebrated fifty years in the market. On that occasion Warren Buffet made some observations regarding his company’s performance through the years. There have great gains and great losses but no one can discount his long innings in the stock market. His career has usually been looked at with awe. For … Read moreWarren Buffet Investment Portfolio Through The Last 50 Years

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

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