Financial Analysis of Small Company (unlisted), Individual Client or Firm
Problem
This prompt solves the problem of manually interpreting and analysing a company’s financial performance using raw financial statements. It automates evaluation of revenue trends, profitability, cash flow strength, leverage, solvency, and key financial ratios. It helps identify financial strengths, weaknesses, efficiency levels, and risk areas, and provides a structured and comprehensive financial analysis based on the attached data. The prompt supports decision-making, internal management review, and business advisory by converting unprocessed financial data into actionable insights.
Prompt Input
Conduct a detailed financial analysis of [Company/Entity Name], using the attached financial data. Conduct a detailed financial analysis of [Company/Entity Name], using the attached financial statements provided, internal performance indicators, and management notes. Your analysis should include the following sections: Financial Performance Review Core Financial Metrics • Revenue Analysis – Year-over-Year and Quarter-over-Quarter trends, key revenue drivers • Profitability Assessment – Gross profit, operating profit, net profit trends • Earnings Quality – Consistency of earnings, recurring vs non-recurring items • Leverage & Solvency – Debt levels, interest burden, repayment capacity • Cash Flow Evaluation – Operating cash flow strength, free cash flow, working-capital movements Financial Ratios & Valuation Indicators • Liquidity Ratios – Current ratio, quick ratio • Profitability Ratios – ROE, ROA, gross margin, EBITDA margin, net margin • Efficiency Ratios – Asset turnover, receivable days, payable days, inventory days, working capital cycle • Valuation Ratios (if applicable) – Use only internal valuation measures if provided (e.g., EV/EBITDA based on internal valuations; omit market-based ratios like P/E if not applicable)
Prompt Output
The prompt generates the following outputs: Revenue analysis (YoY/QoQ), key revenue drivers Profitability analysis: gross margin, operating margin, net profit trends Earnings quality assessment (recurring vs non-recurring items) Leverage and solvency review: debt levels, interest burden, repayment capacity Cash-flow analysis: operating cash flow, free cash flow, working-capital movements Liquidity ratios (current ratio, quick ratio) Profitability ratios (ROE, ROA, gross margin, EBITDA margin, net margin) Efficiency ratios (asset turnover, receivable days, payable days, inventory days, working-capital cycle) Internal valuation indicators (EV/EBITDA or similar, if data available) A structured, comprehensive financial analysis report with insights and findings