Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Comps Valuation Excel Skill πŸ“ˆ

    1

    Build structured, audit-ready trading comparable valuation models in Excel with peer buckets and implied pricing.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Comps Valuation Excel Skill πŸ“ˆ

    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 NameTickerEV/Revenue (LTM)EV/EBITDA (LTM)P/E (LTM)Revenue GrowthEBITDA Margin
    CloudScale IncCLSD8.5x22.0x45.0x25%20%
    DataFlow SystemsDAFS6.0x18.5x38.0x18%15%
    NetLogic GroupNLOG7.2x20.0x42.0x22%18%
    SaaSFlow CoSFLW9.1x25.0x50.0x30%22%
    Vertex SoftwareVRTX5.5x16.0x35.0x15%12%
    Median7.2x20.0x42.0x22%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

    1. Verify the LTM EBITDA for the 5 peers against their latest 10-Q or 10-K filings.
    2. Update the share prices to the current market close for accurate market caps.
    3. 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

    1. Define target by providing the name, ticker, sector, and the financial period to be used for the valuation.
    2. Collect data for the peer set, including share prices, diluted shares, and core income statement items.
    3. 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.

    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.

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

    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

    Listed18 days ago
    Updated7 days ago

    What's inside

    Frequently Asked Questions

    This skill automates the complex structural layout and financial logic of a trading multiples workbook, ensuring enterprise value bridges and statistical peer summaries are mathematically consistent and audit-ready.

    The skill generates a structured workbook compatible with Microsoft Excel, Google Sheets, and LibreOffice, provided your AI agent has permission to output or edit spreadsheet files.

    No, this skill focuses on the structural and logical framework; you will need to provide the specific financial data and current share prices for the target and peer companies.

    You receive the logic and architectural instructions for a six-tab professional valuation model, including peer buckets, standardized multiples formulas, and implied pricing summaries.

    The skill includes logic to identify and filter out 'Non-Meaningful' (N/M) values, preventing outliers from skewing your mean, median, and interquartile range calculations.

    New in Finance & Accounting