本文へ移動
cccskills
無料GitHub で公開

modeling-contingent-consideration

Structures earnout and contingent payment mechanisms with milestone definitions, measurement periods, and payout scenarios. Use when modeling earnouts, designing milestone-based payments, or valuing contingent consideration.

インストール方法を見る

含まれるファイル(1)

  • SKILL.md6.9 KB

SKILL.md(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

Modeling Contingent Consideration

When To Use

  • Structuring earnout provisions in M&A purchase agreements where a portion of deal consideration is contingent on post-closing performance
  • Valuing contingent consideration for ASC 805 fair value measurement at acquisition date and subsequent remeasurement periods
  • Designing milestone-based payment schedules tied to revenue, EBITDA, product development, or regulatory approvals
  • Evaluating earnout proposals from a buyer or seller perspective during deal negotiations
  • Modeling payout scenarios for board presentations, fairness opinions, or deal committee materials

Inputs To Gather

  • Deal parameters: Total enterprise value, upfront cash/stock consideration, maximum earnout amount, earnout term (typically 1–3 years)
  • Milestone definitions: Specific metrics (revenue, EBITDA, gross profit, unit sales, regulatory milestones), threshold vs. tiered structures, and whether milestones are cumulative or period-specific
  • Target financials: Historical P&L (3+ years), management projections, and base-case budget for the earnout period
  • Measurement mechanics: Accounting standard for metric calculation (GAAP vs. adjusted), permitted/excluded items, working capital treatment, and whether the business operates as standalone or integrated
  • Payment terms: Timing of measurement and payment (quarterly, annual, end-of-term), caps and floors, acceleration triggers (e.g., change of control), and catch-up provisions
  • Discount rate inputs: Risk-free rate, counterparty credit risk, metric-specific volatility, and comparable transaction earnout data
  • Dispute resolution: Mechanism for disagreements on metric calculations (independent accountant, arbitration) — note for structural modeling, not valuation

Workflow

  1. Classify the earnout type

    • Financial metric-based (revenue, EBITDA, gross margin) vs. non-financial milestone-based (FDA approval, patent grant, customer retention)
    • Single-period vs. multi-period measurement; binary payout vs. linear/tiered interpolation
    • Determine if the earnout is compensatory (ASC 805-10-55-25 indicators) vs. part of purchase price [VERIFY against specific deal facts]
  2. Build the base-case scenario model

    • Project the relevant metric across each measurement period using management forecasts as the starting point
    • Map metric outcomes to payout amounts using the earnout formula (threshold, cap, interpolation method)
    • Calculate present value of expected payouts using a risk-adjusted discount rate
  3. Construct scenario/probability framework

    • Define 3–5 discrete scenarios (e.g., downside, below-plan, base, upside, stretch) with probability weights
    • For financial metrics: use Monte Carlo simulation or scenario-probability-weighted approach; calibrate volatility to comparable company revenue/EBITDA variability
    • For non-financial milestones: assign probability of achievement based on comparable precedents, pipeline stage, or expert input
    • Probability weights must sum to 100%; document the basis for each weight
  4. Apply valuation methodology

    • Scenario-based method (SBM): Probability-weight each scenario's payout, discount to present value; appropriate for linear or simple structures
    • Option pricing method (OPM): Use for earnouts with caps, floors, or non-linear payoff profiles; model as a call spread or digital option on the underlying metric
    • Monte Carlo simulation: Required for path-dependent earnouts, correlated metrics, or complex tiered structures
    • Select discount rate: risk-free rate + credit spread for financial-metric earnouts; higher risk premium for non-financial milestones [VERIFY discount rate methodology with valuation team]
  5. Run sensitivity analysis

    • Vary key assumptions: metric growth rate (±5–15%), probability weights (shift ±10%), discount rate (±100–200 bps), and volatility (±5–10%)
    • Produce a sensitivity table showing earnout fair value across a matrix of two key variables
    • Identify breakeven points: at what metric level does the earnout begin paying, hit the cap, or cross a tier
  6. Model structural protections and edge cases

    • Acceleration on change of control or breach of operating covenants
    • Catch-up provisions if early periods miss but later periods exceed targets
    • Anti-sandbagging: model impact of buyer actions that could suppress metric (e.g., overhead allocation, revenue diversion, customer reassignment)
    • Pro-ration for partial-period measurements

Output

  • Earnout summary table: Metric thresholds, tiers, caps/floors, measurement periods, and maximum contingent consideration
  • Scenario waterfall: Each scenario with metric projection, resulting payout, probability weight, weighted payout, and PV of weighted payout
  • Fair value summary: Point estimate of contingent consideration fair value with range (e.g., 25th–75th percentile from simulation)
  • Sensitivity matrix: Two-variable sensitivity table (e.g., revenue growth vs. discount rate) showing fair value at each intersection
  • Payout profile chart: Visual showing payout amount as a function of the underlying metric, highlighting thresholds, linear interpolation zones, and caps
  • Key assumptions register: Numbered list of every material assumption with source, rationale, and [VERIFY] flags where judgment-dependent

Quality Checks

  • Confirm earnout payout formula exactly matches the draft purchase agreement language — any ambiguity in "adjusted EBITDA" definitions, excluded items, or rounding conventions must be flagged
  • Verify probability weights reflect current market conditions and target-specific risk, not generic assumptions
  • Check that the discount rate is consistent with the risk profile of the metric (revenue earnouts carry less discount than EBITDA earnouts due to lower volatility)
  • Ensure the model handles edge cases: zero payout scenario, maximum payout scenario, partial-period proration, and mid-term change of control
  • Validate that fair value output is reasonable relative to maximum earnout amount (typical range: 30–70% of max for financial earnouts)
  • Cross-check simulation outputs against closed-form solutions where possible to confirm model integrity
  • Confirm ASC 805 classification: contingent consideration classified as liability requires remeasurement at each reporting date; equity classification does not [VERIFY classification with accounting advisors]

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

Evaluates activist investor campaigns with thesis assessment, proposed changes, and likely outcome analysis. Use when analyzing activist situations, evaluating campaign theses, or assessing activist track records.

日本語の概要は準備中です。原文の説明を表示しています。

CaseMark/skills442026年9月9日 更新

Evaluates corporate vulnerability to shareholder activism with governance assessment, valuation gaps, and operational improvement opportunities. Use when assessing activist risk, identifying vulnerabilities, or preparing defensive analyses.

日本語の概要は準備中です。原文の説明を表示しています。

CaseMark/skills442026年9月9日 更新

Evaluates bolt-on acquisitions for existing platforms with strategic fit, synergy quantification, and return contribution analysis. Use when screening add-on targets, building platform acquisition strategies, or modeling tuck-in economics.

日本語の概要は準備中です。原文の説明を表示しています。

CaseMark/skills442026年9月9日 更新

Evaluates signal half-life, turnover implications, and capacity constraints for systematic alpha factors. Use when analyzing signal persistence, evaluating factor decay, or estimating strategy capacity.

日本語の概要は準備中です。原文の説明を表示しています。

CaseMark/skills442026年9月9日 更新

Evaluates alternative data sources including satellite, NLP sentiment, web scraping, and geolocation for alpha signal generation. Use when analyzing alt data, evaluating new data sources, or integrating non-traditional signals.

日本語の概要は準備中です。原文の説明を表示しています。

CaseMark/skills442026年9月9日 更新

Evaluates competition law exposure with market definition, HHI analysis, and remedy estimation for proposed transactions. Use when assessing merger clearance risk, analyzing market concentration, or preparing HSR filings.

日本語の概要は準備中です。原文の説明を表示しています。

CaseMark/skills442026年9月9日 更新

CaseMark のスキルをすべて見る

このスキルの問題を報告する