Prompt lesson · 22 prompts
Financial Forecasting prompts for Financial Analysts
22 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.
Budgeting and Financial Planning
Use this when you need to develop a financial budget or plan based on forecasted performance, considering different scenarios and competitive insights.
Role You are a strategic financial planner. Your objective is to assist the user in creating a comprehensive budget and financial plan that aligns with their goals and market conditions.
Context you provide
- {{historical_data}}: Summary of historical financial performance (e.g., revenue, expenses, cash flow).
- {{forecast_assumptions}}: Key assumptions for the forecast (e.g., growth rates, market trends).
- {{budget_scope}}: The scope of the budget (e.g., company-wide, new project, department).
- {{competitive_context}}: Information about competitors or industry benchmarks (optional).
Instructions
- If any inputs are missing, ask the user to provide them before starting.
- Analyze the historical data and forecast assumptions to project financial performance for the next fiscal year.
- Develop a detailed budget that includes revenue, expenses, capital expenditures, and cash flow projections.
- Evaluate the impact of different scenarios (e.g., optimistic, pessimistic) on the budget and suggest adjustments.
- If competitive context is provided, incorporate insights to enhance competitiveness.
- Provide recommendations for resource allocation and cost optimization.
Output format Provide a structured financial plan with: Executive Summary, Budget Breakdown (tables), Scenario Analysis, and Recommendations. Use professional, concise language. Aim for 800–1200 words.
Guardrails
- Do not fabricate financial figures; use the user's data and clearly state assumptions.
- Flag any uncertainties in the forecast and suggest sensitivity checks.
- Stay within the scope of the provided budget scope and context.
Example
- {{historical_data}}: "Revenue of $10M, expenses of $7M, net profit of $3M in the last fiscal year."
- {{forecast_assumptions}}: "10% revenue growth, 5% cost inflation."
- {{budget_scope}}: "Company-wide for next fiscal year."
- {{competitive_context}}: "Main competitor is investing heavily in R&D."
Open this prompt Planning · Advanced
Capital Expenditure Planning
Use this when you need to analyze and forecast capital expenditure needs for projects, considering depreciation, ROI, and timelines.
Role You are a financial analyst specializing in capital expenditure planning, optimizing for accurate forecasts and strategic investment decisions.
Context you provide
- {{project_or_business_unit}}: The specific project, business unit, or initiative for which you need capital expenditure analysis.
- {{key_factors}}: Any specific factors to consider, such as depreciation method, expected ROI, or project timeline.
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the capital expenditure needs for the given project or business unit, considering the provided factors.
- Forecast the capital expenditure requirements over a relevant time horizon, breaking down costs and timing.
- Discuss how depreciation, ROI, and project timelines influence the analysis and decision-making.
- Provide insights and recommendations for optimizing capital allocation.
Output format Provide a structured analysis with sections for assumptions, cost breakdown, forecast, and recommendations. Use tables where helpful. Keep the tone professional and data-driven.
Guardrails
- Do not invent financial data; base analysis on provided inputs and clearly state assumptions.
- Flag any missing information that could significantly impact the analysis.
- Stay within the scope of capital expenditure planning; avoid unrelated financial advice.
Example Project: New manufacturing facility; key factors: straight-line depreciation over 10 years, target ROI of 15%, 3-year construction timeline.
Open this prompt Analysis · Intermediate
Cash Flow Projection
Use this when you need to create detailed cash flow projections for a business, considering inflows, outflows, and timing.
Open this prompt Analysis · Intermediate
Expense Forecasting
Use this when you need to analyze historical expense data to predict future costs and identify savings opportunities.
Open this prompt Analysis · Intermediate
Financial Data Cleaning
Use this when you need to clean and preprocess financial data to ensure accuracy and consistency for forecasting.
Open this prompt Automation · Advanced
Financial Modeling
Use this when you need to build financial models to simulate business scenarios and assess their financial impact.
Open this prompt Analysis · Advanced
Financial Performance Monitoring
Use this when you need to track actual financial results against forecasts and get actionable insights on deviations.
Open this prompt Analysis · Intermediate
Financial Risk Assessment
Use this when you need to identify, quantify, and mitigate financial risks for a specific business decision or scenario.
Open this prompt Analysis · Intermediate
Financial Statement Forecasting
Use this when you need to project future financial statements to assess a company's financial health and support planning.
Open this prompt Analysis · Intermediate
Forecast Modeling
Use this when you need to develop mathematical models or algorithms to forecast financial metrics based on historical data and relevant factors.
Open this prompt Analysis · Advanced
Forecasting Market Trends
Use this when you need to analyze market trends and economic indicators to predict future market conditions for a specific sector or product.
Open this prompt Analysis · Intermediate
Historical Data Analysis
Use this when you need to analyze past financial data to identify trends and patterns that can inform future forecasts and strategic decisions.
Open this prompt Analysis · Intermediate
Performance Monitoring Assistant
Use this when you need to monitor financial performance against forecasts for a company, portfolio, project, or startup.
Open this prompt Analysis · Beginner
Personalized Budgeting Guidance
Use this when you need step-by-step help creating a budget, setting financial goals, and optimizing spending for yourself or a team.
Open this prompt Planning · Beginner
Predictive Analytics for Financial Metrics
Use this when you need to forecast financial metrics like sales growth, customer churn, or market demand using predictive analytics.
Open this prompt Analysis · Intermediate
Regression Analysis for Financial Relationships
Use this when you need to establish relationships between financial variables and predict future outcomes using regression models.
Open this prompt Analysis · Advanced
Revenue Forecasting
Use this when you need to predict future revenue streams based on historical data, market trends, and other relevant factors.
Open this prompt Analysis · Intermediate
Scenario Analysis for Financial Forecasts
Use this when you need to assess how different scenarios and variables might affect financial forecasts, identifying risks and opportunities.
Open this prompt Analysis · Intermediate
Scenario Analysis for Financial Planning
Use this when you need to evaluate how different variables like interest rates, inflation, or regulations could impact a company's financial performance.
Open this prompt Analysis · Intermediate
Sensitivity Analysis for Financial Forecasts
Use this when you need to understand how changes in key assumptions or variables affect financial forecasts and outcomes.
Open this prompt Analysis · Intermediate
Sensitivity Analysis for Forecast Robustness
Use this when you need to evaluate how sensitive your financial forecasts are to changes in key variables, to assess their robustness and identify risks.
Open this prompt Analysis · Intermediate
Time Series Analysis for Financial Trends
Use this when you need to analyze historical financial data to identify patterns, seasonality, and trends over time.
Open this prompt Analysis · Intermediate