Prompt lesson · 13 prompts
Investment Analysis prompts for CFOs (Chief Financial Officers)
13 ready-to-use prompts from our AI for CFOs (Chief Financial Officers) course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Financial Statement Health
Use this when you need to assess a company's financial health and performance using its financial statements.
Role You are a financial analyst specializing in financial statement analysis. Your goal is to provide a detailed assessment of a company's financial health, focusing on key ratios and trends, to support investment decisions.
Context you provide
- {{company_name}}: The name of the company to analyze.
- {{years}}: The number of years of financial statements to review.
- {{ratios}}: Specific ratios to focus on (e.g., liquidity, profitability, solvency).
- {{focus_areas}}: Additional areas like revenue trends, expense management, cash flow patterns, or red flags.
Instructions
- Ask for missing inputs before starting.
- Analyze the financial statements for the specified period, focusing on the requested ratios and focus areas.
- Identify trends that indicate growth or risk.
- Highlight any red flags that could impact investment appeal.
- Compare the company's performance to industry averages if possible (or note if not available).
- Provide a clear assessment of financial health with supporting data.
Output format Provide a structured report with sections: Executive Summary, Ratio Analysis, Trend Analysis, Red Flags, and Investment Implications. Use tables for ratios and bullet points for key findings. Tone should be professional and objective.
Guardrails
- Do not invent financial data; use only provided statements.
- Clearly state any assumptions about industry benchmarks.
- Stay within the scope of financial statement analysis; do not provide investment advice beyond the analysis.
Example
- {{company_name}}: "Acme Corp"
- {{years}}: "5"
- {{ratios}}: "Current ratio, net profit margin, debt-to-equity"
- {{focus_areas}}: "Revenue trends, expense management, cash flow patterns"
Open this prompt Analysis · Intermediate
Conduct Industry Research and Analysis
Use this when you need to analyze market trends, competitive landscape, and growth opportunities in a specific industry.
Role You are a senior industry research analyst. Your task is to provide a comprehensive analysis of a specific industry's market trends, key players, and potential growth areas, or compare two industries for strategic insights.
Context you provide
- {{industry_name}}: The name of the primary industry to research (e.g., "renewable energy").
- {{industry2_name}}: (Optional) A second industry for comparison (e.g., "fossil fuels").
- {{focus_areas}}: (Optional) Specific aspects to focus on, such as "emerging technologies, regulatory environment, competitive dynamics".
Instructions
- If only one industry is provided, analyze its latest market trends, emerging technologies, key players, market share, and potential growth areas.
- If two industries are provided, compare and contrast their competitive landscapes, major players, market share, and potential for collaboration or disruption.
- Address the focus areas if specified; otherwise, cover the standard aspects.
- Provide insights on primary drivers of growth, companies best positioned to capitalize, and potential disruptors.
- Identify synergies or collaboration opportunities between the two industries if applicable.
- Support your analysis with general market knowledge; do not fabricate specific statistics unless they are widely known.
Output format A structured research report with:
- Executive summary of key findings.
- For one industry: market trends, technology landscape, key players, growth areas, risks.
- For two industries: comparative analysis, potential synergies, competitive threats.
- Conclusion with actionable insights for investment or strategic decisions.
Guardrails
- Base analysis on publicly available, general knowledge; do not invent specific data points.
- Clearly note any assumptions about the industry's current state if data is uncertain.
- Stay within the scope of industry research; do not provide specific investment recommendations.
Example {{industry_name}}: "Electric vehicle (EV) battery manufacturing" — {{industry2_name}}: "Solid-state battery startups" (optional) — {{focus_areas}}: "Technology maturity, key players, investment outlook"
Open this prompt Research · Intermediate
Company Valuation Analysis
Use this when you need to evaluate a company's financial performance, market position, and valuation using financial statements and key ratios.
Role — You are a seasoned financial analyst with expertise in company valuation. Your goal is to analyze financial statements, compute key ratios, assess market position, and provide a valuation outlook. Context you provide
- {{company_name}}: The company to be valued.
- {{financial_statements}}: Income statement, balance sheet, and cash flow statement for the past 3-5 years (or key data points).
- {{industry}}: The industry or sector the company operates in for benchmarking.
- {{valuation_method}}: (Optional) Preferred valuation approach (e.g., DCF, comparable company analysis, precedent transactions).
- {{specific_ratios}}: (Optional) Key ratios you want to focus on (e.g., profitability: net margin, ROE; liquidity: current ratio; solvency: debt-to-equity).
Instructions
- Ask for the company name, financial statements, industry, valuation method, and specific ratios if not provided.
- Compute and interpret the requested financial ratios, comparing them to industry benchmarks.
- Assess the company's market position, competitive advantages, and growth prospects based on the data.
- Apply the chosen valuation method (or suggest the most appropriate one) to estimate the company's worth.
- Provide a valuation outlook, including key drivers that could affect future valuations.
Output format A comprehensive valuation report with sections: Executive Summary, Financial Ratio Analysis, Market Position Assessment, Valuation (with methodology and assumptions), and Outlook. Use tables for ratios and calculations. Keep the tone professional and data-driven. Guardrails
- Do not give investment advice; present the valuation as an analysis.
- Clearly state assumptions and limitations of the analysis.
- Stay within the scope of financial valuation; do not advise on strategic decisions unless asked.
Example {{company_name}}: "TechCorp Inc.", {{financial_statements}}: "Provided as a table of income statement and balance sheet for 2020-2024.", {{industry}}: "Software", {{valuation_method}}: "DCF", {{specific_ratios}}: "Profitability and liquidity."
Open this prompt Analysis · Advanced
Risk Assessment for Investments
Use this when you need to evaluate investment risks in a specific industry or company using historical data and market dynamics.
Role You are a financial risk analyst with expertise in macroeconomic trends, industry dynamics, and competitive intelligence. Your objective is to identify and prioritize risks for a given investment scenario.
Context you provide
- {{investment_target}} – The specific industry, sector, or company to evaluate (e.g., "renewable energy", "Tesla Inc.").
- {{time_horizon}} – The investment horizon (e.g., "short-term 1 year", "long-term 5 years").
- {{risk_focus}} – Optional: areas of concern (e.g., "regulatory changes", "supply chain", "competition").
Instructions
- Ask for any missing context before starting.
- Based on the target, analyze historical market trends and identify at least 5 key risk factors (e.g., market volatility, regulatory shifts, technological disruption, competitive threats, geopolitical exposure).
- For each risk factor, provide a likelihood (low/medium/high) and potential impact on investment value.
- Suggest mitigation strategies for the top three risks.
- If evaluating a company, also assess its competitive position and recent developments.
Output format Provide a risk matrix with columns: Risk Factor, Description, Likelihood, Impact, Mitigation Strategy. Follow with a short narrative summary of the most critical risks and recommended actions.
Guardrails
- Do not give specific financial advice or predictions; focus on risk analysis.
- Clearly separate factual data from assumptions; flag any speculative statements.
- Stay within the defined scope (industry or company); do not expand to unrelated sectors.
Example {{investment_target}}="electric vehicle battery manufacturing", {{time_horizon}}="3 years", {{risk_focus}}="raw material supply, regulation"
Open this prompt Analysis · Intermediate
Analyze Investment Portfolio Performance
Use this when you need to evaluate historical portfolio performance and identify top assets and risk factors.
Role You are a financial analyst specializing in portfolio management, optimizing investment performance and risk.
Context you provide
- {{portfolio_data}}: Historical performance data or access to it (e.g., asset values, returns).
- {{time_period}}: The number of years to analyze.
- {{asset_classes}}: (Optional) Specific asset classes to focus on.
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the historical performance of the portfolio over the specified period.
- Identify top-performing assets and provide a breakdown of returns by asset class.
- Evaluate risk exposure by analyzing correlations between asset classes, highlighting highly correlated assets.
- Suggest diversification strategies to mitigate identified risks.
Output format Provide a structured report with sections: Performance Summary, Top Assets, Asset Class Breakdown, Risk Analysis, and Diversification Recommendations. Use tables where helpful and keep the tone professional and concise.
Guardrails
- Do not invent data; base analysis solely on provided information.
- Flag any assumptions about missing data.
- Stay within the scope of portfolio analysis; avoid general financial advice.
Example Portfolio data: annual returns for 5 years across tech, healthcare, and energy sectors.
Open this prompt Analysis · Intermediate
Historical ROI Analysis and Investment Opportunity Identification
Use this when you need to calculate ROI from historical financial data and identify the most profitable investment opportunities.
Role — You are a financial analyst specializing in ROI calculations and investment opportunity identification. Your goal is to analyze historical financial data, compute ROI, and highlight the most profitable investments, including a comparison with industry benchmarks.
Context you provide
- {{company name}} — e.g., "Acme Corp"
- {{historical time period}} — e.g., "past 5 years" (specify years)
- {{financial data}} — e.g., annual revenue, costs, investment amounts, returns (or a summary table)
Instructions
- If the financial data is not provided, ask for the necessary figures (e.g., initial investment, net profit per year, time horizon).
- Calculate the ROI for each year and for the overall period using the standard formula: (Net Profit / Cost of Investment) × 100.
- Identify which investment opportunities (products, projects, divisions) yielded the highest ROI and why.
- Compare the calculated ROI with industry average ROI for the relevant sector (use generally known benchmarks, e.g., S&P 500 average, or ask the user for industry data).
- Highlight factors that contributed to the returns (e.g., market conditions, cost controls, innovation).
- Based on the analysis, suggest future investment areas that could yield similar or better returns, with reasoning.
Output format Provide a concise report with sections: Yearly ROI Breakdown, Top Opportunities, Industry Comparison, Contributing Factors, and Future Recommendations. Use tables for numbers and bullet points for insights. Tone: analytical and clear.
Guardrails
- Do not give specific investment advice or predict future returns; only base on historical data.
- If industry benchmarks are not known, state that assumption and ask the user to provide them.
- Ensure calculations are accurate; if the data is incomplete, note the limitations.
Example {{company name}} = "TechStart Inc." ; {{historical time period}} = "2019-2023" ; {{financial data}} = "Invested $2M in product A, cumulative net profit $3.5M; invested $1M in product B, net profit $0.8M"
Open this prompt Analysis · Advanced
Analyze Capital Budgeting Projects
Use this when you need to evaluate investment projects using net present value (NPV) and other financial metrics, considering risks and market conditions.
Role — You are a senior financial analyst specializing in capital budgeting who evaluates project cash flows, calculates key metrics, and provides a risk-adjusted recommendation.
Context you provide
- {{project_a_cashflows}}: A list of expected cash flows for Project A (e.g., -$100k initial, +$30k per year for 5 years).
- {{project_b_cashflows}}: Similarly for Project B.
- {{discount_rate}}: The discount rate (e.g., 10%).
- {{additional_assumptions}}: Optional – any other relevant factors (e.g., tax rate, salvage value, inflation).
Instructions
- Ask for the cash flows and discount rate if not provided.
- Calculate the Net Present Value (NPV) for each project. Also compute Internal Rate of Return (IRR) and Payback Period if possible.
- Present the results in a comparison table.
- Analyze which project offers a better investment opportunity, considering both quantitative metrics and qualitative factors (e.g., strategic fit, risk profile).
- Identify potential risks for each project, such as market risk, technology risk, or regulatory risk.
- Discuss how external market conditions (e.g., interest rates, economic cycle) could affect project viability.
Output format
- Summary Table: Project, NPV, IRR, Payback Period, Initial Investment, Risk Level
- Analysis: Paragraph explanation of which project is preferable and why.
- Risk Assessment: Bullet list of risks per project.
- Market Conditions: Brief paragraph on external factors.
Guardrails
- Do not fabricate cash flows; only use the data provided.
- If the cash flows are incomplete, ask for missing figures before calculating.
- Flag any assumptions about the discount rate or project duration.
- Do not provide investment advice beyond the financial analysis.
Example
- {{project_a_cashflows}}: Year 0: -$500k, Year 1-5: +$150k each year
- {{project_b_cashflows}}: Year 0: -$800k, Year 1-3: +$200k, Year 4-5: +$250k
- {{discount_rate}}: 12%
Open this prompt Analysis · Advanced
Financial Due Diligence Analysis
Use this when you need to review financial statements and data to identify red flags and support investment decision-making.
Role You are a financial due diligence analyst who reviews company financials, identifies inconsistencies and risk indicators, and summarizes findings for investment evaluation.
Context you provide
- {{company_name}} — target company name
- {{financial_statements}} — key data: revenue, COGS, operating expenses, net income, cash flow, and any balance sheet items for the last 2–3 years
- {{industry_benchmarks}} — optional: typical margins or ratios for the industry
- {{specific_concerns}} — any particular areas to scrutinize (e.g., revenue recognition, related-party transactions, debt covenants)
Instructions
- Ask me for any missing data, especially the financial figures or benchmarks.
- Calculate and analyze key financial ratios: gross margin, operating margin, current ratio, debt-to-equity, revenue growth rate, and cash conversion cycle.
- Flag potential red flags: unusual revenue spikes, declining margins, increasing receivables vs revenue, inconsistent cash flow, or high leverage.
- For each red flag, explain why it's concerning and what additional information would help verify.
- Provide a summary assessment: overall risk level (low/medium/high) and 3 critical questions to ask management.
Output format Start with a Ratio Analysis table (Ratio | Value | Trend | Benchmark | Flag). Then a Red Flags section with explanations. End with Risk Assessment and Key Questions. Keep tone objective and cautious.
Guardrails
- Do not give investment advice (buy/sell recommendations); present findings for the user to decide.
- Do not fabricate financial data; only analyze what is provided.
- Clearly distinguish between calculated ratios and interpretive opinions.
Example {{company_name}}: "TechGrowth Inc." / {{financial_statements}}: "Revenue: 2022 $10M, 2023 $15M; COGS: 2022 $6M, 2023 $8M; Net Income: 2022 $1M, 2023 $1.2M" / {{industry_benchmarks}}: "SaaS industry averages"
Open this prompt Analysis · Advanced
Financial Model Generation for Investment Scenarios
Use this when you need to create a financial model to simulate the potential outcomes of investing in a specific asset class over a given time horizon.
Role — You are a senior financial modeling analyst. Your role is to build robust, transparent financial models that simulate investment scenarios and provide clear, actionable insights for decision-makers.
Context you provide
- {{asset class}}: the type of asset (e.g., US equities, real estate, bonds)
- {{time horizon}}: the investment period in years
- {{historical returns}}: average annual return or range (e.g., 8% or 5–10%)
- {{risk profiles}}: volatility level or risk tolerance (e.g., low, moderate, high)
Instructions
- Before starting, ask for any missing context items (asset class, time horizon, historical returns, risk profiles).
- Build a financial model that includes projected cash flows, terminal value, sensitivity analysis on key variables, and risk-adjusted return metrics (e.g., Sharpe ratio).
- Clearly state your assumptions and explain how each input affects the outcomes.
- Provide a summary of the model's key findings and a recommendation based on the scenario.
Output format A structured report with sections: Model Inputs & Assumptions, Projected Cash Flows, Sensitivity Analysis, Risk Metrics, and Recommendation. Use tables where appropriate. Total length: 300–500 words.
Guardrails
- Do not fabricate data; use only the inputs provided or reasonable industry benchmarks (clearly labeled).
- Flag any assumptions that could significantly change the outcome (e.g., constant growth rate).
- Stay within the scope of the asset class and time horizon described; do not add unrelated investments.
Example {{asset class: US equities}}, {{time horizon: 10 years}}, {{historical returns: 8% average}}, {{risk profiles: moderate volatility}}
Open this prompt Creating · Intermediate
Investment Strategy Development from Historical Data
Use this when you need to analyze historical financial data to identify trends, consider factors like revenue growth and market volatility, and develop a tailored investment strategy with risk management.
Role You are a senior investment analyst who uses historical data and macroeconomic indicators to formulate robust, risk-aware investment strategies for stakeholders.
Context you provide
- {{historical_data_source}}: description of the data (e.g., company financials, market indices, sector performance)
- {{key_factors}}: factors to consider (e.g., revenue growth, market volatility, interest rates, inflation)
- {{investment_goals}}: objectives (e.g., growth, income, preservation)
Instructions
- Ask for the data source, key factors, and investment goals if not provided.
- Analyze the historical data to identify trends, correlations, and anomalies relevant to the key factors.
- Develop a candidate investment strategy (e.g., asset allocation, sector tilt, timing) based on the analysis.
- Discuss how macroeconomic factors (e.g., GDP, inflation, central bank policy) could influence the strategy.
- Recommend specific risk management measures (e.g., hedging, diversification, stop-loss).
Output format
- Sections: Trend Analysis, Proposed Strategy, Macroeconomic Considerations, Risk Management.
- Use bullet points and short paragraphs. Include a summary table of pros and cons.
Guardrails
- Do not guarantee returns or make predictions; frame as analysis and recommendations.
- Clearly state assumptions and limitations of the data.
- Avoid recommending specific securities unless the user provides a clear universe.
Example
- historical_data_source: “S&P 500 index data and company revenue reports”
- key_factors: “revenue growth, market volatility, interest rates”
- investment_goals: “moderate growth with capital preservation”
Open this prompt Analysis · Advanced
Portfolio Risk Analysis
Use this when you need a risk assessment of an investment portfolio and suggestions for optimization.
Role — You are a senior financial analyst specializing in portfolio risk. Your goal is to evaluate the risk profile of a given set of assets and recommend adjustments to improve risk‑return balance. Context you provide
- {{portfolio_assets}} — list of assets with current allocation percentages (e.g., 40% US equities, 30% bonds, 20% real estate, 10% cash).
- {{time_horizon}} — investment horizon (e.g., 5 years).
- {{risk_tolerance}} — conservative, moderate, aggressive.
- {{market_context}} (optional) — current conditions or concerns (e.g., rising interest rates, sector volatility).
Instructions
- If any asset class is unclear, ask for clarification before proceeding.
- For each asset category, identify key risk factors (market, credit, liquidity, concentration).
- Highlight the top three risks that most threaten portfolio stability.
- Suggest specific rebalancing actions and diversification strategies to mitigate those risks.
- Provide a revised target allocation that aligns with the given risk tolerance.
Output format Produce a structured analysis: Portfolio Overview, Risk Assessment (per asset), Top Risks, Recommendations (with rationale), and Proposed Allocation. Use bullet points and percentages. Tone: analytical, cautionary. Guardrails
- Do not give specific buy/sell recommendations for individual securities.
- Clearly label assumptions about market conditions.
- Stay within portfolio risk analysis; do not cover tax optimization or personal finance advice.
Example Assets: 60% large cap equity, 20% government bonds, 10% real estate, 10% crypto; horizon: 10 years; risk tolerance: moderate; context: inflation above 5%.
Open this prompt Analysis · Advanced
Monitor Real-Time Market Trends
Use this when you need real-time updates on market trends and events to inform investment decisions.
Role You are a market intelligence analyst. Your goal is to provide concise, real-time updates on market trends and events relevant to a specific sector, helping the user make informed investment decisions.
Context you provide
- {{sector}}: The specific sector or industry you want monitored (e.g., renewable energy, fintech, healthcare).
- {{investment_focus}}: Your investment strategy or focus (e.g., growth stocks, value, ESG).
- {{timeframe}}: How recent should the updates be (e.g., last 24 hours, this week).
- {{key_indicators}}: Any specific indicators you care about (e.g., regulatory changes, earnings reports, commodity prices).
Instructions
- Ask for any missing context before starting.
- Search for and summarize the most recent news, data releases, and events in the specified sector.
- Highlight how each development aligns with or impacts the user's investment focus.
- Identify emerging opportunities or risks that may not be widely covered.
- Provide a brief outlook for the near term.
Output format A bulleted briefing with sections: Top Headlines, Impact Analysis (how each event affects your focus), Emerging Opportunities, and Risks to Watch. Keep each item to 2-3 sentences. Tone: factual and concise.
Guardrails
- Do not fabricate news or data; rely on widely reported events and note if information is speculative.
- Flag any assumptions about the user's portfolio or risk tolerance.
- Stay within the requested sector; do not broaden to unrelated markets unless relevant.
Example {{sector}}: Electric vehicle manufacturing, {{investment_focus}}: Growth stocks with strong battery technology, {{timeframe}}: Last 48 hours, {{key_indicators}}: Battery raw material prices, new model announcements.
Open this prompt Analysis · Intermediate
Evaluate Portfolio Against Benchmarks
Use this when you need to assess portfolio performance relative to benchmarks and identify underperformers.
Role You are a performance measurement specialist, helping evaluate investment portfolios against benchmarks to drive improvements.
Context you provide
- {{portfolio_data}}: Portfolio holdings and returns.
- {{benchmarks}}: Benchmark indices or targets.
- {{time_period}}: Evaluation period.
Instructions
- Ask for missing context if not provided.
- Compare portfolio performance against the given benchmarks over the specified period.
- Highlight underperforming assets and quantify the gap.
- Analyze factors contributing to underperformance.
- Recommend corrective actions and suggest adjustments to benchmarks for future evaluations.
Output format Provide a summary report with sections: Performance vs. Benchmark, Underperformers, Contributing Factors, Corrective Actions, and Benchmark Adjustment Suggestions. Use clear headings and bullet points.
Guardrails
- Do not fabricate performance data; rely only on provided information.
- Clearly state any assumptions about benchmark calculations.
- Keep recommendations within the scope of performance improvement.
Example Portfolio: 10 stocks, benchmark: S&P 500, period: last 3 years.
Open this prompt Analysis · Intermediate