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