Financial Planning and Analysis: AI Prompts for Finance

I’ll never forget my first board meeting as a startup CFO. I was asked to walk through our financial model, and I spent 72 hours straight building a DCF analysis in Excel. When the board started asking scenario questions—“What if churn increases? What if we raise prices?”—I had to rebuild entire sections. The meeting was torture.

After that experience, I started wondering: there’s got to be a better way. Could AI help me answer these questions in real-time instead of spending days building new models from scratch?

The answer changed my career. Once I learned to craft specific prompts for financial analysis, I could generate scenario analyses in minutes that previously took days. The key insight: AI doesn’t replace financial expertise—it amplifies it. The finance professionals who master these prompts aren’t outsourcing their judgment; they’re using AI to handle the calculation heavy lifting so they can focus on strategic interpretation.

Here’s what surprised me most: the quality of AI financial output depends entirely on how you frame the request. Vague prompts produce vague analysis. Specific prompts with clear assumptions, output formats, and analytical frameworks produce professional-grade financial models.

Why AI-Powered Financial Planning Works

Financial planning and analysis has always been time-intensive. Building a proper DCF model takes 20-40 hours for an experienced analyst. Even routine variance analysis consumes hours of manual spreadsheet work. The intellectual work is valuable, but the mechanical calculations are repetitive.

AI changes this fundamentally. The same financial frameworks that investment banks charge premium rates for—DCF analysis, SaaS metrics, scenario planning—can be systematically applied using well-crafted prompts. Not as a replacement for financial judgment, but as a force multiplier.

The numbers speak clearly. According to McKinsey research, finance teams that integrate AI into FP&A processes see 50-70% reductions in model-building time while improving accuracy and enabling more frequent scenario analysis. The key word is “integrate”—not replace.

What makes these prompts different from generic AI requests is specificity. Every prompt below defines the role the AI should play, the financial framework to apply, the constraints to follow, and the output format required. This structure transforms vague AI capabilities into precise financial instruments.

Note: For a broader view of how AI transforms business operations, explore our guide on AI prompts for business analysts.

Core Financial Modeling Prompts

These foundational prompts cover the essential financial analysis that every FP&A professional needs—valuation, metrics, and planning.

1. DCF (Discounted Cash Flow) Model Helper

Purpose: Build comprehensive DCF valuation models with projections, WACC calculation, terminal value, and sensitivity analysis.

Use case: M&A transactions, IPO valuation, investment decisions, equity research

# Role
Investment Banking Analyst or Certified Financial Analyst (CFA)

# Objective
Guide the user through building a comprehensive DCF valuation model, structuring projections, calculating WACC, determining terminal value, and arriving at an enterprise value and equity value.

# Context
The user wants to value a company using the Discounted Cash Flow method. This is typically used for:
- M&A transactions
- Initial public offering (IPO) pricing
- Private company valuation for investment decisions
- Intrinsic value analysis for equity research

# Constraints
- **Chain of Thought**: Show all formula calculations explicitly
- **Negative Constraints**: Do not make unrealistic growth assumptions without justification
- **Transparency**: Clearly state all assumptions made
- **Industry Standards**: Follow CFA Institute and investment banking best practices

# Output Format

### 1. Input Summary
- Company Name & Ticker (if applicable)
- Valuation Date
- Currency
- Projection Period (typically 5-10 years)

### 2. Free Cash Flow Projections
| Year | Revenue | Revenue Growth | EBIT | Tax Rate | NOPAT | D&A | CapEx | Working Capital | FCF |
|------|---------|----------------|------|----------|-------|-----|-------|-----------------|-----|
| 1 | | | | | | | | | |
| 2 | | | | | | | | | |
| ... | | | | | | | | | |

### 3. WACC Calculation
- Cost of Equity (CAPM: Rf + Beta × ERP)
- Cost of Debt (Yield to Maturity × (1 - Tax Rate))
- Weights (Equity %, Debt %)
- **WACC = (E/V × Re) + (D/V × Rd × (1-T))**

### 4. Terminal Value
- **Method 1 - Perpetuity Growth**: TV = (Final FCF × (1 + g)) / (WACC - g)
- **Method 2 - Exit Multiple**: TV = Final EBITDA × Industry Multiple
- Range analysis (low, base, high cases)

### 5. Valuation Summary
| Component | Low Case | Base Case | High Case |
|-----------|----------|-----------|-----------|
| PV of FCF | | | |
| PV of Terminal Value | | | |
| **Enterprise Value** | | | |
| Less: Net Debt | | | |
| **Equity Value** | | | |
| Implied Share Price | | | |

### 6. Sensitivity Analysis
Table showing how Enterprise Value changes with:
- WACC (±0.5% increments)
- Terminal Growth Rate (±0.25% increments)

## User Input
[PASTE YOUR DATA HERE]

Please include:
- Historical financial statements (3-5 years)
- Current capital structure (debt, equity mix)
- Risk-free rate preference
- Industry/sector for comparable analysis
- Any specific assumptions you want to use

Customize it: Include as much historical data as possible—the DCF is only as good as its underlying assumptions.

2. SaaS Metrics Calculator

Purpose: Calculate and analyze key SaaS metrics including LTV, CAC, MRR, Churn, NRR, and Magic Number.

Use case: Investor reporting, board presentations, go-to-market optimization

# Role
SaaS Finance Lead or VP of Finance

# Objective
Calculate and analyze key SaaS metrics including LTV, CAC, MRR, Churn, Net Revenue Retention, and Magic Number to assess subscription business health and growth efficiency.

# Context
The user is running a SaaS business and needs to understand their unit economics and growth efficiency. These metrics are critical for:
- Investor reporting and fundraising
- Board presentations
- Board-level decision making
- Go-to-market strategy optimization
- Understanding sustainable growth rates

# Constraints
- **Chain of Thought**: Show all formulas explicitly
- **Negative Constraints**: Do not annualize monthly data without clearly stating this
- **Industry Context**: Use generally accepted SaaS benchmarks (e.g., LTV:CAC > 3x is healthy)
- **Clarity**: Distinguish between dollar-based and customer-based churn

# Output Format

### 1. Revenue Metrics

#### Monthly Recurring Revenue (MRR)
| Metric | Amount |
|--------|--------|
| New MRR | $ |
| Expansion MRR | $ |
| Contraction MRR | ($) |
| Churned MRR | ($) |
| **Net New MRR** | $ |
| **Starting MRR** | $ |
| **Ending MRR** | $ |
| MRR Growth Rate | % |

### 2. Retention Metrics

#### Net Revenue Retention (NRR)
| Metric | Value |
|--------|-------|
| Starting MRR | $ |
| Expansion | $ |
| Contraction | ($) |
| Churn | ($) |
| **NRR** | % |
| **Status**: [Healthy if >100%] |

#### Gross Revenue Retention (GRR)
| Metric | Value |
|--------|-------|
| Starting MRR | $ |
| Contraction | ($) |
| Churn | ($) |
| **GRR** | % |
| **Status**: [Healthy if >90%] |

### 3. Customer Economics

#### Lifetime Value (LTV)
| Metric | Calculation | Value |
|--------|-------------|-------|
| ARPU | Revenue / Customers | $ |
| Gross Margin | (Revenue - COGS) / Revenue | % |
| Monthly Churn | Churned / Starting | % |
| LTV (Months) | ARPU × Gross Margin / Churn | $ |
| LTV (Years) | LTV(Months) / 12 | $ |

#### Customer Acquisition Cost (CAC)
| Metric | Value |
|--------|-------|
| Sales & Marketing Spend | $ |
| New Customers Acquired | |
| **CAC** | $ |

#### Unit Economics
| Metric | Formula | Value | Benchmark | Status |
|--------|---------|-------|-----------|--------|
| LTV:CAC | LTV / CAC | x | >3.0x | [Green/Yellow/Red] |
| Payback Period | CAC / (ARPU × Gross Margin) | months | <12 months | |
| CAC as % of ACV | CAC / (ARPU × 12) | % | <100% | |

### 4. Sales Efficiency

#### Magic Number
| Metric | Value |
|--------|-------|
| Net New ARR/MRR | $ |
| Prior Period S&M | $ |
| **Magic Number** | x |

**Interpretation**:
- <0.75: Inefficient
- 0.75-1.0: Moderate
- >1.0: Efficient

### 5. Summary Dashboard
| Metric | Current | Target | Status |
|--------|---------|--------|--------|
| MRR Growth | | >10%/mo | |
| NRR | | >110% | |
| Churn | | <5%/mo | |
| LTV:CAC | | >3.0x | |
| Magic Number | | >0.75 | |

### 6. Recommendations
- Priority areas for improvement
- Suggested targets for next quarter
- Key risks identified

## User Input
[PASTE YOUR DATA HERE]

Please include:
- Current month and prior month MRR breakdown
- New, expansion, contraction, and churn MRR
- Total customers (starting, ending)
- Sales & Marketing spend
- Gross margin percentage (or COGS for detailed calculation)

Customize it: Run this monthly for board decks—the consistency of calculation matters more than any single month’s numbers.

3. Financial Ratio Calculator

Purpose: Compute and interpret key financial ratios across liquidity, profitability, leverage, and efficiency categories.

Use case: Financial health assessment, credit analysis, investment screening

# Role
Senior Credit Analyst or Financial Statement Analyst

# Objective
Compute and interpret key financial ratios across liquidity, profitability, leverage, and efficiency categories to assess overall financial health and performance.

# Context
Financial ratios provide standardized metrics for comparing performance across companies, time periods, and industries. This analysis helps identify strengths, weaknesses, and trends.

# Constraints
- Use appropriate ratios for the industry context
- Compare to relevant benchmarks (industry averages, historical performance)
- Explain the drivers behind ratio changes
- Note any data limitations or adjustments

# Output Format

### 1. Liquidity Ratios
| Ratio | Formula | Current | Prior Period | Change | Benchmark |
|-------|---------|---------|--------------|--------|-----------|
| Current Ratio | Current Assets / Current Liabilities | | | | >1.5 |
| Quick Ratio | (Current Assets - Inventory) / CL | | | | >1.0 |
| Cash Ratio | Cash / Current Liabilities | | | | >0.5 |
| Operating Cash Flow Ratio | OCF / Current Liabilities | | | | >1.0 |

### 2. Profitability Ratios
| Ratio | Formula | Current | Prior Period | Change | Benchmark |
|-------|---------|---------|--------------|--------|-----------|
| Gross Margin | (Revenue - COGS) / Revenue | | | | Industry-specific |
| Operating Margin | EBIT / Revenue | | | | |
| Net Margin | Net Income / Revenue | | | | |
| ROA | Net Income / Total Assets | | | | |
| ROE | Net Income / Equity | | | | |
| ROIC | NOPAT / Invested Capital | | | | |

### 3. Leverage Ratios
| Ratio | Formula | Current | Prior Period | Change | Benchmark |
|-------|---------|---------|--------------|--------|-----------|
| Debt-to-Equity | Total Debt / Equity | | | | <2.0 |
| Debt-to-EBITDA | Total Debt / EBITDA | | | | <4.0 |
| Interest Coverage | EBIT / Interest Expense | | | | >3.0 |
| Debt Service Coverage | OCF / Total Debt Service | | | | >1.25 |

### 4. Efficiency Ratios
| Ratio | Formula | Current | Prior Period | Change | Benchmark |
|-------|---------|---------|--------------|--------|-----------|
| Asset Turnover | Revenue / Total Assets | | | | |
| Inventory Turnover | COGS / Inventory | | | | |
| Receivables Turnover | Revenue / Accounts Receivable | | | | |
| Days Sales Outstanding | 365 / Receivables Turnover | | | | |
| Payables Turnover | COGS / Accounts Payable | | | | |

### 5. Cash Flow Ratios
| Ratio | Formula | Current | Prior Period | Change |
|-------|---------|---------|--------------|--------|
| Free Cash Flow Margin | FCF / Revenue | | | |
| CapEx as % of Revenue | CapEx / Revenue | | | |
| OCF to Net Income | OCF / Net Income | | | |

### 6. Summary Assessment
- Overall financial health rating
- Key strengths identified
- Areas of concern
- Trend analysis

## User Input
[PASTE YOUR FINANCIAL DATA]
- Balance sheet (current and prior period)
- Income statement (current and prior period)
- Cash flow statement
- Any notes on unusual items or adjustments

Customize it: Include industry context—the same ratios mean very different things in capital-intensive vs. service businesses.

4. Cash Flow Projection

Purpose: Build rolling cash flow projections with scenario analysis and runway calculations.

Use case: Treasury planning, fundraising preparation, liquidity management

# Role
Treasury Director or VP of Finance

# Objective
Create comprehensive cash flow projections including operating, investing, and financing activities, with scenario analysis and runway calculations.

# Context
Cash flow projections are essential for:
- Managing liquidity and avoiding cash crunches
- Planning fundraising or debt refinancing
- Supporting strategic decisions about growth investments
- Communicating with investors and board members

# Constraints
- Use rolling projections (monthly for at least 12 months)
- Include seasonality where relevant
- Differentiate between committed and discretionary cash flows
- Show key assumptions clearly

# Output Format

### 1. Opening Cash Position
- Beginning cash balance
- Cash sources (customers, financing, etc.)

### 2. Operating Cash Flows
| Category | Jan | Feb | Mar | Q1 Total |
|----------|-----|-----|-----|----------|
| Cash Collections | | | | |
| Cash Payments (COGS) | | | | |
| Cash Payments (OpEx) | | | | |
| Payroll | | | | |
| Other Operating | | | | |
| **Net Operating CF** | | | | |

### 3. Investing Cash Flows
| Category | Jan | Feb | Mar | Q1 Total |
|----------|-----|-----|-----|----------|
| CapEx | | | | |
| Acquisitions | | | | |
| Other Investing | | | | |
| **Net Investing CF** | | | | |

### 4. Financing Cash Flows
| Category | Jan | Feb | Mar | Q1 Total |
|----------|-----|-----|-----|----------|
| Debt Payments | | | | |
| Debt Proceeds | | | | |
| Equity Financing | | | | |
| Dividends | | | | |
| **Net Financing CF** | | | | |

### 5. Cash Balance Summary
| Month | Opening | Operating | Investing | Financing | Closing |
|-------|---------|-----------|-----------|-----------|---------|
| Jan | | | | | |
| Feb | | | | | |
| Mar | | | | | |

### 6. Scenario Analysis
| Scenario | Assumptions | Runway | Key Risks |
|----------|-------------|--------|-----------|
| Base Case | | | |
| Upside | | | |
| Downside | | | |

### 7. Runway Analysis
- Months of cash at each scenario
- Cash flow breakeven date
- Recommended cash buffer

## User Input
[PASTE YOUR CASH FLOW DATA]
- Historical cash collection patterns
- Known/predicted payments
- Debt repayment schedules
- Capital expenditure plans
- Financing activities planned
- Seasonality patterns

Customize it: Update this weekly during fundraising or uncertain periods—the model is only useful if it reflects current reality.

Budgeting and Analysis Prompts

These prompts help with routine FP&A work—budgeting, variance analysis, and scenario planning.

5. Variance Analysis

Purpose: Analyze budget-to-actual variances with root cause identification and actionable recommendations.

Use case: Monthly reporting, performance reviews, forecast updates

# Role
FP&A Manager or Financial Controller

# Objective
Conduct comprehensive variance analysis comparing actual results to budget/forecast, identifying root causes of significant variances, and providing actionable recommendations.

# Context
Variance analysis is the foundation of financial control and continuous improvement. Effective analysis moves beyond "what happened" to "why it happened" and "what we should do about it."

# Constraints
- Focus on material variances (typically >5% or >$10K)
- Distinguish between timing differences and permanent variances
- Quantify variance impact where possible
- Provide actionable recommendations, not just observations

# Output Format

### 1. Executive Summary
- Overall variance to budget
- Favorable/unfavorable breakdown
- Key themes identified
- Priority action items

### 2. Revenue Variance Analysis
| Category | Budget | Actual | Variance $ | Variance % | Explanation |
|----------|--------|--------|------------|------------|-------------|
| Product Revenue | | | | | |
| Service Revenue | | | | | |
| Other Revenue | | | | | |
| **Total Revenue** | | | | | |

### 3. Expense Variance Analysis
| Category | Budget | Actual | Variance $ | Variance % | Explanation |
|----------|--------|--------|------------|------------|-------------|
| Cost of Goods Sold | | | | | |
| Personnel | | | | | |
| Marketing | | | | | |
| Operations | | | | | |
| G&A | | | | | |
| **Total Expenses** | | | | | |

### 4. Margin Analysis
| Metric | Budget | Actual | Variance | Driver |
|--------|--------|--------|----------|--------|
| Gross Margin % | | | | |
| Operating Margin % | | | | | |
| Net Margin % | | | | | |

### 5. Root Cause Analysis
For significant variances:
- Primary driver of variance
- Controllable vs. uncontrollable factors
- Timing vs. permanent difference
- Recurring vs. one-time

### 6. Recommendations
- Actions to address unfavorable variances
- Opportunities to accelerate favorable trends
- Forecast adjustments for next period
- Control improvements

## User Input
[PASTE YOUR VARIANCE DATA]
- Budget/forecast figures
- Actual results
- Any context on significant events
- Prior period comparisons

Customize it: Include commentary from department heads—the numbers tell you what happened, people tell you why.

6. Scenario Planning

Purpose: Build multi-scenario financial models with consistent assumptions and clear trade-offs.

Use case: Strategic planning, board presentations, investor updates

# Role
Strategic Finance Lead or CFO

# Objective
Develop comprehensive scenario planning analysis with multiple financial scenarios, consistent assumptions, and clear trade-off analysis.

# Context
Scenario planning helps leadership teams:
- Understand the range of possible outcomes
- Make robust decisions that work across scenarios
- Prepare contingency plans for adverse conditions
- Align on priorities under uncertainty

# Constraints
- Use consistent framework across scenarios
- Clearly document assumptions for each scenario
- Focus on key value drivers, not all line items
- Provide actionable insights, not just projections

# Output Format

### 1. Scenario Overview
| Scenario | Description | Probability | Key Drivers |
|----------|-------------|-------------|-------------|
| Base Case | | | |
| Upside | | | |
| Downside | | | |

### 2. Key Assumptions by Scenario
| Assumption | Base | Upside | Downside |
|------------|------|--------|----------|
| Revenue Growth | | | |
| Gross Margin | | | |
| OpEx Growth | | | |
| Churn/Attrition | | | |
| [Key Driver 5] | | | |

### 3. Projected P&L by Scenario
| Metric | Base | Upside | Downside |
|--------|------|--------|----------|
| Revenue | | | |
| Gross Profit | | | |
| Operating Expenses | | | |
| EBITDA | | | |
| Net Income | | | |

### 4. Key Metrics by Scenario
| Metric | Base | Upside | Downside |
|--------|------|--------|----------|
| Gross Margin % | | | |
| EBITDA Margin % | | | |
| Cash Position (EOY) | | | |
| Burn Rate | | | |
| Runway (months) | | | |

### 5. Scenario Comparison
- Best case / worst case spread
- Break-even points
- Key decision points by scenario
- Recommended hedges or actions

### 6. Risk Register
| Risk | Scenario | Likelihood | Impact | Mitigation |
|------|----------|------------|--------|------------|
| R1 | | | | |

## User Input
[PASTE YOUR SCENARIO DATA]
- Current financial position
- Historical performance trends
- Market/industry expectations
- Strategic initiatives planned
- Known risks and uncertainties

Customize it: Build 3 scenarios maximum—five becomes confusing and dilutes decision-making clarity.

7. Zero-Based Budgeting Guide

Purpose: Structure zero-based budgeting processes with category-by-category justification.

Use case: Cost optimization, annual budgeting, organizational restructuring

# Role
Management Consultant or Finance Transformation Lead

# Objective
Provide comprehensive guidance for implementing zero-based budgeting (ZBB), including framework, category analysis, and decision support.

# Context
Zero-based budgeting requires every expense to be justified from scratch each period, rather than simply rolling forward prior budgets. ZBB is particularly valuable for:
- Cost transformation programs
- Organizations with historical bloat
- Private equity portfolio companies
- High-growth companies needing financial discipline

# Constraints
- Focus on material expense categories
- Ensure consistency in justification criteria
- Separate must-have from nice-to-have spending
- Consider organizational impact of changes

# Output Format

### 1. Current State Assessment
| Category | Current Spend | % of Total | Trend (YoY) | Benchmark |
|----------|--------------|------------|-------------|-----------|
| Personnel | | | | |
| Technology | | | | |
| Marketing | | | | |
| Facilities | | | | |
| Professional Services | | | | |

### 2. ZBB Decision Framework
For each category, evaluate:

#### Must-Have Spending
- Regulatory/compliance requirements
- Core operational needs
- Revenue-enabling investments
- Safety/security necessities

#### Should-Have Spending
- Efficiency improvements
- Quality enhancements
- Competitive positioning
- Talent retention

#### Nice-to-Have Spending
- Enhancements without clear ROI
- Historical budget artifacts
- duplicative capabilities

### 3. Optimization Opportunities
| Category | Current Spend | Target Spend | Savings % | Implementation |
|----------|--------------|--------------|-----------|----------------|
| Category 1 | | | | |
| Category 2 | | | | |

### 4. Implementation Roadmap
- Phased approach timeline
- Stakeholder communication plan
- Governance and controls
- Monitoring metrics

## User Input
[PASTE YOUR BUDGET DATA]
- Current budget by category
- Historical spending patterns
- Organization structure
- Cost reduction targets
- Timeline and constraints

Customize it: Start with the largest categories first—personnel and technology typically drive 60-70% of costs.

Financial Operations Prompts

These prompts support routine finance operations—invoicing, reporting, and compliance.

8. P&L Summarizer

Purpose: Transform detailed P&L data into executive-ready summaries with key insights and trends.

Use case: Board presentations, executive reporting, investor updates

# Role
FP&A Manager or Controller

# Objective
Transform detailed profit and loss data into executive-ready summaries with clear insights, trend analysis, and forward-looking context.

# Context
Executives need financial information that is:
- Concise (one page or less)
- Focused on key insights, not raw data
- Contextualized against targets and trends
- Actionable with clear recommendations

# Constraints
- Limit to 3-5 key messages
- Use consistent formatting across periods
- Highlight variances requiring attention
- Include forward-looking context

# Output Format

### 1. Executive Summary Box
| Metric | Current | vs. Budget | vs. Prior Year | Trend |
|--------|---------|------------|----------------|-------|
| Revenue | | | | |
| Gross Margin | | | | |
| OpEx | | | | |
| EBITDA | | | | |
| Net Income | | | | |

### 2. Key Insights (3-5 bullets)
- Revenue exceeded guidance driven by [driver]
- Gross margin compression due to [factor]
- OpEx under control despite [challenge]
- Notable item requiring attention: [issue]

### 3. Revenue Analysis
- Product performance breakdown
- Geographic/segment highlights
- Pipeline and forward-looking indicators

### 4. Cost Analysis
- OpEx by category variance
- Headcount and compensation trends
- One-time vs. recurring items

### 5. Outlook
- Next period guidance
- Key risks and opportunities
- Management actions planned

## User Input
[PASTE YOUR P&L DATA]
- Current period P&L
- Budget/forecast
- Prior period P&L
- Any notable events or items
- Forward-looking indicators

Customize it: Tailor the summary to your board’s preferences—some want more detail, some want less.

9. Expense Categorization

Purpose: Systematically categorize and analyze expenses for financial reporting and cost management.

Use case: Monthly close, cost analysis, budgeting

# Role
Financial Analyst or Controller

# Objective
Provide a structured framework for expense categorization, classification, and analysis to support accurate financial reporting and cost management.

# Context
Consistent expense categorization enables:
- Accurate financial statements
- Meaningful variance analysis
- Informed decision-making
- Audit and compliance requirements

# Constraints
- Follow GAAP/IFRS classification rules
- Ensure consistency period-over-period
- Document significant estimates
- Consider materiality thresholds

# Output Format

### 1. Primary Expense Categories
| Category | Definition | Examples |
|----------|------------|----------|
| COGS | Direct costs of producing revenue | Hosting, support labor, APIs |
| R&D | Product development investments | Engineering salaries, tools |
| S&M | Sales and marketing costs | Ads, events, sales comp |
| G&A | General administrative | Finance, legal, facilities |
| One-time | Non-recurring items | Restructuring, litigation |

### 2. COGS Breakdown
| Sub-category | Current | Prior | Variance | Notes |
|--------------|---------|-------|----------|-------|
| Infrastructure | | | | |
| Third-party software | | | | |
| Support labor | | | | |

### 3. OpEx Breakdown
| Category | Current | Budget | Variance | YTD |
|----------|---------|--------|----------|-----|
| Personnel | | | | |
| Marketing | | | | |
| Operations | | | | |
| G&A | | | | |

### 4. Recommendations
- Inconsistent categorizations identified
- Suggested reclassifications
- Control improvements

## User Input
[PASTE YOUR EXPENSE DATA]
- Raw expense transactions
- Current categorization rules
- Previous period data

Customize it: Update categorization rules when business model changes—SaaS vs. services have very different COGS.

10. Break-Even Analysis

Purpose: Calculate break-even points and margin of safety across multiple scenarios.

Use case: Pricing decisions, cost structure analysis, profitability planning

# Role
Management Accountant or Pricing Analyst

# Objective
Conduct comprehensive break-even analysis including point calculations, margin of safety, and multi-product scenarios.

# Context
Break-even analysis answers fundamental business questions:
- How much do we need to sell to cover costs?
- What's our margin of safety at current levels?
- How do price changes affect profitability?
- What's the impact of cost structure changes?

# Constraints
- Use appropriate cost allocation for multi-product
- Distinguish fixed and variable costs accurately
- Consider relevant range of analysis
- Document assumptions about cost behavior

# Output Format

### 1. Cost Structure Analysis
| Cost Category | Amount | Fixed/Variable | % of Revenue |
|---------------|--------|----------------|--------------|
| Fixed Costs | | | |
| Variable Costs | | | |

### 2. Break-Even Calculations
| Metric | Value | Notes |
|--------|-------|-------|
| Contribution Margin | | Revenue - Variable Costs |
| Contribution Margin % | | CM / Revenue |
| Break-Even Revenue | | Fixed Costs / CM% |
| Break-Even Units | | (if applicable) |

### 3. Margin of Safety
| Metric | Current | Break-Even | Ratio |
|--------|---------|------------|-------|
| Revenue | | | |
| Units | | | |

### 4. Multi-Product Analysis
| Product | Revenue Mix | CM% | Weighted CM% |
|---------|-------------|-----|--------------|
| Product A | | | |
| Product B | | | |

### 5. Scenario Analysis
| Scenario | Price Change | Cost Change | New BE |
|----------|--------------|-------------|--------|
| Base Case | | | |
| Price +10% | | | |
| Cost +5% | | | |

### 6. Recommendations
- Pricing optimization opportunities
- Cost structure improvements
- Product mix recommendations

## User Input
[PASTE YOUR COST DATA]
- Revenue by product/service
- Fixed costs (by category)
- Variable costs (by category)
- Cost allocation methodology

Customize it: Re-run when prices or cost structures change—even small changes can significantly impact break-even.

Fundraising and Investor Relations Prompts

These prompts support fundraising and investor communication.

11. Investor Update Email

Purpose: Structure compelling investor update communications with key metrics and progress highlights.

Use case: Monthly/quarterly investor updates, board communications, fundraising preparation

# Role
Investor Relations Manager or CFO

# Objective
Create a professional investor update email that communicates key metrics, highlights progress, and maintains investor confidence.

# Context
Investor updates are critical for:
- Maintaining investor relationships
- Setting expectations for future performance
- Positioning for future fundraising
- Building credibility and trust

# Constraints
- Lead with metrics and highlights
- Be honest about challenges
- Provide forward-looking context
- Maintain professional tone

# Output Format

### Subject Line Options
- [Company] Q1 2026 Update: [Key Achievement]
- [Company] Monthly Update: [Metric] Reached [Number]

### Email Structure

#### Opening (2-3 sentences)
- Thank investors for support
- State update period and key message

#### Key Metrics (bullet points)
- Revenue: $[X]M ([Y]% MoM/YoY)
- Key milestone achieved
- Notable operational progress

#### Business Update (2-3 paragraphs)
- Product/technology progress
- Team updates
- Market conditions

#### Financial Snapshot
- Cash position
- Runway
- Burn rate (if applicable)

#### Looking Ahead
- Next period priorities
- Key milestones
- Fundraising status (if relevant)

#### Closing
- Appreciation
- Availability for questions

Customize it: Customize for your investor audience—strategic investors care about different things than financial investors.

12. Pitch Deck Financial Slide

Purpose: Structure compelling financial slides for pitch decks with appropriate metrics and projections.

Use case: Fundraising presentations, board meetings, partner discussions

# Role
Investment Banker or Startup CFO

# Objective
Design impactful financial slides that tell a compelling story for pitch decks, including historical performance, projections, and key metrics.

# Context
Financial slides in pitch decks must:
- Build credibility with data
- Tell a growth story
- Support fundraising ask
- Anticipate investor questions

# Constraints
- Show 2-3 years of historical data
- Project 3-5 years forward
- Highlight key growth drivers
- Include appropriate disclaimers

# Output Format

### Historical Performance
| Metric | 2023 | 2024 | 2025 |
|--------|------|------|------|
| Revenue | | | |
| Growth Rate | | | |
| Gross Margin | | | |
| Customers | | | |

### Key Metrics
| Metric | Current | Target | Year 5 Target |
|--------|---------|--------|---------------|
| ARR | | | |
| Customers | | | |
| NRR | | | |
| LTV:CAC | | | |

### Financial Projections
| Year | Revenue | EBITDA | Margin |
|------|---------|--------|--------|
| 2026 | | | |
| 2027 | | | |
| 2028 | | | |

### Use of Funds
| Category | Amount | % |
|----------|--------|---|
| R&D | | |
| S&M | | |
| G&A | | |

### Key Assumptions
- Growth rate drivers
- Margin expansion drivers
- Capital efficiency improvements

## User Input
[PASTE YOUR FINANCIAL DATA]
- Historical financials
- Current metrics
- Projections and assumptions
- Fundraising details

Customize it: Tailor to round size—Series A focuses on growth, Series B on efficiency, growth equity on scale.

13. Term Sheet Explainer

Purpose: Decode term sheet provisions and their implications for founders and investors.

Use case: Fundraising preparation, founder education, investment analysis

# Role
Venture Capital Investor or Startup Attorney

# Objective
Provide clear explanations of common term sheet provisions, their implications, and typical market terms for startup financing.

# Context
Term sheets contain complex provisions that significantly impact company economics and control. Understanding these terms helps founders negotiate better deals and avoid common pitfalls.

# Constraints
- Explain provisions in plain language
- Note that terms vary by stage and market
- Recommend legal counsel for specific advice
- Focus on most common/prevalent terms

# Output Format

### 1. Valuation Terms
| Term | Typical Range | Explanation |
|------|---------------|-------------|
| Pre-money Valuation | $X - $Y | Company value before investment |
| Post-money Valuation | $X - $Y | Company value after investment |
| Option Pool | 10-20% | Reserved for future employees |

### 2. Economic Terms
| Term | Typical Range | Explanation |
|------|---------------|-------------|
| Liquidation Preference | 1x non-participating | Priority in exit scenarios |
| Participation | 0-1x | Additional upside participation |
| Dividends | Non-cumulative | Typical for venture |

### 3. Control Terms
| Term | Typical Range | Explanation |
|------|---------------|-------------|
| Board Composition | 2:1:1 (FO:Inv:CB) | Board seat allocation |
| Protective Provisions | Veto rights | Major company decisions |
| Pro-rata Rights | Pro-rata | Right to invest in future rounds |

### 4. Other Key Terms
| Term | Typical Range | Explanation |
|------|---------------|-------------|
| Anti-dilution | Weighted average | Protection against down rounds |
| Vesting | 4-year + 1-year cliff | Founder equity retention |
| Information Rights | Standard | Access to company information |

### 5. Negotiation Priorities
- Critical terms to negotiate
- Terms where founders commonly concede too much
- Red flags to watch for

## User Input
[PASTE TERM SHEET OR QUESTIONS]
- Specific terms to explain
- Comparative terms (if evaluating multiple)
- Stage and market context

Customize it: Always pair this with experienced legal counsel—term sheets have significant legal implications.

Specialized Analysis Prompts

14. Chart of Accounts Generator

Purpose: Design and structure chart of accounts optimized for financial reporting and analysis.

Use case: New business setup, ERP implementation, reporting optimization

# Role
Controller or ERP Implementation Lead

# Objective
Design a comprehensive chart of accounts (COA) structure optimized for financial reporting, analysis, and compliance requirements.

# Context
A well-designed chart of accounts:
- Supports accurate financial reporting
- Enables meaningful variance analysis
- Facilitates audit and compliance
- Scales with business growth

# Constraints
- Follow GAAP/IFRS requirements
- Consider ERP system capabilities
- Plan for 5+ years of growth
- Enable drill-down to transaction level

# Output Format

### 1. Asset Accounts (1000s)
| Account | Type | Description | Reporting Level |
|---------|------|-------------|-----------------|
| 1000 | Cash | Operating accounts | Monthly |
| 1100 | AR | Trade receivables | Monthly |

### 2. Liability Accounts (2000s)
| Account | Type | Description | Reporting Level |
|---------|------|-------------|-----------------|
| 2000 | AP | Trade payables | Monthly |
| 2100 | Accrued | Accrued expenses | Monthly |

### 3. Equity Accounts (3000s)
| Account | Type | Description |
|---------|------|-------------|
| 3000 | Common Stock | |
| 3100 | Additional PIC | |

### 4. Revenue Accounts (4000s)
| Account | Type | Description | Analytics |
|---------|------|-------------|-----------|
| 4000 | Product Revenue | By product line | Monthly + Product |
| 4100 | Service Revenue | By service type | Monthly + Type |

### 5. Expense Accounts (5000s-7000s)
| Account | Category | Description | Analytics |
|---------|----------|-------------|-----------|
| 5000 | COGS | Direct costs | Monthly + Category |
| 6000 | R&D | Research & development | Monthly |

### 6. Sub-Account Strategy
- Required sub-accounts for each major category
- Department/segment allocation approach
- Project/customer tagging requirements

### 7. Implementation Notes
- Migration path from existing COA
- Mapping for historical comparisons
- Training requirements

## User Input
[PASTE YOUR REQUIREMENTS]
- Business model and revenue streams
- Current chart of accounts (if exists)
- Reporting requirements (board, investors, tax)
- ERP/system constraints
- Growth plans and complexity anticipated

Customize it: Plan the COA before ERP implementation—changing it later is expensive and disruptive.

Quick Reference: All Finance Prompts

#	Prompt	Purpose	Use Case
1	DCF Model Helper	Build valuation models	M&A, IPO, investment analysis
2	SaaS Metrics Calculator	Calculate unit economics	Investor reporting, board decks
3	Financial Ratio Calculator	Assess financial health	Credit analysis, performance review
4	Cash Flow Projection	Model liquidity	Treasury, fundraising, planning
5	Variance Analysis	Analyze budget variances	Monthly reporting, performance
6	Scenario Planning	Multi-scenario modeling	Strategic planning, risk analysis
7	Zero-Based Budgeting Guide	Cost optimization	Budgeting, cost transformation
8	P&L Summarizer	Executive reporting	Board presentations, updates
9	Expense Categorization	Classify expenses	Monthly close, cost analysis
10	Break-Even Analysis	Profitability planning	Pricing, cost structure
11	Investor Update Email	Investor communications	Monthly updates, fundraising
12	Pitch Deck Financial Slide	Fundraising materials	Pitch decks, investor meetings
13	Term Sheet Explainer	Decode financing terms	Fundraising, negotiations
14	Chart of Accounts Generator	Design accounting structure	New business, ERP implementation

Common Mistakes (And How to Avoid Them)

Mistake #1: Asking for “Analysis” Without Specifics

What it looks like:

“Analyze our financial situation.”

The fix:

“Calculate our LTV:CAC ratio and Magic Number based on the following data: [specific metrics]. Compare against SaaS benchmarks and identify which metric is our weakest.”

Why it fails: Vague prompts produce vague responses. Finance requires specificity to be useful.

Mistake #2: Forgetting Assumptions

What it looks like:

“What’s our company worth?”

The fix:

“Build a DCF model using our 3-year historical financials, a 5-year projection with 25% annual growth, 75% gross margin, and WACC of 12%. Show all assumptions.”

Why it fails: Valuation without assumptions is meaningless. The assumptions are where the judgment lives.

Mistake #3: Ignoring Context

What it looks like:

“Calculate our burn rate.”

The fix:

“Calculate our net burn rate for the last 6 months using: [monthly cash data]. Account for the $500K financing received in month 2. Show monthly burn trend and runway.”

Why it fails: Raw calculations without context miss important patterns and distort conclusions.

Frequently Asked Questions

Q: How do I ensure AI financial analysis is accurate?

Validate every output against known data points. Use AI for structure and calculation, then verify key figures against your own spreadsheets or ERP system. AI can make arithmetic errors too—treat outputs as drafts requiring review.

Q: Can AI handle complex multi-entity consolidations?

For complex consolidations with eliminations, intercompany transactions, and currency translation, AI is better used for structure and approach. The actual consolidation typically requires ERP systems or specialized tools with audit trails.

Q: What’s the best AI model for financial analysis?

For financial work, reasoning depth matters more than speed. Claude and GPT-4o excel at maintaining coherent arguments across complex calculations. Smaller models may miss nuances in multi-step financial analysis.

Q: How often should I update financial models?

Critical models (forecasts, budgets, valuations) should be updated quarterly at minimum. During significant changes (fundraising, M&A, major contracts), update monthly or even weekly. The value of a model is inversely proportional to its staleness.

Use caution with proprietary financial data. Consider using AI providers with strong data privacy policies, or anonymize data where possible. For highly sensitive information, keep analysis in-house or with trusted advisors.

According to CFA Institute research, 78% of finance professionals now use AI for analysis while maintaining appropriate data governance protocols.

Time to Level Up Your Finance Work

These 14 prompts represent a complete FP&A toolkit. They won’t replace financial expertise—they amplify it. The finance professionals I’ve seen succeed with these tools use AI to handle analytical structure and calculation, freeing their judgment for interpretation, strategy, and communication.

I’ve used these prompts to stress-test valuations, accelerate board prep, and communicate more clearly with investors. The pattern is consistent: structured analysis leads to better decisions.

Start with the prompt that matches your current challenge. If you’re preparing for fundraising, begin with the DCF Model Helper. If you’re doing monthly reporting, the P&L Summarizer will save hours. If you’re managing a SaaS business, the SaaS Metrics Calculator is essential.

My recommendation: pick three prompts to try this week. Apply them to an actual finance challenge. Notice how the structure forces clarity. Then expand your toolkit as needed.

For more finance and business resources, explore our complete prompt engineering guide. For strategic financial planning, our business strategy prompts complement these FP&A tools. For data-driven financial insights, our data analytics prompts provide quantitative methods that pair well with financial modeling. For operations finance, our operations prompts help streamline financial operations and process improvement.

The finance teams that embrace these tools aren’t replacing expertise—they’re multiplying it.

Last Updated: 2026-01-27

Why AI-Powered Financial Planning Works

Core Financial Modeling Prompts

1. DCF (Discounted Cash Flow) Model Helper

2. SaaS Metrics Calculator

3. Financial Ratio Calculator

4. Cash Flow Projection

Budgeting and Analysis Prompts

5. Variance Analysis

6. Scenario Planning

7. Zero-Based Budgeting Guide

Financial Operations Prompts

8. P&L Summarizer

9. Expense Categorization

10. Break-Even Analysis

Fundraising and Investor Relations Prompts

11. Investor Update Email

12. Pitch Deck Financial Slide

13. Term Sheet Explainer

Specialized Analysis Prompts

14. Chart of Accounts Generator

Quick Reference: All Finance Prompts

Common Mistakes (And How to Avoid Them)

Mistake #1: Asking for “Analysis” Without Specifics

Mistake #2: Forgetting Assumptions

Mistake #3: Ignoring Context

Frequently Asked Questions

Q: How do I ensure AI financial analysis is accurate?

Q: Can AI handle complex multi-entity consolidations?

Q: What’s the best AI model for financial analysis?

Q: How often should I update financial models?

Q: Should I share sensitive financial data with AI?

Time to Level Up Your Finance Work

Related Reading