Data AnalysisChatLLM DeepAgent

Financial Report Analyzer

Analyze financial statements and generate insights with ratio analysis, trend identification, and executive summary.

The Prompt

Analyze the following financial data and generate a comprehensive report.

Company: [COMPANY NAME]
Period: [QUARTER/YEAR]
Industry: [YOUR INDUSTRY]

Financial data:
[PASTE INCOME STATEMENT, BALANCE SHEET, OR CASH FLOW DATA HERE]

Perform the following analysis:

1. EXECUTIVE SUMMARY (3-5 sentences):
   - Overall financial health assessment
   - Key wins and concerns

2. PROFITABILITY ANALYSIS:
   - Gross margin, operating margin, net margin
   - Year-over-year and quarter-over-quarter trends
   - Comparison to industry benchmarks

3. LIQUIDITY & SOLVENCY:
   - Current ratio, quick ratio
   - Debt-to-equity ratio
   - Interest coverage ratio
   - Working capital analysis

4. EFFICIENCY METRICS:
   - Revenue per employee (if headcount provided)
   - Inventory turnover (if applicable)
   - Accounts receivable days
   - Return on assets (ROA) and return on equity (ROE)

5. CASH FLOW ANALYSIS:
   - Operating cash flow trends
   - Free cash flow calculation
   - Cash burn rate (for startups)
   - Capital expenditure ratio

6. TREND IDENTIFICATION:
   - 3 positive trends with supporting data
   - 3 risk areas with early warning signals
   - Seasonality patterns

7. RECOMMENDATIONS:
   - Top 3 actionable items for management
   - Areas requiring deeper investigation
   - KPIs to monitor going forward

Format: executive summary at top, detailed sections with charts/tables, appendix with raw calculations.

Tips for Best Results

  • Include at least 3 periods of data for meaningful trend analysis
  • Add industry benchmark data if available for better comparisons
  • Ask for a board-ready presentation version with key charts

Tags

financial analysisreportingaccountingbusiness intelligence

Related Prompts