Link copied โ€” paste it anywhere

Get the full toolkit

Live-refresh Excel workbook + 19 tabs + Python source. Cyclical industries focus. Free monthly research notes.

Substack handles signup โ€” no spam, unsubscribe anytime.

Football Field Calculator

Drop in your low and high implied price for each valuation methodology. See the visual range chart that synthesizes your view โ€” the same artifact you'd put on the cover slide of a pitchbook.

Inputs
Target
Ticker / name
Current price ($)
Valuation Range by Method ($/share)
Low
High
52-Week Trading Range
Analyst Price Targets
EV / Revenue (peers)
EV / EBITDA LTM (peers)
EV / EBITDA FY1E (peers)
P / E LTM (peers)
P / E FY1E (peers)
Through-Cycle EV/EBITDA
Mini DCF
Football Field
Min Implied
$โ€”
Max Implied
$โ€”
Median Mid
$โ€”
Current
$โ€”

How this works

Each row is a valuation methodology with its low and high implied share price. The bar's width represents the range; the dark vertical line is the current market price. Methods are sorted from narrowest to widest range so the cleanest signals are at the top.

Reading the chart: if the current price line falls within most bars, the market is roughly in line with consensus methodologies. If it's to the right of most bars, the stock is trading rich. If it's to the left, cheap. The methods that disagree most loudly are the ones to investigate.

For cyclicals, the Through-Cycle EV/EBITDA row often diverges sharply from LTM EV/EBITDA โ€” that gap IS the cyclical positioning. Watch it carefully when sentiment is at extremes.

This is a clean, classroom-grade tool โ€” useful for a quick read or stress-testing assumptions. For a fully-loaded football field that ties into a 19-tab IB workbook, see the toolkit.

Want this auto-generated for any ticker?

The full toolkit pulls live financials from Yahoo Finance and computes every implied price methodology automatically. Football field tab updates instantly. 19 tabs of analysis, 3,049 formulas.

โ†’ See the full toolkit

Nothing on this page is investment advice. Built by Brandon Leon โ€” independent research focused on cyclical industries.

y>