Home/Templates/Financial Model Assumptions
Business

Financial Model Assumptions Prompt Template

Write the narrative behind a financial model with key assumptions, sensitivity analysis, and scenario planning.

The Prompt

ROLE: CFO and financial modelling expert who has built models for Series A–C fundraises and used them as operational management tools — you know that the assumptions document is more important than the model itself, because the model is only as honest as its inputs. CONTEXT: Financial models are theories about how a business works expressed in spreadsheet form. The assumptions document is the explicit statement of those theories, which makes it possible to test them against reality, update them as you learn, and have honest conversations with investors and the board about what must be true for the model to be right. Most companies treat assumptions as a formality; the best use them as their primary analytical tool. TASK: Write a comprehensive financial model assumptions document for [COMPANY_NAME]'s [3_OR_5]-year financial model. Every assumption must be stated with its basis and its sensitivity. RULES: • Every assumption must specify its basis: historical data, industry benchmark, management estimate, or pure hypothesis — and label it accordingly • Revenue assumptions must distinguish between price × volume drivers explicitly — a revenue assumption that just says "20% growth" is not an assumption, it's a wish • Unit economics must include the metrics that lead the financials: if CAC goes up 30%, what happens to the model in 12 months? • Each scenario must be driven by a single key variable change, not a wholesale rewrite — this makes scenario analysis operationally useful rather than academic • Includ

🔒

Upgrade to see the full prompt

Get unlimited access to all 215+ templates — starting at $9/month.

✦ Upgrade to Pro

Already have an account? Sign in

How to use this template

1

Copy the template

Click the copy button to grab the full prompt text.

2

Fill in the placeholders

Replace anything in [BRACKETS] with your specific details.

3

Paste into any AI tool

Works with ChatGPT, Claude, Gemini, Cursor, and more.

4

Or enhance with AI

Sign in to PromptIt and let AI tailor the prompt to your exact situation in seconds.

Why this prompt works

Labelling each assumption as Data/Benchmark/Estimate/Hypothesis is the transparency tool that transforms assumptions documents from narratives into testable frameworks — it immediately signals to any reader which parts of the model are grounded and which are speculative. The single-lever scenario design ensures scenarios remain analytically useful rather than becoming arbitrary best/worst case fantasies.

Tips for best results

  • Build your assumptions document in the spreadsheet alongside the model, not in a separate Word document — when assumptions are linked directly to model inputs, updating them automatically updates the forecast
  • The most common fundraising mistake is presenting only the base case — presenting all three scenarios with clear drivers signals financial sophistication and builds investor confidence that you understand your own business
  • Run a 'garbage in, garbage out' test: give your model to someone who doesn't know the business and ask them to find the assumption that makes the model most fragile. They'll find something you've normalised
  • Update the assumptions document monthly and track how actual performance compares to assumptions — this builds a learning record that improves future models dramatically
  • The 'riskiest assumption' flag is your most important management tool: if it's CAC trajectory and CAC starts rising in month 2, you have an early warning system built into your model

More Business templates

Business Proposal

Write a complete business proposal with executive summary, problem statement, solution, deliverables, timeline, and pricing — ready to send to clients.

View →

SWOT Analysis

Create a detailed SWOT analysis with 5 specific points per quadrant and 3 strategic recommendations grounded in the findings.

View →

Meeting Agenda

Build a focused meeting agenda with objectives, pre-reads, 5–7 time-allocated items, key decision points, and an action item template.

View →
← Browse all 215 templates