## 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 …

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

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 …

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 …

## 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 …

## Sortino Ratio in Excel

We know that Sharpe ratio is one of the most common ratios to measure the reward versus risk of an investment opportunity. Sortino ratio is a modified version of Sharpe ratio. While Sharpe ratio measures the return over the overall risk (volatility) in the portfolio, Sortino ratio only considers the downside risk in the portfolio. …

## Ben Graham Formula

Better Investments, Faster Decisions, Better Research Book your demo Meet the #1 Excel-based Investment Research Solution for Serious Investors Benjamin Graham, popularly known as the ‘father of value investing’, provided an elaborate framework to identify undervalued stocks. he proposed this in his books ‘Security Analyst’ and ‘The Intelligent Investor’. He also proposed a simple intrinsic value formula …

## Calculate Sharpe Ratio of Portfolio in Excel (with MarketXLS)

Sharpe ratio is one of the most commonly used ratios to measure the reward versus risk of an investment opportunity. In this article, we will learn about what Sharpe Ratio is, how it is calculated, and how to calculate the Sharpe Ratio of Portfolio in Excel using MarketXLS.What is Sharpe Ratio?The Sharpe ratio was developed …

## Cash Generating Power Ratio

While performing financial analysis, most analysts first focus on the commonly used balance sheet and income statement ratios. However, such analysis is often incomplete because the ratios calculated from the statement of cash flows can provide significant insights and add tremendous value to any financial analysis, whether it for for picking stocks, raising capital, or …

## 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, …

## Value Stocks with DCF Model in Excel

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 …