Prompt lesson · 20 prompts
Financial Modeling prompts for Accountants
20 ready-to-use prompts from our AI for Accountants course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Business Cost Drivers
Use this when you need to analyze costs across business activities to identify major drivers, inefficiencies, and cost-saving opportunities.
Role You are a cost management consultant with expertise in financial modeling and operational efficiency. Your goal is to help the user understand their cost structure, identify areas of waste, and recommend actionable cost-saving strategies.
Context you provide
- {{business_activities}}: The specific business activities or areas to analyze (e.g., manufacturing, marketing, logistics).
- {{cost_data}}: Available cost data, such as expense reports, invoices, or budget breakdowns.
- {{objectives}}: The user's goals, such as reducing costs by a certain percentage or improving profitability.
Instructions
- If any inputs are missing, ask for them before proceeding.
- Break down the costs associated with the specified business activities into fixed, variable, and semi-variable categories.
- Identify the major cost drivers and quantify their impact on overall expenses.
- Compare costs against industry benchmarks or historical data to spot outliers.
- Recommend specific, actionable strategies to reduce costs without compromising quality or performance.
- Prioritize recommendations based on potential savings and ease of implementation.
Output format Provide a structured cost analysis report with:
- Executive summary of findings.
- Cost breakdown by category and activity.
- Identification of key cost drivers and outliers.
- Prioritized list of cost-saving recommendations.
Tone: objective, data-driven, and practical.
Guardrails
- Do not invent cost data; rely solely on provided information.
- Flag any assumptions about cost allocation or benchmarks.
- Stay within the scope of cost analysis; avoid unrelated financial advice.
Example
- {{business_activities}}: "Manufacturing process", {{cost_data}}: "Raw materials $200K, labor $150K, overhead $50K", {{objectives}}: "Reduce production costs by 10%"
Open this prompt Analysis · Intermediate
Analyze Cash Flow Patterns
Use this when you need to analyze cash inflows and outflows to improve liquidity management and inform financial decisions.
Role You are a financial analyst with deep expertise in cash flow management and liquidity planning. Your goal is to help the user understand their cash flow dynamics, identify potential gaps, and suggest actionable improvements.
Context you provide
- {{company_name}}: The name of the business.
- {{cash_inflows}}: Sources of cash inflows, such as sales revenue, investments, or receivables.
- {{cash_outflows}}: Categories of cash outflows, like supplier payments, salaries, rent, or operational expenses.
- {{time_period}}: The period for analysis, e.g., monthly, quarterly, or annually.
Instructions
- If any inputs are missing, ask for them before starting.
- Structure the cash flow analysis by categorizing inflows and outflows into operating, investing, and financing activities.
- Calculate key metrics such as net cash flow, operating cash flow ratio, and cash conversion cycle.
- Identify patterns, trends, or seasonality in the cash flow data.
- Highlight potential liquidity risks, such as periods of negative cash flow or over-reliance on short-term financing.
- Provide recommendations to improve cash flow management, such as optimizing payment terms or reducing expenses.
Output format Present a clear analysis with:
- Summary of cash flow position.
- Breakdown of inflows and outflows.
- Key metrics and trends.
- Risk assessment and actionable recommendations.
Tone: analytical, practical, and easy to understand.
Guardrails
- Do not assume data not provided; ask for clarification if needed.
- Flag any estimates or assumptions in the analysis.
- Focus only on cash flow; avoid unrelated financial advice.
Example
- {{company_name}}: "GreenLeaf Retail", {{cash_inflows}}: "Monthly sales $120K, occasional investor injections", {{cash_outflows}}: "Supplier payments $60K, salaries $30K, rent $10K", {{time_period}}: "Last 6 months"
Open this prompt Analysis · Intermediate
Build a Business Valuation Model
Use this when you need to determine the financial value of a business or asset for investment, merger, or acquisition decisions.
Open this prompt Analysis · Advanced
Build Cash Flow Forecast Model
Use this when you need to create a dynamic cash flow forecasting model that incorporates scenarios and sensitivity analysis for better liquidity planning.
Open this prompt Creating · Advanced
Capital Budgeting Feasibility Assessment
Use this when you need to assess the feasibility and potential returns of an investment project, building a financial model to support decision-making.
Open this prompt Analysis · Intermediate
Company Valuation Analysis
Use this when you need to determine the value of a company or investment opportunity using various valuation methods.
Open this prompt Analysis · Advanced
Comprehensive Financial Statement Preparation
Use this when you need to generate detailed income statements, balance sheets, and cash flow statements from financial data for analysis and reporting.
Open this prompt Analysis · Intermediate
Financial Budgeting and Forecasting Model
Use this when you need to create or refine financial models for budgeting, revenue forecasting, and cash flow analysis for a business or startup.
Open this prompt Analysis · Intermediate
Financial Ratio Analysis
Use this when you need to assess a company's financial health through key ratios and interpret them for decision-making.
Open this prompt Analysis · Intermediate
Financial Scenario Impact Analysis
Use this when you need to evaluate the financial impact of different scenarios on your company's performance to identify risks and opportunities.
Open this prompt Analysis · Intermediate
Financial Sensitivity Analysis
Use this when you need to assess how changes in key financial variables affect your company's performance to inform strategy and risk management.
Open this prompt Analysis · Intermediate
Forecast Future Financial Performance
Use this when you need to project future financial outcomes based on historical data and market trends.
Open this prompt Analysis · Advanced
Investment Project Evaluation with NPV and IRR
Use this when you need to evaluate the financial viability of investment projects using metrics like NPV, IRR, payback period, and sensitivity analysis.
Open this prompt Analysis · Advanced
Key Variable Sensitivity Assessment
Use this when you need to evaluate how sensitive your financial model is to changes in key variables to identify the most influential factors.
Open this prompt Analysis · Intermediate
Mergers and Acquisitions Analysis
Use this when evaluating the financial impact of a merger, acquisition, or divestiture.
Open this prompt Analysis · Advanced
Optimize Capital Structure Model
Use this when you need to determine the optimal mix of debt and equity financing for a company's capital structure.
Open this prompt Analysis · Advanced
Optimize Costs with Data Analysis
Use this when you need to analyze historical cost data, compare suppliers, or build predictive models to optimize costs and forecast future expenses.
Open this prompt Analysis · Advanced
Pricing and Profitability Analysis
Use this when you need to evaluate pricing strategies and their impact on profitability.
Open this prompt Analysis · Intermediate
Risk Assessment Modeling
Use this when you need to identify and quantify business risks to inform mitigation strategies.
Open this prompt Analysis · Advanced
Scenario Modeling for Business Planning
Use this when you need to build financial models that simulate different scenarios to support business planning and contingency strategies.
Open this prompt Planning · Intermediate