- Home
- Skills
- Finance & Accounting
- Comps Valuation Excel
Works with the AI Agents you already use
Comps Valuation Excel
Build a comparable-company (trading comps) analysis in Excel: pick a peer set, gather operating metrics and valuation multiples like EV/EBITDA and P/E, bucket b
$5
Comps Valuation Excel
Example session with this skill installed
Build a trading comps table for a mid-cap SaaS target with $50M EBITDA. Use 8 public peers, calculate EV/EBITDA and P/E, and give me the implied share price range.
- Read your context and instructions
- Compiled the comps valuation excel
I have structured the Excel model. Peer set includes 8 SaaS companies (Adobe, Salesforce, etc.). Median EV/EBITDA is 14.2x. Target implied EV is $710M. After adjusting for $40M net debt and 20M shares, the 25th-75th percentile range is $31.50 - $36.20 per share.
Connects securely to your tools. The creator never sees your data.
About this skill
The problem
Building trading comps in Excel is prone to manual errors, from inconsistent TTM periods to broken EV formulas. Most analysts waste hours formatting peer tables and calculating summary statistics instead of analyzing the valuation gaps.
What it does
- Selects a peer set of 6-10 public companies based on industry and business mix.
- Calculates Enterprise Value by aggregating market cap, total debt, and cash balances.
- Computes standard valuation multiples including EV/EBITDA, EV/Revenue, P/E, and P/B.
- Generates a statistical summary block with Mean, Median, Min, Max, and Quartiles.
- Derives an implied valuation range for the target company based on peer medians and quartiles.
Frameworks & tools
Microsoft Excel, Google Sheets.
Why this beats prompting it yourself
This skill enforces strict financial modeling logic, such as using consistent TTM figures and specific Enterprise Value formulas. It ensures that statistical summaries cover the exact peer range and flags outliers that would otherwise skew your median valuation.
Use cases
- Conducting buy-side screens for potential acquisition targets.
- Sanity-checking a Discounted Cash Flow (DCF) valuation with market-based data.
- Preparing valuation slides for investment pitch books or fairness opinions.
- Analyzing valuation gaps between a target and its peer size buckets.
Known limitations
Not suitable for companies without public peers or startups with no revenue. Requires manual entry or an external data source for peer financial inputs.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
Requires financial inputs for peers. Not for companies without public peers. Best for TTM comparisons.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
This skill has been used 7 times.
Trust & safety
Security scan
Security scan passed 3 months ago
Permissions
No special permissions declared or detected