Financial projection model with scenarios in Google Sheets
Creates a 12-month financial projection model with optimistic, realistic, and pessimistic scenarios using Google Sheets with advanced formulas.
Build a financial projection model in Google Sheets that allows simulation of 3 different scenarios, with adjustable assumptions and sensitivity analysis for decision-making.
At a glance
Access
Free prompt
Open to copy without upgrading.
Prompt objective
Build a financial projection model in Google Sheets that allows simulation of 3 different scenarios, with adjustable assumptions and sensitivity analysis for decision-making.
Real use case
BemBolado Delivery, a fit meal marketplace in São Paulo operating for 6 months with R$ 85k/month in revenue, needs to present financial projections for a R$ 2 million seed round and wants to showcase multiple scenarios to investors.
Customize these fields first
Replace the placeholders with your own context before you run the prompt. That usually improves the first output more than adding more instructions later.
Prompt
Build a 12-month financial projection model in Google Sheets for [COMPANY NAME], operating in the [SECTOR] sector, with current monthly revenue of R$ [AMOUNT].\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**'Assumptions' Sheet:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Adjustable input table:\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n - Monthly growth rate: Pessimist [X%] / Realistic [Y%] / Optimist [Z%]\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n - Average order value: R$ [AMOUNT] with seasonal variation\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n - CAC (Customer Acquisition Cost): R$ [AMOUNT]\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n - Monthly churn: [X%]\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n - Gross margin: [X%]\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Dropdown to select active scenario (Data validation)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Fixed and variable cost assumptions\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**'P&L Projection' Sheet:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Gross Revenue (by channel: [CHANNEL 1], [CHANNEL 2], [CHANNEL 3])\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Deductions (Simples Nacional / Lucro Presumido taxes — simplified Brazilian tax regimes)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Net Revenue\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- COGS detailed breakdown\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Contribution Margin\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Operating expenses (staff, marketing, tech, admin)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- EBITDA\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- IF() formulas to switch between scenarios automatically\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**'Cash Flow' Sheet:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Month-by-month cash projection\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Average collection period vs. payment terms\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Working capital requirement\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Break-even point highlighted visually\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Runway in months (cash / burn rate)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**'Scenario Dashboard' Sheet:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Comparative chart of the 3 scenarios (revenue)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Sensitivity table: variation of [VARIABLE 1] vs [VARIABLE 2]\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Sparklines for each KPI trend\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- SPARKLINE() and QUERY() Google Sheets functions\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Key formulas (Google Sheets):**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- QUERY() to consolidate data\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- ARRAYFORMULA() for bulk calculations\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- IMPORTRANGE() to connect with actual data source\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- SPARKLINE() for inline mini-charts\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- IF(assumption='Optimist', optimistic_value, IF(assumption='Pessimist', pessimistic_value, realistic_value))\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\nAll formulas using Brazilian Portuguese syntax (e.g., SOMASE instead of SUMIF, SOMA instead of SUM).
Open directly in an AI — the text is pre-filled:
How to use this prompt
- 1Replace the key placeholders first: COMPANY NAME, SECTOR, AMOUNT, X%.
- 2Replace any bracketed placeholders like [this] with your own context.
- 3Add extra background information when you want more tailored results.
- 4Combine multiple prompts in one conversation when you need a richer output.
- 5Save your best-performing prompts so they are easy to reuse later.
Next best step
Open the guide first, then branch only if you still need more.
A guide for technical builders choosing between prompts, coding workflows, and agent-based implementation.
If this prompt is close but not quite right, generate variants next. If the job is recurring, move into the course library after the guide.
Related prompts
View allAutomated Financial Dashboard in Excel with VLOOKUP and Pivot Tables
Build a complete financial dashboard using advanced Excel formulas and pivot tables for monthly performance tracking.
Best for
Create an interactive financial panel in Excel that consolidates revenue, expenses, and contribution margin data with automatic updates via pivot tables.
Data Cleaning and Standardization with Power Query in Excel
Automate the process of cleaning messy data using Power Query to transform inconsistent datasets into reliable, analysis-ready sources.
Best for
Build an ETL (extract, transform, load) workflow in Excel Power Query to clean, standardize, and consolidate datasets affected by common real-world corporate data problems.
Smart Inventory Control with XLOOKUP and Conditional Formatting
Build an inventory management spreadsheet with automatic alerts, reorder forecasting, and ABC analysis using advanced formulas.
Best for
Develop an Excel or Google Sheets inventory control system that classifies products using the ABC curve, calculates reorder points, and generates automatic visual alerts.
VBA macro for monthly management report automation
Develops VBA macros in Excel to automate monthly management report generation—a process that typically consumes hours of the finance team's time.
Best for
Create a set of VBA macros that automate data consolidation from multiple sheets, generate standardized charts, and export reports as PDF for executive distribution.
Explore other prompt categories
Move sideways into adjacent libraries when the current category is not the full answer.
Free browsing stays open. Premium prompts unlock the reusable workflow layer.
Use the guides and role paths to validate the job first. Upgrade when you want the full prompt text, editable premium prompts, and the surrounding course paths in one place.
Free access
- Browse guides, role paths, and category pages.
- Preview prompts before you decide to upgrade.
- Find the right starting point without friction.
Membership access
- Unlock premium prompts and the full copy text.
- See more workflow paths and course connections.
- Keep the reusable templates in one place.
