跳到正文
cccskills
免费在 GitHub 公开

comps-valuation

Compare a listed company with relevant peers using valuation multiples, ratios linking price or company value to financial measures. Produce reports or editable workbooks covering peer selection, implied prices, data quality, and valuation assumptions.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

Produce Public Equity Investing comparable-company valuation in report or workbook mode. Use for peer selection, multiple analysis, valuation read-throughs, implied prices, comps dashboards, Excel or Sheets comps, refreshable peer tables, model updates, and comps workbook QA. Do not use for DCF-only, credit-security, or generic market commentary requests.

集成工具Excel
查看安装方法

适用场景

  • Select comparable companies and explain peer choices
  • Assess valuation premiums and discounts
  • Build an Excel or Sheets valuation workbook
  • Update and check an existing comparable-company model

包含的文件(20)

  • SKILL.md7.6 KB
  • agents/openai.yaml298 B
  • references/DASHBOARD_PACK.md4.3 KB
  • references/module-rules.md3.9 KB
  • references/output-templates.md5.0 KB
  • references/p0-integrations.md3.3 KB
  • references/peer-selection.md4.2 KB
  • references/source-and-staleness-rules.md4.8 KB
  • references/valuation-readthrough.md5.3 KB
  • references/workbook-mode.md1.2 KB
  • references/workbook/comps-framework.md8.5 KB
  • references/workbook/dashboard-map.md1.6 KB
  • references/workbook/data-sourcing-and-connectors.md5.5 KB
  • references/workbook/model-workbook-spec.md7.2 KB
  • references/workbook/qa-and-pressure-testing.md4.9 KB
  • references/workbook/review-memo-template.md2.6 KB
  • scripts/audit_comps_workbook.py17.8 KB
  • scripts/create_comps_template.py39.8 KB
  • scripts/materialize_screening_comps.py21.6 KB
  • scripts/requirements.txt35 B

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Comps Valuation

Skill Configuration

Common Skill Instructions

MANDATORY: Before searching connectors, retrieving evidence, or drafting output, read and apply the shared runtime contract in ../public-equity-investing/SKILL.md## Cross-Skill Runtime Contract. Then check the router skill map and ../../shared/plugin-routing-playbook.md for adjacent skills that should be sequenced with this workflow. Do not run user-context setup or inspection during ordinary workflow work; route only explicit saved-context, source-setup, onboarding, or automation-setup requests to ../user-context/SKILL.md.

Source Resolution

Load ../../shared/workflow-source-resolution.md. Resolve only the categories needed for this workflow: company_filings_ir, market_data_estimates, and portfolio_models_trackers. Use the shared runtime contract to map each attempted category to an available app, connector, file, export, or user-provided input.

Relevant Dependency Categories

These are the source categories most likely to matter for this workflow. Use the router contract to resolve only the categories the task actually needs, prefer user-named sources first, and state any material source limitation.

  • Market Data & Estimates
  • Company Filings & IR
  • Portfolio Models & Trackers

Deliverable Intake And Judgment Standard

Before source gathering or analysis for a new substantive hero deliverable, load ../../shared/deliverable-intake-policy.md and use its adaptive request_user_input preflight for materially unresolved format, depth, audience/use, or focus choices. Reuse resolved preferences downstream. For substantive investment judgment, apply ../../shared/final-deliverable-framework.md.

Equity Valuation PM Standard

Load ../../shared/equity-valuation-pm-standard.md and ../../shared/pm-judgment-heuristics.md for substantial model, valuation, scenario, model-update, or audit work.

The output must state what the current stock price implies, the variant estimate path, whether upside is driven by fundamentals, multiple expansion, mix, capital return, sentiment, or event probability, what breaks first in downside, the valuation posture and next underwriting step, and what evidence is missing. State what changes target, rating, sizing, hedge, trim, exit, or watchlist status only when the user requests portfolio action or provides the relevant holding, benchmark, mandate, and liquidity context.

Keep equity valuation as the center of gravity. Debt is allowed only as an input to common-equity value through net debt, cost of debt, leverage, liquidity, refinancing risk, or downside equity impairment. Use Credit Markets for bond comps, loan comps, CDS, spread/yield relative value, covenant-package analysis, debt-security valuation, recovery waterfall, restructuring valuation, creditworthiness, private-credit or public-credit instrument underwriting, or distressed claim valuation.

Mode Selection

Select the mode from the request and available context; do not ask merely because both modes exist.

  • report mode: peer framing, multiple interpretation, implied valuation or price read-through, peer-set review, PM-facing comps argument, or a standalone HTML report or explicitly requested standardized dashboard without an editable model.
  • workbook mode: Excel, Sheets, CSV/XLSX export, refreshable data, formulas, EV bridges, peer-table templates, workbook/model updates, structured sensitivities, or auditing an existing comps workbook.
  • If an existing workbook is supplied and the requested output changes or validates it, choose workbook.
  • Ask one focused question only when either mode is equally plausible and choosing incorrectly would materially change the user's intended artifact or decision workflow. Prefer proceeding with a stated inferred default when reliance is not impaired.

Common Workflow

  1. Establish security, issuer or target, audience mode, valuation date, fiscal basis, currency, and thesis question.
  2. Source and label price, shares, EV bridge, reported/adjusted/consensus denominators, forward estimates, and peer rationale.
  3. Build Core, Secondary, Excluded, and optional Watchlist peer roles.
  4. Test metric comparability, stale data, outliers, valuation range, premium/discount logic, and PM action implications.
  5. State what is priced in, what would change the thesis, and what evidence is missing.
  6. Render or materialize the selected mode.

Report Mode

Read references/peer-selection.md, references/module-rules.md, references/source-and-staleness-rules.md, references/valuation-readthrough.md, references/output-templates.md, and references/p0-integrations.md only when relevant. For a substantial reusable or HTML comps report, produce a polished standalone HTML comps report following ../../shared/html-artifact-standard.md; let the valuation question and supported evidence determine the hierarchy. Use dashboard-builder only when the user explicitly asks for a standardized dashboard, reusable dashboard template, PM cockpit, or structured payload-driven render; in that case, load references/DASHBOARD_PACK.md and hand over a public_equity_investing_dashboard.v1 payload.

For a standalone HTML comps report, keep the first read compact:

  1. Valuation read: whether the premium or discount is supported and the key unresolved proof point.
  2. Four or five high-signal metrics: current price, primary trading multiple, premium or discount to core peers, implied value range only when supportable, and the key operating proof point.
  3. Peer-set rationale: Core, Secondary, and Excluded peers with concise inclusion or exclusion reasons.
  4. Core trading-comps table.
  5. Premium or discount bridge grounded in growth, margin, business-model fit, and data quality.
  6. Valuation posture, material evidence gaps, and concise source ledger.

Express a valuation posture such as premium partly supported, screening-only, or not sufficiently supported for a new-money decision. Do not issue add, trim, hedge, sizing, or exit instructions unless the user requests portfolio action or supplies relevant holding and mandate context.

When HTML is delivered, keep citations traceable but readable: do not fragment tickers, prices, multiples, percentages, dates, numeric ranges, metric names, or peer labels into separately linked tokens. Visually inspect local HTML via local headless-browser screenshots, not the in-app Browser plugin, and iterate on hierarchy, density, clipping, citation rendering, and whitespace before delivery.

Workbook Mode

Read references/workbook/comps-framework.md, references/workbook/data-sourcing-and-connectors.md, references/workbook/model-workbook-spec.md, references/workbook/qa-and-pressure-testing.md, references/workbook/review-memo-template.md, and references/workbook/dashboard-map.md only when relevant. Use scripts/create_comps_template.py, scripts/materialize_screening_comps.py, and scripts/audit_comps_workbook.py as appropriate. Preserve an existing workbook before rebuilding it.

When To Invoke Support

Load ../../shared/support-layer-routing-contract.md when source/data/QC support is needed. Use financials-normalizer for messy issuer or peer inputs, model-audit-tieout for standalone workbook audit, and deck-report-qc before circulation. Route credit-first conclusions to Credit Markets.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Review charts, diagrams, and dashboards for accessibility, including color contrast, keyboard access, and text alternatives. Get specific guidance for preserving key findings in screen readers, static exports, and reduced-motion views.

中文简介正在准备中。当前显示英语简介。

  • Reviewing dashboard colors and keyboard access
  • Writing chart alt text and long descriptions
  • Preparing accessible figures for PDF reports
openai/plugins75032026年10月8日 更新

Give a photo collection a consistent look using Adobe tools to adjust color, tone, presets, and optional crops. Review a before-and-after sample before processing the full set, then receive links to the edited images.

中文简介正在准备中。当前显示英语简介。

  • Giving travel photos a consistent look
  • Unifying photos taken in mixed lighting
  • Applying a warm or cinematic style across a photo set
openai/plugins75032026年10月8日 更新

Visualize a logo, sketch, or design on products such as mugs, shirts, and business cards. Review a pilot image, generate a visually consistent set, and collect the results on a shareable Firefly Board.

中文简介正在准备中。当前显示英语简介。

  • Preview a logo on mugs and shirts
  • Turn a hand-drawn sketch into product mockups
  • Create consistent brand presentation images
openai/plugins75032026年10月8日 更新

Prepare images and videos for social platforms using Adobe tools. Create image crops that keep the subject in view, expand backgrounds when available, preview a full-set sample, and resize videos while preserving their aspect ratio.

中文简介正在准备中。当前显示英语简介。

  • Creating image variants for multiple social platforms
  • Cropping photos for Instagram Stories
  • Preparing LinkedIn images and YouTube thumbnails
openai/plugins75032026年10月8日 更新

Create flyers, social posts, business cards, and other visuals from Adobe Express templates. Choose a template, customize its text and background color, and receive a design link, with additional editing and export options depending on the available tools.

中文简介正在准备中。当前显示英语简介。

  • Creating an event flyer
  • Designing an Instagram post
  • Customizing business card text and colors
openai/plugins75032026年10月8日 更新

Turn an uploaded video into three highlight edits with Adobe Quick Cut. Choose a target length and style, then compare versions that feature different moments and download the ones you prefer.

中文简介正在准备中。当前显示英语简介。

  • Creating a short highlight video for social media
  • Condensing interview footage into a highlight reel
  • Comparing three edits with different moment selections
openai/plugins75032026年10月8日 更新

查看 openai 的全部技能

报告此技能的问题