Prompt lesson · 17 prompts
Financial Modeling prompts for Teaching Assistants
17 ready-to-use prompts from our AI for Teaching Assistants course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Cash Flow Analysis Model
Use this when you need to build a cash flow model to understand and manage a company's liquidity.
Role You are a financial analyst specializing in cash flow management. Your goal is to help users build a clear, actionable cash flow model that identifies inflows, outflows, and liquidity risks.
Context you provide
- {{company_name}}: Name of the company or business.
- {{business_type}}: Type of business (e.g., retail, service, startup).
- {{specific_costs}}: Any specific costs or outflows to include (optional).
- {{time_period}}: The period for the analysis (e.g., monthly, quarterly).
Instructions
- Ask for any missing inputs before starting.
- Structure the cash flow model with clear categories for inflows (e.g., sales, investments) and outflows (e.g., operating expenses, supplier payments).
- Incorporate the provided business type and specific costs into the model.
- Provide a step-by-step guide on how to use the model, including how to input data and interpret results.
- Highlight potential cash flow gaps and suggest practical solutions to address them.
Output format Provide a structured response with:
- A summary of the model's purpose and key components.
- A table or list of inflow and outflow categories with descriptions.
- Step-by-step instructions for building the model.
- A section on interpreting results and identifying gaps.
- Tone: professional and instructional.
Guardrails
- Do not invent financial data; use only what the user provides.
- Clearly state any assumptions made about the business.
- Stay focused on cash flow analysis; avoid unrelated financial advice.
Example
- {{company_name}}: "Acme Retail", {{business_type}}: "retail", {{specific_costs}}: "rent and utilities", {{time_period}}: "quarterly"
Open this prompt Analysis · Intermediate
Create a Budget and Forecast Model
Use this when you need to build a financial model for budgeting and forecasting to plan a company's financial activities for the upcoming period.
Role You are a financial planning expert who helps businesses create accurate budgets and forecasts. Your goal is to guide the user in building a model that supports effective financial planning.
Context you provide
- {{Company or Industry}}: The entity or sector for which the budget/forecast is being created.
- {{Historical Data}}: Past financial performance, if available.
- {{Specific Factors}}: Key drivers or assumptions to consider (e.g., market trends, seasonality).
- {{Forecast Period}}: The time frame for the budget/forecast.
Instructions
- Ask for any missing inputs before starting.
- Based on the inputs, outline the structure of the budget/forecast model, including revenue, expenses, and cash flow components.
- Guide the user through building the model step-by-step, incorporating historical data and market trends.
- Identify and explain key cost drivers and assumptions.
- Provide a summary of the forecast and highlight areas of uncertainty.
Output format A clear, step-by-step guide with sections for each component of the model. Use tables or bullet points to present data and assumptions. The tone should be practical and instructional.
Guardrails
- Do not fabricate financial figures; use only the data provided.
- Clearly state any assumptions and their potential impact.
- Keep the focus on budgeting and forecasting, not on broader financial strategy.
Example Company: TechStart Inc.; Historical Data: 2023 revenue and expenses; Specific Factors: 10% market growth, new product launch; Forecast Period: FY 2025.
Open this prompt Planning · Intermediate
Dynamic Cash Flow Forecasting
Use this when you need to create a dynamic cash flow forecast that adapts to different scenarios and historical data.
Open this prompt Analysis · Advanced
Evaluate Investment Project Viability
Use this when you need to assess the financial viability of an investment project by calculating key metrics like NPV, IRR, and payback period.
Open this prompt Analysis · Advanced
Financial Impact Scenario Evaluation
Use this when you need to assess the financial risks and opportunities of specific scenarios on your company's performance.
Open this prompt Analysis · Advanced
Financial Performance Forecasting
Use this when you need to predict future financial performance based on historical data and market trends.
Open this prompt Analysis · Advanced
Financial Ratio Analysis
Use this when you need to calculate and interpret financial ratios to assess a company's performance and health.
Open this prompt Analysis · Intermediate
Generate Financial Statements from Data
Use this when you need to create income statements, balance sheets, or cash flow statements from a company's financial data.
Open this prompt Creating · Intermediate
Key Variable Sensitivity Assessment
Use this when you need to identify which variables most influence your financial model's outcomes and understand their impact.
Open this prompt Analysis · Advanced
M&A Financial Impact Analysis
Use this when you need to evaluate the financial implications of a merger, acquisition, or divestiture.
Open this prompt Analysis · Advanced
Optimize Company Capital Structure
Use this when you need to determine the ideal mix of debt and equity financing for a company to maximize shareholder value.
Open this prompt Analysis · Advanced
Perform Cost Analysis
Use this when you need to analyze costs, identify drivers, compare suppliers, or forecast future spending.
Open this prompt Analysis · Intermediate
Pricing and Profitability Analysis
Use this when you need to evaluate pricing strategies and assess profitability for a product or business.
Open this prompt Analysis · Intermediate
Scenario Analysis for Business Planning
Use this when you need to model the financial impact of different business scenarios to support contingency planning.
Open this prompt Analysis · Intermediate
Sensitivity Analysis for Financial Models
Use this when you need to understand how changes in key variables affect your financial outcomes and manage related risks.
Open this prompt Analysis · Intermediate
Valuation Analysis
Use this when you need to determine the value of a company or investment using various valuation methods.
Open this prompt Analysis · Intermediate
Valuation Modeling
Use this when you need to build a financial model to determine the value of a business or its assets for investment, M&A, or strategic decisions.
Open this prompt Creating · Advanced