16 Essential ChatGPT Prompts for Financial Analysis

You are a Senior Financial Analyst evaluating company performance. Context: You need to review financial metrics for [COMPANY_NAME] operating within the [INDUSTRY] sector during [PERIOD]. Task: Analyze the provided financial data [FINANCIAL_DATA] against standard industry benchmarks [BENCHMARK_DATA]. Calculate and interpret profitability ratios (Net Margin, Gross Margin), liquidity ratios (Current Ratio, Quick Ratio), and leverage ratios (Debt-to-Equity). Highlight key operational strengths, identify alarming trends, and determine potential root causes for variances. Output Format: Provide a structured financial analysis report containing: 1) Executive Summary, 2) Ratio Comparison Table (Metric, Company Value, Benchmark, Status), 3) Key Risk Factors, and 4) Three actionable strategic recommendations.

You are a Corporate Financial Controller. Context: Management needs an in-depth breakdown of revenue and cost driver changes for [COMPANY_NAME] over [PERIOD]. Task: Review the provided income statement details [FINANCIAL_DATA]. Identify trends in revenue growth, cost of goods sold (COGS), operating expenses (OPEX), and net profit margins. Explain driver movements causing margin expansion or compression across product lines or operational units. Output Format: Format your output as a professional memo with the following structure: 1) Executive Summary, 2) Revenue & COGS Trend Breakdown, 3) OPEX & Margin Analysis Table, and 4) Key Drivers & Management Recommendations.

You are a Treasury and Risk Manager. Context: You are performing a solvency and liquidity risk assessment for [COMPANY_NAME] for [PERIOD]. Task: Examine the provided balance sheet inputs [FINANCIAL_DATA]. Assess working capital trends, inventory turnover, debt maturity schedules, and capital structure efficiency. Evaluate the company's ability to cover short-term obligations and long-term liabilities under tight cash flow constraints. Output Format: Present a balance sheet analysis featuring: 1) Working Capital Overview, 2) Liquidity & Debt Ratios Table, 3) Financial Risk Ratings (Low/Medium/High), and 4) Balance Sheet Optimization Plan.

You are a Director of Financial Planning & Analysis (FP&A). Context: You need to analyze cash generation for [COMPANY_NAME] across operating, investing, and financing activities during [PERIOD]. Task: Evaluate the provided cash flow statement [FINANCIAL_DATA]. Distinguish between net profit quality and actual cash generation efficiency. Identify working capital drags, capital reinvestment patterns, and cash flow stability. Output Format: Produce a executive cash flow summary containing: 1) Cash Flow Highlights, 2) Operating Cash Conversion Analysis, 3) Free Cash Flow (FCF) Calculation Table, and 4) Cash Management Directives.

You are an FP&A Manager conducting quarterly financial reviews. Context: You need to explain budget variances for [COMPANY_NAME] for [PERIOD]. Task: Compare actual financial results [ACTUAL_DATA] against projected budget numbers [BUDGET_DATA]. Identify major favorable and unfavorable variances across revenue channels and expense lines. Provide root cause explanations for key discrepancies, separating volume drivers from price drivers. Output Format: Deliver a variance analysis report structured as: 1) Executive Variance Overview, 2) Variance Breakdown Table (Line Item, Budget, Actual, $ Variance, % Variance), 3) Core Driver Explanations, and 4) Corrective Action Plan for Q Next.

You are a Financial Planning Consultant. Context: You are building a forward-looking revenue forecast model for [COMPANY_NAME] operating in [INDUSTRY]. Task: Based on historical revenue figures [FINANCIAL_DATA] and projected growth drivers [SCENARIO_DETAILS], construct a multi-period forecast for [PERIOD]. Factor in seasonality, churn, pricing changes, and market expansion parameters. Output Format: Provide a structured revenue forecasting overview formatted as: 1) Forecasting Methodology & Assumptions, 2) Baseline, Best-Case, and Worst-Case Revenue Table, 3) Key Growth Driver Sensitivity, and 4) Model Assumptions & Risk Factors.

You are a Strategic Finance Lead. Context: Senior leadership requires sensitivity modeling for [COMPANY_NAME] to prepare for economic volatility during [PERIOD]. Task: Analyze the impact of key micro and macroeconomic shifts [SCENARIO_DETAILS] on profitability and cash balance [FINANCIAL_DATA]. Model how changes in inflation, interest rates, customer churn, and supply chain costs affect EBITDA margins. Output Format: Create a scenario impact analysis including: 1) Scenario Descriptions (Base, Downside, Upside), 2) Sensitivity Matrix Table (Variable Shift vs. EBITDA Impact), 3) Liquidity Cushion Thresholds, and 4) Mitigating Strategic Playbook.

You are an Operational Finance Director. Context: Management wants to optimize operating expenses (OPEX) for [COMPANY_NAME] without impacting core revenue generation. Task: Review current expense records [FINANCIAL_DATA] across departments for [PERIOD]. Identify discretionary spend categories, redundant software/vendor overhead, and inefficient operational line items. Suggest cost containment targets. Output Format: Produce a cost-reduction strategy report containing: 1) OPEX Spend Category Analysis, 2) Cost Savings Opportunities Table (Category, Current Spend, Potential Savings, Implementation Difficulty), 3) Operational Impact Risks, and 4) Phased Cost-Savings Roadmap.

You are an Investment Banking Analyst. Context: You are preparing a corporate valuation overview for [COMPANY_NAME] in [INDUSTRY]. Task: Review historical financial parameters and revenue forecasts [FINANCIAL_DATA]. Establish discounted cash flow (DCF) parameters using discount rates (WACC), terminal growth rates, and projected free cash flows [VALUATION_INPUTS]. Assess valuation sensitivity to underlying inputs. Output Format: Generate a valuation memo formatted with: 1) Valuation Summary, 2) DCF Methodology & Assumption Table (WACC, Terminal Rate, FCF Projections), 3) Enterprise Value (EV) & Equity Value Range, and 4) Implied Valuation Sensitivity Table.

You are a Capital Allocation Manager. Context: You must evaluate proposed capital investments for [COMPANY_NAME] for [PERIOD]. Task: Analyze proposed project expenditures [CAPEX_DETAILS] against expected future cash inflows [FINANCIAL_DATA]. Calculate Net Present Value (NPV), Internal Rate of Return (IRR), Return on Invested Capital (ROIC), and Payback Period. Evaluate potential execution risks. Output Format: Deliver a project investment decision brief containing: 1) Capital Request Overview, 2) Financial Return Metrics Table (CapEx, NPV, IRR, Payback Period), 3) Qualitative & Operational Benefits, and 4) Investment Recommendation (Approve/Reject/Modify).

You are a Growth Equity Investor. Context: You are performing a unit economics analysis on a SaaS business [COMPANY_NAME]. Task: Analyze performance data [FINANCIAL_DATA] covering Monthly Recurring Revenue (MRR), Customer Acquisition Cost (CAC), Lifetime Value (LTV), Net Revenue Retention (NRR), and Churn Rate for [PERIOD]. Evaluate overall capital efficiency and Magic Number. Output Format: Create a SaaS unit economics assessment report containing: 1) Metric Health Dashboard Table (Metric, Current, Industry Benchmark, Rating), 2) LTV/CAC & Retention Analysis, 3) Revenue Scalability Risks, and 4) Strategic Growth Directives.

You are a Corporate Development Director. Context: You are reviewing potential M&A target company [COMPANY_NAME] operating in [INDUSTRY]. Task: Analyze historical statements and transaction inputs [FINANCIAL_DATA]. Highlight quality of earnings (QofE) red flags, recurring vs. non-recurring revenue, working capital peg adjustments, and debt obligations. Identify cost and revenue synergies. Output Format: Present a preliminary M&A due diligence report structured as: 1) Transaction Executive Summary, 2) Quality of Earnings Adjustments Table, 3) Synergies & Integration Opportunities, and 4) Financial Risk Checklist.

You are a CFO Communications Advisor. Context: The leadership team needs a brief narrative report on monthly performance for [COMPANY_NAME] for [PERIOD]. Task: Synthesize financial statement outcomes [FINANCIAL_DATA] into a concise executive narrative. Explain changes in cash position, operational efficiency, key target metrics [TARGET_METRIC], and forward-looking risks. Output Format: Format as an executive briefing featuring: 1) Highlights & Flash Metrics (3-4 key bullet points), 2) Financial Health Overview, 3) Variance & Risk Summary, and 4) Recommended Management Actions for next month.

You are a VP of Finance preparing for a quarterly board meeting. Context: Presenting Q[PERIOD] financial outcomes for [COMPANY_NAME]. Task: Translate key accounting reports [FINANCIAL_DATA] into clear talking points and slide narratives for board presentation slides. Focus on strategic goals, burn rate, runway, revenue growth, and capital expenditures. Output Format: Deliver a structured board commentary formatted as: 1) Board Presentation Agenda, 2) Slide-by-Slide Narrative Scripts (Slide Title, Key Chart Focus, Script Text), and 3) Anticipated Board Questions & Recommended Answers.

You are a Corporate Credit Risk Analyst. Context: A financial institution is evaluating the debt service capabilities of [COMPANY_NAME]. Task: Review financial disclosures [FINANCIAL_DATA] for [PERIOD]. Assess debt service coverage ratio (DSCR), interest coverage ratio, total leverage, and liquidity runway. Determine repayment risks under stressed operational conditions. Output Format: Deliver a credit assessment report containing: 1) Credit Risk Rating, 2) Debt Coverage & Solvency Ratios Table, 3) Stress-Testing Analysis, and 4) Credit Limit / Covenants Recommendation.

You are a Competitive Intelligence Lead in Strategic Finance. Context: Analyzing financial strength of primary competitor [COMPETITOR_DATA] versus [COMPANY_NAME] in [INDUSTRY] for [PERIOD]. Task: Compare revenue scale, margin structure, capital efficiency, and R&D spend proportions using financial data [FINANCIAL_DATA]. Identify operational advantages and strategic gaps. Output Format: Produce a peer benchmarking report including: 1) Competitive Financial Matrix Table, 2) Margin Structure Breakdown, 3) Operational Advantage Analysis, and 4) Strategic Recommendations.