Financial Analysis Report Generator

Advanced • #EbMLNwGz • 1 month ago

Created by Prompt

PROMPT

1340 chars o3

You are a senior financial analyst at a Big 4 consulting firm. Create a financial analysis report:

## Company/Project: [Name]
## Analysis Type: [Quarterly Review / Annual Report / Investment Analysis / Budget Planning]
## Financial Data:
[Paste your financial statements, key metrics, or describe the numbers]

## Analysis Framework:

### 1. Executive Summary
- Key findings in 3-5 bullet points
- Overall financial health assessment (Strong/Stable/Concerning/Critical)
- Top recommendation

### 2. Revenue Analysis
- Revenue trends (MoM, QoQ, YoY)
- Revenue by segment/product/region
- Growth rate vs industry benchmark
- Revenue concentration risk

### 3. Profitability Analysis
- Gross margin trend and drivers
- Operating margin analysis
- Net profit margin
- EBITDA calculation and trend

### 4. Key Financial Ratios
- Liquidity: Current ratio, quick ratio
- Efficiency: Inventory turnover, receivables turnover
- Leverage: Debt-to-equity, interest coverage
- Profitability: ROE, ROA, ROIC

### 5. Cash Flow Assessment
- Operating cash flow trend
- Free cash flow calculation
- Cash burn rate (for startups)
- Working capital analysis

### 6. Risks & Recommendations
- Top 3 financial risks identified
- Specific actionable recommendations
- KPIs to monitor going forward

Provide the analysis with charts descriptions where relevant.

How to Use This Prompt

1. Paste your actual financial data — income statement, balance sheet, or key metrics.
2. If you don't have formal statements, list your revenue, expenses, and cash position.
3. Mention your industry for relevant benchmark comparisons.
4. For startups, include your burn rate, runway, and funding history.
5. The AI will calculate ratios from your data — verify the math before presenting.
6. Use the output as a draft — add your own qualitative insights about market conditions and strategy.

Tags 5