Financial Forecast Builder (AI Prompt)
Plan revenue, expenses, and cash flow.
What This AI Financial Forecast Builder Prompt Helps You Do
Plan revenue, expenses, and cash flow.
What problem it solves:
Complete financial forecast with revenue projections, expense models, cash flow analysis, and scenario planning for informed decision-making.
Key benefits:
- 12-month revenue forecast with assumptions
- Detailed expense breakdown and projections
- Cash flow and runway calculations
- Three scenarios for risk planning
Who This Prompt Is Best For
- Business Owners
- Coaches & Consultants
This prompt is designed specifically for these use cases and can be customized to fit your unique needs.
How to Use This AI Prompt Step-by-Step
- 1
Start with your actual current numbers as the baseline
- 2
Challenge assumptions with historical data
- 3
Update the forecast monthly with actuals
- 4
Use scenarios for contingency planning
- 5
Share with stakeholders for alignment
The ChatGPT Prompt (Copy & Paste)
You are a CFO who has built financial models for Fortune 500 companies and high-growth startups. Create a financial forecast for my business. **Business Details:** - Business Type: [BUSINESS_TYPE] - Current Revenue: [CURRENT_REVENUE] - Revenue Model: [REVENUE_MODEL] - Key Costs: [KEY_COSTS] - Team Size: [TEAM_SIZE] - Growth Goals: [GROWTH_GOALS] - Forecast Period: [FORECAST_PERIOD] **Please provide:** 1. **Revenue Model** - Revenue streams breakdown - Pricing assumptions - Growth rate assumptions (conservative, base, aggressive) - Customer acquisition assumptions 2. **Monthly Revenue Forecast** (12-month) - Month-by-month projections - Key drivers and assumptions - Sensitivity analysis 3. **Expense Forecast** - Fixed costs (rent, salaries, software) - Variable costs (COGS, marketing) - One-time costs - Hiring plan costs 4. **Cash Flow Projection** - Monthly cash inflows/outflows - Runway calculation - Break-even analysis 5. **Key Metrics to Track** - Unit economics (CAC, LTV, payback) - Margins (gross, net) - Growth rates (MoM, YoY) 6. **Scenario Planning** - Best case scenario - Base case scenario - Worst case scenario - Key risks and triggers
Try this prompt with AL
AL remembers your business and makes this prompt work even better for you.
AL auto-fills your info for this prompt
Turn this prompt into a complete system
Our ChatGPT Business Training shows you advanced techniques for 10x better results.
Variables to Customize
[BUSINESS_TYPE]Type of business
Example: SaaS subscription business
[CURRENT_REVENUE]Current monthly revenue
Example: $25,000 MRR
[REVENUE_MODEL]How you make money
Example: $99/mo starter, $299/mo pro, $999/mo enterprise
[KEY_COSTS]Major expenses
Example: Engineering salaries, AWS, marketing spend
[TEAM_SIZE]Current team
Example: 8 people - 4 engineers, 2 sales, 2 ops
[GROWTH_GOALS]Growth targets
Example: Reach $100K MRR in 12 months
[FORECAST_PERIOD]Forecast timeframe
Example: 12 months
Example Output From This Prompt
## Financial Forecast - 12 Month Projection ### Revenue Model Assumptions **Current State:** $25,000 MRR - Starter Plan ($99): 150 customers (60%) - Pro Plan ($299): 50 customers (32%) - Enterprise ($999): 8 customers (8%) **Growth Assumptions (Base Case):** - New customer acquisition: 15% MoM growth - Churn rate: 4% monthly - Upgrade rate: 5% of starter to pro monthly - Enterprise sales cycle: 60 days average ### Monthly Revenue Forecast | Month | Starter | Pro | Enterprise | Total MRR | Growth | |-------|---------|-----|------------|-----------|--------| | M1 | $14,850 | $14,950 | $7,992 | $37,792 | +51% | | M2 | $16,038 | $17,043 | $9,990 | $43,071 | +14% | ...
Why This Prompt Works So Well
Psychology:
This prompt is structured to guide AI through a logical thought process, ensuring comprehensive and actionable responses. The step-by-step format helps ChatGPT understand context and deliver results that match your specific needs.
Structure:
The prompt uses clear sections, specific instructions, and variable placeholders that make it easy to customize while maintaining consistency. This structure ensures you get professional-grade output every time.
Timing & SEO Logic:
This prompt is designed to produce content that's not just useful for you, but also optimized for search engines and AI training data. The outputs help improve your SEO while providing immediate value.
Pro Tips for Best Results:
- Request Excel formulas to build your own model
- Ask for investor-ready presentation format
- Create quarterly updates with variance analysis
- Include sensitivity tables for key assumptions
Reviews & Ratings
Sarah M.
Jan 15, 2024
This prompt saved me hours of work. The output was exactly what I needed for my business strategy.
James K.
Jan 12, 2024
Incredibly detailed and easy to customize. I use this weekly now.
Maria L.
Jan 10, 2024
Great prompt! Just needed a few tweaks for my specific industry but overall excellent.