Financial Forecasting Skill

Builds driver-based revenue and expense forecasts with base, bull, and bear scenarios.

Finance / Modelingfinancemodeling
by AgentVoltv1.0.0Published 1y ago1 install
Free to sign up · every skill included with AgentVolt Pro

Before & after

Same prompt, same agent — the only difference is the skill.

PromptBuild a 12-month revenue forecast with base and bull case scenarios.
Beforegeneric AI agent
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?
Afterwith Financial Forecasting Skill
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

SKILL.md
---
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)
Sign up to view, copy, and install the full skill

Featured in

More finance skills

View all Finance skills →