skills.rest
t0ddc3by
t0ddc3byCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

scenario-modeling

Generate P10/P50/P90 ARR forecast scenarios from HubSpot pipeline data.

58|21|Updated May 15, 2026
Search Tags:#forecasting#scenario planning#hubspot#capacity planning#revops#win rate sensitivity
One-click install
npx skills add https://github.com/t0ddc3by/claude-for-customer-success --skill scenario-modeling-t0ddc3by
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: scenario-modeling
Source: https://github.com/t0ddc3by/claude-for-customer-success/tree/main/rev-ops/skills/scenario-modeling
Command: npx skills add https://github.com/t0ddc3by/claude-for-customer-success --skill scenario-modeling-t0ddc3by

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Scenario modeling converts current RevOps pipeline state into calibrated downside/base/upside forecasts (P10/P50/P90) so leaders can plan capacity and assess risk without relying on a single-point estimate.

Core Features & Use Cases

  • Range Forecast Generation: Builds P10/P50/P90 ARR scenarios from HubSpot pipeline state and stage/segment win-rate history.
  • Sensitivity & Risk Modeling: Quantifies win-rate sensitivity (±5pp) and flags enterprise concentration risk when top accounts dominate pipeline.
  • Annual Planning Handoff: Produces structured outputs including p10/p50/p90_growth_pct fields for annual-planning-workflow capacity modeling.

Quick Start

Ask it to build downside/base/upside ARR scenarios for next year using your current pipeline, P10/P50/P90, and win rate sensitivity.

Frequently Asked Questions about scenario-modeling

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate P10 P50 P90 revenue scenarios from HubSpot pipeline data?▼

Range forecasting uses stage-and-segment win-rate history to convert current pipeline into P10/P50/P90 scenarios, preventing reliance on single-point estimates. It quantifies win-rate sensitivity and flags enterprise concentration risk for annual planning.

Can I model win rate sensitivity and slip scenarios for RevOps annual planning?▼

Yes, scenario modeling requires HubSpot pipeline data with data-as-of timestamps and company-profile inputs. These prerequisites enable stage-and-segment win-rate modeling to accurately forecast P10/P50/P90 ARR scenarios.

What is the best way to assess enterprise concentration risk in my revenue forecast?▼

The output produces a structured three-scenario table plus p10/p50/p90_growth_pct handoff fields for capacity modeling. These structured fields integrate directly into annual-planning-workflow to support downstream RevOps capacity decisions.

How do I use P10 P50 P90 forecast outputs for capacity planning?▼

Use the structured p10/p50/p90_growth_pct handoff fields from the three-scenario table as inputs for annual-planning-workflow capacity modeling. This allows RevOps leaders to align capacity with calibrated downside, base, and upside projections.

Related Skills

Explore More Data & Analytics Skills→
t0ddc3byt0ddc3by
58

pipeline-coverage-analysis

Calculate pipeline coverage ratios from segment-specific win rates.

Community
Advanced
t0ddc3byt0ddc3by
58

closed-won-to-cs-capacity-modeling

Convert closed-won ARR into CSM capacity demand with P10/P50/P90 scenarios.

Community
Advanced
kenny589kenny589
58

icp-matrix-builder

Construct ICP matrices with multi-dimensional scoring and tiering rules.

Community
Advanced
devCharuzudevCharuzu

cro-advisor

Forecast B2B SaaS revenue by modeling ARR, churn, and NRR from CSV inputs.

Community
Advanced