The Acquirer’s Multiple – BackgroundMany people have heard of the infamous Magic Formula documented by Joel Greenblatt in his book “The Little Book That Beats the Market” which is a direct quantitative value investment model in ranking stocks by price and ROIC. In a similar nature, The Acquirer’s Multiple founded by Tobias Carlisle is a … Read more
Why Monthly Dividend Stocks Seasoned investors interpret dividends as the cash payments disbursed to shareholders monthly, quarterly, semi-annually, or annually; or frankly the system for reinvestments. As for the beginning investor – dividends can be treated as passive income. It is pretty straightforward – corporate earnings not used for expansion are issued to shareholders periodically. … Read more
What is Cash Conversion Cycle? The cash conversion cycle (CCC) is an inventory efficiency and cash flow metric. Companies use CCC to determine the number of days that it takes to convert resources inputs into cash flows. The purpose of the CCC is to measure the length of time each dollar, put into the business, … Read more
What is Times Interest Earned Ratio Times interest earned ratio indicates a company’s ability to meet interest payments when they come due. The higher the ratio the more easily the company can meet its interest expenses. Times interest earned ratio is also known as Interest Coverage Ratio Typically you would look at this ratio along with … Read more
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 more
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 more
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 more
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 more
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 more
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 more
