Skip to content
Edition NigeriaGlobal
Country: Mexico

You are in the Mexico edition. Type your country to switch.

The Americas

Set up your profile

You are learning in the Mexico edition, with examples in pesos and from Mexico.

Statistics and fundamental analytics · Lesson 5 of 8

Ratio analysis at scale

Calculating ratios for many companies at once is mostly about consistency: the same definitions, periods, currency, units and formula in every row. Negative denominators, outliers and sector differences then need deliberate handling before companies can be compared.

Intermediate9 min read5 steps

This lesson is complete in writing. A video for it is on its way.

What you will learn

  • By the end you can lay out ratios for many companies in one consistent table.
  • You can align periods with trailing twelve months, and handle currencies, units and restatements.
  • You can deal with negative and tiny denominators, for example by using earnings yield instead of P/E.
  • You can tame outliers with medians and winsorising, and compare companies with z-scores and percentile ranks.

Key terms in this lesson

Return on equity
Profit after tax divided by shareholders' funds: how much profit a company earns on shareholders' money.
P/E ratio
Price-to-earnings ratio: share price divided by earnings per share. It shows how much investors pay for each dollar of yearly profit.
Tidy data
A table with one row per record, one column per field and no merged cells or subtotals mixed in.
Trailing twelve months
A figure that adds up the most recent four quarters or two half-years, so companies with different financial years can be compared over the same recent period. Often written TTM.
TTM
Short for trailing twelve months: the total of the most recent four quarters or two half-years.
Outlier
A value far away from most of the others in a set, which can distort averages and charts.
Median
The middle value when a set of values is sorted in order. Half the values are above it and half below.
Winsorising
Replacing values beyond a chosen limit, such as the 1st and 99th percentiles, with the limit itself so that a few outliers cannot dominate an average.
Z-score
How many standard deviations a value sits above or below the mean of its group: the value minus the mean, divided by the standard deviation.

Step 1 of 5

From one company to a hundred

Opening this step…

Step 2 of 5

Lining up periods, currencies and units

This step opens when you finish the one above.

Step 3 of 5

Negative and tiny denominators

This step opens when you finish the one above.

Step 4 of 5

Outliers: medians and winsorising

This step opens when you finish the one above.

Step 5 of 5

Comparing across a group: z-scores and percentile ranks

This step opens when you finish the one above.

Key takeaways

The key takeaways open when you finish every step.

Lesson quiz

5 questions. You need 85% to pass.

The quiz opens when you finish every step.

Read first

Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.

Up next

Financial data & analyticsScreening shares with dataRead nowScreening shares with dataFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsPeer comparisonRead nowPeer comparisonFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsBuilding a simple valuation mode…Read nowBuilding a simple valuation model from dataFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsLab 1: reading CSV files in Pyth…Read nowLab 1: reading CSV files in Python and SQLFinancial data & analytics · Advanced · 15 minValuation & company analysisFinancial ratios every investor …Read nowFinancial ratios every investor should knowValuation & company analysis · Intermediate · 15 minFinancial data & analyticsPivot tables for financial dataRead nowPivot tables for financial dataFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsAverages: mean, median and modeRead nowAverages: mean, median and modeFinancial data & analytics · Beginner · 15 minFinancial data & analyticsforecasts fail, and stating unce…Read nowWhy forecasts fail, and stating uncertainty honestlyFinancial data & analytics · Advanced · 15 minFinancial data & analyticsSharpe, Sortino and benchmark co…Read nowSharpe, Sortino and benchmark comparisonFinancial data & analytics · Advanced · 15 minFinancial data & analyticsLab 3: plotting prices and returnsRead nowLab 3: plotting prices and returnsFinancial data & analytics · Advanced · 15 minFinancial data & analyticsLab 6: a sentiment classifier on…Read nowLab 6: a sentiment classifier on sample headlinesFinancial data & analytics · Advanced · 15 minFinancial data & analyticsCommon financial modelling errorsRead nowCommon financial modelling errorsFinancial data & analytics · Advanced · 15 min
English