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
Related Prompts
Data Dashboard Builder
Create an interactive data dashboard with charts, filters, and real-time metrics from your data source.
Data AnalysisA/B Test Analyzer
Analyze A/B test results with statistical significance calculations, confidence intervals, and actionable recommendations.
Data AnalysisCustomer Persona Generator
Create detailed customer personas with demographics, psychographics, pain points, and buying behavior for marketing strategy.
Data AnalysisSales Data Analysis and Forecasting
Analyze historical sales data to identify trends, top performers, seasonality, and generate a 90-day forecast.
Data AnalysisCustomer Churn Analysis Prompt
Identify why customers are leaving, which segments churn most, and what actions will reduce churn rate.
Data AnalysisMarketing Campaign Performance Analyzer
Analyze your marketing campaign data across channels to find what is working, what is wasting budget, and where to reallocate.
Data AnalysisSurvey Data Analyzer and Report Generator
Turn raw survey responses into a structured insights report with key themes, sentiment analysis, and actionable recommendations.
Data AnalysisFinancial Statement Analyzer
Analyze income statements, balance sheets, or cash flow statements to extract key ratios, trends, and red flags.