8 Financial Model Prompts That Impress Investors and Close Deals
Spending days building financial models that investors still question? Your spreadsheets look amateur. Growth assumptions seem pulled from thin air. Fundraising gets delayed because your numbers don't add up.
Here's how you use AI to help automate your job as a founder or finance professional. These 8 AI prompts transform financial modeling from weeks of Excel hell into investor-grade projections in minutes. Build 5-year revenue models, cap tables with dilution scenarios, and cash flow projections that actually close deals.
Perfect for startup founders preparing for Series A/B rounds and finance teams at high-growth companies. Each prompt delivers professional models with defensible assumptions and scenario planning. Average time saved per model: 2-3 hours.
The Prompts
Pro tip: Click the heart icon on any prompt to save it to your account for quick access later.
1. Build 5-Year Revenue Model with Growth Assumptions
Build 5-Year Revenue Model with Growth Assumptions
Stop building revenue models from scratch every pitch deck. Use this when preparing for investor meetings or board presentations. Creates detailed 5-year projections with defensible growth assumptions and scenario planning. Saves 2-3 hours of spreadsheet work while delivering investor-grade financial models.
You are an expert financial modeler specializing in startup revenue projections and investor presentations.
Build a comprehensive 5-year revenue model with growth assumptions:
- Business type: [BUSINESS MODEL - e.g., SaaS, marketplace, e-commerce]
- Current metrics: [CURRENT REVENUE/USERS/PRICING]
- Market context: [TARGET MARKET SIZE AND GROWTH RATE]
- Key assumptions: [GROWTH DRIVERS AND CONSTRAINTS]
Provide:
1. Revenue Model Structure
- Primary revenue streams breakdown
- Unit economics foundation
- Pricing strategy evolution
- Customer acquisition channels
2. 5-Year Projections Table
- Year-over-year revenue growth
- Customer acquisition numbers
- Average revenue per user/customer
- Market penetration percentages
3. Growth Assumptions Framework
- Customer acquisition rate assumptions
- Retention and churn projections
- Pricing power and expansion revenue
- Market size and competition factors
4. Scenario Analysis
- Conservative case (70% of base)
- Base case (most likely)
- Aggressive case (130% of base)
- Key sensitivity factors
5. Investor Talking Points
- Defensible growth drivers
- Comparable company benchmarks
- Risk mitigation strategies
- Milestone-based validation
Format as investor-ready tables and bullet points. Include percentage growth rates and absolute numbers.Customization Tips
- • Add industry-specific metrics for better accuracy
- • Include competitor benchmarks for validation
- • Specify funding milestones tied to revenue targets
Expected Output
- • Complete 5-year revenue projection with scenarios
- • Defensible growth assumptions and benchmarks
- • Investor-ready talking points and risk analysis
2. Create Cash Flow Projections for Funding Rounds
Create Cash Flow Projections for Funding Rounds
Finally get cash flow projections that actually help close funding rounds. Use this when preparing Series A/B materials or bridge funding requests. Builds month-by-month cash flow models with burn rate analysis and runway calculations. Saves 90+ minutes while creating investor-grade financial projections.
You are an expert startup CFO specializing in cash flow modeling and fundraising financial projections.
Create detailed cash flow projections for funding rounds:
- Current cash position: [CURRENT CASH BALANCE]
- Monthly burn rate: [CURRENT MONTHLY EXPENSES]
- Revenue timeline: [MONTHLY REVENUE PROJECTIONS]
- Funding target: [AMOUNT SEEKING TO RAISE]
Provide:
1. 18-Month Cash Flow Model
- Monthly cash inflows (revenue, funding)
- Monthly cash outflows by category
- Running cash balance
- Burn rate trends
2. Runway Analysis
- Current runway without funding
- Extended runway with new funding
- Break-even timeline
- Cash flow positive projections
3. Funding Requirements
- Minimum viable funding amount
- Optimal funding for growth targets
- Use of funds breakdown
- Milestone-based deployment
4. Scenario Planning
- Best case: Faster revenue growth
- Base case: Current trajectory
- Worst case: Slower growth, higher burn
- Contingency funding needs
5. Key Metrics Dashboard
- Monthly burn rate evolution
- Revenue growth trajectory
- Gross margin improvements
- Unit economics progression
6. Investor Communication Points
- Capital efficiency metrics
- Risk mitigation strategies
- Growth investment rationale
- Path to profitability
Format with monthly tables and clear milestone markers. Include percentage changes and absolute dollar amounts.Customization Tips
- • Specify hiring plan timeline for accurate projections
- • Include seasonal revenue patterns if applicable
- • Add bridge funding scenarios for contingency planning
Expected Output
- • 18-month cash flow model with runway analysis
- • Funding requirements and use of funds breakdown
- • Scenario planning with risk mitigation strategies
Get Free AI Tips & Prompts Weekly
Join thousands getting exclusive AI automation tips, ready-to-use prompts, and custom agents delivered to your inbox.
3. Design Unit Economics Dashboard for SaaS Models
Design Unit Economics Dashboard for SaaS Models
Stop guessing if your SaaS unit economics actually work. Use this when building investor decks or optimizing pricing strategy. Creates comprehensive unit economics framework with CAC, LTV, and payback calculations. Saves 60+ minutes while delivering metrics that prove business viability.
You are an expert SaaS financial analyst specializing in unit economics modeling and subscription business metrics.
Design a comprehensive unit economics dashboard:
- Pricing model: [PRICING TIERS AND STRUCTURE]
- Customer data: [ACQUISITION COSTS AND RETENTION RATES]
- Revenue metrics: [MRR, CHURN, EXPANSION REVENUE]
Provide:
1. Core Unit Economics Metrics
- Customer Acquisition Cost (CAC) by channel
- Customer Lifetime Value (LTV) calculation
- LTV:CAC ratio analysis
- Payback period by customer segment
2. Revenue Cohort Analysis
- Monthly cohort revenue tracking
- Churn rates by customer segment
- Net revenue retention rates
- Expansion revenue contributions
3. SaaS Metrics Dashboard
- Monthly Recurring Revenue (MRR) growth
- Annual Run Rate (ARR) projections
- Gross revenue retention
- Logo retention vs dollar retention
4. Profitability Framework
- Gross margin by pricing tier
- Contribution margin per customer
- Unit economics break-even timeline
- Scale economics projections
5. Optimization Recommendations
- CAC reduction opportunities
- LTV improvement strategies
- Pricing optimization insights
- Channel efficiency analysis
6. Investor-Ready Metrics
- Rule of 40 calculation
- Magic number analysis
- Benchmark comparisons
- Growth efficiency scores
Format as clear tables with percentage improvements and dollar impacts. Include industry benchmark comparisons where relevant.Customization Tips
- • Add customer segment breakdowns for detailed analysis
- • Include freemium conversion rates if applicable
- • Specify enterprise vs SMB metrics separately
Expected Output
- • Complete unit economics dashboard with key ratios
- • Cohort analysis and retention metrics breakdown
- • Actionable optimization recommendations with benchmarks
4. Generate Investor-Ready Sensitivity Analysis Models
Generate Investor-Ready Sensitivity Analysis Models
Stop presenting single-point forecasts that make investors nervous about your assumptions. Use this when preparing for investor meetings or board presentations where you need to show how key variables impact your projections. It creates professional sensitivity tables that demonstrate you've thought through risks and opportunities. Saves 2-3 hours of manual Excel modeling while building investor confidence.
You are an expert financial modeler specializing in startup and growth company valuations.
Create a comprehensive sensitivity analysis for investor presentations:
- Business model: [DESCRIBE YOUR BUSINESS MODEL]
- Key variables: [LIST 3-4 KEY VARIABLES TO TEST]
- Base case assumptions: [YOUR CURRENT ASSUMPTIONS]
- Time horizon: [FORECAST PERIOD IN YEARS]
Provide:
1. Variable Selection & Rationale
- Justify why each variable matters most
- Typical range variations for your industry
- Interdependencies between variables
2. Sensitivity Tables
- Two-way sensitivity matrix for top 2 variables
- One-way sensitivity for remaining variables
- Revenue, EBITDA, and valuation impacts
- Color-coded results (green/yellow/red zones)
3. Scenario Analysis
- Bull case (top 25% outcomes)
- Base case (most likely)
- Bear case (bottom 25% outcomes)
- Key assumptions for each scenario
4. Investment Implications
- Risk factors investors should consider
- Upside potential quantification
- Recommended monitoring metrics
- Mitigation strategies for downside scenarios
Format with clear headers and tables. Include specific percentage ranges and dollar amounts. Make it boardroom-ready.Customization Tips
- • Add industry-specific variables for better relevance
- • Include competitor benchmarks for context
- • Specify investor type (VC, PE, strategic)
Expected Output
- • Professional sensitivity tables with color-coded risk zones
- • Three detailed scenarios with financial implications
- • Investor-focused risk assessment and mitigation strategies
5. Build Cap Table with Dilution Impact Scenarios
Build Cap Table with Dilution Impact Scenarios
Finally get clear answers on how funding rounds affect everyone's ownership. Use this when planning fundraising rounds, negotiating with investors, or explaining dilution to employees and co-founders. It models multiple funding scenarios so you can make informed decisions about valuation and deal terms. Saves 3-4 hours of complex spreadsheet work while preventing costly dilution mistakes.
You are an expert startup finance advisor specializing in cap table modeling and equity structuring.
Model cap table dilution across multiple funding scenarios:
- Current cap table: [DESCRIBE CURRENT OWNERSHIP - founders, employees, investors with %]
- Funding target: [AMOUNT YOU WANT TO RAISE]
- Use of funds: [HOW YOU'LL SPEND THE MONEY]
Provide:
1. Current Cap Table Analysis
- Pre-money valuation implications
- Fully diluted share count
- Option pool adequacy assessment
- Founder ownership vs. industry benchmarks
2. Funding Scenarios
- Scenario A: Target raise at 20% dilution
- Scenario B: Target raise at 25% dilution
- Scenario C: Target raise at 30% dilution
- Post-money ownership for each stakeholder
3. Dilution Impact Tables
- Before/after ownership percentages
- Dollar value impact at exit scenarios
- Anti-dilution provision effects
- Employee option pool adjustments
4. Strategic Recommendations
- Optimal dilution range for your stage
- Negotiation priorities with investors
- Future round planning considerations
- Employee communication strategy
5. Next Round Preview
- Projected Series B dilution impact
- Founder ownership trajectory
- Investor return expectations
Format with clear tables and percentage calculations. Include specific dollar amounts at different exit values.Customization Tips
- • Add specific investor types and deal terms
- • Include employee stock option details
- • Specify your company stage and industry
Expected Output
- • Detailed cap table with three funding scenarios
- • Dilution impact analysis with dollar value calculations
- • Strategic recommendations for fundraising negotiations
6. Create Burn Rate Calculator with Runway Analysis
Create Burn Rate Calculator with Runway Analysis
Stop guessing when you'll run out of money and start planning with confidence. Use this when updating investors, planning hiring, or deciding on fundraising timing. It calculates your exact runway under different scenarios and identifies the optimal time to start fundraising. Saves 2-3 hours of manual calculations while giving you precise cash management insights.
You are an expert startup CFO specializing in cash flow management and runway planning.
Build a comprehensive burn rate and runway analysis:
- Current cash balance: [CASH ON HAND IN $]
- Monthly expenses: [BREAKDOWN OF MAJOR EXPENSE CATEGORIES]
- Revenue run rate: [CURRENT MONTHLY RECURRING REVENUE]
- Team size: [CURRENT HEADCOUNT AND PLANNED HIRES]
Provide:
1. Current Burn Analysis
- Gross burn rate (total monthly expenses)
- Net burn rate (expenses minus revenue)
- Burn rate trend (last 6 months)
- Major expense categories and percentages
2. Runway Scenarios
- Current runway at existing burn rate
- Scenario A: Conservative growth (10% monthly expense increase)
- Scenario B: Moderate growth (20% monthly expense increase)
- Scenario C: Aggressive growth (35% monthly expense increase)
- Revenue growth impact on each scenario
3. Monthly Cash Flow Projections
- 12-month cash balance forecast
- Break-even timeline estimates
- Seasonal adjustment factors
- Working capital requirements
4. Fundraising Timeline
- Optimal fundraising start date (6-month buffer)
- Minimum viable runway recommendations
- Bridge financing considerations
- Emergency cost-cutting scenarios
5. Action Items & Monitoring
- Key metrics to track weekly
- Expense optimization opportunities
- Revenue acceleration priorities
- Board reporting recommendations
Format with clear month-by-month projections and scenario comparisons. Include specific dates and dollar amounts.Customization Tips
- • Add seasonal business variations if applicable
- • Include specific hiring plans and salary costs
- • Specify your industry and growth stage
Expected Output
- • Monthly cash flow projections for 12 months
- • Three growth scenarios with exact runway dates
- • Fundraising timeline with strategic recommendations
7. Build ROI Marketing Model That Impresses Investors
Build ROI Marketing Model That Impresses Investors
Stop presenting marketing spend without clear ROI projections to investors. Use this when preparing board decks, fundraising materials, or budget approval meetings. It transforms basic marketing metrics into investor-grade financial models with clear payback periods and sensitivity analysis. Saves 90 minutes vs building from scratch while ensuring professional presentation standards.
You are an expert financial analyst specializing in marketing ROI models for investor presentations.
Create a comprehensive marketing ROI model with the following inputs:
- Marketing Budget: [TOTAL MARKETING BUDGET]
- Customer Acquisition Cost: [CURRENT CAC]
- Customer Lifetime Value: [CURRENT LTV]
- Business Type: [B2B/B2C/SAAS/ECOMMERCE]
Provide:
1. Executive Summary
- Key ROI metrics (ROAS, payback period, LTV:CAC ratio)
- Marketing efficiency score
- Risk assessment summary
2. Financial Model Structure
- Monthly budget allocation by channel
- Customer acquisition projections
- Revenue attribution timeline
- Cumulative ROI progression
3. Scenario Analysis
- Best case (20% improvement in metrics)
- Base case (current performance)
- Worst case (20% decline in metrics)
- Break-even analysis for each scenario
4. Investor-Ready Metrics
- Payback period calculation
- Marketing contribution to revenue growth
- Unit economics improvement over time
- Sensitivity analysis for key variables
5. Implementation Timeline
- 90-day rollout plan
- Key performance milestones
- Budget release triggers
- Success measurement framework
Format as investor presentation with clear assumptions, methodology, and actionable insights. Include formulas and calculation logic.Customization Tips
- • Add industry benchmarks for credible comparisons
- • Include competitor CAC data for market context
- • Specify measurement tools and tracking methods
Expected Output
- • Complete ROI model with 3 scenarios and timelines
- • Investor-ready metrics with clear assumptions
- • Implementation roadmap with success milestones
8. Create Break-Even Analysis with Growth Timeline
Create Break-Even Analysis with Growth Timeline
Finally get clear answers on when your business hits profitability. Use this when preparing investor updates, board presentations, or strategic planning sessions. It creates detailed break-even analysis with monthly progression and scenario planning that investors expect to see. Saves 75 minutes vs manual spreadsheet work while ensuring accuracy and professional formatting.
You are an expert financial planner specializing in break-even analysis for growing businesses.
Build a comprehensive break-even analysis using these inputs:
- Monthly Fixed Costs: [TOTAL FIXED COSTS]
- Variable Cost per Unit: [COST PER UNIT/CUSTOMER]
- Average Revenue per Unit: [REVENUE PER UNIT/CUSTOMER]
- Current Monthly Units: [CURRENT VOLUME]
Provide:
1. Break-Even Calculation
- Break-even point in units
- Break-even point in revenue
- Contribution margin analysis
- Safety margin assessment
2. Timeline Analysis
- Month-by-month progression to break-even
- Required growth rate calculation
- Cumulative cash flow projection
- Key milestone dates
3. Scenario Planning
- Conservative growth (current rate)
- Aggressive growth (2x current rate)
- Market downturn (50% slower growth)
- Impact of cost changes on timeline
4. Sensitivity Analysis
- Break-even changes with 10% cost variations
- Revenue price elasticity impact
- Fixed cost optimization opportunities
- Variable cost reduction targets
5. Action Plan
- Critical success factors for timeline
- Cost control priorities
- Revenue acceleration tactics
- Monthly tracking metrics
6. Visual Dashboard
- Break-even chart description
- Key performance indicators
- Progress tracking framework
- Alert thresholds for course correction
Format with clear assumptions, formulas, and actionable recommendations. Include monthly tracking template and variance analysis framework.Customization Tips
- • Add seasonal adjustments for cyclical businesses
- • Include funding runway analysis for startups
- • Specify cost categories for detailed tracking
Expected Output
- • Complete break-even model with monthly timeline
- • Scenario analysis with 3 growth projections
- • Actionable tracking framework and success metrics
How to Use These Prompts
1. Choose Your Platform: These prompts work with ChatGPT, Claude, Gemini, Grok, Copilot and other AI assistants. Click the dropdown button to select your preferred AI tool.
2. Click Run: Click the run button to open your preferred AI tool with the prompt pre-filled.
3. Fill in the Placeholders: Replace all text in [BRACKETS] with your specific information. The "What You'll Need" section tells you exactly what to prepare.
4. Press Enter: Hit enter. The AI will generate your result based on the instructions.
5. Refine if Needed: If the output isn't perfect, use the customization tips to adjust the prompt or ask follow-up questions.
Prompt Engineering Tips for financial model prompts
Tip 1: Always Include Your Business Model Type
Specify whether you're B2B SaaS, marketplace, e-commerce, or subscription-based. Each model has different growth patterns, unit economics, and investor expectations. The AI will use industry-specific benchmarks and metrics that actually matter for your business type.
Tip 2: Provide Real Numbers, Not Estimates
Use your actual current revenue, burn rate, and customer metrics instead of rounded estimates. AI models work better with precise data points. If you input "$47,300 MRR" instead of "around $50k," you'll get more accurate projections and realistic growth scenarios.
Tip 3: Request Multiple Scenarios with Assumptions
Ask for conservative, base case, and optimistic projections with clear assumptions for each. Investors expect to see scenario planning. Include phrases like "show me three scenarios with different growth rates and explain the key drivers behind each assumption."
Tip 4: Specify Your Fundraising Context
Tell the AI your funding stage (pre-seed, Series A, etc.) and target investor type. A Series A model needs different metrics than a bridge round. Include your intended use of funds so the AI can align projections with your growth plan.
Tip 5: Ask for Investor-Ready Formatting
Request outputs in table format with clear headers, color coding for different scenarios, and summary bullet points. Specify "format this for a board presentation" or "create investor-ready tables." This saves hours of manual formatting work.
Tip 6: Include Industry Benchmarks
Ask the AI to compare your metrics against industry standards. Request statements like "compare our CAC payback period to SaaS benchmarks" or "show how our burn multiple compares to Series A companies." This adds credibility to your projections.
Tip 7: Build Connected Models, Not Isolated Calculations
Link your revenue projections to headcount plans, cash flow to marketing spend, and unit economics to growth targets. Ask for models where changing one assumption updates related metrics automatically. This creates comprehensive financial stories that impress investors.
Frequently Asked Questions
Ready to Launch Your Startup?
Get 75+ AI agents that are personalized to your business and custom-built for founders. Everything you need to validate, build, and operate your business.
Claim Your Founder Pack