LogoLogo
More help and supportPhocas website
  • Home
  • Getting started
    • Navigation
    • Homepage
    • Data access
    • User licenses, profiles and permissions
    • Account settings
    • Databases
    • Periods
      • Offset dates
      • Default period for a database
    • Sharing and folders
      • Share a dashboard, favorite, or alert
    • Subscriptions
  • Analytics
    • Take a tour of Analytics
    • Work with the grid
    • View a summary of the data
    • Customize your view (Analytics)
      • Change the mode
        • Period mode
        • Period Variance mode
        • Period Stream mode
        • Moving mode
        • Stream mode
        • Total mode
        • Transaction mode
        • Matrix mode
        • Matrix Variance mode
        • Matrix Share mode
        • Variance mode
        • Search mode
        • Market mode
        • Custom mode
      • Change the properties (Analytics)
      • Change the measures (Analytics)
      • Change the stream
      • Use the activity filter
      • Change the data format
      • Change the period (Analytics)
    • Drill down into your data (view transactions)
    • Filter data (use dimensions)
    • Select data (Analytics)
    • Focus on data (Analytics)
    • Copy or export data
    • Search for data
      • Perform a basic search
      • Perform an advanced search
      • Search for similar or comparative data (right-click filter)
    • Add levels to the grid (grid nesting)
    • Compare data with Matrix mode
    • Get more options for viewing data
    • Visualize your data in a chart
      • Bar and Column charts
      • Combo chart
      • Pareto chart
      • Waterfall chart
      • Line chart
      • Area and % Area charts
      • Pie and Donut charts
      • Bubble chart
      • Radar chart
      • Gauge chart
      • Bullet chart
      • Summary and Ring Summary charts
      • Map charts
      • Configure the chart options
      • Select and focus on a chart segment
      • Export a chart as an image
      • Use the chart legend
    • Save favorites and add to dashboards (Analytics)
    • Reset data
    • Phocas AI
  • Flex Modes
    • Switch modes
    • Change the period (Flex Modes)
    • Filter data (Flex Modes)
    • Apply conditional formatting
    • Create a nested view
    • Manage columns (Flex Modes)
    • Save and share a favorite (Flex Modes)
    • View your data in a chart (Flex Modes)
  • Financial Statements
    • Take a tour of Financial Statements
    • Overview of access to financial statements
    • Customize your view (Financial Statements)
      • Change the properties (Financial Statements)
      • Change the measures (Financial Statements)
      • Change the period (Financial Statements)
      • Change the streams and scenarios
        • Change the budget data
      • Change the columns
      • Change the style
      • Change the rows (activity filter)
    • Filter the financial information
    • Select and focus on data (Financial Statements)
    • Copy or export financial information
    • Add a level in a financial statement
    • View financial information in a matrix (change column groups)
    • Add and view comments (Financial Statements)
    • View transactions (Financial Statements)
    • View financial information in a chart
      • Create a Pie and Donut chart (Financial Statements)
      • Create a Value card
      • Export a financial chart widget as an image
    • Save and share favorites (Financial Statements)
    • Add financial analysis to a dashboard
    • Manage financial statements
      • Overview of financial statements and dimensions
      • Create a financial statement
      • Delete a financial statement
      • Customize a financial statement
        • Rename a financial statement
        • Reorder a financial statement
        • Customize account groups
        • Customize calculations
          • Functions for Profit & Loss calculations
          • Formulas for financial ratios
        • Customize headings and spacers
        • Set the revenue row in a Profit & Loss statement
        • Customize columns
        • Customize a Cash Flow statement
          • Common account mapping for Cash Flow statements
        • Rebuild the database
      • Set the financial year end date
      • Map the Retained Earnings account(s)
      • Restrict access to accounts
      • Manage streams and scenarios
        • Manage budget streams (Financial Statements)
      • Create a budget (Financial Statements)
      • Use statistical streams
      • Use multiple currencies
      • Manage dimension groups
      • Map categories from your Chart of Accounts
  • Budgets & Forecasts
    • Overview of key terms and concepts
      • Budgets versus forecasts
      • Users and data access
      • Relationship with the Financial Statements module
      • 3-statement budgeting
      • Filtering methods
      • Demand planning
      • Loan repayments
    • Take a tour of Budgets & Forecasts
      • Explore the budget workbook
      • Explore the forecast workbook
      • Explore the Balance Sheet and Cash Flow budgets and forecasts
    • Customize your view (Budgets & Forecasts)
      • Filter a worksheet (search for items)
      • Group period columns
      • Use layouts
    • Use session filters
    • Edit values in a worksheet
      • Open workbook notes
      • Use keyboard shortcuts
      • Copy and paste values
      • Use comparison rows
      • Use sum and working lines
      • Use formulas
      • Spread totals
      • Revert to the baseline values
      • Edit the Balance Sheet budget
      • View and use headcount data
    • Refresh a workbook
    • Use workflows
      • Contribute to the workflow
      • View the workflow history
      • View workflow comments
    • View budget information in a chart
    • Open baseline, comparative, or opening balance data
    • Review the budget or forecast
      • Add and view cell comments
      • View and restore the cell history
      • View the audit log
      • Compare actuals, budgets and forecasts
    • Export a workbook or worksheet tab
    • Manage budgets and forecasts
      • Create a budget workbook
        • Best practices for efficient budgeting
        • Filtered budget or forecast
        • Budget by region and branch
        • Multi-currency budget
        • Unclassified data
        • Period types in budgets
        • Additional measures for driver-based budgeting
      • Create a forecast workbook
      • Clone a workbook
      • Import a budget or forecast
      • Edit the workbook setup
      • Roll a budget forward
      • Add more detail to a budget or forecast
      • Add worksheet tabs (drivers)
        • Balance Sheet and Cash Flow tabs
        • Manual Entry tab
        • Database tab
        • Headcount tab
          • Headcount tab FAQs
        • Reference tab
        • Lookup tab
        • Allocations tab
        • Scratch Pad tab
      • Manage worksheet tabs
      • Add notes to a workbook
      • Customize the format of measures
      • Manage the workflow
      • Manage user access and notifications
      • Publish a budget, forecast or other worksheet tab
      • Fix the baseline in a budget
      • Delete or restore a workbook
      • Delete a stream (Budgets & Forecasts)
  • Rebates
    • Overview of rebates
    • Get started with Rebates
    • Projects
    • Rules
      • Parent-child rebate rules
      • Rebates calculation methods
      • Yearly rebates
      • Quarterly rebates
      • Monthly rebates
      • Whole rule period rebates
      • Retrospective rebates
      • Pro rata rebates
    • Calculations
      • Run a calculation
      • Schedule calculations
      • View calculation results and transactions
      • Post calculation results
    • Seasonal calendars
    • Rebates analysis
    • Rebates near miss analysis
  • CRM
    • Overview of CRM
    • Agenda
    • Contacts
    • Accounts
    • Leads
    • Activities
      • Microsoft 365 Outlook calendar integration
    • Campaigns
    • CRM analysis
    • CRM administration
  • Favorites
    • Save a favorite
    • Manage favorites
    • Set a favorite as your default view
    • Use alerts
  • Dashboards
    • Use dashboards
    • Create a dashboard
    • Set a dashboard as your homepage
    • Manage dashboards
  • Administration
    • Overview of access to data (Administration)
    • Users
      • Add, update or delete a user account
        • User maintenance form
        • User permissions
      • Create a user template
      • Manage a user's database access and restrictions
      • Manage user passwords
      • Monitor user activity
      • Lock user accounts
      • Impersonate a user
    • Profiles
    • Folders (Administration)
    • Favorites (Administration)
    • Dashboards (Administration)
    • Subscriptions (Administration)
    • Periods (Administration)
      • Period types
      • Working days
    • Databases (Administration)
    • Sync Sources
    • Connectors
    • Configuration
      • Set up SSO
      • Set up SSO with Microsoft Entra ID
    • Logs
    • Designer
      • Modify a database
      • Get your data into Phocas
      • Design a database
        • Create a database
        • Add (connect) data to a database
        • Map data to the database
        • Save your database design
      • Design a financial database
      • Build a database
      • View and revert to older design versions
      • Add a budget file to a financial database
      • Add a budget file to a non-financial database (easy budget upload)
    • Sync
      • Automatically join or split items during Sync (split view)
      • Schedule the sync process
      • Migrate Sync
      • Test the sync process
    • Reserved words and characters
    • End of year maintenance tips
  • OTHER INFORMATION
    • File upload
    • Encrypt (share secrets)
    • Glossary
    • Release notes
      • Analytics release notes
      • Flex Modes release notes
      • Financial Statements release notes
      • Budgets and Forecasts release notes
      • Rebates release notes
      • Administration release notes
    • System requirements
    • Technical limitations
    • Security information
    • Scheduled upgrade and maintenance periods
    • More help and support
Powered by GitBook

© Phocas Software

On this page
  • Liquidity ratios
  • Current
  • Acid-test
  • Cash
  • Operating Cash Flow
  • Working Capital
  • Profitability ratios
  • Gross Profit
  • Gross Margin
  • Operating Profit Margin
  • Return on Assets
  • Return on Equity
  • Efficiency ratios
  • Asset Turnover
  • Inventory Turnover
  • Days Sales in Inventory (DSI)
  • Days Sales Outstanding (DSO)
  • Days Payable Outstanding (DPO)
  • Cash Conversion Cycle (CCC)
  • Leverage ratios
  • Debt
  • Debt to Equity
  • Interest Cover

Was this helpful?

  1. Financial Statements
  2. Manage financial statements
  3. Customize a financial statement
  4. Customize calculations

Formulas for financial ratios

Learn about the common financial ratios you can add to your financial statement calculations.

PreviousFunctions for Profit & Loss calculationsNextCustomize headings and spacers

Last updated 23 days ago

Was this helpful?

Ratios look at two numbers relative to one another and provide an objective, standardized measurement method. You might use ratios in your to assess aspects of financial performance such as liquidity, leverage, growth, margins, profitability, rates of return, valuation, and more. Note the formulas are indicative, as every business will have its own naming conventions and groupings.

Learn more about using ratios in your financial statements

The values in a standard financial statement grid are useful, but they don’t tell the full story about your company’s performance, such as how well your company turns revenue into profits and how much your company is bringing in after all direct manufacturing-related costs. That’s why many companies add ratios to the financial statement grid. These ratios can be used as key performance indicators (KPIs).

If you are viewing a financial statement that contains ratios, it’s important to recognize them and understand the information they provide you with.

The use of ratios allows you to:

  • Compare different entities in your business.

  • Compare how your company stacks up against other companies in your industry. This can help you see how well your company is performing and identify its strengths and weaknesses. You can find ratio values for organizations in your local area by consulting your local Board of Trade, Chamber of Commerce, or industry association. Industry standards reports, typically accessible online, can also be valuable sources of information.

  • Explore relationships between different areas of the business to get a more complete financial picture of your business.

  • Get critical insights into the financial health of your business and determine how much debt you can continue to take on while still meeting the terms of your financial obligations.

In summary, the use of ratios in your financial statements can uncover hidden insights and drive more detailed decision-making.

Read the blogs on our website for more information, such as:

Watch these PUG Training videos:

  • (jump to 03.29)

  • (jump to 23.00)

See also .


Liquidity ratios

Liquidity ratios measure a company’s ability to repay both short-term and long-term debt obligations. Many of these ratios use the in their formulas.

Current

Current Assets / Current Liabilities

The Current ratio, also known as the Working Capital ratio, measures a company's capability to meet its short-term obligations (liabilities) that are due within a year. In other words, it measures a company’s liquidity. The ratio considers the weight of total Current Assets versus total Current Liabilities. It indicates a company's financial health and shows how it can maximize the liquidity of its current assets to settle debt and obligations to suppliers.

The formula you use in the calculation:

  • On a Balance Sheet: [a]/[b] where [a] is Current Assets and [b] is Current Liabilities

  • On a Profit & Loss statement: [bal(Balance Sheet, Current Assets, closing)]/[bal(Balance Sheet, Current Liabilities, closing)]

Acid-test

(Current Assets - Inventories) / Current Liabilities

The Acid-Test ratio, also known as the Quick ratio, is a liquidity ratio that measures how sufficient a company’s short-term assets are to cover its current liabilities. It measures how well a company can satisfy its short-term (current) financial obligations.

The formula you use in the calculation:

  • On a Balance Sheet: ([a]-[d])/[b] where [a] is Current Assets, [d] is Inventories, and [b] is Current Liabilities

  • On a Profit & Loss statement: ([bal(Balance Sheet, Current Assets, closing)]-[bal(Balance Sheet, Inventories, closing)])/[bal(Balance Sheet, Current Liabilities, closing)]

Cash

Cash & Cash Equivalents / Current Liabilities

The Cash ratio, sometimes referred to as the Cash Asset ratio, is a liquidity metric that indicates a company’s capacity to pay off short-term debt obligations with its cash and cash equivalents. Compared to other liquidity ratios, the Cash ratio is a stricter, more conservative measure because only cash and cash equivalents (a company’s most liquid assets) are used in the calculation.

The formula you use in the calculation:

  • On a Balance Sheet: [e]/[b] where [e] is Cash and [b] is Current Liabilities

  • On a Profit & Loss statement: [bal(Balance Sheet, Cash, closing)]/[bal(Balance Sheet, Current Liabilities, closing)]

Operating Cash Flow

Operating Cash Flow / Current Liabilities

The Operating Cash Flow ratio is a measure of the number of times a company can pay off current liabilities with the cash generated in a given period. Companies often use EBITDA (Earnings Before Interest, Tax, Depreciation and Amortization) as a proxy for the operating cash flow.

The formula you use in the calculation on a Cash Flow statement: [c]/[bal(Balance Sheet, Current Liabilities, closing)] where [c] is the operating cash flow

Working Capital

Current Assets - Current Liabilities

Like the Current ratio, the Working Capital ratio measures the ability of a company to repay its short-term obligations (liabilities).

The formula you use in the calculation:

  • On a Balance Sheet: [a]-[b] where [a] is Current Assets and [b] is Current Liabilities

  • On a Profit and Loss statement: [bal(Balance Sheet, Current Assets, closing)]-[bal(Balance Sheet, Current Liabilities, closing)]


Profitability ratios

Profitability ratios are financial metrics used by analysts and investors to measure and evaluate a company's ability to generate profit relative to revenue, Balance Sheet assets, operating costs, and shareholders' equity during a specific period. They show how well a company uses its assets to produce profit and value for shareholders. In other words, they paint a picture of a company’s performance.

Gross Profit

Revenue - Cost of Goods Sold

The Gross Profit is the difference between Revenue and Cost of Goods Sold.

The formula you use in the calculation: [a]-[b] where [a] is Revenue and [b] is Cost of Goods Sold

Gross Margin

(Revenue – Cost of Goods Sold) / Revenue * 100

The Gross Margin ratio, also known as the Gross Profit margin, compares a company's gross profit to its revenue. It shows a company's profit after paying off its Cost of Goods Sold (COGS). The ratio indicates the percentage of each dollar of revenue that the company retains as gross profit (profit before operating expenses). For example, if the Gross Margin is calculated to be 20%, that means for every dollar of revenue generated, $0.20 is retained while $0.80 is attributed to the cost of goods sold. The remaining amount can be used to pay off general operating expenses, interest expenses, debts, rent, overhead, etc.

The formula you use in the calculation: (([a]-[b])/[a])*100 where [a] is Revenue and [b] is Cost of Goods Sold

Operating Profit Margin

Operating Profit (before interest & tax) / Revenue * 100

The Operating Profit Margin ratio reflects the percentage of profit a company produces from its operations before subtracting taxes and interest charges. It is calculated by dividing the operating profit by total revenue and expressing it as a percentage. The margin is also known as EBIT (Earnings Before Interest and Tax) Margin.

The formula you use in the calculation: (([c]-[d])/[a])*100 where [c] is Gross Profit and [d] is Operating Expenses and [a] is Revenue

Return on Assets

Operating Profit (Annualised)/ Asset Value * 100

The Return on Assets (ROA) ratio is a type of return on investment (ROI) metric that measures a company's profitability in relation to its total assets. This ratio indicates how well a company is performing by comparing the profit it is generating to the capital it has invested in assets. The higher the return, the more efficient management is in using the company’s economic resources.

The formula you use in the calculation: ([h]/[DaysInPeriod]*365)/[bal(Balance Sheet, Total Assets, average)]*100 where [h] is Profit

Return on Equity

Operating Profit (Annualised)/ Shareholders’ Equity * 100

The Return on Equity (ROE) ratio measures a company’s annual operating profit divided by the value of its total shareholders' equity, expressed as a percentage. The number represents the total return on equity capital and shows the company’s ability to turn equity investments into profits. In other words, it measures the profits made for each dollar of shareholders’ equity.

The formula you use in the calculation: ([h]/[DaysInPeriod]*365)/-[bal(Balance Sheet, Equity, average)]*100 where [h] is Profit

You need to reverse the sign on Equity.


Efficiency ratios

Efficiency ratios, also known as Activity Financial ratios, measure how well a company is using its assets and resources.

Asset Turnover

Net Sales Revenue / Total Assets The Asset Turnover ratio measures the value of revenue generated by a business relative to its average total assets for a given fiscal or calendar year. It is an indicator of how efficiently the company uses both current and fixed assets to produce revenue.

The formula you use in the calculation: [a]/[DaysInPeriod]*365)/[bal(Balance Sheet, Total Assets, average)] where [a] is Revenue.

Inventory Turnover

Cost of Goods Sold / Average Inventory

The Inventory Turnover ratio is the number of times a company sells and replaces its stock of goods during a given period. It considers the cost of goods sold, relative to its average inventory for a year or in any set period. A high inventory turnover generally means that goods are sold faster and a low turnover rate indicates weak sales and excess inventories, which may be challenging for a company.

The formula you use in the calculation: [b]/[DaysInPeriod]*365)/[bal(Balance Sheet, Inventory, average)] where [b] is Cost of Goods Sold

Days Sales in Inventory (DSI)

365 days / Inventory Turnover The Days Sales in Inventory (DSI) ratio, sometimes known as Inventory Days or Days in Inventory, measures the average number of days or time required for a company to convert its inventory into sales. The DSI value is calculated by dividing the inventory balance by the amount of Cost of Goods Sold. This number is then multiplied by the number of days in a year, quarter, or month.

You can use either of these formulas in the calculation, where [b] is Cost of Goods Sold:

  • 365/([b]/[DaysInPeriod]*365/[bal(Balance Sheet, Inventory, average)])

  • [bal(Balance Sheet, Inventory, average)]/([b]/[DaysInPeriod])

Days Sales Outstanding (DSO)

Accounts Receivable/Sales x 365

The Days Sales Outstanding (DSO) ratio, also called the Average Collection Period or Days’ Sales in Receivables, measures the number of days it takes a company to collect cash from its sales. It shows the liquidity and efficiency of a company’s collections department.

The formula you use in the calculation: [bal(Balance Sheet, Accounts Receivable, average)]/([a]/[DaysInPeriod]) where [a] is Revenue

Days Payable Outstanding (DPO)

Accounts Payable/COGS x 365

The Days Payable Outstanding (DPO) ratio measures the average time it takes a company to pay its invoices from suppliers and vendors. For instance, a company that takes longer to pay its bills has access to its cash for a longer period and can do more things with it during that period.

The formula you use in the calculation: [bal(Balance Sheet, Accounts Payable, average)]/([b]/[DaysInPeriod]) where [b] is Cost of Goods Sold.

Cash Conversion Cycle (CCC)

DSI + DSO - DPO

The Cash Conversion Cycle (CCC) ratio attempts to measure the time it takes a company to convert its investment in inventory and other resource inputs into cash. In other words, it measures how long cash is tied up in inventory before the inventory is sold and cash is collected from customers.


Leverage ratios

Leverage Ratios measure the amount of capital in a company that comes from debt. In other words, they evaluate the risks associated with a company’s debt levels.

Debt

(Short-term Debt + Long-term Debt) / Total Assets

The Debt Ratio indicates the percentage of assets that are being financed with debt. The higher the ratio, the greater the degree of leverage and financial risk. It’s commonly used by creditors to determine the amount of debt in a company, the ability to repay its debt, and whether additional loans will be extended to the company. On the other hand, investors use the ratio to make sure the company is solvent, can meet current and future obligations, and can generate a return on their investment.

The formula you use in the calculation:

  • On a Balance Sheet: ([e]+[f])/[a] where [e] is Short Term Loans, [f] is Long Term Loans, and [a] is Total Assets

  • On a Profit and Loss statement: ([bal(Balance Sheet, Loans due this year, closing)]+[bal(Balance Sheet, Loans Long Term, closing)])/[bal(Balance Sheet, Total Assets, closing)]


Debt to Equity

(Short-term Debt + Long-term Debt) / Shareholders’ Equity

The Debt to Equity ratio, also called the Debt-Equity, Risk, or Gearing ratio, calculates the weight of total debt and financial liabilities against total shareholders' equity. This ratio highlights how a company’s capital structure is tilted either toward debt or equity financing.

The formula you use in the calculation:

  • On a Balance Sheet: ([e]+[f])/[g] where [e] is Short Term Loans, [f] is Long Term Loans, and [g] is Total Shareholders' Equity

  • On a Profit and Loss statement: ([bal(Balance Sheet, Loans due this year, closing)]+[bal(Balance Sheet, Loans Long Term, closing)])/[bal(Balance Sheet, Total Equity, closing)]


Interest Cover

Earnings Before Interest & Tax / Interest Expense

The Interest Coverage ratio determines how well a company can pay the interest on its outstanding debts. It’s commonly used by lenders, creditors, and investors to determine the riskiness of lending capital to a company.

The formula you use in the calculation: [p]/[h] where [p] is Earnings Before Interest & Tax and [h] is Interest Expense

The multiplied by 365 part of the formula produces annualized profit.

The multiplied by 365 part of the formula produces annualized profit.

The multiplied by 365 part of the formula produces annualized revenue.

The multiplied by 365 part of the formula produces annualized cost of goods sold.

custom calculations
All about leverage ratios
What's a good liquidity ratio for your business?
Profitability ratios: a great benchmarking tool
Efficiency ratios focus on operational effectiveness
Ratios and statistical streams
Cashflow - direct and indirect
Functions for Profit & Loss calculations
[BAL] function
[DaysInPeriod] function
[DaysInPeriod] function
[DaysInPeriod] function
[DaysInPeriod] function