Country
You are in the Nigeria edition. Type your country to switch.
Nigeria
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
Your learning profile
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.
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 naira of 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: From one company to a hundred, not started
- Step 2: Lining up periods, currencies and units, not started
- Step 3: Negative and tiny denominators, not started
- Step 4: Outliers: medians and winsorising, not started
- Step 5: Comparing across a group: z-scores and percentile ranks, not started
About 9 min of reading
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.
Popular this week: Basics: BeginnerStock market: Intermediate