Financial Analysis of a listed Company Prompt


Problem

This prompt helps automate and streamline the financial analysis of a company by converting raw financial statements into a structured, insightful, and comprehensive analytical report. It solves the need for detailed evaluation of revenue trends, profitability, financial ratios, cash-flow strength, leverage, solvency, operational efficiency, growth outlook, and business risks. It assists in identifying financial strengths, weaknesses, strategic opportunities, potential risks, and overall financial health for internal management, valuation, decision-making, or advisory purposes.

Prompt Input

Perform a Comprehensive Financial Analysis of [Company/Entity Name] Conduct a detailed financial analysis of [Company/Entity Name], using the most recent financial data, performance indicators, and strategic insights. Your analysis should include the following sections: Financial Performance Review Core Financial Metrics Revenue Analysis – YOY & QOQ performance, revenue drivers Profitability Assessment – Gross profit, operating profit, net profit trends Earnings Quality – EPS trends (if applicable), earnings consistency Leverage & Solvency – Debt-to-equity, interest coverage, borrowing trends Cash Flow Evaluation – Operating cash flow strength, free cash flow sustainability Financial Ratios & Valuation Indicators Liquidity Ratios – Current ratio, quick ratio for short-term health Profitability Ratios – ROE, ROA, ROCE Efficiency Ratios – Asset turnover, inventory turnover, working capital cycle Valuation Ratios (if applicable) – P/E, P/B, EV/EBITDA, price-to-sales Growth Outlook & Strategic Position Growth Potential – Revenue and profit outlook based on current trajectory Competitive Positioning – Strengths vs competitors, market presence Innovation & Investments – Capex, R&D spending, technological advancements Management Evaluation – Leadership quality, governance standards Risk Assessment Market & Economic Risks – Inflation, interest rates, global uncertainty Operational Risks – Raw material risks, supply chain, labour issues Financial Risks – Liquidity risk, debt repayment capability, credit exposure Recent Developments & Key Catalysts Latest Financial Results – Performance vs expectations Partnerships, Investments & Deals – M&A, strategic alliances Regulatory or Policy Updates – Any changes impacting financial standing

Prompt Output

The prompt generates the following outputs: Detailed financial performance review (revenue, profitability, margins) Cash-flow analysis including operating, investing, and financing trends Liquidity, solvency, profitability, and efficiency ratio calculations Valuation indicators (P/E, P/B, EV/EBITDA, etc., if applicable) Growth outlook and strategic positioning assessment Competitive and managerial evaluation Comprehensive risk assessment (market, financial, operational risks) Summary of recent developments and key performance catalysts Final structured financial analysis report with insights and recommendations

LLM Name: ChatGPT