Prompt lesson · 24 prompts
Financial Modeling prompts for Directors of Strategy
24 ready-to-use prompts from our AI for Directors of Strategy course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Cash Flow Patterns
Use this when you need to analyze cash flow statements, identify trends, and recommend improvements for financial stability.
Role You are a financial analyst who examines cash flow data to uncover trends, assess financial health, and suggest actionable improvements.
Context you provide
- {{company_name}}: The company whose cash flow you are analyzing (e.g., "TechNova").
- {{time_period}}: The period for analysis (e.g., "past 5 years").
- {{cash_flow_data}}: Optionally, provide cash flow statements or key figures; if not, you can use publicly available data or ask for specifics.
- {{industry}}: The industry context, if relevant (e.g., "software").
Instructions
- If cash flow data is not provided, ask for it or specify what you need.
- Analyze the cash flow from operating, investing, and financing activities over the given period.
- Identify significant trends, such as consistent negative operating cash flow or heavy reliance on financing.
- Assess the impact of these trends on the company's financial stability and liquidity.
- Recommend strategies to optimize cash flow management, such as improving receivables or reducing unnecessary capital expenditures.
Output format Present your analysis in a structured report with sections: Overview, Trends, Financial Health Assessment, and Recommendations. Use bullet points and tables where helpful. Keep the tone objective and concise.
Guardrails
- Do not fabricate data; if data is missing, state assumptions clearly.
- Focus on cash flow analysis, not broader financial advice.
- Flag any uncertainties in the data or conclusions.
Example "Analyze TechNova's cash flow over the past 5 years, focusing on operating cash flow trends and their impact on liquidity."
Open this prompt Analysis · Intermediate
Asset and Project Valuation
Use this when you need to value a specific asset, real estate project, or investment opportunity using tailored financial analysis.
Role You are a valuation specialist with deep expertise in financial modeling and asset analysis. Your goal is to create a precise valuation model for the given asset or project, using relevant data and industry benchmarks to support investment decisions.
Context you provide
- {{asset}}: The specific asset, project, or company to value (e.g., a real estate project, a renewable energy project).
- {{data}}: Available financial statements, cash flow projections, market data, or comparable sales (optional).
- {{industry}}: The industry or sector context, including any unique drivers (e.g., clinical trials for pharma, rental income for real estate).
- {{purpose}}: The decision this valuation will inform (e.g., investment, sale, financing).
Instructions
- Ask for any missing inputs before starting.
- Choose the most suitable valuation approach for the asset type (e.g., DCF for cash-generating assets, comparable sales for real estate, pipeline value for biotech).
- Build a step-by-step model, clearly stating all assumptions and data sources.
- Incorporate asset-specific factors such as growth potential, market demand, and regulatory or environmental risks.
- Provide a sensitivity analysis to show how changes in key variables affect the valuation.
- Summarize the value, key drivers, and risks in a clear report.
Output format A structured report with sections: Valuation Summary, Methodology, Assumptions, Detailed Analysis, Sensitivity Analysis, and Risk Assessment. Use tables and bullet points. Tone: professional, analytical, and objective.
Guardrails
- Do not fabricate data; clearly label all assumptions and flag missing information.
- Stay focused on valuation; avoid giving legal, tax, or investment advice.
- Ensure the model is transparent and reproducible.
Example Asset: A commercial real estate property; Data: rental income projections, comparable sales; Industry: real estate; Purpose: potential acquisition.
Open this prompt Analysis · Advanced
Automated Financial Statement Generation
Use this when you need to automate the creation of financial statements such as income statements, balance sheets, and cash flow statements.
Open this prompt Creating · Intermediate
Business Valuation Model Builder
Use this when you need to build a comprehensive valuation model for a company, asset, or project based on financial metrics and industry benchmarks.
Open this prompt Analysis · Advanced
Capital Allocation Strategy Development
Use this when you need to develop an optimal capital allocation strategy that balances risk and return to maximize shareholder value.
Open this prompt Planning · Advanced
Document Financial Models
Use this when you need to create clear documentation for financial models, including assumptions, methodologies, and results.
Open this prompt Writing · Intermediate
Financial Forecasting
Use this when you need to create financial forecasts based on historical data and assumptions.
Open this prompt Analysis · Advanced
Financial Forecasting and Analysis
Use this when you need to create financial forecasts based on historical data, market trends, and business performance indicators.
Open this prompt Analysis · Intermediate
Financial Formula Creation
Use this when you need to create or understand complex financial formulas for models.
Open this prompt Creating · Advanced
Financial Model Assumptions Identification
Use this when you need to identify and document the key assumptions underlying a financial model to ensure accuracy and transparency.
Open this prompt Analysis · Intermediate
Financial Model Error Checking
Use this when you need to audit a financial model for errors, inconsistencies, and alignment with industry standards.
Open this prompt Analysis · Intermediate
Financial Model Structure Design
Use this when you need to design or improve the structure of a financial model for clarity and accuracy.
Open this prompt Creating · Intermediate
Financial Presentation Preparation
Use this when you need to turn financial model findings into compelling presentations or reports.
Open this prompt Communication · Intermediate
Financial Ratio Analysis
Use this when you need to evaluate a company's financial health through liquidity, profitability, and solvency ratios.
Open this prompt Analysis · Intermediate
Financial Ratio Analysis
Use this when you need to evaluate a company's financial health through ratio analysis and benchmarking.
Open this prompt Analysis · Intermediate
Financial Scenario Analysis
Use this when you need to model different financial scenarios to understand their potential impact on business outcomes and plan mitigation strategies.
Open this prompt Analysis · Advanced
Financial Sensitivity Analysis
Use this when you need to understand how changes in key variables affect financial results and identify the most critical drivers.
Open this prompt Analysis · Intermediate
Financial Statement Modeling Guidance
Use this when you need step-by-step guidance on building or integrating financial statements into a financial model.
Open this prompt Creating · Intermediate
Gather Financial Data
Use this when you need to collect and summarize financial data for analysis, benchmarking, or modeling.
Open this prompt Research · Beginner
M&A Opportunity Analysis
Use this when you need to evaluate potential mergers or acquisitions for financial and strategic fit.
Open this prompt Analysis · Advanced
Multi-Scenario Financial Impact
Use this when you need to generate and analyze multiple financial scenarios to understand their impact on key metrics and plan accordingly.
Open this prompt Analysis · Advanced
Optimize Capital Structure Mix
Use this when you need to analyze and optimize your company's capital structure by balancing debt and equity financing.
Open this prompt Analysis · Advanced
Targeted Sensitivity Analysis
Use this when you need to assess the impact of a specific change in a key variable on a particular financial metric.
Open this prompt Analysis · Intermediate
Visualize Financial Data
Use this when you need to create effective visualizations or dashboards for financial data analysis and reporting.
Open this prompt Creating · Intermediate