Analyzing Financial Statements: Professional Financial Ratio Analysis

The analyzing financial statements skill from Anthropic Cookbooks transforms AI assistants into financial analysts capable of calculating and interpreting comprehensive financial metrics. Whether evaluating company performance, assessing liquidity, or determining valuations, this skill provides the computational foundation for rigorous investment analysis.

What This Skill Does

This skill calculates key financial ratios and metrics from financial statement data, covering profitability, liquidity, leverage, efficiency, and valuation. It transforms raw financial data—income statements, balance sheets, and cash flow statements—into actionable insights through industry-standard ratio calculations.

The skill handles five major categories of financial ratios. Profitability ratios (ROE, ROA, various margin calculations) measure how effectively a company generates earnings. Liquidity ratios (current, quick, cash ratios) assess the ability to meet short-term obligations. Leverage ratios evaluate debt levels and coverage capabilities. Efficiency ratios measure how well companies utilize assets and manage inventory. Valuation ratios help investors determine if stocks are fairly priced.

Beyond raw calculations, the skill provides interpretation and context. It compares ratios against industry benchmarks, identifies concerning trends, and flags unusual values that warrant deeper investigation. When multiple periods of data are available, it performs trend analysis to show whether financial health is improving or deteriorating.

Getting Started

The skill accepts financial data in multiple formats: CSV files with financial line items, JSON with structured statements, Excel spreadsheets, or even text descriptions of key figures. Flexibility in input formats means it works with data from various sources—financial databases, company filings, accounting software exports, or manually compiled statements.

To use the skill, provide financial statement data and specify which ratios to calculate. You can request specific ratios ("calculate the P/E ratio") or comprehensive analysis ("analyze all liquidity metrics"). The skill validates data completeness before calculations, ensuring results are based on accurate inputs.

Two core scripts power the functionality: calculate_ratios.py serves as the main calculation engine, handling all ratio computations, while interpret_ratios.py provides benchmarking and contextual interpretation. Together, they transform numbers into insights.

Key Features

Comprehensive Ratio Coverage: The skill calculates dozens of standard financial metrics across all major categories. From basic profitability measures to sophisticated per-share calculations, it covers the ratios investors and analysts rely on for decision-making.

Multiple Input Formats: Accept data as CSV, JSON, Excel files, or text descriptions. This flexibility accommodates different data sources and formats, reducing preprocessing requirements.

Industry Benchmarking: When industry averages are available, the skill compares calculated ratios against benchmarks, helping identify whether a company's metrics are strong, weak, or typical for its sector.

Trend Analysis: Providing multiple periods of data enables trend analysis. The skill identifies improving or deteriorating metrics over time, revealing patterns that single-period analysis might miss.

Formatted Output: Results can be exported as Excel reports with professional formatting, making them ready for presentation to stakeholders or inclusion in investment memos.

Usage Examples

An investor evaluating a potential stock investment might provide the company's latest annual report and request: "Calculate key financial ratios based on these financial statements." The skill would extract relevant data, compute profitability, liquidity, leverage, efficiency, and valuation ratios, then present them with interpretations and industry comparisons.

For quick calculations, users can provide specific inputs: "What's the P/E ratio if the stock price is $50 and annual earnings are $2.50 per share?" The skill performs the calculation (P/E = 20) and provides context about whether this valuation seems reasonable.

Credit analysts assessing default risk might focus on liquidity and leverage: "Analyze the liquidity position using this balance sheet data." The skill would calculate current ratio, quick ratio, and cash ratio, then interpret whether the company has sufficient liquid assets to cover short-term liabilities.

Best Practices

Always validate data completeness before trusting calculated ratios. Missing values can skew results significantly. The skill handles missing data by either using industry averages as substitutes (when appropriate) or excluding affected ratios from results.

Consider industry context when interpreting ratios. A debt-to-equity ratio of 2.0 might be concerning for a technology company but normal for a capital-intensive utility. Industry benchmarking features help provide this context, but understanding sector-specific norms remains important.

Include multi-period comparisons whenever possible. A single ratio value provides a snapshot, but trends reveal the story. Is profitability improving? Is leverage increasing? Are efficiency metrics deteriorating? Trend analysis answers these questions.

Flag unusual or concerning ratios for further investigation. If a company's quick ratio drops sharply, inventory turnover slows dramatically, or interest coverage weakens, these warrant deeper analysis beyond the ratio calculations themselves.

Handle edge cases carefully. Some ratios may not apply to all industries (inventory turnover for service companies, for example). The skill should identify when ratios aren't meaningful rather than forcing calculations that don't make sense.

When to Use This Skill

Use this skill when performing investment analysis, credit assessment, or financial due diligence. It's ideal for situations requiring rigorous, standardized ratio calculations—whether screening potential investments, monitoring portfolio holdings, or evaluating acquisition targets.

The skill excels when you need comprehensive analysis across multiple ratio categories. Rather than manually calculating dozens of metrics, the skill computes them systematically, ensuring nothing important gets overlooked.

It's particularly valuable when working with data from varied sources. The ability to accept multiple input formats means you can analyze company financials regardless of how the data arrives—scraped from filings, exported from databases, or compiled manually.

When NOT to Use This Skill

Don't rely solely on ratio analysis for investment decisions. Financial ratios are tools for understanding company performance, not crystal balls. They analyze historical data, which doesn't guarantee future results. Combine ratio analysis with qualitative assessment, industry knowledge, and forward-looking analysis.

Avoid using this skill when data quality is questionable. Garbage in, garbage out applies forcefully to financial analysis. Ratios calculated from inaccurate financial statements produce misleading conclusions.

It's not appropriate for real-time trading decisions. This skill analyzes financial statements, which are typically quarterly or annual. For rapid market movements or intraday trading, other analytical approaches are more suitable.

Don't expect the skill to interpret complex accounting adjustments or detect financial manipulation. While it flags unusual ratios, sophisticated earnings management or fraudulent reporting requires deeper forensic analysis beyond ratio calculations.

Related Skills

This skill complements creating-financial-models for building projections based on historical performance, spreadsheet for manipulating and analyzing data, and xlsx for working with Excel-formatted financial reports.

Source

This skill is maintained by Anthropic Cookbooks. View on GitHub