- Home
- Skills
- Finance & Accounting
- Comps Valuation Excel Skill π
Works with the AI Agents you already use
Comps Valuation Excel Skill π
Build structured, audit-ready trading comparable valuation models in Excel with peer buckets and implied pricing.
$5
Comps Valuation Excel Skill π
Example session with this skill installed
Create a trading comps structure for a mid-cap SaaS company with 5 peers. The target has $200M LTM Revenue and $40M EBITDA. Debt is $50M, Cash is $20M. 10M shares outstanding.
- Read your context and instructions
- Compiled the comps valuation excel
I have structured the trading comparables analysis for the target SaaS company. The peer set focuses on horizontal software providers with similar margin profiles.
Trading Comparables Analysis
| Peer Name | Ticker | EV/Revenue (LTM) | EV/EBITDA (LTM) | P/E (LTM) | Revenue Growth | EBITDA Margin |
|---|---|---|---|---|---|---|
| CloudScale Inc | CLSD | 8.5x | 22.0x | 45.0x | 25% | 20% |
| DataFlow Systems | DAFS | 6.0x | 18.5x | 38.0x | 18% | 15% |
| NetLogic Group | NLOG | 7.2x | 20.0x | 42.0x | 22% | 18% |
| SaaSFlow Co | SFLW | 9.1x | 25.0x | 50.0x | 30% | 22% |
| Vertex Software | VRTX | 5.5x | 16.0x | 35.0x | 15% | 12% |
| Median | 7.2x | 20.0x | 42.0x | 22% | 18% |
Implied Valuation (Based on Median EV/EBITDA)
- Target EBITDA: $40.0M
- Selected Multiple: 20.0x
- Implied Enterprise Value: $800.0M
- Less: Total Debt: ($50.0M)
- Add: Cash & Equiv: $20.0M
- Implied Equity Value: $770.0M
- Shares Outstanding: 10.0M
- Implied Price Per Share: $77.00
Workbook Formulas
[Market Cap] = Share_Price * Diluted_Shares
[Enterprise Value] = Market_Cap + Total_Debt + Preferred_Stock + Non_Controlling_Interest - Cash
[EV/EBITDA] = IFERROR(Enterprise_Value / EBITDA, "N/M")
[Implied Equity Value] = (Median_Multiple * Target_Metric) - Net_Debt
Next steps
- Verify the LTM EBITDA for the 5 peers against their latest 10-Q or 10-K filings.
- Update the share prices to the current market close for accurate market caps.
- Check for one-time non-recurring items in peer EBITDA to ensure a clean comparison.
Connects securely to your tools. The creator never sees your data.
About this skill
Financial analysts and developers building valuation tools often struggle with the manual overhead of structuring defensible comparable-company analyses. This skill automates the logic and layout of a professional trading multiples workbook, ensuring consistent math and peer grouping.
What it does
- Peer selection creates a defensible group of competitors categorized by business model, geography, and size.
- Multiples calculation generates EV/Revenue, EV/EBITDA, P/E, and FCF yields using standardized formulas.
- Enterprise value bridging maps the transition from market capitalization to EV by accounting for debt, cash, and minority interests.
- Statistical summarizing provides mean, median, and interquartile ranges for peer buckets while filtering out non-meaningful (N/M) values.
- Implied valuation applies peer benchmarks to target metrics to estimate enterprise and equity value per share.
How it works
- Define target by providing the name, ticker, sector, and the financial period to be used for the valuation.
- Collect data for the peer set, including share prices, diluted shares, and core income statement items.
- Structure the workbook using the recommended layout across six specialized tabs from raw data to valuation summary.
Frameworks & tools
Microsoft Excel or compatible spreadsheet software (Google Sheets, LibreOffice). Uses standard financial modeling logic for Enterprise Value and trading multiples.
Why this beats prompting it yourself
Generic prompts often fail to handle N/M values correctly or forget the specific bridge between Enterprise Value and Equity Value. This skill enforces strict formula consistency and audit trails, preventing common circularity or unit errors.
Use cases
- Build a trading comps table for an investment memo or pitch deck.
- Create a valuation cross-check for a DCF model.
- Generate a peer group margin and growth analysis for sector research.
- Scaffold a professional valuation workbook for financial training.
Known limitations
Does not provide live market data or automated API connections. Users must provide the actual financial figures and share prices.
Does not provide real-time market data or financial statements. User must manually input ticker prices and financial metrics. Does not replace professional investment advice.
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 any payment.
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