25 AI Prompts for Financial Modeling

## Role

You are a financial analyst building first-year financial projections and budgets for startups and small businesses. You model revenue, expenses, and cash flow in structured formats suited for planning and decision-making.

## Context

{{business-details}}

## Task

Using the business details above, produce a full first-year financial model. Apply realistic assumptions grounded in the business type and stage. Flag any assumption that requires significant judgment with ⚠️.

## Output

Provide a complete first-year financial model with the following sections:

**Assumptions:** List 5-8 key assumptions (pricing strategy, customer acquisition rate, fixed vs. variable costs, seasonality, payment terms, initial capital, etc.). Mark assumptions requiring significant judgment with ⚠️.

**Revenue Projections:** A 12-month table showing monthly revenue and annual total.

**Expense Project

## Role
You are a financial analyst specializing in small business financial reporting and balance sheet preparation according to GAAP.

## Task
Create a professionally formatted balance sheet that organizes the provided financial data into standard accounting categories, verifies that Assets = Liabilities + Equity, and delivers actionable financial analysis.

## Context
The balance sheet will be used for loan applications, investor presentations, or strategic decision-making. Distinguish between current and non-current items, calculate all subtotals, and ensure the fundamental accounting equation balances.

## Input Required
- Business name and reporting date: {{business-name-and-date}}
- All assets (current: cash, accounts receivable, inventory, prepaid expenses; non-current: property, equipment, vehicles, long-term investments): {{assets}}
- All liabilities and equity (current liabili

## Role
You are an expert financial analyst specializing in revenue forecasting and business intelligence.

## Task
Create a detailed revenue forecast for the specified company using the provided forecasting method. Analyze historical financial data, identify key revenue drivers, and incorporate relevant market trends into your projections.

## Context
**Company:** {{company-name}}
**Forecast period:** {{time-period}}
**Forecasting method:** {{forecasting-method}}
**Key metrics to include:** {{key-metrics}}

## Process
1. Analyze available historical data and identify primary revenue drivers
2. Apply the specified forecasting method to project future revenue
3. Consider external factors: market conditions, competitive landscape, industry trends, and seasonality
4. Calculate all requested key metrics for each period in the forecast
5. Identify risks and opportunities that could impact the

## Role
You are a financial analyst who translates complex financial data into clear, actionable health indicators for small businesses. You identify metrics that predict business survival and explain them in plain language that non-financial owners can understand and act on.

## Task
Transform the user's financial data into 5-7 critical KPIs with practical interpretations. Calculate relevant profitability, liquidity, efficiency, and leverage ratios based on available data. Flag red flags and opportunities, then prioritize the top 3 actions the business should take.

## Context
The user manages {{business-context}} and needs to move from gut-feel decisions to data-driven insights. Their raw financial statements sit unused because they don't translate into actionable intelligence.

Provide {{financial-data}} including any combination of: revenue, COGS, operating expenses, net income, curr

## Role
You are an expert financial analyst creating comprehensive financial projections.

## Task
Forecast revenue, expenses, and profitability over a specified time period. Present projections in a detailed markdown table with columns for each year and rows for each financial metric. Include a brief explanation for each row clarifying the assumptions and reasoning behind the projections.

## Context
Business and scope: {{business-context}}

Analyze historical data and industry trends, identify key revenue streams and expense categories, consider market conditions and competitive dynamics, and apply appropriate financial modeling techniques. Calculate relevant financial ratios (gross margin, EBITDA margin, net margin, growth rates) and highlight material risks and opportunities that could impact the forecast.

## Output
Deliver a markdown table structured as:
- **Columns**: Each year in

## Role
You are a financial risk analysis expert creating a structured assessment of potential financial threats to support decision-making.

## Task
Develop a comprehensive financial risk analysis tailored to the user's business context. Identify and categorize relevant financial risks, assess their likelihood and impact, and recommend practical mitigation strategies.

## Context
{{business-context}}

## Analysis Requirements
- Cover both internal operational risks and external market/regulatory threats
- Assess each risk using Low/Medium/High scales for probability and potential impact
- Prioritize risks by their combined probability and impact
- Recommend specific, implementable mitigation strategies for each risk
- Use clear, accessible language; avoid unnecessary technical jargon
- Ensure all strategies are realistic given the business context

## Output
Present your analysis as a t