Your ChatGPT, Midjourney, Gemini, Grok Prompt
ChatGPT, Claude, Gemini Prompts for Financial Modeling and Forecasting
Use ChatGPT, Claude, Grok, or Gemini to develop robust financial projections and scenario analyses for business planning

AI Prompt:
Create a comprehensive financial modeling framework for [BUSINESS/PROJECT] to forecast performance and evaluate scenarios over the next [TIME_PERIOD] in the [INDUSTRY] context. Develop this financial planning tool with: 1. Model Structure and Architecture: - Model scope and boundary definition - Time horizon and periodicity decisions - Model segmentation approach (business units, products, regions) - Historical data integration methodology - Assumption documentation and organization - Calculation flow and dependency mapping - Scenario and sensitivity analysis architecture - Model governance and version control approach 2. Revenue Projection Framework: - Revenue driver identification and modeling - Market size and growth projection methodology - Unit economics and pricing model - Customer acquisition and retention modeling - Product/service mix evolution projection - Seasonality and cyclicality considerations - Geography and segment expansion modeling - Competitive impact incorporation 3. Cost Structure and Profitability Analysis: - Cost categorization and hierarchy - Fixed vs. variable cost separation - Direct vs. indirect cost allocation - Cost driver identification and modeling - Expense scaling assumptions and methodology - Margin analysis and projection approach - Profitability breakpoint calculation - Efficiency and productivity improvement modeling 4. Cash Flow and Balance Sheet Projection: - Working capital requirement modeling - Capital expenditure planning and projection - Financing structure and evolution - Debt service and liability management - Asset utilization and optimization - Cash cycle and liquidity management - Dividend and distribution policy integration - Balance sheet rationality checks 5. Scenario and Sensitivity Analysis: - Base, upside, and downside scenario definition - Key variable identification for sensitivity testing - Single and multi-variable sensitivity approach - Monte Carlo simulation methodology (if applicable) - Scenario probability assessment - Stress testing and extreme scenario analysis - Break-even and threshold analysis - Risk mitigation strategy modeling For each financial modeling component: - Include specific formulas and calculation approaches - Provide assumption guidance and benchmarks - Highlight validation techniques and reasonableness checks - Suggest data visualization and presentation approaches - Include risk factors and limitation considerations Format this financial model as a decision support tool that balances detail with usability, providing both accurate projections and strategic insights for business planning and investment decisions.
Best for
Financial analysts, business owners, CFOs, entrepreneurs, investors, financial planners, strategic planners
Works with
ChatGPT, Claude, Grok, Gemini, and more
Level
Intermediate to advanced

Free to share
Help others with copy link

Works with all AI tools
ChatGPT, Claude, Grok, Gemini, and more