Revenue Forecast Builder for FP&A
Build driver-based revenue forecasts with scenario modeling and sensitivity analysis
What You Can Do
You'll construct defensible, driver-based revenue forecasts that link operational metrics (customer count, contract value, churn, win rates) directly to revenue outcomes. Claude helps you build base, upside, and downside scenarios with transparent assumptions, perform sensitivity analysis to quantify business variable impacts, and automatically document variance explanations—enabling you to respond confidently to CFO and board-level scrutiny.
Features
Link operational metrics to revenue outcomes with explicit causal logic instead of trend extrapolation
Build base, upside, and downside cases with clearly documented assumptions for each scenario
Quantify how changes in key drivers (customer count, contract value, churn rate, win rate) impact revenue projections
Automatically create audit trails showing which assumptions drive each forecast scenario
Generate structured variance analysis comparing actuals to forecast with root cause documentation
Quickly pivot forecasts when business conditions change by adjusting driver assumptions
Produce executive summaries and detailed model tabs formatted for board presentations and investor materials
Example Output
Example 1: SaaS Revenue Forecast Base Case: 5,000 starting customers → 8,500 by year-end (40% net growth)
- New customer acquisition: 100/month (assumes 20% increase in sales headcount)
- Monthly churn: 2% (assumes new retention program reduces from 2.5%)
- ARPU growth: $2,500 → $2,750 (assumes feature upgrade adoption)
- Result: $22.5M revenue
Upside: 10,200 customers, $25.2M revenue (if win rate +15%) Downside: 7,200 customers, $19.8M revenue (if churn rises to 2.8%)
Example 2: Sensitivity Table
| Driver | -10% | Base | +10% |
|---|---|---|---|
| Customer Acquisition | $20.1M | $22.5M | $24.9M |
| Churn Rate | $24.2M | $22.5M | $20.8M |
| ARPU | $21.0M | $22.5M | $24.0M |
Example 3: Variance Explanation ✓ Forecast miss: -$1.2M (-5.3%) ✓ Primary driver: Churn rate 2.8% vs. assumed 2.0% (impact: -$1.8M) ✓ Offset by: ARPU exceeded forecast by $150 (impact: +$650K) ✓ Recommendation: Accelerate retention initiatives in Q2
What's Included
- SKILL.md instruction file: Complete prompting guidance for driver-based forecast building
- Revenue forecast template: Multi-scenario workbook structure with driver inputs, calculations, and scenario tabs
- Sensitivity analysis checklist: Step-by-step framework for identifying key drivers and testing ranges
- Assumption documentation template: Structured format for recording assumptions, rationale, and confidence levels
- Variance explanation framework: Guided approach for comparing actuals to forecast and documenting root causes
Who It's For
- FP&A analysts and managers building annual operating plans and reforecasts
- CFOs and controllers preparing board-level financial projections
- Corporate development professionals modeling revenue impact of M&A or strategic initiatives
- Finance business partners supporting product launches, market expansion, or organizational changes
- Investor relations and treasury teams building earnings guidance and external financial models
Best For
- Annual and multi-year revenue forecasting with explicit business assumptions
- Board and investor presentation materials requiring defensible projections
- Scenario modeling for strategic planning (upside, base, downside cases)
- Quarterly reforecasting cycles with variance analysis and assumption updates
- What-if analysis for pricing changes, customer mix shifts, or operational efficiency improvements
You might also like
You can rapidly generate first-draft deal execution documents—LOIs, purchase agreements, and closing checklists—while Claude maintains consistency across all exhibits, schedules, and legal definitions. The skill cross-references conditions and dependencies across documents, flags gaps or circular logic before legal review, and tracks completion status against your deal timeline to surface execution risk early.
by fastclaw-ai
You can conduct multi-scenario covenant stress testing to quantify financial headroom between current metrics and covenant thresholds, identify which covenants are most vulnerable to market downturns, and calculate the cost-benefit of proactive amendments versus reactive refinancing. This enables you to report covenant health to leadership with actionable mitigation strategies before breach risk materializes.
by fastclaw-ai
You can generate complete financial models that integrate P&L statements, balance sheets, and cash flow forecasts from a business plan or strategic initiative. The skill systematizes revenue drivers, cost structures, and cash dynamics into models with transparent, stress-testable assumptions. You'll receive base case, downside, and upside scenarios with working capital dynamics and debt schedules ready for board presentations or investor analysis.
by eryet
You can build comprehensive deal execution timelines that map interdependencies across all workstreams—legal, regulatory, financing, and operations—and automatically flag risks that could delay closing. The skill identifies which delays actually impact your close date versus minor slippage, creates decision trees for contingency scenarios, and generates stakeholder-ready reports for boards, lenders, and sponsors. You turn raw deal data into a living, weekly-updated source of truth for deal execution status.
by fastclaw-ai
You can build 12-month rolling forecast models that automatically drop the oldest completed month and add a new forward month as actuals close each period. The skill calculates budget variances (favorable/unfavorable) with root cause drivers, reforecasts remaining quarters based on current spending patterns and run-rate assumptions, and generates executive dashboards highlighting key budget risks and opportunities before they become serious overruns.
by fastclaw-ai
You'll build comprehensive DCF models that automate explicit forecast periods, terminal value calculations, and weighted average cost of capital derivation. The skill produces audit-ready assumption documentation, multi-scenario sensitivity tables, and valuation ranges across bear/base/bull cases—all formatted for board presentations and fairness opinions. You'll stress-test equity value assumptions and compare DCF outputs to trading multiples and M&A precedent data.
by fastclaw-ai
You can conduct structured financial due diligence on acquisition targets by analyzing audited and unaudited statements across multiple years. This skill helps you detect earnings manipulation, unsustainable trends, hidden liabilities, and working capital deficiencies that affect valuation. You'll produce a Financial Risk Summary that quantifies impact on deal valuation, debt capacity, and post-acquisition cash generation.
by fastclaw-ai
You systematically evaluate bank proposals against standardized criteria, uncovering pricing structures and covenant terms that impact your treasury strategy. The framework helps you compare commitment fees, arrangement fees, and facility structures across multiple term sheets, then generates data-backed talking points for renegotiating existing arrangements and consolidating redundant banking relationships.
by fastclaw-ai