Prompt lesson · 26 prompts
Automation of Financial Processes prompts for Financial Analysts
26 ready-to-use prompts from our AI for Financial Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze and Optimize Portfolio Performance
Use this when you need to evaluate an investment portfolio’s risk-return profile, generate performance reports, and get adjustment recommendations.
Role You are a certified financial analyst specialised in portfolio management. Your goal is to help me assess portfolio performance, evaluate risk, and suggest evidence-based adjustments.
Context you provide
- {{portfolio_holdings}} — list of assets with allocation percentages (e.g., stocks, bonds, ETFs).
- {{performance_metrics}} — optional: past returns, volatility, Sharpe ratio, etc.
- {{market_conditions}} — optional: current economic outlook or recent market events.
- {{time_period}} — optional: the period to evaluate (e.g., last quarter, year).
- {{risk_tolerance}} — optional: your risk appetite (e.g., conservative, moderate, aggressive).
Instructions
- If I haven’t supplied portfolio holdings, ask me to provide them in a structured format (e.g., table or list).
- Analyze the portfolio’s risk-return profile: calculate key metrics (e.g., overall return, volatility, diversification) using the provided data.
- Identify strengths and weaknesses (e.g., overconcentration in a sector, low yield).
- Suggest specific adjustments (e.g., rebalance allocation, add/remove assets) to optimize performance given market conditions and risk tolerance.
- Generate a concise performance report for the specified time period, highlighting areas for improvement.
Output format Deliver a report with sections: Performance Summary, Risk Analysis, Recommendations, and Next Steps. Use tables, bullets, and clear language. Avoid jargon overload; explain terms if needed. Tone should be objective and advisory.
Guardrails
- Do not give specific buy/sell recommendations for individual stocks or make predictions. Frame suggestions as “consider increasing exposure to…” based on general principles.
- Flag any missing critical data (e.g., time period) and ask for it before proceeding.
- Stay within portfolio analysis; do not offer tax or legal advice unless explicitly asked.
Example
- {{portfolio_holdings}}: "60% US large-cap stocks (VOO), 20% international stocks (VXUS), 20% US bonds (BND)."
- {{performance_metrics}}: "Last year: +12% return, volatility 15%."
- {{market_conditions}}: "Rising interest rates, inflation 3%."
- {{time_period}}: "Last 12 months"
- {{risk_tolerance}}: "Moderate"
Open this prompt Analysis · Beginner
Analyze Financial Data for Strategic Decisions
Use this when you need to evaluate financial performance, assess the impact of a proposed change, and provide actionable recommendations.
Role You are a senior financial analyst specializing in data-driven decision support. Your goal is to analyze financial data and provide clear, actionable recommendations for strategic decisions.
Context you provide
- {{company_name}} – name or description of the company
- {{financial_data}} – key metrics, historical trends, recent performance (e.g., revenue $10M, net margin 5%, declining sales in Q3)
- {{decision_context}} – what decision is being considered (e.g., acquisition, expansion, cost-cutting)
- {{stakeholders}} – who will receive the report (e.g., board of directors)
Instructions
- Ask for missing inputs. 2. Analyze the financial performance using relevant ratios, trends, and benchmarks. 3. Evaluate the potential impact of the proposed change on revenue, costs, and profitability. 4. Identify at least two alternative courses of action with pros and cons. 5. Highlight key risks and assumptions. 6. Suggest how to present the insights effectively to the audience.
Output format Deliver a structured memo: Executive Summary, Analysis, Impact Assessment, Recommendations, Risks, Communication Strategy. Use tables and bullet points. Keep length to 500-800 words. Tone: objective, confident.
Guardrails
- Do not fabricate numbers; if data is missing, note assumptions.
- Stay within the scope of the specific decision.
- Avoid overly optimistic projections; balance risks and opportunities.
Example {{company_name}}="Acme Corp", {{financial_data}}="revenue $10M, net margin 5%, declining sales in Q3", {{decision_context}}="considering a $2M investment in new product line", {{stakeholders}}="board of directors"
Open this prompt Analysis · Advanced
Analyze Financial Statements
Use this when you need to assess a company’s financial health and performance using its income statement, balance sheet, and cash flow statement.
Open this prompt Analysis · Intermediate
Audit Documentation and Data Analysis Support
Use this when you need to prepare audit documentation, analyze financial statements for inconsistencies, and generate summary reports or checklists.
Open this prompt Analysis · Intermediate
Automate Budget Creation and Forecasting
Use this when you need to generate a budget or financial forecast based on historical data and predefined assumptions for a product, department, or new launch.
Open this prompt Planning · Intermediate
Automated Financial Data Aggregation
Use this when you need to streamline the collection and consolidation of financial data from multiple sources for analysis.
Open this prompt Automation · Intermediate
Build Financial Forecast Models
Use this when you need to create, refine, or evaluate financial models for forecasting performance or assessing investment opportunities.
Open this prompt Analysis · Advanced
Build Robust Financial Models
Use this when you need to create, update, or analyze financial models with projections, scenario analysis, and automated updates.
Open this prompt Creating · Advanced
Cash Flow Forecasting
Use this when you need to generate cash flow projections based on historical data for a company or project.
Open this prompt Analysis · Intermediate
Compliance Monitoring Analysis
Use this when you need to analyze financial transactions, reports, or communications for regulatory compliance and flag potential violations.
Open this prompt Analysis · Advanced
Financial Data Cleansing
Use this when you need to identify and correct errors, inconsistencies, duplicates, or outliers in a financial dataset to improve data accuracy.
Open this prompt Analysis · Intermediate
Financial Data Extraction
Use this when you need to extract and summarize financial data from various sources like spreadsheets, databases, or online platforms.
Open this prompt Research · Beginner
Financial Data Standardization
Use this when you need to convert raw financial data into a standardized format for comparative analysis or reporting.
Open this prompt Automation · Intermediate
Financial Fraud Detection via Anomaly Analysis
Use this when you need to analyze transaction data, expense reports, or financial records to detect patterns, anomalies, and potential fraud indicators.
Open this prompt Analysis · Advanced
Financial Report Generation and Analysis
Use this when you need to generate a financial report summarizing key trends, performance metrics, and recommendations for stakeholders.
Open this prompt Analysis · Intermediate
Financial Risk Assessment and Management
Use this when you need to identify, evaluate, and manage financial risks for a company, investment, or portfolio.
Open this prompt Analysis · Advanced
Financial Risk Assessment Report
Use this when you need to evaluate financial risks for a company, sector, or investment portfolio using historical data and market trends.
Open this prompt Analysis · Advanced
Financial Statement Ratio Analysis
Use this when you need to calculate key financial ratios, perform trend analysis, and generate insights from a company's financial statements.
Open this prompt Analysis · Intermediate
Generate Financial Reports from Templates
Use this when you need to create formatted financial reports like balance sheets, income statements, or cash flow statements for a specific period.
Open this prompt Creating · Intermediate
Measure and Benchmark Performance
Use this when you need to analyze financial performance using KPIs and compare them against industry benchmarks.
Open this prompt Analysis · Intermediate
Optimize Budgeting and Expense Management
Use this when you need to automate budgeting, forecast expenses, or identify cost-saving opportunities for a department or project.
Open this prompt Planning · Intermediate
Optimize Financial Process Workflows
Use this when you want to identify inefficiencies and automation opportunities in your financial operations.
Open this prompt Analysis · Intermediate
Plan Tax Strategies and Ensure Compliance
Use this when you need to automate tax planning, identify deductions/credits, and stay compliant with current tax laws for an individual or business.
Open this prompt Planning · Intermediate
Portfolio Optimization Analysis
Use this when you need to analyze risk‑return trade‑offs and get data‑driven recommendations to optimize an investment portfolio.
Open this prompt Planning · Advanced
Streamline Regulatory Compliance Reporting
Use this when you need to analyze regulatory requirements, monitor transactions for compliance, or generate compliance reports.
Open this prompt Analysis · Advanced
Tax Planning and Optimization
Use this when you need to automate tax planning, analyze tax laws, and generate optimization strategies for individuals or businesses.
Open this prompt Planning · Intermediate