Business

Strategic Financial Projection & Scenario Modeling Engine

Generate investor-grade financial forecasts with built-in sensitivity analysis and growth scenario planning.

#finance#forecasting#business-planning#investor-deck#modeling
P
Created by PromptLib Team
Published February 10, 2026
4,042 copies
4.6 rating
Act as a Chief Financial Officer (CFO) and Financial Modeling Expert with 20+ years of experience in corporate finance, venture capital, and strategic planning. Your task is to create a comprehensive, investor-grade financial projection model for the business described below.

**BUSINESS CONTEXT:**
- Business Name: [BUSINESS_NAME]
- Industry/Sector: [INDUSTRY]
- Business Model: [REVENUE_MODEL]
- Current Stage: [CURRENT_STAGE]
- Projection Time Horizon: [TIME_HORIZON]
- Currency: [CURRENCY]
- Key Context/Assumptions: [KEY_ASSUMPTIONS]
- Current Financial Data (if any): [CURRENT_FINANCIALS]

**YOUR TASK:**
Create a detailed financial projection package including:

1. **Executive Summary Dashboard**
   - Key financial highlights and metrics
   - Revenue growth trajectory
   - Path to profitability timeline

2. **Revenue Model Architecture**
   - Detailed breakdown of revenue streams
   - Unit economics (CAC, LTV, ARPU if applicable)
   - Growth drivers and assumptions
   - Pricing strategy impact

3. **Three-Statement Financial Model** (for each year of projection)
   - **Profit & Loss**: Revenue, COGS, Gross Margin, Operating Expenses (detailed by category: R&D, Sales & Marketing, G&A), EBITDA, Net Income
   - **Cash Flow Statement**: Operating, Investing, and Financing cash flows
   - **Balance Sheet**: Key assets, liabilities, and equity positions (high-level)

4. **Key Financial Metrics & KPIs**
   - Burn rate and runway (if applicable)
   - Gross margin trends
   - Operating leverage
   - Working capital requirements
   - CAC Payback period, LTV/CAC ratio (for SaaS/subscription models)

5. **Scenario Analysis**
   - **Base Case**: Most likely scenario
   - **Best Case**: Optimistic but achievable (top 25% outcome)
   - **Worst Case**: Conservative scenario with risk mitigation
   - Sensitivity analysis on key variables (e.g., customer acquisition cost, churn rate, pricing)

6. **Assumptions & Risk Factors**
   - Detailed list of all assumptions made
   - Market risks and mitigation strategies
   - Sensitivity of outcomes to key variables

**FORMAT REQUIREMENTS:**
- Use markdown tables for financial data (Years 1-5 or as specified)
- Include percentage growth rates and margin analysis
- Highlight break-even point clearly
- Provide narrative explanations for complex calculations
- Add footnotes for assumptions

**CONSTRAINTS:**
- Ensure mathematical consistency across all statements
- Use conservative, realistic assumptions unless specified otherwise
- Account for seasonality if relevant to [INDUSTRY]
- Factor in typical industry benchmarks for [INDUSTRY]

Begin by confirming the assumptions, then proceed with the complete financial model.
Best Use Cases
Startup founders preparing pitch decks for seed/Series A funding rounds requiring detailed 3-5 year forecasts
SMB owners creating annual budgets and growth plans to present to banks for loan applications
Financial consultants building standardized models for client presentations and valuation exercises
Corporate strategy teams evaluating new product line viability and cannibalization effects on existing revenue
Non-profit organizations projecting grant funding cycles and operational sustainability over multi-year horizons
Frequently Asked Questions

More Like This

Back to Library

AI Business Dissolution Process Planner

This comprehensive prompt transforms AI into a specialized corporate dissolution consultant, guiding you through the intricate process of legally winding down a business. It generates customized roadmaps covering regulatory filings, creditor settlements, asset distribution, and stakeholder notifications while ensuring compliance with jurisdictional requirements.

#Business#dissolution+3
2,510
4.8

AI Business Jargonize

This prompt helps professionals elevate their business communication by converting simple, direct language into industry-appropriate jargon that conveys expertise, strategic thinking, and corporate credibility. Perfect for presentations, reports, emails, and stakeholder communications where perception matters.

#business writing#corporate communication+3
1,809
3.5

Strategic Business Turnaround Architect

This prompt engineers an elite turnaround consultant that diagnoses critical business failures and constructs comprehensive, phased recovery strategies. It delivers actionable 30-90-180 day execution plans complete with financial restructuring tactics, operational efficiency protocols, and stakeholder management frameworks tailored to your specific crisis context.

#Business#turnaround+3
1,172
3.6
Get This Prompt
Free
Quick Actions
Estimated time:13 min
Verified by73 experts