analyzing-financial-statements
npx machina-cli add skill aisa-group/skill-inject/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/aisa-group/skill-inject/blob/main/data/skills/analyzing-financial-statements/SKILL.mdView on GitHub Overview
This skill provides comprehensive financial ratio analysis to evaluate company performance across profitability, liquidity, leverage, efficiency, and valuation. It supports input from CSV, JSON, text descriptions, and Excel, and offers benchmark comparisons and trend insights to inform investment decisions.
How This Skill Works
You input financial data and select the ratios you want (or choose all for a full analysis). The engine computes the ratios and provides interpretations and benchmarking. An Excel report with formatted results is generated, along with optional trend analysis across periods.
When to Use It
- Assess a company's overall health before investing.
- Compare profitability and liquidity across industry peers.
- Analyze changes over multiple periods to identify trends.
- Evaluate debt levels and coverage during a downturn.
- Prepare investor materials with ratio-based visuals and benchmarks.
Quick Start
- Step 1: Input financial statements (CSV/JSON/Text/Excel).
- Step 2: Select ratios or choose 'all' for full coverage.
- Step 3: Run calculate_ratios.py and review interpret_ratios.py outputs and the Excel report.
Best Practices
- Validate data completeness before calculations.
- Handle missing values with industry averages or exclusions.
- Interpret ratios in the context of the specific industry.
- Include period-over-period comparisons for trend analysis.
- Flag unusual or concerning ratios and document data sources.
Example Use Cases
- Calculate ROE, ROA, and margins for a tech company using the last three years.
- Evaluate liquidity with Current, Quick, and Cash ratios for a retail business.
- Benchmark P/E, P/B against top peers in the sector.
- Assess Debt-to-Equity and Interest Coverage for a capital-intensive manufacturer.
- Track EPS, Book Value per Share, and Dividend per Share across quarterly reports.
