analyzing-financial-statements
npx machina-cli add skill Microck/ordinary-claude-skills/analyzing-financial-statements --openclawFinancial 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
- Input Data: Provide financial statement data (income statement, balance sheet, cash flow)
- Select Ratios: Specify which ratios to calculate or use "all" for comprehensive analysis
- 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 ratiosinterpret_ratios.py: Provides interpretation and benchmarking
Best Practices
- Always validate data completeness before calculations
- Handle missing values appropriately (use industry averages or exclude)
- Consider industry context when interpreting ratios
- Include period comparisons for trend analysis
- 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
Source
git clone https://github.com/Microck/ordinary-claude-skills/blob/main/skills_all/analyzing-financial-statements/SKILL.mdView on GitHub Overview
This skill computes profitability, liquidity, leverage, efficiency, valuation ratios, and per-share metrics from financial statements to aid investment decisions. It supports input as CSV, JSON, text, or Excel and can provide benchmarks, trends, and an Excel report when available.
How This Skill Works
The core engine calculate_ratios.py computes the requested ratios, while interpret_ratios.py adds industry benchmarks and interpretations. You provide financial data, select specific ratios (or use 'all'), and receive calculated values along with insights and an optional formatted Excel report.
When to Use It
- You have company financial statements and need a snapshot of profitability, liquidity, leverage, efficiency, and valuation ratios for investment decisions.
- You want to assess a company's ability to meet short-term obligations before investing by analyzing liquidity.
- You compare multiple companies or industries using standardized ratios against benchmarks.
- You perform trend analysis by inputting data from multiple periods.
- You need an Excel report with ratios and interpretations for stakeholder presentations.
Quick Start
- Step 1: Input financial data via CSV, JSON, plain text, or Excel
- Step 2: Choose specific ratios or select 'all' for a full analysis
- Step 3: Run the analyzer to review calculated ratios, interpretations, benchmarks, and the Excel report
Best Practices
- Always validate data completeness before calculations
- Handle missing values appropriately (use industry averages or exclude)
- Consider industry context when interpreting ratios
- Include period comparisons for trend analysis
- Flag unusual or concerning ratios
Example Use Cases
- Compute P/E, P/B, P/S, and EV/EBITDA to rank peers for investment screening
- Calculate current ratio, quick ratio, and cash ratio to assess liquidity from the balance sheet
- Analyze ROE, ROA, and gross/operating/net margins to gauge profitability
- Evaluate debt-to-equity and interest coverage to understand leverage and solvency
- Derive EPS, book value per share, and dividend per share to support per-share valuations
