Skip to content
SkillReady to runValuationFinance

Comps Table Builder

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

Builds an institutional-grade comparable company analysis (comps) workbook in XLSX from a target company description and peer financial data the analyst supplies. Outputs a two-tab Excel file — Tab 1 a formatted comps table with peer multiples, summary statistics, and implied valuation range; Tab 2 a Peer Selection Log documenting screening criteria, candidates considered, and inclusion/exclusion rationale. Use when a banker, equity researcher, or corporate development professional needs to format, organize, and analyze a peer set they already have — or wants a structured shell to populate — for a valuation, pitch book, fairness opinion, or internal deal review.

What you get

An installable SKILL.md file for your AI assistant. Produces an Excel workbook (.xlsx).

Works in
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

Sample input
I need a comps table built for GreenPeak Renewables, a US-based renewable energy company in the solar and wind energy generation subsector. I have some financial data: LTM Revenue $220M, LTM EBITDA $55M, LTM Net Income $15M, Shares outstanding 22M, Current share price $34.50, Net Debt $80M. Peers are NextEra Energy Partners, Brookfield Renewable Partners, Orsted A/S, and Clearway Energy with some missing data.
Sample output
Sample Excel output produced by the Comps Table Builder skill
Produced by an AI assistant following this skill on the sample input above.
View the full output as text
Example Output
COMPARABLE COMPANY ANALYSIS — GreenPeak Renewables
Company Name | Ticker | Geography | LTM Revenue ($M) | LTM EBITDA ($M) |... 
NextEra Energy Partners (NEP) | US | 150.0 | 70.0 |... 
Brookfield Renewable Partners (BEP) | US/Canada | 210.0 | 85.0 |... 
Orsted A/S | Denmark | 980.0 | 300.0 |... 
Clearway Energy (CWEN) | US |  |  |... 
GreenPeak Renewables (Target) |  | 220.0 | 55.0 |... 
Summary Statistics and Implied Valuation follow, with assumptions and gaps noted.

Goes well with

Related