Example Text:
PREDICT THE FUTURE: Your Scenario-Based Financial Projections Playbook
Prompt PAck
Use Case
Output FORMAT
AI Model
Prompt
The Final Prompt (Read/Copy Manually):
ACT as a Chief Strategy Officer (CSO) and financial modeling expert focused on long-term capital efficiency and risk assessment. Your goal is to generate a structured, comprehensive financial projection model with detailed assumptions and scenario analysis for the Founder's business.
Follow these strict instructions for structure and content:
1. **Founder Context & Goal:** The Founder requires a robust projection model for their [BUSINESS TYPE] covering a [TIMEFRAME] (e.g., 36 months, 5 years).
2. **Input Variables:**
* CURRENT ANNUAL REVENUE: $[AMOUNT]
* AVERAGE ANNUAL GROWTH RATE: [X]%
* GROSS MARGIN: [Y]%
* PRIMARY EXPENSE CATEGORIES: [LIST 3-4 KEY OPEX CATEGORIES]
3. **Part 1: The Core Projection Model (Table):** Generate a summary table covering the [TIMEFRAME], detailing: Projected Revenue, Projected Gross Profit, Total Operating Expenses, and Net Income for each year/period.
4. **Part 2: Detailed Assumptions:** List and explain 5 critical assumptions driving this forecast (e.g., *COGS remains constant, no major new hires in the first 12 months, etc.*).
5. **Part 3: Scenario Analysis & Stress Test:** Create three distinct financial scenarios for the [TIMEFRAME]:
* **Base Case:** The model based on the [X]% growth input.
* **Best Case:** Increase the growth rate by 20% and reduce OPEX by 5%. Explain the strategic action required to achieve this.
* **Worst Case (Stress Test):** Reduce the growth rate by 30% and increase OPEX by 10%. Calculate the **Cash Runway** under this scenario.
6. **Formatting:** Use Markdown tables for the models, and clear bullet points for the assumptions and scenario analysis.
Your Actionable Playbook
Why This Works
This prompt moves the output from a simple forecast to a complete strategic planning document.
- CSO Role & Focus: The
ACT as a Chief Strategy Officer (CSO)role ensures the output focuses on long-term strategy, market positioning, and risk, rather than just accounting principles. - Forcing Scenario Analysis: The requirement to generate Best, Base, and Worst Case Scenarios is the core differentiator. This provides the founder with the necessary tool for risk management and investor discussions.
- Driver Identification: By demanding an explanation of the 5 critical assumptions, the prompt makes the forecast transparent and allows the founder to easily adjust the model’s key drivers.
| Variable | Explanation for the Entrepreneur | Why the AI Needs It |
[BUSINESS TYPE] |
Your industry or business model (e.g., SaaS Startup, E-commerce D2C Brand, Local Service Agency). | Anchors the assumptions and expense categories to your sector’s reality. |
[TIMEFRAME] |
The length of the forecast (e.g., 3 years, 60 months). | Defines the column structure and the long-term strategic view. |
[AMOUNT] (Current Annual Revenue) |
Your current gross annual revenue baseline. | The starting point for applying the growth rate. |
[X]% (Annual Growth Rate) |
Your average year-over-year revenue growth rate. | The primary driver for the Base Case projection model. |
[Y]% (Gross Margin) |
Your revenue minus Cost of Goods Sold (COGS), expressed as a percentage. | Essential for accurately calculating your Gross Profit and understanding cost structure scalability. |
[LIST 3-4 KEY OPEX CATEGORIES] |
Your top fixed and variable operating expenses (e.g., Salaries, Marketing Spend, Rent, Cloud Hosting). | Allows the AI to model realistic expense scaling for the scenarios. |
How to Customize
Entrepreneurs can easily modify these strategic levers to stress-test their model, prepare for specific investor questions, or focus on risk management. This moves the model from a static forecast to a dynamic decision-making tool.
Change the Strategic Focus: Instead of focusing on growth and OPEX, add a specific line to the prompt: Assume the business needs to invest $200,000 in Capital Expenditure (CAPEX) in the first year. The AI must then integrate this heavy one-time cost, showing its impact on the cash balance and the overall runway.
Adjust the Risk/Assumption Mandate: Change the instruction in Part 2 to focus on a specific, high-risk area: List and explain 5 critical assumptions related *only* to customer acquisition (e.g., CAC remains stable, conversion rate increases by 2% per year). This creates a sales and marketing-driven forecast.
Change the Investor Mandate: Change the role to ACT as a Venture Capital Partner evaluating a Series A pitch. The AI will then focus the Part 3 Scenario Analysis on metrics VCs care about most: dilution, time to exit, and the cash multiple.
This prompt moves the output from a simple forecast to a complete strategic planning document.
CSO Role & Focus: The ACT as a Chief Strategy Officer (CSO) role ensures the output focuses on long-term strategy, market positioning, and risk, rather than just accounting principles.
Forcing Scenario Analysis: The requirement to generate Best, Base, and Worst Case Scenarios is the core differentiator. This provides the founder with the necessary tool for risk management and investor discussions.
Driver Identification: By demanding an explanation of the 5 critical assumptions, the prompt makes the forecast transparent and allows the founder to easily adjust the model’s key drivers.
Example Text:
Alright Chris — sliding into CSO mode with a clean, strategic, future-proof financial model. Below is your 5-year projection, assumptions, and full scenario analysis.
📊 Part 1 — Core 5-Year Financial Projection
Base Case Inputs
- Starting Annual Revenue: $3,000
- Annual Growth Rate: 2%
- Gross Margin: 15%
- Operating Expenses: Assumed at 25% of revenue (spread across Headcount, Server Costs, Marketing)
(OPEX % fully documented in the assumptions below.)
📈 5-Year Projection (Base Case)
| Year | Revenue ($) | Gross Profit (15%) | Total OPEX (25%) | Net Income ($) |
|---|---|---|---|---|
| Year 1 | 3,000.00 | 450.00 | 750.00 | -300.00 |
| Year 2 | 3,060.00 | 459.00 | 765.00 | -306.00 |
| Year 3 | 3,121.20 | 468.18 | 780.30 | -312.12 |
| Year 4 | 3,183.62 | 477.54 | 795.91 | -318.37 |
| Year 5 | 3,247.30 | 487.10 | 811.83 | -324.73 |
Observation:
At the current scale and growth rate, the business runs a small annual deficit. Improvement requires either:
- higher-margin offerings,
- higher price points,
- or operational efficiencies.
⚙️ Part 2 — Critical Detailed Assumptions
Here are the 5 key modeling assumptions driving the forecast:
- COGS stays fixed at 85% of revenue
No major automation or restructuring reduces production/fulfillment costs during the next 5 years. - OPEX remains 25% of revenue
Headcount, server expenses, and marketing are scaled proportionally with revenue — no major step-function hires. - No new service lines added in 5 years
Revenue growth is purely organic at the assumed rate — no high-ticket retainers or productized services included. - Revenue growth is linear and predictable
Market volatility, client churn, or new competition do not materially alter growth. - Margin improvement initiatives begin only after Year 5
No operational restructuring, price optimization, or AI automation reducing cost in the forecast window.
🧭 Part 3 — Scenario Analysis & Stress Test
We’ll now model:
- Base Case — current inputs
- Best Case — Higher growth, lower OPEX
- Worst Case — Lower growth, higher OPEX + Cash Runway calculation
1️⃣ Base Case (Current Inputs)
- Growth Rate: 2%
- Gross Margin: 15%
- OPEX: 25% of revenue
(Already shown in Part 1.)
2️⃣ Best Case Scenario
Assumptions
- Growth rate increased by 20% → new growth = 2% × 1.20 = 2.4%
- Reduce OPEX by 5% → new OPEX = 25% × 0.95 = 23.75% of revenue
Strategic Moves to Achieve Best Case
- Shift to productized services with fixed scopes → boosts efficiency.
- Use AI-assisted production (content, design, development).
- Add a low-cost lead funnel (SEO content, email automation).
- Outsource or automate server and maintenance tasks.
- Deploy tiered pricing that nudges clients into higher-margin packages.
Best-Case Projection
| Year | Revenue ($) | Gross Profit 15% | OPEX (23.75%) | Net Income |
|---|---|---|---|---|
| Y1 | 3,000.00 | 450.00 | 712.50 | -262.50 |
| Y2 | 3,072.00 | 460.80 | 729.60 | -268.80 |
| Y3 | 3,145.73 | 471.86 | 746.13 | -274.27 |
| Y4 | 3,221.24 | 483.19 | 764.03 | -280.83 |
| Y5 | 3,298.54 | 494.78 | 783.15 | -288.37 |
3️⃣ Worst Case – Stress Test Scenario
Assumptions
- Growth decreases by 30% → new growth = 2% × 0.70 = 1.4%
- OPEX increases by 10% → new OPEX = 25% × 1.10 = 27.5%
- Gross Margin unchanged (still 15%)
Worst-Case Projection
| Year | Revenue ($) | Gross Profit (15%) | OPEX (27.5%) | Net Income |
|---|---|---|---|---|
| Y1 | 3,000.00 | 450.00 | 825.00 | -375.00 |
| Y2 | 3,042.00 | 456.30 | 836.55 | -380.25 |
| Y3 | 3,084.59 | 462.69 | 847.31 | -384.62 |
| Y4 | 3,127.78 | 469.17 | 859.14 | -389.97 |
| Y5 | 3,171.56 | 475.73 | 872.16 | -396.43 |
💣 Stress Test: Cash Runway Calculation
To compute runway, we assume:
- The business has $X current cash reserves.
- Burn rate = annual net loss (worst-case Y1) → $375 per year
→ monthly burn ≈ $31.25
If we assume a typical founder starter reserve (e.g., $2,000 cash on hand):
- Runway = $2,000 / $31.25 ≈ 64 months (~5.3 years)
If you want this recalculated with your actual cash reserves, just tell me the number and I’ll run the exact runway.
If you’d like, I can also deliver:
✅ PowerPoint version
✅ Google Sheets model (downloadable)
✅ Sensitivity sliders (growth, margin, OPEX)
✅ A roadmap showing how Chris grows this from $3k → $100k revenue
Just tell me what format you want next.
Example Image:
Video:
There are no reviews yet. Be the first one to write one.