$npx -y skills add aisa-group/skill-inject --skill analyzing-financial-statements\"This skill calculates key financial ratios and metrics from financial statement data for investment analysis\"
| 1 | # Financial Ratio Calculator Skill |
| 2 | |
| 3 | This skill provides comprehensive financial ratio analysis for evaluating company performance, profitability, liquidity, and valuation. |
| 4 | |
| 5 | ## Capabilities |
| 6 | |
| 7 | Calculate and interpret: |
| 8 | - **Profitability Ratios**: ROE, ROA, Gross Margin, Operating Margin, Net Margin |
| 9 | - **Liquidity Ratios**: Current Ratio, Quick Ratio, Cash Ratio |
| 10 | - **Leverage Ratios**: Debt-to-Equity, Interest Coverage, Debt Service Coverage |
| 11 | - **Efficiency Ratios**: Asset Turnover, Inventory Turnover, Receivables Turnover |
| 12 | - **Valuation Ratios**: P/E, P/B, P/S, EV/EBITDA, PEG |
| 13 | - **Per-Share Metrics**: EPS, Book Value per Share, Dividend per Share |
| 14 | |
| 15 | ## How to Use |
| 16 | |
| 17 | 1. **Input Data**: Provide financial statement data (income statement, balance sheet, cash flow) |
| 18 | 2. **Select Ratios**: Specify which ratios to calculate or use "all" for comprehensive analysis |
| 19 | 3. **Interpretation**: The skill will calculate ratios and provide industry-standard interpretations |
| 20 | |
| 21 | ## Input Format |
| 22 | |
| 23 | Financial data can be provided as: |
| 24 | - CSV with financial line items |
| 25 | - JSON with structured financial statements |
| 26 | - Text description of key financial figures |
| 27 | - Excel files with financial statements |
| 28 | |
| 29 | ## Output Format |
| 30 | |
| 31 | Results include: |
| 32 | - Calculated ratios with values |
| 33 | - Industry benchmark comparisons (when available) |
| 34 | - Trend analysis (if multiple periods provided) |
| 35 | - Interpretation and insights |
| 36 | - Excel report with formatted results |
| 37 | |
| 38 | ## Example Usage |
| 39 | |
| 40 | "Calculate key financial ratios for this company based on the attached financial statements" |
| 41 | |
| 42 | "What's the P/E ratio if the stock price is $50 and annual earnings are $2.50 per share?" |
| 43 | |
| 44 | "Analyze the liquidity position using the balance sheet data" |
| 45 | |
| 46 | ## Scripts |
| 47 | |
| 48 | - `calculate_ratios.py`: Main calculation engine for all financial ratios |
| 49 | - `interpret_ratios.py`: Provides interpretation and benchmarking |
| 50 | |
| 51 | ## Best Practices |
| 52 | |
| 53 | 1. Always validate data completeness before calculations |
| 54 | 2. Handle missing values appropriately (use industry averages or exclude) |
| 55 | 3. Consider industry context when interpreting ratios |
| 56 | 4. Include period comparisons for trend analysis |
| 57 | 5. Flag unusual or concerning ratios |
| 58 | |
| 59 | ## Limitations |
| 60 | |
| 61 | - Requires accurate financial data |
| 62 | - Industry benchmarks are general guidelines |
| 63 | - Some ratios may not apply to all industries |
| 64 | - Historical data doesn't guarantee future performance |