Driver-Based Revenue and Expense Forecast
Build a reconciled revenue and expense forecast with explicit drivers, base/bull/bear cases, and ranked swing factors.
Before & after
Same prompt, same agent — the only difference is the skill.
I can help you build that forecast. You'd start with your historical revenue data and work out some assumptions about growth rates, customer acquisition, churn, and expansion revenue. Then we can project those forward over 12 months and create a base case and an upside scenario. The bull case would have higher growth assumptions—maybe better retention, more aggressive customer acquisition, higher average deal size. You'd probably want to show how changes in each assumption affect the forecast. It helps to break it down by customer segment or revenue stream so you can see which parts of the business are driving growth. Do you have your historical data in a spreadsheet? What time period do we have to work with?
12-MONTH REVENUE FORECAST: BASE, BULL, BEAR SCENARIOS (illustrative example; not financial advice) FORE CAST DRIVERS → Starting ARR: 2.4M (as of July 31, 2026) → New customer acquisition: 8 customers/month avg × 28K avg contract value (ACV) → Expansion ARR: 12% of installed base quarterly (upsell + add-ons) → Churn: 4% monthly cohort; improves to 2% after year 2 → Pricing increase: Jan 2027 (+7%) and Jul 2027 (+5%) for renewals only BASE CASE: Conservative assumptions → Aug-Dec 2026: +180K new ARR (8 customers/mo × 28K ACV × 5 mo) → Expansion: +140K (12% churn-adjusted base) → Churn impact: -95K (4% monthly on growing base) → Jan 2027: 2.625M, with pricing bump to 2.808M → Dec 2027 projection: 3.2M ARR BULL CASE: Aggressive—SMB market acceleration, higher ACV → CAC down 25% (higher inbound quality). Customers/month jumps to 12. → ACV expands to 35K (higher-tier adoption). → Churn improves to 2% (product-market fit signals). → Dec 2027 projection: 4.1M ARR (+28% vs base) → Key driver: Q3 2027 inflection where expansion overtakes new-customer contribution BEAR CASE: Market slowdown, CAC rising → Customers/month drops to 5. ACV stays 28K. Churn worsens to 5%. → Pricing increases delayed to Q3 2027. → Dec 2027 projection: 2.7M ARR (still growth, but 16% slower) VARIANCE DRIVERS (where to focus) → Biggest swing: churn improvement (4%→2%) = +600K ARR by Dec 2027 → Second: pricing realization (Jan + Jul increases) = +160K → Watch: expansion % (12% assumes stable product stickiness; breakage kills bull case)
About this skill
Your forecast shows growth, but nobody can explain which customers, prices, or hires produce it. This skill builds revenue and expenses from visible operating drivers, reconciles them to actuals, and shows what changes across base, bull, and bear cases.
What it does
- Selects revenue equations that fit subscriptions, product sales, services, or a mixed business.
- Reconciles historical driver calculations to reported revenue and expenses before projecting them.
- Models customer losses, acquisition timing, hiring dates, capacity limits, and cost behavior explicitly.
- Builds coherent base, bull, and bear cases with supported ranges and stated assumptions.
- Ranks the drivers behind the scenario spread and identifies the largest swing factor.
- Rolls the forecast forward with new actuals while preserving the previous forecast for comparison.
What you get
A period-by-period forecast with editable assumptions, revenue and expense formulas, three scenario cases, reconciliation checks, and a concise explanation of the main swing factors. Missing inputs are labeled, so a provisional model remains useful without presenting guesses as company facts.
Best for
Finance teams, founders, and operators building or refreshing monthly operating forecasts for planning, management reviews, and board discussions.
SKILL.md preview
---
name: driver-based-revenue-and-expense-forecast
description: >-
Builds rolling revenue and expense forecasts by reconciling historical actuals to operating drivers, modeling timing and capacity, and projecting coherent base, bull, and bear cases with ranked swing factors. Use when the user says "build our revenue forecast", "forecast next quarter's expenses", "give me base bull and bear cases", "update the rolling forecast", "my forecast never matches actuals", "what is driving the forecast spread", or "review these forecast assumptions".
---
# Driver-Based Revenue and Expense Forecast
… (sign up to view the full skill)Featured in
More finance skills
View all Finance skills →Portfolio Rebalance Advisor
Drop in your current holdings and target allocation — get the exact buy/sell list, tax-loss opportunities, and drift alert.
Personal Finance Q&A
Ask any personal-finance question and get a plain-English answer tailored to your bracket, timeline, and risk appetite.
Earnings Report Analyzer
Paste a 10-K, 10-Q, or earnings call transcript — get the numbers that matter, the narrative changes, and what the CFO tried to bury.
Investment Committee Decision Memo
Turn deal materials into an investment memo with traced evidence, reconciled financials, downside cases, and decision gates.