본문으로 건너뛰기
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(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

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 / 1,000자

이 양식은 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/plugins7.5천2026년 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/plugins7.5천2026년 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/plugins7.5천2026년 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/plugins7.5천2026년 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/plugins7.5천2026년 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/plugins7.5천2026년 10월 8일 업데이트

openai의 스킬 모두 보기

이 스킬의 문제 신고