AI Prompts for Financial Analysis & Forecasting
TL;DR — Key Takeaways
- Two safe modes only: formulas you paste into a spreadsheet, or code run by a code interpreter. Never a number calculated in prose.
- Models can’t check their own maths. Asking “are you sure?” is not verification — recalculate independently.
- The median small business holds ~27 days of cash buffer; the bottom quarter, ~13 days or fewer (2026 data).
- Forecasts are assumption stacks. The value is in exposing which assumption drives the outcome — not in the number at the end.
- Ask what breaks you, not how long you last. The reverse stress test is the prompt real finance people run.
On this page
Why can’t AI be trusted with your numbers?
Because language models predict plausible text, and a plausible number is not a correct one. A 2026 benchmark found multi-agent systems extracting financial data achieved around 88% accuracy, while the native numerical calculations performed by the model itself dropped to about 52%. Other work found top models falling from 95.6% accuracy on simple lookups to near zero on multivariate calculations.
The compounding problem: models are unreliable at detecting their own reasoning errors. So the failure mode isn’t an obviously broken answer — it’s a confident, well-formatted, wrong one, and asking “are you sure?” tends to produce reassurance rather than a check.
The two safe modes for financial prompting
Never accept a number the model calculated in prose. Research on program-aided language models found that delegating arithmetic to a Python interpreter produced large accuracy gains over reasoning alone — roughly +38 percentage points on arithmetic-heavy tasks — because the interpreter, not the model, does the maths. Both safe modes apply that principle.
=B4*(1+C4)); you paste them into your own sheet and it calculates. Works in any model, no special features needed. Best default for founders.
Add this line to every finance prompt: “Do not calculate anything yourself. Output formulas (or code) only, and state every assumption you’re making.” It’s the single most useful sentence in this guide.
The finance context block
FINANCE CONTEXT (paste at the top of every prompt): BUSINESS: [WHAT WE SELL, IN ONE SENTENCE] MODEL: [subscription / project / product / retainer — and typical order or contract value] CURRENCY & PERIOD: [e.g. GBP, monthly, financial year ends March] REVENUE PATTERN: [steady / seasonal / lumpy — and if seasonal, which months are strong and weak] PAYMENT TERMS: [when customers actually pay vs when you invoice — 30/60/90 days changes everything about cash] WHO I AM: [no finance background — explain terms plainly] STANDING RULES — apply to every response: 1. DO NOT CALCULATE ANYTHING YOURSELF. Give me formulas (or code), never computed results in prose. 2. State EVERY assumption explicitly, as a labelled list. 3. Mark any figure I did NOT give you as [ASSUMPTION] or [NEED FROM YOU] — never fill a gap silently. 4. Distinguish PROFIT from CASH every time. They are not the same and I will confuse them. 5. Explain terms in plain English the first time you use them. 6. If a conclusion depends on something you don't know, say so instead of estimating. 7. Do not give tax, investment, or regulatory advice. Flag where I need an accountant.
Rule 4 matters more than founders expect. Profitable businesses run out of cash routinely — a profitable month with 60-day payment terms and a VAT bill due can still be a month you can’t make payroll.
1. How do I read my P&L with AI?
Ask what changed and why, not “is this good?” A P&L in isolation tells you very little; the signal is in movement between periods. The prompt’s job is to find where money is quietly leaking — usually in margin erosion rather than in a line item you’d notice.
[PASTE FINANCE CONTEXT BLOCK] MY P&L — CURRENT PERIOD: [PASTE: revenue, cost of sales, each overhead line, net profit. Exact figures.] MY P&L — COMPARISON PERIOD: [SAME LINES, 6 or 12 months earlier] Analyse. Do NOT calculate — give me the formulas and tell me what to compute. Then interpret the results I report back. Cover: 1. WHAT TO CALCULATE — list each metric with its formula: gross margin %, net margin %, each overhead as % of revenue, and the period-over-period change in each. 2. WHERE TO LOOK FIRST — based on the raw figures I gave you, which lines moved most in absolute terms, and which moved most as a proportion of revenue? These are different questions and both matter. 3. THE MARGIN QUESTION — if gross margin moved, what would the current revenue have produced at the OLD margin? Give me that formula. This number is usually the story. 4. COST CONCENTRATION — which single overhead is largest, and what would a 10% reduction there be worth annually? 5. WHAT THIS P&L DOESN'T TELL ME — what would I need to see (cash position, debtor days, order book) before drawing conclusions? Be specific. 6. THE THREE QUESTIONS I should ask my accountant based on these figures. Do not tell me whether this is "good" or "bad" — I need to know what's happening and what to check.
Get the Finance Prompt Pack + Spreadsheet
Every prompt here plus a pre-built runway model, a P&L comparison sheet with the formulas already in, a pricing calculator, and the scenario stress-test template. Free.
Get the pack →2. How do I build a cash runway model?
Get a model, not a number. “You have 7 months of runway” is useless — it hides every assumption that produced it. What you want is a sheet where you can change one input and watch the answer move, because that’s what tells you which risk actually matters.
[PASTE FINANCE CONTEXT BLOCK] CURRENT POSITION: Cash in bank today: [AMOUNT] Money owed TO me, and when due: [AMOUNTS + DATES] Money I owe, and when due: [AMOUNTS + DATES — include tax/VAT liabilities, they're the classic omission] Monthly revenue, last 6 months: [SIX FIGURES] Monthly costs, itemised & fixed vs variable: [LIST] Committed future costs: [hires, renewals, equipment] Build me a 12-month cash flow model as a SPREADSHEET STRUCTURE. Do not calculate. Give me: 1. THE LAYOUT — exact rows and columns, so I can rebuild it. Separate clearly: - ASSUMPTIONS block at the top (every number I can change) - CALCULATION rows that reference the assumptions Never hard-code a number inside a formula. 2. THE FORMULAS — cell by cell, in spreadsheet syntax I can paste. Include: - Cash received (timing-adjusted for my payment terms — NOT the same as revenue billed) - Cash out, split fixed and variable - Closing cash each month - Months of runway remaining at each point 3. THE ASSUMPTIONS LIST — every assumption baked into the model, labelled, with the cell it lives in. Flag which ones I supplied and which you inferred. 4. WHAT'S COMMONLY MISSED — list the cash items founders forget: tax and VAT, annual renewals, seasonality, payment terms drift, one-off costs. Ask me directly whether each applies to me. 5. THE THREE CELLS THAT MATTER MOST — which inputs, if wrong by 20%, most change the outcome? Tell me which to double-check before trusting anything. 6. THE UNCOMFORTABLE MONTH — based on the shape of this (not a computed figure), which month is most likely to be tight, and why? Remember: profit ≠ cash. Model when money MOVES.
3. How do I analyse a pricing change?
Treat the volume response as an assumption, not a prediction. No model knows how your customers will react to a price rise. What AI can do is show you how much volume you could afford to lose and still be better off — which converts an anxious guess into a measurable threshold.
[PASTE FINANCE CONTEXT BLOCK] Current price: [PRICE + UNIT/PERIOD] Direct cost to deliver one unit: [AMOUNT] Current volume: [UNITS OR CUSTOMERS PER PERIOD] Fixed costs per period: [AMOUNT] Considering: [e.g. "a 15% increase" / "a new tier at £X"] Do not calculate. Give me the formulas and the structure. 1. BREAK-EVEN VOLUME CHANGE — the formula for how much volume I could LOSE after this price rise and still make the same total contribution. Explain it in plain English. This threshold is the actual decision. 2. THE SENSITIVITY TABLE — lay out a grid: price change down the side (-10%, 0, +10%, +20%), volume change across the top (-20%, -10%, 0, +10%), with the formula for each cell. I'll build it and see the shape. 3. WHAT ELSE MOVES — beyond revenue, what changes if I raise prices? Consider: support load per customer, payment reliability, who I attract vs lose, expectations about service level. 4. THE SEGMENT QUESTION — is a uniform change right, or should this differ by customer type? What data would I need to decide? 5. WHAT I'D NEED TO CHANGE about the offer to justify this to an existing customer. 6. THE ARGUMENT AGAINST doing this at all. Make it properly. State clearly: any volume response is MY assumption, not your prediction. Do not estimate customer price sensitivity — you have no basis for it.
4. How do I stress-test a forecast?
Three scenarios, one shared assumption list. Most founders build one forecast — the one they hope for. The useful exercise is watching which single variable moves the outcome most, because that’s the thing to monitor weekly.
[PASTE FINANCE CONTEXT BLOCK] MY BASE FORECAST: [PASTE ASSUMPTIONS AND STRUCTURE FROM PROMPT 2] Build three scenarios on the SAME model structure. Formulas only — no computed figures. BASE — my current assumptions. DOWNSIDE — revenue growth stops at 0%, one large customer leaves, and one cost rises 15%. UPSIDE — growth doubles, but include the cost of servicing it (founders model upside revenue and forget upside cost). For each, give me formulas for: - Closing cash by month - The month cash goes below [MY COMFORT THRESHOLD] — not the month it hits zero. Zero is far too late. - Months of runway at period end Then, without calculating: 1. THE SINGLE VARIABLE that most changes the outcome across all three. This is the one to track weekly. 2. THE EARLY WARNING — what observable signal would tell me the downside is happening, 6-8 weeks before it shows in the bank balance? 3. THE DECISION POINTS — for the downside, what would I need to decide and by when? Frame as "if X by date Y, then Z." 4. WHAT I'M NOT MODELLING — risks absent from all three scenarios entirely. Flag every assumption you inferred rather than took from me.
Point 2 is the one that changes behaviour. A forecast tells you what might happen; an early-warning signal tells you it’s happening while you can still act.
What separates a good finance prompt from a bad one?
| Move | ❌ Weak (and unsafe) | ✅ Strong |
|---|---|---|
| Computation | “Calculate my runway” | “Give me the formulas; I’ll compute in a spreadsheet” |
| Output | A number in a sentence | A model with a visible, editable assumptions block |
| Assumptions | Silently filled in by the model | “Mark anything I didn’t give you as [ASSUMPTION]” |
| Profit vs cash | Treated as interchangeable | “Distinguish profit from cash every time” |
| Verification | “Are you sure that’s right?” | Recalculate independently — models can’t self-check |
| The question | “How long is my runway?” | “What would have to happen for me to run out?” |
The through-line: weak prompts ask for an answer. Strong prompts ask for a model — because the model is inspectable and the answer isn’t.
Can you show a real prompt with its actual output?
Prompt 1 on a small agency’s P&L. Note that the model isn’t computing — it’s telling the founder what to compute and where to look.
CONTEXT: Design agency, GBP, monthly. Project-based, £8-25k engagements. Payment terms 30 days, often paid at 45. No finance background. NOW (monthly): Revenue 68,000 · Cost of sales (contractors) 27,200 · Salaries 24,000 · Rent 2,800 · Software 3,400 · Marketing 4,500 · Other 2,100 SIX MONTHS AGO: Revenue 52,000 · Cost of sales 18,200 · Salaries 21,000 · Rent 2,800 · Software 2,600 · Marketing 3,000 · Other 1,900 Formulas only — do not calculate.
1. What to calculate
| Metric | Formula |
|---|---|
| Gross profit | = Revenue − Cost of sales |
| Gross margin % | = (Revenue − Cost of sales) / Revenue |
| Net profit | = Gross profit − (all overheads) |
| Overhead as % of revenue | = Overhead line / Revenue |
| Margin gap | = (Revenue_now × Margin_then) − Gross profit_now |
2. Where to look first — and it isn’t the overheads
In absolute terms your largest increases are cost of sales (+£9,000) and salaries (+£3,000). But cost of sales rose faster than revenue did, and that’s the finding. Revenue grew — calculate (68,000 − 52,000) / 52,000 — while cost of sales grew from 18,200 to 27,200. Compute both growth rates and compare them directly.
3. The margin question — calculate this one first
Work out gross margin for both periods. If the earlier margin was higher, apply = 68,000 × (old margin) to find what today’s revenue would have produced under the old cost structure, then subtract your actual gross profit. Multiply that monthly gap by 12 and compare it to your annual net profit. On these figures I’d expect that comparison to be uncomfortable — the annualised margin gap looks likely to approach the size of your entire annual net profit. Verify it before you act on it.
4. Cost concentration
Salaries are your largest overhead at £24,000. A 10% reduction is = 24,000 × 0.10 × 12 annually. But note: your contractor spend now exceeds salaries. For an agency, that ratio is worth understanding — it may indicate you’re buying capacity at a worse rate than you’d pay to employ it.
5. What this P&L doesn’t tell you
- Your cash position. Nothing here shows the bank balance. With 30-day terms paid at 45, roughly 1.5 months of revenue is sitting in debtors at any time — on this revenue that’s a six-figure sum outside your account.
- Whether the margin change is one bad project or a trend across all of them. [NEED FROM YOU] — margin by project.
- Your order book. A P&L is history; it says nothing about next quarter.
- Whether any tax or VAT liability is accruing against this profit.
6. Three questions for your accountant
- “My gross margin has moved — can you show me margin by project so I can see whether it’s one client or all of them?”
- “What’s my current debtor days figure, and how has it changed over six months?”
- “Given this profit level, what should I be setting aside monthly for tax, and am I currently behind?”
The founder’s own calculation confirmed it: gross margin fell from 65% to 60% while revenue grew 30.8%. At the old margin, £68,000 of revenue would have produced £44,200 gross profit instead of £40,800 — a gap of £3,400 a month, £40,800 a year, against an annual net profit of £48,000. Growth of 31% had consumed roughly 85% of a year’s profit in margin erosion. Notice the model never asserted those figures — it told the founder which comparison to run and flagged what it expected. That’s the difference between usable and dangerous.
Level-up: the reverse stress test
This is the part competitors’ finance prompt lists don’t have. Everyone asks “how long is my runway?” — a question with a comforting single answer that hides everything important. Real finance people ask the inverse: what combination of events would exhaust my cash, and would I see it coming?
[PASTE FINANCE CONTEXT BLOCK] MY MODEL & ASSUMPTIONS: [PASTE FROM PROMPT 2] MY CURRENT CASH: [AMOUNT] MY COMFORT FLOOR: [the balance below which I'd have to take drastic action] Reverse the question. Don't tell me how long my cash lasts. Tell me what would have to happen for it to run out. Formulas only — do not compute. Six sections: A. THE BREAKING COMBINATIONS — list the 5 most plausible COMBINATIONS of events that would take me below my comfort floor within 12 months. Combinations, not single events — businesses rarely fail from one thing. For each, give the formula showing the impact and say which of my assumptions it violates. B. PLAUSIBILITY, HONESTLY — for each combination, is this remote, plausible, or already partly happening based on what I've told you? Quote the evidence from my figures. C. THE FRAGILE ASSUMPTION — which single assumption in my model am I least justified in holding? Not the one with the biggest impact — the one with the weakest evidence behind it. Say why. D. EARLY WARNING SYSTEM — for each breaking combination, what would I observe 6-8 WEEKS BEFORE it hit the bank balance? Give me specific, checkable indicators — something I could put on a weekly dashboard. E. THE DECISION TREE — for the most plausible combination, frame the response as: "If [observable] by [date], then [action], because [reason]." Decisions made in advance are better than decisions made in a panic. F. WHAT WOULD MAKE ME ROBUST — the single change that most reduces my exposure across multiple scenarios. Not the biggest saving — the biggest reduction in fragility. Rules: - Do not reassure me. Do not soften the finding. - If my model has no meaningful downside protection, say that plainly. - Distinguish "unlikely" from "I have no evidence either way" — those are different, and I'll conflate them.
Why this is the unlock: Section C is the sharpest question in this guide — which assumption am I least justified in holding? — because founders’ models usually fail at the assumption with the least evidence, not the one with the biggest number attached. Section D is what makes it operational: converting a forecast into weekly indicators means you find out while you can still change something. And Section E is how genuinely well-run businesses handle uncertainty — the decision is made calmly, in advance, with the trigger defined.
Run this quarterly, and keep the outputs. Comparing this quarter’s fragile assumption to last quarter’s tells you whether your business is getting more robust or just bigger.
What must you never ask AI to decide?
| Never | Why |
|---|---|
| Tax positions & filings | Jurisdiction-specific, changes annually, and errors carry penalties that fall on you. Use AI to prepare questions for your accountant. |
| Whether to take debt or investment | A regulated advice area in most jurisdictions, and the consequences are long-lived. Model the scenarios; take the decision to a qualified adviser. |
| Company valuation for a transaction | Valuation depends on comparables, structure and negotiation context a model can’t access. It will still produce a confident number. |
| Anything near insolvency | If you may be unable to pay debts as they fall due, specific legal duties apply and mistakes can carry personal liability. Get professional advice immediately. |
| Personal investment decisions | Regulated financial advice. Not what a general chatbot is for. |
| Any number you haven’t recalculated | Approximately 52% native accuracy on financial calculations means roughly half of unverified figures may be wrong. |
The workable pattern: AI structures the analysis and writes the formulas; your spreadsheet computes; a qualified human decides anything with legal or tax consequence. Used this way, the biggest benefit is often indirect — founders who understand their own numbers ask far better questions of their accountant, and get much more value from that relationship.
Which model for which task?
For finance specifically, code interpreter access matters more than model choice.
| Task | Best fit | Why |
|---|---|---|
| Any actual calculation | A model with a code interpreter | The Python genuinely executes. Delegating arithmetic to an interpreter is the documented fix for the accuracy problem. |
| Reading a P&L or statement | Claude or ChatGPT | Both handle document structure well. Keep them on interpretation and formulas, not sums. |
| Building model structure | Any | Formula mode needs no special features — this is the safe default. |
| Benchmarks & market rates | A model with live web search | Training data produces outdated figures. Never cite a benchmark you can’t click through to. |
| Sensitive financial data | Enterprise tier with a data agreement | Consumer tiers may lack the data-processing terms your obligations require. |
We re-check these notes whenever a major model ships. If you’re reading this more than two weeks after the date above, verify your model versions still match.
Frequently asked questions
Can ChatGPT do financial analysis accurately?
It can structure analysis well and calculate badly. Published benchmarking has found native language model accuracy on financial calculations falling to roughly 52%, and accuracy on multivariate calculations collapsing towards zero even in models that handle simple lookups reliably. Models also can’t reliably detect their own arithmetic errors, so a wrong figure arrives with the same confidence as a correct one. Use AI to structure the analysis and write formulas, and compute in a spreadsheet or via generated code.
How do I get AI to do maths reliably?
Don’t let it calculate in prose. Either ask for spreadsheet formulas you paste into your own file, or use a model with a code interpreter so a Python environment performs the computation. Research on program-aided language models found delegating arithmetic to an interpreter produced large accuracy gains over reasoning alone — because the interpreter, not the model, is doing the maths.
Can I use AI to build a cash flow forecast?
Yes, provided the output is a model rather than a number. Have AI produce the structure, name every assumption explicitly and write the formulas, then enter your figures and let the spreadsheet calculate. The value is in exposing which assumptions drive the outcome — not in the forecast itself, since a forecast is only as good as the inputs you chose.
What is a good cash runway for a small business?
More than most businesses hold. Research on small business cash positions has found the median firm holds roughly 27 days of cash buffer, with the bottom quarter holding around 13 days or fewer. Running out of cash is associated with close to three in ten business failures. A commonly cited working target is three to six months of operating costs, though the appropriate level depends on your revenue volatility and payment terms.
Is it safe to upload my financial statements to ChatGPT?
Treat it as publishing the data outside your business. Check whether your plan includes a data processing agreement and whether inputs are used for training, prefer an enterprise tier for anything sensitive, and remove customer names, bank details and personally identifiable information first. Aggregated figures such as monthly revenue and cost categories are far lower risk than raw transaction exports.
Can AI replace my accountant or bookkeeper?
No. AI can’t file accounts, take responsibility for tax positions, or give regulated advice, and errors in these areas carry financial and legal consequences that rest with you. What it does well is help you understand your own numbers well enough to ask your accountant better questions — which usually improves the value you get from that relationship.
How do I check whether AI got the numbers right?
Recalculate independently. Ask the model to show every step of its arithmetic, then verify the totals in a spreadsheet rather than asking the model to check itself, since models are unreliable at detecting their own errors. Sense-check against magnitude too: if a figure implies a margin or growth rate that would be remarkable for your industry, it’s more likely wrong than remarkable.
What financial questions should I never ask AI?
Anything requiring a regulated opinion or carrying legal consequence: tax positions and filings, whether to take on debt or investment, company valuation for a transaction, insolvency questions, and any personal investment decision. Use AI to prepare the questions and organise the information, then take those to a qualified accountant or adviser.
Download: Finance Prompt Pack + Spreadsheet
All four prompts plus the reverse stress test, a pre-built 12-month runway model with formulas already in place, a P&L comparison sheet, a pricing sensitivity calculator, and the assumptions checklist.
Send me the pack →Enter your email and we’ll send the pack plus a short monthly prompt update. Unsubscribe anytime.
Narracomm is a communications and content strategy team that helps business owners, operators, and founders use AI to produce clear, credible, high-performing work. We build and test these prompt systems inside real client work and revise them as models change. [Add specific credentials here — for a finance guide, a named reviewer with an accounting qualification (ACA/ACCA/CPA) materially strengthens E-E-A-T, and this content should be reviewed by one before publication.]
Sources & further reading
- PAL: Program-Aided Language Models for Reliable Financial Arithmetic
- FinVerBench — validity and calibration in LLM financial statement verification
- Evaluating Mathematical Reasoning of LLMs: Error Identification and Correction
- SMB Compass — small business cash flow failure data
- Crestmont Capital — Top reasons businesses fail financially (2026)
- Federal Reserve — Small Business Credit Survey
- Small business cash flow statistics and financing pain points
A note on one widely-cited figure: the claim that “82% of small businesses fail due to cash flow problems” traces to a single 2015 study and describes a contributing factor, not a sole cause. We’ve cited the more defensible finding — that close to 29% of failures trace directly to running out of money — and flag the older statistic because you’ll encounter it frequently elsewhere.
Last reviewed and updated: July 25, 2026 · Research, benchmarks and model notes verified against current sources. Next review due within 14 days. This guide is general information, not financial, accounting, tax or investment advice.
