analyzing-financial-statements

lladdy's avatarfrom lladdy

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

⭐2stars🔀0forks📁View on GitHub🕐Updated Oct 22, 2025⬇️1downloads

When & Why to Use This Skill

This Claude skill automates the calculation and interpretation of essential financial ratios and metrics from corporate financial statements. It streamlines investment analysis by providing deep insights into a company's profitability, liquidity, leverage, and valuation, helping users make data-driven financial decisions with speed and accuracy.

Use Cases

  • Investment Analysis: Quickly evaluate a company's valuation and growth potential using P/E, EV/EBITDA, and PEG ratios from earnings reports.
  • Credit Risk Assessment: Determine a business's financial stability and solvency by calculating liquidity ratios like the Quick Ratio and leverage ratios like Debt-to-Equity.
  • Operational Performance Benchmarking: Analyze efficiency metrics such as Inventory Turnover and Asset Turnover to compare company performance against industry standards.
  • Financial Reporting: Generate comprehensive summaries of financial health including ROE, ROA, and profit margins for stakeholder presentations or internal reviews.
nameAnalyzing Financial Statements
descriptionThis skill calculates key financial ratios and metrics from financial statement data for investment analysis

Financial Ratio Calculator Skill

This skill provides comprehensive financial ratio analysis for evaluating company performance, profitability, liquidity, and valuation.

Capabilities

Calculate and interpret:

  • Profitability Ratios: ROE, ROA, Gross Margin, Operating Margin, Net Margin
  • Liquidity Ratios: Current Ratio, Quick Ratio, Cash Ratio
  • Leverage Ratios: Debt-to-Equity, Interest Coverage, Debt Service Coverage
  • Efficiency Ratios: Asset Turnover, Inventory Turnover, Receivables Turnover
  • Valuation Ratios: P/E, P/B, P/S, EV/EBITDA, PEG
  • Per-Share Metrics: EPS, Book Value per Share, Dividend per Share

How to Use

  1. Input Data: Provide financial statement data (income statement, balance sheet, cash flow)
  2. Select Ratios: Specify which ratios to calculate or use "all" for comprehensive analysis
  3. Interpretation: The skill will calculate ratios and provide industry-standard interpretations

Input Format

Financial data can be provided as:

  • CSV with financial line items
  • JSON with structured financial statements
  • Text description of key financial figures
  • Excel files with financial statements

Output Format

Results include:

  • Calculated ratios with values
  • Industry benchmark comparisons (when available)
  • Trend analysis (if multiple periods provided)
  • Interpretation and insights
  • Excel report with formatted results

Example Usage

"Calculate key financial ratios for this company based on the attached financial statements"

"What's the P/E ratio if the stock price is $50 and annual earnings are $2.50 per share?"

"Analyze the liquidity position using the balance sheet data"

Scripts

  • calculate_ratios.py: Main calculation engine for all financial ratios
  • interpret_ratios.py: Provides interpretation and benchmarking

Best Practices

  1. Always validate data completeness before calculations
  2. Handle missing values appropriately (use industry averages or exclude)
  3. Consider industry context when interpreting ratios
  4. Include period comparisons for trend analysis
  5. Flag unusual or concerning ratios

Limitations

  • Requires accurate financial data
  • Industry benchmarks are general guidelines
  • Some ratios may not apply to all industries
  • Historical data doesn't guarantee future performance