Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Comps Valuation Excel

    12

    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

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    7 uses5.0 (1 review)
    Comps Valuation Excel

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    5.0
    1 review
    5
    1
    4
    0
    3
    0
    2
    0
    1
    0

    This skill has been used 7 times.

    Trust & safety

    Security scan

    Security scan passed 3 months ago

    Permissions

    No special permissions declared or detected

    Listed3 months ago

    What's inside

    Frequently Asked Questions

    The skill provides a pre-configured logic framework for Microsoft Excel and Google Sheets that automates the calculation of Enterprise Value, TTM valuation multiples, and statistical summaries for peer groups.

    This skill is compatible with AI agents that support spreadsheet integration, such as ChatGPT with Advanced Data Analysis or specialized financial modeling agents.

    You receive the structured modeling logic, a standardized template layout, and instructions for integrating your chosen data source to populate peer metrics.

    While the skill automates the heavy lifting of valuation formulas and statistical bucketing, you will still need to provide the raw financial inputs for your chosen peer set.

    The skill includes logic to flag outliers and ensures that Enterprise Value is calculated consistently across the entire peer set to prevent skewed median results.

    Buyers receive lifetime access to the current version, including any logic updates or formula optimizations released by the creator to ensure compatibility with new spreadsheet versions.

    New in Finance & Accounting