Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    comps valuation excel Skill Prop

    1

    Build auditable comparable-company valuation models in Excel with structured peer buckets and EV-bridge formulas.

    $9

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    comps valuation excel Skill Prop

    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

    CompanyTickerMarket CapEnterprise ValueLTM EBITDAEV/EBITDA
    CloudScale IncCLSD850.0920.080.011.5x
    DataFlow CorpDFLW600.0580.045.012.9x
    NetSecure LtdNSEC1,200.01,350.095.014.2x
    SaaSStream CoSSTR450.0510.038.013.4x
    LogicGate SystemsLGYS780.0810.062.013.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

    1. Define target parameters by inputting the company name, sector, valuation date, and reporting currency.
    2. Execute peer grouping to categorize direct competitors and adjacent industry players into distinct buckets.
    3. Map the data table using the recommended layout for operating metrics and valuation multiples.
    4. 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.

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

    Listed18 days ago

    What's inside

    Frequently Asked Questions

    This skill provides a structured framework and logic to build professional-grade valuation models, ensuring accurate Enterprise Value (EV) bridging and peer statistics while eliminating common manual errors found in basic spreadsheets.

    The skill is designed to work with any AI agent capable of generating structured Excel files or complex spreadsheet logic, including ChatGPT (Advanced Data Analysis), Claude, and Microsoft Copilot.

    No, this skill focuses on the structural logic and formulaic framework; users must input the specific financial data and current share prices to ensure the most up-to-date valuation.

    You will receive the complete logic set for peer categorization, EV bridging formulas, and the standardized Excel layout required to produce investment-banking-ready valuation outputs.

    Yes, the framework is designed to handle both Last Twelve Months (LTM) and forward-looking projections, allowing you to compare historical performance alongside future growth expectations.

    New in Finance & Accounting