💰 Finance Prompt
Why Startup CFOs Struggle with Lack of Scenario Planning — and How Gemini Fixes It
Build a structured scenario planning framework that satisfies auditors, convinces boards, and reduces back-and-forth on going concern assumptions
The Prompt
You are a senior startup finance advisor and scenario planning specialist with 11 years of experience helping early-stage CFOs build structured scenario planning frameworks so they can make faster decisions and reduce the back-and-forth with auditors that comes from undocumented assumptions. Help me build a scenario planning framework so I can reduce back-and-forth with auditors and stop lack of scenario planning from limiting my credibility with the board.
My situation:
- Company stage: [PRE-REVENUE / SEED / SERIES A / SERIES B]
- Current scenario planning capability: [NONE / INFORMAL / BASE CASE ONLY / FULL SCENARIOS]
- Key financial uncertainty: [REVENUE TIMING / BURN RATE / FUNDRAISING CLOSE DATE / HEADCOUNT GROWTH / MARKET SIZE]
- Audit or board challenge related to scenarios: [e.g., "auditors ask for documented basis for going concern assumptions" / "board asks what happens if revenue misses by 20%"]
- Planning horizon: [6 MONTHS / 12 MONTHS / 18-24 MONTHS]
- Tools used: [EXCEL / GOOGLE SHEETS / CAUSAL / MOSAIC / OTHER]
Deliver:
1. A startup scenario planning framework — a 3-scenario structure (base, downside, crisis) calibrated for early-stage company financials, including which line items to stress-test and by how much
2. A scenario assumption documentation template — a one-page format for recording the logic behind each scenario that satisfies auditor and board requests without requiring a financial model rebuild
3. A board scenario presentation format — how to present 3 scenarios to a board in 5 minutes without triggering a 45-minute debate about which scenario is correct
4. A going concern scenario checklist — 8 specific scenario tests auditors expect to see documented for early-stage companies and the language to use in each
5. A scenario trigger monitoring system — 5 leading indicators to track monthly that tell you which scenario is materializing before month-end financials confirm it
6. A scenario sensitivity table — a one-page format showing how runway, burn multiple, and cash-out date change under each scenario, designed to be updated in under 30 minutes
7. A cross-functional scenario communication plan — how to brief sales, product, and ops leads on scenario implications without creating organizational anxiety
8. A scenario planning audit trail — the documentation standard that proves to auditors your scenarios were based on documented assumptions and not post-hoc rationalization
Build the framework so it takes under 2 hours per month to maintain — a scenario planning system that requires a week to update will be abandoned within 3 months.
💡 How to use this prompt
- Output 4 (the going concern scenario checklist) is the most urgent output for any startup CFO facing an audit — going concern challenges are the single most common audit issue for early-stage companies and almost always stem from poorly documented scenarios.
- The most common mistake is building 3 scenarios that are too similar. A base case and a downside that differ by 10% provide no planning value. Output 1 includes calibration guidance on how far apart scenarios need to be to be meaningful for board and auditor purposes.
- Gemini's real-time web access gives it an edge here — use it to pull current startup benchmark data such as median burn multiples and revenue growth rates by stage to calibrate your scenario assumptions against real market data. For the final narrative polish, paste Gemini's research output into Claude for cleaner professional language.
Best Tools for This Prompt
🤖 Best AI Productivity Tools for This Prompt
Tested & reviewed — run this prompt with the best AI tools
Related Topics
About This Finance AI Prompt
This free Finance prompt is designed for Gemini and works with any modern AI assistant including ChatGPT, Claude, Gemini, and more. Simply copy the prompt above, paste it into your preferred AI tool, and customize the bracketed sections to fit your specific needs.
Finance prompts like this one help you get better, more consistent results from AI tools. Instead of starting from scratch every time, you can use this tested prompt as a foundation and adapt it to your workflow. Browse more Finance prompts →