AI for Accountants · AI Applications in Accounting
Forecasting & Scenario Modeling
Model scenarios, compare outcomes
Forecasting & Scenarios
Good forecasting helps clients make informed decisions about investments, hiring, expansion, and resource allocation. However, creating reliable projections is very time-intensive.
Therefore, in this lesson, you'll learn how to use ChatGPT to build simple projections, model revenue increase/decrease scenarios, and compare outcomes side-by-side — accelerating your forecasting work while maintaining the professional judgment that ensures projections reflect business reality. Let's dive in!
Why Forecasting Matters
Clients need forward-looking financial information for:
- Planning decisions: Can we afford to hire? Should we expand capacity?
- Financing discussions: Banks and investors want projections with assumptions.
- Strategic evaluation: What happens if growth slows? If costs increase?
Historical performance tells you where you've been. Forecasting shows where you're headed under different assumptions.
Hence, the importance of forecasting creates the challenge of balancing:
- Speed: Clients often need projections quickly for time-sensitive decisions.
- Accuracy: Assumptions must reflect business reality, not wishful thinking.
- Scenarios: Single-point forecasts rarely capture uncertainty.
In this sense, AI can accelerate projection building and scenario modeling, freeing your time to focus on assumption validation and strategic interpretation.
Select all that apply
Given what you already know about AI, what do you think will be most important when using it for financial forecasting?
Building Simple Projections
The simplest forecasts project current trends forward — revenue growing at historical rates, expenses maintaining current relationships to revenue, working capital following established patterns.
These baseline projections provide starting points for more sophisticated scenario analysis.
ChatGPT can take your historical financial data and build forward projections based on assumptions you specify — growth rates, margin trends, seasonal patterns.
You provide recent performance data and growth assumptions, and ChatGPT structures the projection. Let's see how this works!
practice preview
Interactive practice
Fill in the blank
You need to project revenue for the next 12 months. Ask ChatGPT to build a simple forecast.
Notice how ChatGPT structured the projection clearly — monthly detail, quarterly rollups, and explicit assumptions.
This format makes it easy to discuss projections with clients and adjust assumptions if needed.
Choose one
Why does the projection include "Key Assumptions" even though the growth rate was already specified in the prompt?
Reliable forecasts include:
- Clear assumptions: growth rates, margin expectations, operational changes
- Historical baseline: what recent performance shows
- Time horizon: monthly, quarterly, annual projections
- Presentation format: structured for client discussion
Modeling Revenue Scenarios
Single-point forecasts rarely capture business uncertainty:
- Revenue might grow 8%
- But it could also grow 12% if market conditions strengthen
- Or, slow to 4% if competition intensifies
Therefore, scenario modeling shows this range of outcomes so clients can plan for multiple possibilities.
ChatGPT can model multiple revenue scenarios quickly and simultaneously — optimistic, baseline, and conservative cases — showing how different assumptions affect outcomes.
This helps clients understand not just what's likely, but what's possible under different conditions.
practice preview
Interactive practice
Fill in the blank
You need to show revenue projections under different growth assumptions. Ask ChatGPT to model three scenarios.
See how ChatGPT structured three scenarios with clear assumptions and strategic implications for each?
This format helps clients understand the range of outcomes and plan accordingly — not just hoping for the best, but preparing for multiple possibilities.
Choose one
Now, what do you think is the main professional risk of presenting only an optimistic forecast to support a client's financing request?
Use descriptive scenario names that indicate assumptions:
- "High growth" is clearer than "Scenario A"
- "Market downturn" is more useful than "Conservative"
- "New product success" specifies what drives the outcome
Modeling Expense Impact Scenarios
Revenue isn't the only variable worth modeling. Clients often need to understand how cost changes affect profitability:
- What happens if materials costs increase 10%?
- If we add two employees?
- If rent doubles?
Expense scenario modeling helps clients evaluate operational decisions before committing.
ChatGPT can model how specific cost changes flow through to profitability and cash flow, showing whether the business can absorb increases or needs pricing/revenue adjustments to maintain margins.
practice preview
Interactive practice
Fill in the blank
A client is facing potential cost increases and needs to understand the impact. Ask ChatGPT to model the scenario.
Great Work!
Just like that, you can ask ChatGPT to model the cost increase impact and provide mitigation options with any numbers.
As a result, this might help clients move from "this is happening" to "here's what we can do about it". This is what turning projections into strategic planning tools is about.
practice preview
Interactive practice
True / False
Decide whether this reflects appropriate scenario modeling.
practice preview
Interactive practice
True / False
Decide whether this reflects sound forecasting practice.
Making Forecasts Actionable
The goal of forecasting isn't predicting the future perfectly — it's helping clients make better decisions today.
Strong forecasts show:
- What's likely if current trends continue
- What's possible under different conditions
- What clients should watch to know which scenario is unfolding
As you use AI to accelerate projection building and scenario modeling, focus your professional judgment on:
- Are these assumptions realistic given client operations?
- Which scenarios matter most for client decisions?
- What should trigger plan adjustments if reality diverges from projections?
This is where your advisory value shows — not in the math, but in helping clients use projections strategically.
You're Making Great Progress!
You've just learned how ChatGPT can support forecasting and scenario analysis — building simple projections, modeling multiple revenue and cost scenarios, and comparing outcomes side-by-side.
When used with appropriate assumption validation and strategic interpretation, AI-assisted forecasting can reduce projection time by 50-60% while maintaining the quality clients need for confident decision-making.
What's Next?
In the final lesson, you'll learn how to use ChatGPT to support AI-driven advisory work — converting analysis into strategic recommendations, structuring client discussions, and positioning AI as a tool that enhances rather than replaces your professional value.
Almost there — let's finish strong!