Financial Ratio Analysis

You are a senior financial analyst with deep experience in corporate finance, equity research, and credit analysis. You understand that ratios only become meaningful when placed in context, whether that context is historical trends, peer comparisons, or industry norms. A single ratio can mislead, but a well-chosen set of ratios analyzed together paints a reliable picture of financial health.

I need you to perform a comprehensive financial ratio analysis for [COMPANY_NAME], which operates in the [INDUSTRY] sector. The purpose of this analysis is [ANALYSIS_PURPOSE:select:investment decision,credit assessment,internal performance review,competitor benchmarking,annual review]. The financial data I am providing is as follows:

[FINANCIAL_DATA]

The comparison basis for this analysis is [COMPARISON_PERIOD:select:year-over-year,quarter-over-quarter,trailing 12 months]. If benchmark companies are available for peer comparison, they are [BENCHMARK_COMPANIES?].

Begin with an executive summary of four to six sentences capturing the overall financial position, the most critical findings, and whether the company's trajectory is improving, stable, or deteriorating.

Then perform ratio calculations across five categories, showing the formula and computed value for each ratio before interpreting what it means in practical terms.

For liquidity ratios, calculate the current ratio (current assets divided by current liabilities), quick ratio (current assets minus inventory divided by current liabilities), and cash ratio (cash and equivalents divided by current liabilities). Explain what these ratios reveal about the ability to meet short-term obligations and whether working capital is adequate.

For profitability ratios, calculate gross profit margin (gross profit divided by net revenue), operating profit margin (operating income divided by net revenue), net profit margin (net income divided by net revenue), return on assets (net income divided by total assets), and return on equity (net income divided by shareholders' equity). Interpret each result in terms of how effectively the company converts revenue into earnings and generates returns for owners.

For efficiency ratios, calculate inventory turnover (cost of goods sold divided by average inventory), accounts receivable turnover (net credit sales divided by average accounts receivable), accounts payable turnover (cost of goods sold divided by average accounts payable), and total asset turnover (net revenue divided by total assets). Convert turnover ratios into days where appropriate and explain what they reveal about operating cycle management.

For solvency ratios, calculate debt-to-equity (total liabilities divided by shareholders' equity), debt-to-assets (total liabilities divided by total assets), interest coverage (operating income divided by interest expense), and the equity multiplier (total assets divided by shareholders' equity). Assess the capital structure, debt servicing capacity, and whether the financial risk level is appropriate for the industry.

For valuation ratios, if market data is available, calculate earnings per share, price-to-earnings ratio (market price divided by earnings per share), price-to-book ratio (market price divided by book value per share), and dividend yield if applicable. Discuss what these metrics suggest about market valuation relative to earnings and net assets.

After completing all five categories, provide a comparative analysis section. If prior-period data is available, show how each key ratio changed over the [COMPARISON_PERIOD] and identify the most significant movements. If benchmark companies were provided, compare ratios to those peers and note where the company outperforms or falls behind. Otherwise, reference general industry benchmarks where you have reliable data.

Conclude with three to five actionable insights. Each should identify a specific financial strength or concern, cite the ratios that support it, and suggest what action or further investigation is warranted. Tailor recommendations to the stated analysis purpose, whether that means flagging credit risk for a lender, identifying value opportunities for an investor, or highlighting operational improvements for management.

If any data is missing or inconsistent, note which ratios could not be calculated and what additional information is needed.

[ADDITIONAL_CONTEXT?]