Financial Forecasting Skill
Builds driver-based revenue and expense forecasts with base, bull, and bear scenarios.
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
name: financial-forecasting description: Use when Builds driver-based revenue and expense forecasts with base, bull, and bear scenarios.
Financial Forecasting Skill
Turns historical data and assumptions into a rolling forecast with clearly separated drivers, then generates base/bull/bear scenarios and highlights the swing factors.
What you get
- A forecast model with driver assumptions and three scenario cases.
Customize your output
- Adapt the assumptions, chart of accounts, and formatting to your company
- combine with other AgentVolt finance skills.
Example output
A 3-scenario 12-month forecast with variance call-outs.
Best for
Finance teams and operators.
SKILL.md preview
---
name: financial-forecasting
description: Use this skill to build driver-based revenue and expense forecasts with base, bull, and bear scenarios from historical data and assumptions.
version: 1.0.0
category: Finance / Modeling
author: AgentVolt
license: proprietary
tags:
- finance
- modeling
- flagship
---
# Financial Forecasting Skill
Builds a rolling driver-based forecast from historical financials, then generates base, bull, and bear scenarios with the swing factors called out explicitly.
## When to use
… (sign up to view the full skill)Featured in
More finance skills
View all Finance skills →Scenario & Sensitivity Skill
Wraps any model in structured best/base/worst scenarios and sensitivity tables.
Financial Statements to Model
Turns raw PDF financial statements into a full Excel model with historicals and forecasts.
Three-Statement Model Builder
Builds a fully linked income statement, balance sheet, and cash flow model from your assumptions.
Portfolio Rebalance Advisor
Drop in your current holdings and target allocation — get the exact buy/sell list, tax-loss opportunities, and drift alert.