NNextResearch

How Trend and P/E in context are worked out

Two signals on every stock pop-up and company page. Both describe the stock; neither is a forecast or a call.

  1. 1. Trend
  2. 2. P/E in context
  3. 3. What they don't do
  4. 4. Worked example

1. Trend

Where the stock’s 1-year price return ranks among the 425 covered stocks that have one: the 90th percentile beat 90% of them. A stock listed under a year ago has none.

percentile = (stocks with a lower return + ½ × ties) ÷ (stocks ranked − 1) × 100, within 1–99

Tested at every month-end since Oct 2022, past-year return (with or without the latest month) was the only simple signal that ranked the next 3 months’ returns (rank correlation, 0 = no link):

SignalNext 3 monthsNext 12 months
Past-year return (what Trend ranks)+0.088+0.123
Return 12 months to 1 month ago+0.090+0.113
Earnings yield (1 ÷ P/E)0.000−0.019
Net margin−0.028−0.067
Beta (what orders a projection's Base)−0.002−0.006

Useful across many stocks, small for any one. Today’s covered companies scored back to 2022, which flatters it a little.

2. P/E in context

Today’s P/E (trailing twelve months) beside two yardsticks.

P/E then = market cap then ÷ net profit of the latest year reported by then

3. What they don’t do

4. Worked example

Trend

The 1-year price return of Bharat Electronics is −3%. Of the 425 companies ranked, 215 had a lower return and 6 others the same.

(215 + ½ × 6) ÷ (425 − 1) × 100 = 51.4 → 51st percentile

Trend: 51st percentile.

P/E in context

Today, from our last data update: P/E 45.3x (trailing twelve months), market cap ₹2,89,651 Cr, price ₹396.00.

shares ≈ ₹2,89,651 Cr ÷ ₹396.00 = 731.44 crore

The last weekly close of each month since Jun 2022: 54 months, 54 with a P/E.

Week ofClose ₹Market cap then ₹ CrYear usedNet profit ₹ CrP/E then
27 Jun 202276.6056,028FY222,40023.3x
25 Jul 202291.7367,098FY222,40028.0x
29 Aug 2022108.1879,130FY222,40033.0x
26 Sep 2022100.9573,839FY222,40030.8x
31 Oct 2022108.9579,691FY222,40033.2x
28 Nov 2022106.1577,643FY222,40032.4x
26 Dec 202299.9073,071FY222,40030.4x
30 Jan 202393.8568,646FY222,40028.6x
27 Feb 202395.8570,109FY222,40029.2x
27 Mar 202397.5571,352FY222,40029.7x
24 Apr 2023103.3075,558FY222,40031.5x
29 May 2023113.3082,872FY222,40034.5x
26 Jun 2023125.7591,979FY232,98630.8x
31 Jul 2023127.6093,332FY232,98631.3x
28 Aug 2023137.851,00,829FY232,98633.8x
25 Sep 2023138.301,01,158FY232,98633.9x
30 Oct 2023135.9599,440FY232,98633.3x
27 Nov 2023147.451,07,851FY232,98636.1x
25 Dec 2023184.201,34,732FY232,98645.1x
29 Jan 2024184.601,35,024FY232,98645.2x
26 Feb 2024205.601,50,384FY232,98650.4x
25 Mar 2024201.501,47,386FY232,98649.4x
29 Apr 2024234.101,71,231FY232,98657.3x
27 May 2024295.952,16,470FY232,98672.5x
24 Jun 2024305.902,23,748FY243,98556.1x
29 Jul 2024302.952,21,590FY243,98555.6x
26 Aug 2024299.302,18,921FY243,98554.9x
30 Sep 2024277.202,02,756FY243,98550.9x
28 Oct 2024288.652,11,131FY243,98553.0x
25 Nov 2024308.002,25,284FY243,98556.5x
30 Dec 2024291.952,13,544FY243,98553.6x
27 Jan 2025281.802,06,120FY243,98551.7x
24 Feb 2025246.251,80,118FY243,98545.2x
31 Mar 2025280.002,04,804FY243,98551.4x
28 Apr 2025311.152,27,588FY243,98557.1x
26 May 2025384.602,81,313FY243,98570.6x
30 Jun 2025427.553,12,728FY255,32358.8x
28 Jul 2025377.202,75,900FY255,32351.8x
25 Aug 2025369.402,70,195FY255,32350.8x
29 Sep 2025412.653,01,830FY255,32356.7x
27 Oct 2025426.103,11,667FY255,32358.6x
24 Nov 2025411.753,01,171FY255,32356.6x
29 Dec 2025403.152,94,881FY255,32355.4x
26 Jan 2026449.003,28,417FY255,32361.7x
23 Feb 2026444.703,25,272FY255,32361.1x
30 Mar 2026421.603,08,376FY255,32357.9x
27 Apr 2026431.303,15,471FY255,32359.3x
25 May 2026410.753,00,440FY255,32356.4x
29 Jun 2026418.053,05,779FY266,06250.4x
27 Jul 2026387.852,83,690FY266,06246.8x
31 Aug 2026405.352,96,490FY266,06248.9x
28 Sep 2026383.102,80,215FY266,06246.2x
26 Oct 2026369.902,70,560FY266,06244.6x
6 Nov 2026396.002,89,651FY266,06247.8x

The last row is today’s price on the latest reported year’s profit (47.8x); the P/E above (45.3x) is on the trailing twelve months, which is what the pop-up compares. The two differ when profit has moved since the year ended.

sorted month-end P/Es (54): 25th percentile 33.4x · median 49.9x · 75th percentile 56.4x

45.3x is between 33.4x and 56.4x: Within its usual range, 9% below its own median.

Primary industry: Naval Shipbuilding & Defence Shipyards, 26 of 28 covered stocks with a P/E, low to high:

StockP/E
Steel Authority of India (SAIL) SAIL11.8x
Ador Welding ADOR20.9x
HBL Engineering HBLENGINE29.0x
Larsen & Toubro LT30.0x
Mazagon Dock Shipbuilders MAZDOCK30.2x
Garden Reach Shipbuilders & Engineers GRSE30.5x
Kirloskar Brothers KIRLOSBROS31.6x
Kirloskar Pneumatic Company KIRLPNU31.9x
Kirloskar Oil Engines KIRLOSENG42.7x
Bharat Electronics BEL45.3x
Titagarh Rail Systems TITAGARH47.0x
Cochin Shipyard COCHINSHIP47.2x
Bharat Heavy Electricals BHEL50.7x
Mishra Dhatu Nigam (MIDHANI) MIDHANI52.6x
Centum Electronics CENTUM58.7x
Zen Technologies ZENTEC73.0x
Solar Industries India SOLARINDS74.3x
Bharat Dynamics BDL74.5x
Data Patterns (India) DATAPATTNS77.8x
Astra Microwave Products ASTRAMICRO78.2x
Premier Explosives PREMEXPLN79.5x
Bharat Forge BHARATFORG85.0x
Paras Defence and Space Technologies PARAS98.1x
Apollo Micro Systems APOLLO111.0x
Azad Engineering AZAD113.0x
MTAR Technologies MTARTECH123.0x
DCX Systems DCXINDIA—
Walchandnagar Industries WALCHANNAG—

Median of the 26 with a P/E: 51.7x; 45.3x is 12% below it.

What the pop-up and company page show for it:

P/E in context
  • Within its usual range · P/E 45.3x is 9% below its own median of 49.9x since Jun 2022 (usual 33.4x–56.4x)
  • It is 12% below the median of 26 covered Naval Shipbuilding & Defence Shipyards stocks (51.7x)
TodayUsual rangeOwn medianIndustry median