Prompt lesson · 18 prompts
Financial Forecasting prompts for Vice Presidents of Business Development
18 ready-to-use prompts from our AI for Vice Presidents of Business Development course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Automate Financial Reporting Workflows
Use this when you want to streamline financial reporting by automating data consolidation, report generation, and forecasting.
Role You are an automation expert who designs efficient financial reporting workflows, reducing manual effort and improving accuracy.
Context you provide
- {{data_sources}}: The systems or files where financial data resides (e.g., ERP, spreadsheets, databases).
- {{report_requirements}}: The types of reports needed (e.g., monthly P&L, cash flow, variance analysis) and their frequency.
- {{forecasting_needs}}: Any specific forecasting or trend analysis to include.
- {{compliance_standards}}: Any regulatory or internal standards to adhere to.
Instructions
- Ask for missing inputs if not provided.
- Outline a step-by-step automation workflow, from data extraction to report delivery.
- Recommend tools and methods for data consolidation and transformation.
- Describe how to generate reports with key insights and forecasting elements.
- Include validation steps to ensure accuracy and compliance.
Output format A detailed automation plan with: workflow diagram (text-based), tool recommendations, report templates, and validation checklist. Tone should be practical and actionable.
Guardrails
- Do not assume specific software; ask if not provided.
- Emphasize data security and compliance in the workflow.
- Keep the plan focused on financial reporting automation.
Example Data sources: QuickBooks and Excel; report requirements: monthly P&L and cash flow forecast; forecasting needs: 12-month rolling forecast; compliance: GAAP.
Open this prompt Automation · Intermediate
Automated Cost Analysis Tool
Use this when you want to automate cost analysis for real-time monitoring and forecasting of expenses.
Role You are an AI automation consultant specializing in financial process optimization. Your objective is to design a practical blueprint for automating cost analysis, enabling real-time monitoring and accurate expense forecasting.
Context you provide
- {{data_sources}}: The financial systems and data sources to integrate (e.g., ERP, accounting software, spreadsheets).
- {{cost_categories}}: The specific cost categories to monitor (e.g., operational, marketing, payroll).
- {{automation_goal}}: The primary goal, such as real-time monitoring, trend identification, or forecasting.
Instructions
- Ask for any missing context before outlining the solution.
- Design a step-by-step plan for building the automated cost analysis tool, from data collection to reporting.
- Specify how to preprocess and structure the data for accurate analysis.
- Recommend methods for identifying cost trends and generating forecasts, including relevant algorithms or rules.
- Outline how to integrate the tool with existing systems and set up real-time dashboards.
Output format Provide a detailed implementation plan with sections for Data Integration, Preprocessing, Analysis Methods, Forecasting Approach, and Dashboard Design. Use bullet points and clear headings. Keep the tone technical and actionable.
Guardrails
- Do not assume specific software; ask for the user's tech stack.
- Avoid overcomplicating the solution; focus on practical, scalable steps.
- Stay within the scope of cost analysis automation; do not expand into other financial areas.
Example
- {{data_sources}}: "QuickBooks and Excel spreadsheets"
- {{cost_categories}}: "Marketing, operations, and payroll"
- {{automation_goal}}: "Real-time monitoring and monthly forecasting"
Open this prompt Automation · Advanced
Balance Sheet Projection
Use this when you need to forecast a company's financial position by projecting assets, liabilities, and equity.
Open this prompt Analysis · Advanced
Budgeting and Expense Tracking
Use this when you need to design a budgeting tool that tracks expenses and provides real-time insights.
Open this prompt Creating · Intermediate
Capital Allocation Optimization
Use this when you need to optimize capital allocation decisions by analyzing financial data and market conditions.
Open this prompt Analysis · Advanced
Capital Budgeting Analysis
Use this when you need to evaluate the financial viability of long-term investment projects.
Open this prompt Analysis · Advanced
Cash Flow Projection Model
Use this when you need to predict cash inflows and outflows to ensure liquidity and identify potential shortages.
Open this prompt Analysis · Intermediate
Customer Lifetime Value Prediction
Use this when you need to predict customer lifetime value to improve financial forecasting and customer-centric strategies.
Open this prompt Analysis · Intermediate
Expense Forecasting and Budgeting
Use this when you need to estimate future expenses based on past spending patterns and budget constraints.
Open this prompt Analysis · Intermediate
Financial Modeling and Forecasting
Use this when you need to build or refine financial models to forecast outcomes and support strategic decisions.
Open this prompt Analysis · Advanced
Financial Ratio Analysis and Benchmarking
Use this when you need to assess a company's financial health through ratio analysis and compare against industry benchmarks.
Open this prompt Analysis · Intermediate
Investment Opportunity Evaluation
Use this when you need to assess potential investments, including risk and return forecasting.
Open this prompt Analysis · Advanced
Market Trend and Competitor Analysis
Use this when you need to understand market trends, competitor moves, and customer behavior to refine strategy and forecasting.
Open this prompt Research · Intermediate
Profit and Loss Forecast
Use this when you need to forecast net income by analyzing revenue and expenses, and identify growth and cost-saving opportunities.
Open this prompt Analysis · Intermediate
Revenue Forecasting
Use this when you need to predict future revenue based on historical data, market trends, and sales projections.
Open this prompt Analysis · Intermediate
Revenue Projection Optimization
Use this when you need to refine revenue projections for accuracy and uncover growth opportunities.
Open this prompt Analysis · Intermediate
Scenario Planning for Financial Forecasts
Use this when you need to prepare for multiple possible futures by creating best-case, worst-case, and most likely financial scenarios.
Open this prompt Planning · Advanced
Sensitivity Analysis for Financial Forecasts
Use this when you need to understand how changes in key variables impact your financial forecast and identify risks and opportunities.
Open this prompt Analysis · Advanced