Etomate Technology LLP
BI & Analytics | Accounting & Outsourcing | Training & Skill Development | Recruitment & Placement

BI & Analytics » Profitability and Return » P&L Funnel (Condensed)

Profitability ratios or Income Statement ratios or P&L ratios

Hardly does a visualization of an Income Statement (or Profit and Loss Account or P&L) get as aesthetic, simple, crisp, concise and illuminating as the below.

Presented as a funnel, this chart shows how much each dollar of revenue boils down to net income or net profit and how it makes that journey through other components of Income Statement. You can select any one or more values from the 'FY ending Dec', Country, Sector and Industry fields to see the profitability ratios (P&L or Income Statement ratios) of listed companies comprised in the selection.

Profitability ratios or P&L Ratios or Income Statement ratios are different components of Income Statement- Total Income, Cost of Total Income excluding Depreciation & Amortization, Gross Income, Total Opex,   Operating Profit before Interest or EBIT, Pre-tax Income and Net Income, expressed as percentage of Total Income or Turnover. 

The ratios, analyses represented in the below chart are based on information drawn from financials (e.g. financial statements comprising balance sheet, income statement or profit & loss account) of listed companies across the globe.

What's the net profit margin would you bet a business is earning if you're not provided with information about the nature of business or even country? In other words, what's the average net profit margin ratio of all businesses in our database?

The magic number is 6.9%, as you can see above.

What you don't see is the depth and width of the underlying data yielding this average. This is what all the 76,820 sets of income statements belonging to 19,529 listed companies falling under 18 different sectors (including financial) and 70 different industries and spread, spatially across 30 countries and temporally across 4 years, average out to! Hope you get a hang of how representative this could be of any and all businesses under the sun!

Following are the other important P&L ratios of the said universe of financial statements.

Gross margin or gross profit ratio: 29%

Operating profit margin: 10.2%

Pre-tax margin: 9.1%

Net income margin: 6.9%

Can't have enough of these ratios? Check out a more detailed version with more components.