50 AI Prompts for Financial Analysts (ChatGPT + Claude)

Published: June 2026 | 8 min read

Financial analysts spend hours on budgeting, forecasting, variance analysis, and reporting. AI can cut that time dramatically — but only if you use the right prompts. Generic "write a financial report" prompts produce generic output. You need prompts with professional structure, domain context, and clear deliverables.

Below are 50 production-ready AI prompts for financial analysts, organized by use case. These are adapted from Skillent's Finance AI Prompt Library, which includes 190,000+ prompts across 8 industries.

Budgeting & Forecasting

1. Annual Budget Build

Role: You are a senior financial analyst at a mid-size company.
Task: Build a draft annual budget from the following data:
- Prior year actuals by month
- Known headcount changes
- Revenue growth target: 12% YoY
- New product launch in Q3

Deliverable: Monthly budget table with revenue, COGS, OpEx, and EBITDA.
Format: Markdown table with YoY variance column.
Failure modes to avoid: Don't annualize partial-year data without seasonality adjustment.

2. Cash Flow Forecast (13-Week)

Role: FP&A analyst
Task: Create a 13-week cash flow forecast
Inputs: AR aging, AP schedule, payroll calendar, debt service schedule
Rules: Conservative collections assumption (70% of AR in 30 days)
Deliverable: Weekly cash position with minimum balance highlighted
Flag: Alert if projected balance drops below $500K

3. Scenario Modeling

Role: Strategic finance analyst
Task: Build base/bull/bear scenarios for Q3 revenue
Base: 12% growth | Bull: 20% | Bear: -5%
For each scenario, model: revenue, gross margin, OpEx, EBITDA
Include sensitivity table showing EBITDA impact at ±2% margin variance
Format: Three-column comparison table

4. Zero-Based Budget Review

Role: Finance manager reviewing department budgets
Task: Challenge each line item in a department's budget
For each expense category, ask:
1. Is this essential for operations?
2. Can this be done cheaper (vendor, process, automation)?
3. What's the ROI of this spend?
Deliverable: Categorized list (Keep/Optimize/Cut) with rationale and estimated savings

5. Revenue Recognition Forecast

Role: Revenue accountant
Task: Forecast monthly recognized revenue for a SaaS company
Inputs: Contract bookings, contract terms (annual/monthly), start dates
Rules: ASC 606 — recognize ratably over contract term
Deliverable: Monthly revenue recognition schedule with deferred revenue waterfall

Variance Analysis

6. Monthly Variance Analysis

Role: FP&A analyst
Task: Perform variance analysis: budget vs actual for [month]
For each line item with variance >5%:
1. Calculate $ and % variance
2. Identify likely cause (volume, rate, timing, error)
3. Classify as favorable/unfavorable
4. Recommend corrective action
Deliverable: Variance table + executive summary (3 bullet points)

7. Gross Margin Deep Dive

Role: Cost analyst
Task: Analyze gross margin change from 42% to 38%
Inputs: Revenue by product line, COGS breakdown
Questions to answer:
1. Is this a mix shift, price erosion, or cost inflation?
2. Which product lines drove the change?
3. What actions restore margin?
Format: Bridge chart description (waterfall) from 42% to 38%

8. Headcount Budget vs Actual

Role: HR Finance partner
Task: Compare budgeted vs actual headcount by department
For each variance:
- Identify if it's a hiring delay, over-hire, or role change
- Calculate quarterly cost impact
- Flag departments >2 positions over/under budget
Format: Department-level table with cost impact column

Financial Reporting

9. Monthly Board Report

Role: CFO preparing board report
Task: Summarize financial performance for [month]
Sections: Revenue, Gross Margin, OpEx, EBITDA, Cash, Key Metrics
For each section: actual vs budget vs prior year + 1-2 sentence commentary
Tone: Concise, factual, no jargon
Format: Executive summary (5 bullets) + detailed table
Length: 1 page maximum

10. KPI Dashboard Narrative

Role: Financial analyst
Task: Write narrative for monthly KPI dashboard
KPIs: MRR, CAC, LTV, Churn, Gross Margin, Burn Rate
For each KPI: current value, trend (↑↓→), vs target, brief commentary
Highlight: 2 KPIs that need attention
Format: One-paragraph per KPI with emoji trend indicators

11. Quarterly Earnings Summary

Role: Equity research analyst
Task: Summarize quarterly results for [Company]
Include: Revenue, EPS, guidance, segment breakdown, margin trends
Compare to: consensus estimates and prior quarter
Tone: Neutral, data-driven
Format: 1-page brief suitable for investment committee

FP&A and Strategic Finance

12. Build vs Buy Analysis

Role: Strategic finance analyst
Task: Compare building in-house vs buying SaaS solution
Factors: 3-year TCO, implementation time, ongoing maintenance, team capacity
Build: $180K development + $40K/yr maintenance
Buy: $60K/yr subscription + $20K implementation
Deliverable: TCO comparison table + recommendation with 3 key reasons

13. Pricing Model Analysis

Role: Pricing strategist
Task: Analyze pricing model options for [product]
Options: Flat $99/mo, Tiered ($49/$99/$199), Usage-based ($0.10/unit)
For each: Project 12-month revenue at 100/500/1000 customers
Consider: Churn risk, expansion revenue, competitive positioning
Format: Revenue projection table + recommendation

14. M&A Target Screening

Role: Corporate development analyst
Task: Screen 5 acquisition targets
Criteria: Revenue >$10M, EBITDA margin >15%, strategic fit (1-5 scale)
For each target: Revenue, EBITDA, margin, growth rate, fit score
Risk flags: Customer concentration, key person dependency, pending litigation
Format: Scorecard table with go/no-go recommendation

15. Cap Table Impact Analysis

Role: Startup CFO
Task: Model cap table impact of Series B raise
Inputs: Pre-money $20M, raise $5M, 20% option pool refresh
Show: Post-money valuation, founder ownership, investor ownership, option pool
Format: Before/after cap table comparison

Modeling & Excel/Sheets

16. Excel Formula Generator

Role: Excel expert
Task: Write the Excel formula for: [describe what you need]
Requirements: 
- Compatible with Excel 365
- No array formulas if avoidable
- Include error handling (IFERROR)
- Explain each component
Format: Formula + explanation of each part

17. DCF Model Structure

Role: Investment banking analyst
Task: Outline a DCF model structure for [Company]
Periods: 5-year explicit forecast + terminal value
Assumptions: Revenue growth, margin trajectory, capex, WACC
Deliverable: Model structure (tabs, line items, formulas) not a completed model
Include: Sensitivity table for WACC and terminal growth rate

18. Revenue Model — SaaS

Role: SaaS CFO
Task: Build a MRR/ARR revenue model
Inputs: New customers/mo, expansion %, churn %, ARPU
Calculate: Net revenue retention, ARR at month 12/24/36
Show: Growth rate, churn impact, expansion contribution
Format: Monthly projection table with key metrics

Cost Analysis

19. Cost Allocation Model

Role: Cost accountant
Task: Design cost allocation methodology
Inputs: Shared costs (rent, IT, admin), department headcounts
Methods to compare: Headcount-based, revenue-based, activity-based
Recommend: Best method with rationale
Format: Methodology comparison + recommendation

20. Vendor Cost Benchmarking

Role: Procurement finance analyst
Task: Benchmark current vendor pricing against market rates
Vendor: [name], Service: [description], Current cost: $X/mo
Research: Market range for comparable services
Deliverable: Cost comparison table + negotiate/keep/switch recommendation

21. Break-Even Analysis

Role: Financial analyst
Task: Calculate break-even point for [product]
Inputs: Fixed costs, variable cost per unit, selling price
Calculate: Break-even units, break-even revenue, margin of safety
Include: Sensitivity to ±10% price and cost changes
Format: Break-even chart description + table

Audit & Compliance

22. SOX Control Testing Plan

Role: Internal audit
Task: Design SOX control testing plan for revenue cycle
Controls: Order-to-cash key controls (5-7)
For each: Control description, test procedure, sample size, frequency
Format: Control matrix table

23. Expense Report Audit

Role: Audit analyst
Task: Review expense reports for policy compliance
Flag: Amounts >$500 without receipt, weekend submissions, duplicate vendors
Risk indicators: Round-dollar amounts, same-day approvals, vendor = employee
Format: Risk-scored expense list

24. Reconciliation Procedure

Role: Staff accountant
Task: Write a step-by-step account reconciliation procedure
Account: [bank/AR/AP/inventory]
Steps: 1) Get TB balance 2) Get subsystem balance 3) Compare 4) Investigate variances 5) Document
Include: Common reconciliation issues and resolution steps
Format: Numbered procedure with timing estimates

Working Capital & Treasury

25. Working Capital Analysis

Role: Treasury analyst
Task: Analyze working capital efficiency
Calculate: DSO, DPO, DIO, Cash Conversion Cycle
Compare: Industry benchmarks (if available) and prior 3 quarters
Identify: Top 3 opportunities to improve CCC
Format: Trend table + improvement recommendations

26. Bank Fee Analysis

Role: Treasury operations
Task: Analyze bank fee statements
Input: Monthly bank fee breakdown by category
Identify: Highest cost categories, month-over-month increases
Benchmark: Against typical corporate banking fee ranges
Deliverable: Fee summary + negotiation targets

27. FX Exposure Assessment

Role: FX risk manager
Task: Assess foreign exchange exposure
Identify: Revenue/cost currencies, net exposure by currency
Recommend: Hedging strategy (natural hedge, forward contracts, options)
Format: Exposure matrix + hedging recommendation

Data & Analytics

28. Financial Data Quality Check

Role: Data governance analyst
Task: Design financial data quality checks
Checks: Completeness (no nulls), accuracy (range validation), timeliness (freshness), consistency (cross-system)
For each check: Definition, threshold, frequency, owner
Format: Data quality scorecard template

29. Anomaly Detection Rules

Role: Financial systems analyst
Task: Define anomaly detection rules for journal entries
Rules: Journal entries >$50K, posted on weekends, created by non-standard users, round amounts >$100K
For each rule: Rationale, risk level, review action
Format: Rule matrix with priority ranking

30. Revenue Cohort Analysis

Role: Growth analyst
Task: Build revenue cohort analysis
Cohorts: Customer acquisition month
Metrics: MRR, retention, expansion, net revenue retention
Format: Cohort grid (rows = month, columns = months since acquisition)
Highlight: Cohorts that outperform/underperform

Additional Prompts (31-50)

Operational Finance

• 31. Capex justification memo — "Write a capex approval memo for [equipment], including ROI, payback period, and alternatives considered"
• 32. Credit memo — "Draft a credit memo for customer [name], including credit score, payment history, recommended terms, and risk rating"
• 33. Intercompany transfer pricing — "Outline transfer pricing methodology for intercompany transactions between US and UK entities"
• 34. Lease vs buy analysis — "Compare leasing vs buying [equipment] over 5 years, including tax impact and balance sheet effects"
• 35. Working capital line sizing — "Calculate optimal revolver/line of credit size based on seasonal working capital needs"

Investor Relations

• 36. Investor update email — "Write a monthly investor update: milestones, metrics, challenges, asks. Keep to 200 words."
• 37. Investor Q&A prep — "Generate 15 likely investor questions about our Q3 results, with suggested talking points for each"
• 38. Competitor benchmarking — "Compare our key metrics to [competitor]'s public filings: revenue, growth, margins, burn rate"
• 39. Fundraising deck financials — "Structure the financial slides for a Series A deck: historical, projections, unit economics, use of funds"
• 40. Valuation comparable analysis — "Build a trading comparable analysis for [company], including EV/Revenue, EV/EBITDA, P/E multiples"

Risk & Controls

• 41. Risk register — "Create a risk register for a finance department: financial, operational, compliance, technology risks"
• 42. Segregation of duties matrix — "Design SoD matrix for order-to-cash and procure-to-pay processes"
• 43. Fraud risk assessment — "Assess fraud risk in expense reimbursement process, including red flags and controls"
• 44. Policy drafting — "Draft a T&E expense policy: thresholds, approval matrix, documentation requirements, exceptions"
• 45. Cybersecurity finance impact — "Estimate financial impact of a ransomware incident: revenue loss, remediation cost, reputational impact"

Special Projects

• 46. Integration plan — "Create a post-merger finance integration plan: systems, processes, headcount, timeline"
• 47. Shared services business case — "Build a business case for moving AP to a shared services center, including 3-year savings"
• 48. Automation ROI — "Calculate ROI of automating [manual process]: hours saved, error reduction, implementation cost"
• 49. Carve-out financial statements — "Outline approach for carving out [business unit] financial statements from parent company"
• 50. Wind-down cost analysis — "Estimate costs to wind down [product line]: severance, contract termination, asset write-offs, lease exit"

How to Use These Prompts

1. Copy and paste into ChatGPT, Claude, or Gemini

2. Replace bracketed text (e.g., [Company], [month]) with your specifics

3. Review the output — AI is a starting point, not a final answer

4. Refine iteratively — if the output isn't right, add more context and ask again

Pro tip: The prompts above include role definition, task specification, format requirements, and failure mode warnings. This structure produces dramatically better output than generic prompts. It's the difference between "write a budget" and "you are a senior financial analyst, build a draft annual budget with monthly breakdown, YoY variance, and seasonality adjustment."

Frequently Asked Questions

Do these work with Claude? Yes. All prompts are model-agnostic and work with ChatGPT (GPT-4o), Claude (Sonnet/Opus), Gemini, and any LLM.

Can I use these for commercial work? Yes. These prompts are designed for professional use in corporate finance, FP&A, and accounting.

What makes Skillent different from free prompt lists? Every Skillent prompt includes a professional role lens, domain priorities, evidence grounding, execution rules, failure modes, and deliverable specifications. Generic prompts produce generic output. Professional prompts produce professional output.