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)

Change in Working Capital (How to Interpret and Calculate) in Excel with MarketXLS

working capital multiple companies

What is working Capital and how to calculate it in Excel with MarketXLS Analysts and investors will frequently refer to something called the net working capital. Or a lot of times they will just call it working capital for short. So working capital is very simple it’s like the current assets minus the current liabilities …

Read moreChange in Working Capital (How to Interpret and Calculate) in Excel with MarketXLS

Download Gordon Growth Model in Excel (with MarketXLS™ Template)

Gordon Growth Model in Excel

Gordon Growth Model is a popular valuation model that analysts use to calculate the intrinsic value of a stock based on the expected dividends in the future. In this article we will learn about what Gordon Growth Model is and how we can build the Gordon Growth Model in Excel. Consider a company that is …

Read moreDownload Gordon Growth Model in Excel (with MarketXLS™ Template)

Using MarketXLS and Excel to easily see a real time snap shot of your portfolio

I have been learning to invest over the past 2 years—it is so much fun! My investments are spread over 3 different brokerage accounts, but I like to look at all of them together. MarketXLS, combined with my knowledge of Excel, allows me to manage my stock portfolio in Excel. Since I’m only about 2 …

Read moreUsing MarketXLS and Excel to easily see a real time snap shot of your portfolio

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)

Fibonacci Retracement Calculator

Fibonacci Retracement is a popular technical analysis tool to identify potential reversal levels, support and resistance levels. Traders (specially day traders) frequently use this to track their trades. These are tracked in the form of ratios which are based on Fibonacci sequence which was developed by an Italian mathematician named Leonardo Fibonacci. The Fibonacci sequence …

Read moreFibonacci Retracement Calculator

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