Archives: Resources

Cash Ratio Template

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…

Continue reading

Accounts Receivable Turnover Ratio Template

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

Continue reading

Accounts Payable Turnover Ratio Template

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…

Continue reading

Dividend Coverage Ratio Template

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…

Continue reading

Cash Conversion Ratio Template

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

Continue reading

Days Inventory Outstanding Template

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)?…

Continue reading

Year to Date (YTD) Template

Year to Date (YTD) Template This Year to Date (YTD) template will guide you on how to calculate the year to date return on a portfolio or a stock for different end dates. Here is a screenshot of the template: Download the Free Template What is Year to Date (YTD)? Year to Date (YTD) refers…

Continue reading

Operating Cash Flow Ratio Template

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…

Continue reading

Net Debt/EBITDA Ratio Template

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…

Continue reading

Interest Coverage Ratio Template

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…

Continue reading
0 search results for ‘