Business IntelligenceFinancial ratios

Ratio analysis.
Check your KPIs.

Monitor profitability, liquidity and debt in Fincorex®. Compare ratios over time and check which financial items are behind the change.

Fincorex® BI screen: ROE tree – DuPont analysis of return on equity
Features

Ratio analysis in Fincorex®.

01

Profitability

Gross, operating and net margin.

02

Liquidity

Current assets relative to current liabilities.

03

Debt

The share of liabilities in financing assets.

04

Capital structure

Comparing liabilities and equity.

05

Trends

Comparing the same KPI over successive periods.

06

Actuals and plan

Comparing a ratio with the set target.

07

Organizational breakdowns

Ratios for the group and individual entities.

08

Ratio components

Visibility into the items used to calculate the KPI.

09

Financial reports

A set of ratios tailored to the audience.

Profitability

Revenue went up.
Why did the margin fall?

In December, revenue grew from PLN 12.0m to PLN 12.5m. Cost of sales grew faster, so gross margin fell from 30% to 28%.

  • Compare margin between periods
  • Check revenue and cost of sales
  • Drill down by product or entity
Gross margin componentsGroup A
ItemNovemberDecember
Revenue · PLN m12.012.5
Cost of sales · PLN m8.49.0
Gross profit on sales · PLN m3.63.5
Gross margin30.0%28.0%

Illustrative data

Liquidity and debt

See what's behind
the change in a ratio.

Current assets increased, but current liabilities grew faster. As a result, the current ratio fell from 1.50 to 1.45.

ItemNovemberDecember
Current assets · PLN m15.015.95
Current liabilities · PLN m10.011.0
Current ratio1.50×1.45×
↗

Comparing the numerator and denominator shows why the ratio changed despite the increase in current assets.

Use cases

Three areas for assessing financial health.

⇄

Profitability

See how much of revenue remains after costs.

Margin / costs

◷

Liquidity

Compare current assets with current liabilities.

Assets / liabilities

☷

Debt

Track the share of liabilities in financing assets.

Liabilities / assets

KPI definitions

Compare ratios
using the same rules.

Define which balance sheet and P&L items go into the calculation. That way, every report reader can interpret the ratio using the same definition.

Definition

Formula and component items.

Period

A common reporting date or range.

Entity

Company or group.

Comparison

Prior period or target.

Sample KPI definitions
RatioCalculation
Gross marginGross profit on sales / revenue
Current ratioCurrent assets / current liabilities
Debt ratioTotal liabilities / total assets
Business Intelligence

Explore our other BI solutions.

Power BI Connector

See the solution →

Management dashboards

See the solution →
FAQ

Frequently asked questions about ratio analysis.

Which ratios can be monitored?

Among others, profitability, liquidity, and debt and capital structure ratios. You can tailor the set of ratios to your company's needs.

Can ratios be compared over time?

Yes. You can compare the same ratio over successive periods, against the prior period or against the set target.

How can I find the cause of a change in a ratio?

Drill down to the ratio's component items. Comparing the numerator and denominator shows which item is responsible for the change.

How can I make sure everyone calculates a ratio the same way?

Define the ratio: the formula and the balance sheet and P&L items that go into the calculation. That way, every report reader interprets the ratio using the same rule, for the same period and entity.

Can I see ratios for a company and for the whole group?

Yes. You can calculate a ratio for a selected company or for the group and compare it with the prior period or with the set target.

Where does the data come from?

From accounting and ERP systems, sales (CRM) and HR systems, and Excel files. All data goes into one model, so reports and dashboards show the same numbers.

Do I need the IT department to create reports?

No. Business users can build reports, analyses and dashboards themselves – without knowing complex IT tools. This makes them more independent and shortens the time it takes to get to key information.

See your model
before you decide.

As a proof of concept, we’ll rebuild your reporting or planning model in Fincorex® and show it to you at our next meeting.

Book a demo