Accounting Ratios: Comprehensive Excel Template

 If you want to analyze private or publicly traded companies, these Accounting ratios will help give some perspective. All ratios include a description of what it is, what a 'good' value is in terms of higher or lower, and the relevant financial statements that are needed to calculate each ratio. The formatting was done to make tracking over time easy and straight forward for comparison of the same company over time or to other companies in the same industry.



Pricing


After purchase the template will be sent to your PayPal / Purchasing email address. This template is a part of the Accounting template bundle.

Ratios Included:

  • Working Capital - Equals current assets divided by current liabilities. Higher is better.
  • Quick Ratio - Equals current assets LESS inventory divided by current liabilities. Higher is better.
  • Earnings per Share - Net income for period divided by weighted average outstanding shares in the same period. Higher is better.
  • Price-to-Earnings - Net income for period divided by weighted average outstanding shares in the same period.
  • Debt-to-Equity - Long and short-term debt divided by book value of shareholders equity. - Lower is better.
  • Return-on-Equity - Common equity divided by (net earnings after tax less preferred dividends) - Higher is better.
  • Gross Margin - Total revenues less variable costs divided by total revenues. - Higher is better.
  • Profit Margin - Total revenues less all expenses (fixed/variable/otherwise/taxes) divided by total revenues. - Higher is better
  • Dividend Payout - Total dividends paid out in period divided by net income in period.
  • Berry - Gross profit divided by operationg expenses. Higher is better.
  • Return On Investment - Total returned cash less initial investment divided by initial investment. Higher is better.
  • Accounts Receivable Turnover - Shows how efficient A/R collections are. Higher is generally better.
  • Days Sales in Inventory - Shows how long it takes to sell inventory. Lower is generally better.
  • Inventory Turnover - Shows how many times inventory is sold in a period. Higher is generally better.
  • Interest Coverage - Shows the available cash flow that can be used to cover interest obligations. Higher the better.
  • Return on Assets - Amount of net income earned relative to the average total assets in the same period. Higher the better.
  • Total Asset Turnover - Amount of net sales earned relative to the average total assets in the same period. Higher the better.
The template will do all the math and calculations for you. The user just has to pull the relevant data off of financial statements and input it as instructed.

Screenshots of Summary Dashboards of this Template:
financial statement ratios

accounting ratios