- Home
- Skills
- Finance & Accounting
- comps valuation excel Skill Prop
Works with the AI Agents you already use
comps valuation excel Skill Prop
Build auditable comparable-company valuation models in Excel with structured peer buckets and EV-bridge formulas.
$9
comps valuation excel Skill Prop
Example session with this skill installed
Build a trading comps analysis for a mid-cap SaaS company with 5 peers. Target EBITDA is 50M, Net Debt is 100M, and Diluted Shares are 10M. Use EV/EBITDA multiples.
- Read your context and instructions
- Compiled the comps valuation excel
The trading comps framework for the target SaaS company has been structured. The analysis includes a peer set, valuation bridge, and implied price per share based on median sector multiples.
Trading Comparables Analysis
| Company | Ticker | Market Cap | Enterprise Value | LTM EBITDA | EV/EBITDA |
|---|---|---|---|---|---|
| CloudScale Inc | CLSD | 850.0 | 920.0 | 80.0 | 11.5x |
| DataFlow Corp | DFLW | 600.0 | 580.0 | 45.0 | 12.9x |
| NetSecure Ltd | NSEC | 1,200.0 | 1,350.0 | 95.0 | 14.2x |
| SaaSStream Co | SSTR | 450.0 | 510.0 | 38.0 | 13.4x |
| LogicGate Systems | LGYS | 780.0 | 810.0 | 62.0 | 13.1x |
Summary Statistics
- Peer Median: 13.1x
- 25th Percentile: 12.6x
- 75th Percentile: 13.6x
Implied Target Valuation
- Target EBITDA: 50.0
- Implied Enterprise Value (Median): 655.0 (50.0 * 13.1x)
- Less: Net Debt: (100.0)
- Implied Equity Value: 555.0
- Diluted Shares: 10.0
- Implied Value Per Share: 55.50
Workbook Structure Recommendations
[Tab: Trading Comps]
- Columns: Ticker, Price, Shares, Mkt Cap, Debt, Cash, EV, EBITDA, EV/EBITDA
- Formulas: EV = Mkt Cap + Debt - Cash
- Handling: Use =IF(EBITDA<=0, "N/M", EV/EBITDA)
[Tab: Valuation Summary]
- Link target EBITDA to the 'Trading Comps' Median cell.
- Build a sensitivity table showing +/- 1.0x multiple range.
Next steps
- Verify the current share prices for all 5 peers to ensure the multiples reflect current market conditions.
- Populate the 'Raw Data' tab with the most recent 10-K or 10-Q filings for accurate LTM EBITDA figures.
- Check if any peers have significant Non-Controlling Interests that need to be added to the Enterprise Value bridge.
Connects securely to your tools. The creator never sees your data.
About this skill
Building a defensible comparable-company analysis requires more than just a list of tickers. It demands rigorous peer selection, consistent enterprise value adjustments, and auditable formulas. Manual entry often leads to broken bridges between market cap and EV, or misleading averages skewed by negative earnings.
This skill structures the entire comps workflow within a spreadsheet-ready framework. It handles the heavy lifting of organizing peer buckets, defining operating metrics, and calculating trading multiples like EV/EBITDA and P/E. It ensures you account for diluted shares, non-controlling interests, and cash adjustments while maintaining clear separation between hardcoded inputs and calculated outputs. The result is a professional valuation model ready for investment memos or corporate finance exercises.
What it does
- Peer selection logic defines a defensible set based on business model, geography, and growth profiles.
- Enterprise value bridging calculates EV from market cap, debt, cash, and minority interests.
- Multiples calculation generates EV/Revenue, EV/EBITDA, and P/E ratios with automated N/M labeling for negative values.
- Statistical summarizing provides mean, median, and interquartile ranges for the full set and specific buckets.
- Implied valuation applies peer multiples to target metrics to derive equity value per share.
How it works
- Define target parameters by inputting the company name, sector, valuation date, and reporting currency.
- Execute peer grouping to categorize direct competitors and adjacent industry players into distinct buckets.
- Map the data table using the recommended layout for operating metrics and valuation multiples.
- Review quality checks to verify currency consistency and reconciliation of enterprise value formulas.
Frameworks & tools
This skill is designed for Microsoft Excel and compatible spreadsheet software. It follows standard investment banking valuation conventions for LTM and forward-looking financial analysis.
Why this beats prompting it yourself
Generic prompts often fail to correctly adjust for net debt or handle the nuances of diluted share counts. This skill enforces professional finance standards, ensuring EV formulas are technically accurate and peer statistics exclude non-meaningful outliers that skew results.
Use cases
- Drafting a trading comps section for an investment committee memo.
- Building a valuation dashboard to monitor sector-specific trading multiples.
- Creating a classroom or practice model for financial valuation training.
- Benchmarking a private company against a set of publicly traded peers.
Known limitations
Does not provide real-time market data or automated API pulls. User must manually verify share prices and financial statement inputs. Not intended for use as investment advice.
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 manual entry of market prices and financials. Cannot independently verify external data sources. Designed for standard equity valuation, not specialized distressed or utility models.
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
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 18 days ago
Permissions
No special permissions declared or detected