Days Inventory Outstanding Template This Days Inventory Outstanding Template will show you how to arrive at the number of days inventory outstanding using the formula: Average Annual Inventory / Cost of Sales x # of Days in Period. Here is a screenshot of the template: Download the Free Template What is Days Inventory Outstanding (DIO)?…
Operating Cash Flow Ratio Template This Operating Cash Flow Ratio template will show you how to calculate the operating cash flow ratio, deriving from the formula: operating cash flow divided by current liabilities. Here is a screenshot of the template: Download the Free Template What is the Operating Cash Flow Ratio? The Operating Cash Flow…
Net Debt/EBITDA Ratio Template This Net Debt/EBITDA Ratio template will show how to calculate the interest coverage ratio using the formula: (Short Term Debt + Long Term Debt – Cash and Cash Equivalent) / EBITDA. Here is a screenshot of the template: Download the Free Net Debt/EBITDA Template What is the Net Debt to EBITDA…
Interest Coverage Ratio Template This Interest Coverage Ratio template will guide you through the calculation of interest coverage ratio using an income statement. Here is a screenshot of the template: What is Interest Coverage Ratio (ICR)? The Interest Coverage Ratio (ICR) is a financial ratio that is used to determine the ability of a company…
Return on Capital Employed (ROCE) Template This Return on Capital Employed (ROCE) template will help you calculate the profitability ratio used to measure how efficiently a company is using its capital. Here is a screenshot of the template: Download the Free Template What is Return on Capital Employed? Return on Capital Employed (ROCE), a profitability ratio,…
Net Profit Margin Template This Net Profit Margin template will show you how to calculate the net profit margin using a company’s income statement line items. Here is a screenshot of the template: Download the Free Template What is Net Profit Margin? Net Profit Margin (also known as “Profit Margin” or “Net Profit Margin Ratio”)…
P/E Ratio Template This P/E ratio template will show you how to calculate the Price-to-Earnings multiple using share price and earnings per share. Here is a screenshot of the template: Download the Free Template What is the Price Earnings Ratio? The Price Earnings Ratio (P/E ratio) is the relationship between a company’s stock price and…
What is the Multiple-Period Dividend Discount Model? A multiple-period dividend discount model is a variation of the dividend discount model. It is often used in situations when an investor is expecting to buy a stock and hold it for a finite number of periods and sell the stock at the end of the holding period….
What is the Dividend Discount Model? The Dividend Discount Model (DDM) is a quantitative method for valuing a company’s stock price, assuming that the current fair price equals the sum of all future dividends discounted to present value. Breaking Down the Dividend Discount Model The dividend discount model was developed under the assumption that the intrinsic value of…
