What are Relative Valuation Models? Relative valuation models are used to value companies by comparing them to other businesses based on certain metrics such as EV/Revenue, EV/EBITDA, and P/E ratios. The logic is that if similar companies are worth 10x earnings, then the company that’s being valued should also be worth 10x its earnings. This…
Dividend Payout Ratio Template This Dividend Payout Ratio Template will show you how to calculate the dividend payout ratio using the formula: DPR = Total dividends / Net income. Here is a preview of the template: Download the Free Template What is Dividend Payout Ratio (DPR)? The Dividend Payout Ratio (DPR) is the amount of…
Acid Test Ratio Template This Acid Test Ratio Template will show you how to calculate the acid test ratio the formula: (Current Assets – Inventory) / Current Liabilities. Here is a preview of the template: Download the Free Template What is the Acid-Test Ratio? The Acid-Test Ratio, also known as the quick ratio, is a…
Fixed Charge Coverage Ratio Template This Fixed Charge Coverage Ratio Template will show you how to compute the fixed charge coverage ratio using annual expenses and EBITDA figures. Here is a preview of the template: Learn more about the fixed charge coverage ratio and other important ratios to track financial health in CFI’s Loan Covenants…
Cash Ratio Template This Cash Ratio Template will show you how to calculate the cash ratio which measures a company’s ability to pay off short-term debt obligations with cash and cash equivalents. Here is a preview of the template: Download the Free Template What is Cash Ratio? The cash ratio, sometimes referred to as the…
Accounts Receivable Turnover Ratio Template This Accounts Receivable Turnover Ratio Template will show you how to calculate receivable turnover ratio and receivable turnover in days. Below is the screenshot of the template: Download the Free Template What is the Accounts Receivable Turnover Ratio? The accounts receivable turnover ratio, also known as the debtor’s turnover ratio,…
Accounts Payable Turnover Ratio Template This Accounts Payable Turnover Ratio Template will show you how to calculate payable turnover ratio and payable turnover in days. Below is the screenshot of the template: Download the Free Template What is the Accounts Payable Turnover Ratio? The accounts payable turnover ratio, also known as the payables turnover or…
Dividend Coverage Ratio Template This Dividend Coverage Ratio Template will show you the calculation for dividend coverage ratios for common shareholders and preferred shareholders. Below is the screenshot of the template: Download the Free Template What is Dividend Coverage Ratio (DCR)? The Dividend Coverage Ratio, also known as dividend cover, is a financial metric that…
Cash Conversion Ratio Template This Cash Conversion Ratio Template will demonstrate how to calculate the cash conversion rate using the income statement and cash flow statement. Here is a preview of the template: Download the Free Template What is the Cash Conversion Ratio (CCR)? The Cash Conversion Ratio (CCR), also known as cash conversion rate,…
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)?…
