AI Prompts for Gemini for Financial Modeling
20 of the best prompts for Gemini for financial modeling, step by step across 4 stages. Works with ChatGPT, Claude, and Gemini.
AI Prompts for Gemini for Financial Modeling
20 of the best prompts for Gemini for financial modeling, step by step across 4 stages. Works with ChatGPT, Claude, and Gemini.
Published July 9, 2026
Design, build, and stress-test financial models using Gemini to structure assumptions, project revenue and costs, and present numbers investors will trust. Built across 4 distinct stages covering Model Design, Revenue and Growth Modeling, Cost and Cash Flow and more, this guide gives you one expert prompt per step so you never have to write from scratch or guess what the AI needs. The prompts work in ChatGPT, Claude, and Gemini and are designed to get usable output on the first try.
Model Design
Design the right model structure before building it out.
Build financial model
I need to build a financial model for [BUSINESS TYPE]. What should the model include? Outline the key sheets, the core drivers I should model, the outputs investors or stakeholders will expect, and any industry-specific metrics I should not miss.
Choose between a top-down
Help me choose between a top-down and bottom-up revenue model for [BUSINESS]. Explain the difference, when each is appropriate, and which is more credible for my stage and business model. Then help me build the structure for the better choice.
Most important assumptions
What are the most important assumptions in a financial model for [BUSINESS TYPE]? For each assumption, explain what drives it, what a reasonable range looks like at early stage, and how sensitive the model outcome is to changes in that assumption.
Building 3-year financial model
I am building a 3-year financial model for [BUSINESS]. What should my model output look like? Describe the P&L structure, key line items, and how to connect revenue drivers to the full income statement in a way that is intuitive to review.
Design cost structure section
Help me design the cost structure section of my financial model for [BUSINESS TYPE]. Categorize costs into COGS, operating expenses, and capital expenditures. For each major cost category, identify whether it scales with revenue or is fixed, and what drives it.
Revenue and Growth Modeling
Build the revenue engine of your model with defensible assumptions.
Build bottom-up revenue model
Help me build a bottom-up revenue model for [BUSINESS]. I have [NUMBER] of [CUSTOMER TYPE], charging [PRICE] per [UNIT/MONTH/YEAR] with an expected [CHURN RATE] monthly. Walk me through the formula structure and how to layer in new customer acquisition month by month.
Run business
I run a [SAAS / E-COMMERCE / MARKETPLACE / SERVICES] business. What revenue drivers should I include in my model? For each driver, explain the formula, what data I need, and how to project growth in it over 3 years.
Create customer cohort model
Create a customer cohort model for [BUSINESS]. I acquire [N] new customers per month, with an average contract value of [ACV] and a monthly churn of [%]. Show me how to model cohort revenue, cumulative MRR growth, and net revenue retention.
Model seasonality
Help me model the seasonality in my [BUSINESS TYPE] revenue. My peak months are [MONTHS] and slow months are [MONTHS]. How do I build seasonal adjustment factors into my monthly forecast without distorting the annual total?
Projecting % revenue
I am projecting [X]% revenue growth for [YEAR]. An investor is challenging my growth assumptions. Help me build a bottoms-up justification for this rate by modeling: new customer acquisition, expansion revenue, and churn impact separately.
Cost and Cash Flow
Model the full cost structure and cash dynamics of the business.
Build headcount plan
Help me build the headcount plan for my financial model. I expect to grow from [CURRENT HEADCOUNT] to [TARGET] over 3 years. Walk me through how to model hiring by department, average fully-loaded cost per role, and how to tie headcount to revenue milestones.
Build gross margin model
Build the gross margin model for my [BUSINESS TYPE]. Revenue is [FORMULA], cost of goods sold includes [LIST COSTS]. Help me calculate gross margin, identify which cost components are most sensitive to scale, and project how margins should improve as revenue grows.
Model cash flow
Help me model the cash flow for my [BUSINESS]. My P&L shows [PROJECTED NET LOSS/PROFIT]. What working capital adjustments, capital expenditures, and financing activities do I need to add to get to a true cash flow forecast?
Model customer acquisition
I need to model customer acquisition cost in my financial model. I spend [AMOUNT] on marketing per month and acquire [N] customers. How do I build a dynamic CAC model that adjusts as I scale spend and as channel efficiency changes over time?
Build scenario analysis
Build a scenario analysis for my financial model with three cases: base, upside, and downside. My key variable assumptions are: [LIST 3-5 KEY DRIVERS]. Show me how to structure the scenarios so a reader can see the range of outcomes clearly.
Validation and Presentation
Stress-test the model and present it with confidence.
Review financial model assumptions:
Review the logic of my financial model assumptions: [PASTE KEY ASSUMPTIONS]. Identify any that seem unrealistic for a [STAGE/INDUSTRY] company, flag internal inconsistencies, and suggest how to make the model more defensible.
Build sensitivity table
Help me build a sensitivity table for my financial model. My most important output is [METRIC] and my most uncertain assumptions are [ASSUMPTION 1] and [ASSUMPTION 2]. Show me how to structure a two-variable sensitivity table and interpret the results.
Present financial model
I need to present my financial model to investors. What are the 5 most important numbers to highlight and how should I frame each one to tell a compelling story about the business trajectory?
Sanity checks
What sanity checks should I run on my financial model for [BUSINESS TYPE]? List the benchmarks, ratios, and cross-checks I should verify to make sure my projections are internally consistent and reasonable for my industry.
Investor is pushing
An investor is pushing back on my [SPECIFIC ASSUMPTION] in the financial model. Help me respond: explain the reasoning behind the assumption, acknowledge what could go wrong, and present an alternative scenario that shows the business is viable even if I am wrong.
Frequently asked questions
Can Gemini build a financial model for me in a spreadsheet?+
Gemini can design the model structure, write the logic, and generate formula-ready content that you build into a spreadsheet. It cannot directly edit Excel or Google Sheets files, but it can produce the exact formulas, structure, and assumptions needed to build the model yourself quickly.
What financial modeling experience do I need to use these prompts?+
Minimal. These prompts are designed to guide you through building models step by step. Basic spreadsheet familiarity is enough. Gemini will explain concepts as it goes and help you understand the logic behind each component.
How accurate are the financial projections Gemini helps me build?+
Accuracy depends entirely on the quality of your inputs and assumptions. Gemini helps you structure the model and think through drivers rigorously, but the projections are only as good as the business knowledge you put in. Always validate key assumptions against real data.
What is the difference between a financial model and a business plan?+
A business plan is a narrative document covering strategy, market, and operations. A financial model is the quantitative engine that translates business assumptions into projected revenue, costs, and cash flow. Gemini can help with both, and they should be tightly connected.
How do investors use the financial models I present to them?+
Investors use models less to verify your exact numbers and more to assess how you think. They will stress-test your assumptions, ask why certain costs scale the way they do, and probe your understanding of unit economics. Gemini can help you anticipate and prepare for these conversations.