Comps Outlier Memo
Written in-house · editorially graded
Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.
Dry-run test passed · Jun 13, 2026
Trigger check passed
Editorially graded · Jun 13, 2026
Takes an existing comparable company analysis (comps) table as input and produces a professional analytical memo — delivered as an editable DOCX plus a fixed-layout PDF copy — identifying valuation trends, statistical outliers by IQR methodology, peer group composition issues, and implied valuation ranges for the target company. Structured exactly as a senior banker or equity research associate would write it for a deal team meeting or investment committee. Use when you have a completed or partial comps table and need a narrative interpretation layered on top of it: benchmarking the target, flagging outliers, and surfacing deal implications — triggered by requests like "write up the analysis on my comps," "flag the outliers in this table," or "I need a valuation range memo from these trading multiples."
An installable SKILL.md file for your AI assistant. Produces a Word document (.docx) and a PDF.
- Claude Code · Cursor
- Native — drops into .claude/skills/
- Copilot · Codex · Gemini CLI
- Native — reads .agents/skills/
- claude.ai — web & desktop
- Upload the .zip in Customize → Skills
- ChatGPT
- Via a Project — paste into its instructions
See it in action
A real input → output sample
I've got my comps table here. Can you write up the analysis and flag any outliers? I need a memo for the deal team meeting tomorrow. | Company | EV/EBITDA | EV/Revenue | |---|---|---| | AlphaCoat Corp | 9.2x | 1.43x | | BetaSolv Ltd | 10.8x | 1.71x | | GammaTech Materials | 11.4x | 1.89x | | DeltaBase Industries | 12.1x | 2.02x | | EpsilonChem | 18.7x | 2.13x | | ZetaFluid Systems | 10.3x | 1.62x |

View the full output as text
MEMORANDUM To: Deal Team From: [Analyst Name] Date: 13 Jun 2026 Re: Target Company — Trading Comps Trend & Outlier Analysis | Specialty Chemicals Peer Group | LTM (assumed) Section 1 — Executive Summary - The specialty chemicals peer group trades at a trimmed median EV/EBITDA of 10.8x and a full-set median EV/Revenue of 1.80x on an LTM basis. - EpsilonChem breaches the upper IQR fence and is excluded from the primary central tendency. - Without target financial metrics, an implied valuation range cannot be calculated. Section 2 — Peer Group Overview The peer group comprises six publicly traded specialty chemicals companies on an LTM basis. Section 3 — Multiple-by-Multiple Analysis 3.1 EV/EBITDA - Central tendency: The full-set median is 11.1x; the mean is 12.1x. (The trimmed-set median of 10.8x — excluding the EpsilonChem outlier — is the primary central-tendency measure.) - Spread: The Q1–Q3 range for the trimmed set is 10.3x–11.4x. - Trend: No multi-period data is available. - Outliers: EpsilonChem breaches the upper IQR fence. Section 4 — Outlier Deep Dive - EpsilonChem: Breaches the upper IQR fence by 5.6x. Section 6 — Recommendations 1. Obtain target LTM EBITDA and Revenue. 2. Obtain NTM estimates. 3. Run a precedent transactions screen. 4. Investigate EpsilonChem's outlier driver. 5. Expand the peer group.
Goes well with
Related
- financial-modeling-template.mdSkill
3-Statement Financial Model
You get a complete financial model template instantly.
- asset-allocation-reporting.mdSkill
Asset Allocation Report
Get a client-ready, tailored asset allocation report with your name on it - every time.
- reconciling-bank-ledger-files.mdSkill
Bank CSV Reconciliation
You reconcile bank statements with your expenses in minutes, not hours.