Financial Projection Helper
Build a realistic revenue model so you know what you're actually building toward.
A financial projection isn't about predicting the future accurately — it's about understanding the relationships between your key numbers. This workflow helps you build a basic model, run scenarios, and identify the variables that matter most to your business.
The Workflow
Identify your key business drivers
Every business model has two or three numbers that determine everything else. Find yours before building the model.
Help me identify the key financial drivers of my business model. My business: [BUSINESS_DESCRIPTION] Revenue model: [REVENUE_MODEL] (one-time sales / recurring subscription / project-based / hourly / per-unit / marketplace) My primary product or service: [MAIN_OFFERING] Average transaction value: $[AVERAGE_TRANSACTION] How often a typical customer buys: [PURCHASE_FREQUENCY] How I get customers: [ACQUISITION_METHOD] Current customer count: [CURRENT_CUSTOMERS] For my business model, identify: 1. The three numbers that most drive revenue (e.g., for subscription: monthly new customers, churn rate, average revenue per user) 2. What I need to track weekly vs. monthly 3. The metric that, if it doubled, would double my revenue 4. The metric that, if it stayed the same, would prevent me from growing
Replace: [BUSINESS_DESCRIPTION], [REVENUE_MODEL], [MAIN_OFFERING], [AVERAGE_TRANSACTION], [PURCHASE_FREQUENCY], [ACQUISITION_METHOD], [CURRENT_CUSTOMERS]
Build a 12-month revenue model
Create a simple, structured revenue projection you can adjust as your business evolves.
Build a 12-month revenue projection for my business. Business model: [REVENUE_MODEL] Starting point (current monthly revenue): $[CURRENT_REVENUE] Key assumptions: - New customers per month: [NEW_CUSTOMERS_PER_MONTH] - Average revenue per customer per month: $[REVENUE_PER_CUSTOMER] - Monthly churn rate (if subscription): [CHURN_RATE]% - Average project size (if project-based): $[AVERAGE_PROJECT] - Projects per month: [PROJECTS_PER_MONTH] Fixed monthly costs: $[FIXED_COSTS] Variable costs (as % of revenue): [VARIABLE_COST_PERCENT]% Build three scenarios: - Conservative: [CONSERVATIVE_GROWTH_ASSUMPTION] - Base: [BASE_GROWTH_ASSUMPTION] - Optimistic: [OPTIMISTIC_GROWTH_ASSUMPTION] Show month-by-month revenue, costs, and net income in a table. Flag when I reach profitability in each scenario.
Replace: [REVENUE_MODEL], [CURRENT_REVENUE], [NEW_CUSTOMERS_PER_MONTH], [REVENUE_PER_CUSTOMER], [CHURN_RATE], [AVERAGE_PROJECT], [PROJECTS_PER_MONTH], [FIXED_COSTS], [VARIABLE_COST_PERCENT], [CONSERVATIVE_GROWTH_ASSUMPTION], [BASE_GROWTH_ASSUMPTION], [OPTIMISTIC_GROWTH_ASSUMPTION]
All Prompts for This Workflow
Build a 12-month revenue projection for my [REVENUE_MODEL] business. Starting revenue: $[CURRENT_REVENUE]/month Key inputs: [KEY_ASSUMPTIONS] Fixed costs: $[FIXED_COSTS]/month Variable costs: [VARIABLE_COST_PERCENT]% of revenue Three scenarios: conservative / base / optimistic. Month-by-month table showing revenue, costs, and net income. Flag profitability point in each scenario.
Replace: [REVENUE_MODEL], [CURRENT_REVENUE], [KEY_ASSUMPTIONS], [FIXED_COSTS], [VARIABLE_COST_PERCENT]
Calculate my break-even point. Fixed monthly costs: $[FIXED_COSTS] Variable cost per unit/sale: $[VARIABLE_COST_PER_UNIT] Revenue per unit/sale: $[REVENUE_PER_UNIT] My target monthly profit: $[TARGET_PROFIT] Calculate: 1. How many units/sales I need to break even monthly 2. How many to hit my profit target 3. Revenue required at current average transaction size 4. Sensitivity: how does break-even change if my average transaction drops by [DROP_PERCENT]%? Present as a simple table. Then tell me: what's the fastest lever to pull if I need to improve this number?
Replace: [FIXED_COSTS], [VARIABLE_COST_PER_UNIT], [REVENUE_PER_UNIT], [TARGET_PROFIT], [DROP_PERCENT]
Help me plan for cash flow gaps in my business. Revenue model: [REVENUE_MODEL] Payment timing: [PAYMENT_TIMING] (e.g., invoice net 30, subscription monthly, upfront) My fixed costs and when they're due: [FIXED_COST_TIMING] Variable costs and timing: [VARIABLE_COST_TIMING] Seasonal patterns I'm aware of: [SEASONAL_PATTERNS] Current cash reserve: $[CASH_RESERVE] Identify: 1. My most likely cash flow crunch months 2. What I should do now to smooth those gaps 3. Whether my current cash reserve is adequate or dangerously thin 4. One change to my payment terms that would most improve my cash flow
Replace: [REVENUE_MODEL], [PAYMENT_TIMING], [FIXED_COST_TIMING], [VARIABLE_COST_TIMING], [SEASONAL_PATTERNS], [CASH_RESERVE]
A 12-month revenue model with three scenarios (conservative/base/optimistic), month-by-month projections, profitability milestones, and identification of the two or three metrics that most drive your numbers.
- !This is a planning tool, not financial advice. Before making significant business financial decisions — especially involving debt, investment, or tax strategy — consult a licensed accountant or financial advisor familiar with your specific situation.
- !AI-generated financial models use the assumptions you provide. Garbage in, garbage out. Double-check every input before trusting the output.
- !Revenue projections are notoriously optimistic. Run your conservative scenario and make sure the business still works. If it doesn't survive the conservative case, the model needs rethinking.
- →Update the model monthly with actuals. A projection that's never compared to reality becomes fiction.
- →The most valuable scenario to analyze is 'what if revenue is 30% lower than expected for 3 months' — can you survive it? If not, your cash reserve plan needs work.