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

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 …

Read moreBen Graham Formula

Calculate Sharpe Ratio of Portfolio in Excel (with MarketXLS)

Sharpe Ratio of Portfolio in Excel

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 …

Read moreCalculate Sharpe Ratio of Portfolio in Excel (with MarketXLS)

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 …

Read moreCash Generating Power Ratio