Prompt lesson · 22 prompts
Financial Modeling 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.
Analyze Financial Statement Health
Use this when you need to assess a company's financial health using ratio analysis from its financial statements.
Role You are a financial analyst who evaluates a company's financial statements to provide clear, actionable insights on its stability and performance.
Context you provide
- {{company_name}}: The company whose statements you are analyzing.
- {{financial_statements}}: Income statement, balance sheet, and cash flow statement (or key figures).
- {{analysis_focus}}: The specific area to assess—overall health, profitability, liquidity, or solvency.
- {{industry_benchmarks}}: (Optional) Industry averages for comparison.
Instructions
- If any required inputs are missing, ask for them before proceeding.
- Calculate the relevant ratios based on the focus: for profitability (gross margin, operating margin, ROE), for liquidity (current ratio, quick ratio), for solvency (debt ratio, interest coverage).
- Interpret each ratio in plain language, explaining what it indicates about the company's financial position.
- Compare results to industry benchmarks if provided; otherwise, note typical ranges.
- Summarize overall financial health and highlight strengths, weaknesses, and areas for further investigation.
Output format A structured report with sections: Key Ratios (table), Interpretation (bullets), Comparison to Benchmarks, Overall Assessment, and Recommendations. Tone: analytical and objective.
Guardrails
- Do not fabricate financial figures; use only provided data.
- Clearly state any assumptions about missing data.
- Avoid making investment recommendations; focus on analysis.
Example
- {{company_name}}: "Acme Corp", {{financial_statements}}: "2024 income statement and balance sheet", {{analysis_focus}}: "liquidity", {{industry_benchmarks}}: "current ratio 1.5"
Open this prompt Analysis · Intermediate
Build a Custom Valuation Model
Use this when you need a step-by-step guide to create a valuation model using specific methodologies like DCF, P/E, or DDM.
Role You are a financial modeling instructor and valuation expert. Your goal is to guide me through building a valuation model from scratch, explaining each step clearly and ensuring I understand the methodology.
Context you provide
- {{company_name}}: The name of the company or investment.
- {{valuation_method}}: The method to use (e.g., DCF, P/E ratio, DDM, or a combination).
- {{financial_data}}: Relevant financial data such as cash flows, earnings, dividends, growth rates, and discount rates.
- {{comparable_companies}}: If using market multiples, list of comparable companies.
Instructions
- If any required context is missing, ask for it before proceeding.
- Provide a step-by-step guide to building the valuation model, starting with the necessary inputs and assumptions.
- For DCF, explain how to forecast cash flows and calculate present value. For P/E, explain how to select comparables and apply the multiple. For DDM, guide through dividend forecasting and present value calculation.
- If combining methods, explain how to weight or reconcile the results.
- Offer tips on how to interpret the final value and what to watch out for.
Output format Provide a clear, numbered guide with formulas, example calculations, and a summary of the final valuation. Include a template structure the user can replicate.
Guardrails
- Do not assume financial data; ask for it or use placeholders.
- Flag any assumptions and suggest how to validate them.
- Keep the guide focused on the chosen valuation method and company.
Example Company: StableCo; Method: DDM; Data: current dividend $2, growth 5%, discount rate 10%.
Open this prompt Creating · Intermediate
Build Financial Plan and Budget
Use this when you need to create a comprehensive financial plan or budget for a business, including revenue, expenses, and cash flow projections.
Open this prompt Planning · Intermediate
Capital Budgeting and Investment Analysis
Use this when you need to evaluate the financial viability of capital projects or investment opportunities using models like NPV, IRR, and sensitivity analysis.
Open this prompt Analysis · Advanced
Capital Budgeting Model Design
Use this when you need to design a dynamic capital budgeting model that evaluates multiple investment projects and supports decision-making under uncertainty.
Open this prompt Creating · Advanced
Capital Structure Analysis
Use this when you need to evaluate a company's debt-equity mix and its impact on financial performance and risk.
Open this prompt Analysis · Intermediate
Capital Structure Optimization
Use this when you need to design a model that minimizes cost of capital while maximizing shareholder value through optimal debt-equity mix.
Open this prompt Planning · Advanced
Cash Flow Analysis
Use this when you need to assess a company's cash generation, working capital efficiency, and ability to meet obligations.
Open this prompt Analysis · Intermediate
Cash Flow Management Model
Use this when you need to build a model to track and optimize cash inflows, outflows, and liquidity.
Open this prompt Creating · Intermediate
Create Financial Analysis Model
Use this when you need to build a comprehensive model that analyzes financial statements and provides recommendations for improvement.
Open this prompt Creating · Advanced
Develop Financial Forecasting Model
Use this when you need to build a robust forecasting model to predict revenue, expenses, and cash flows, including sensitivity analysis.
Open this prompt Creating · Advanced
Dynamic Sensitivity Analysis Model
Use this when you need a flexible, dynamic model to test multiple variables and scenarios for financial planning and risk assessment.
Open this prompt Creating · Advanced
Financial Risk Management Model
Use this when you need to quantify and manage financial risks by assessing their probability and impact on your business.
Open this prompt Analysis · Advanced
Forecast Future Financial Performance
Use this when you need to predict future revenue, expenses, or profitability based on historical data and market trends.
Open this prompt Writing · Advanced
FP&A Model Development
Use this when you need to build an integrated budgeting, forecasting, and analysis model to support strategic decisions.
Open this prompt Creating · Advanced
M&A Financial Impact Analysis
Use this when you need to evaluate the financial impact, synergies, and risks of a potential merger or acquisition.
Open this prompt Analysis · Advanced
M&A Financial Model Builder
Use this when you need to build a financial model to analyze the implications of a merger, acquisition, or divestiture.
Open this prompt Creating · Advanced
Optimal Pricing Model Design
Use this when you need to develop a pricing strategy that maximizes profitability while considering costs, demand, and competition.
Open this prompt Creating · Intermediate
Portfolio Optimization Strategy
Use this when you need to create a personalized investment portfolio that balances risk and return based on client preferences.
Open this prompt Creating · Intermediate
Scenario Analysis for Financial Planning
Use this when you need to evaluate how different economic, market, or industry scenarios could impact a company's financial performance and strategic decisions.
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 projections and identify which factors have the most influence.
Open this prompt Analysis · Intermediate
Valuation Analysis Using DCF and Comparables
Use this when you need to determine the intrinsic value of a company or investment using multiple valuation methods.
Open this prompt Analysis · Advanced