Analyzing 金融 Sta
- 作者仓库星标 44,893
- 作者仓库 claude-cookbooks
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
- 流狐分类
- 数据
- 作者声明 Agent
- 未找到明确声明；不据此推断已兼容或已测试
- 静态检查
- 85 / 100 · 启发式扫描，不代表运行安全
- 作者 / 版本 / 许可
- @anthropics · 未声明 license
- 流狐 Token 估算
- 低消耗
- 流狐接入估算
- 即装即用
- 是否需要外部 API Key
- 未发现要求
- 检测到的系统要求
- 未声明
- 底层运行要求
- 未声明
- 检测到的文件与系统行为
-
- 只读
- 检测到的网络行为
- 仅限本地
- 安装命令数
- 无（仅作为资料）
档案由构建时根据 SKILL.md 与安装命令自动衍生，可能与作者实际意图存在差异。
需要注意： 未限定 allowed-tools，默认拥有全部工具权限。；上游仓库已 190 天未更新，可能与最新 agent 行为不一致。
作者没有在当前 SKILL.md 中定义固定输出样例。Calculate and interpret: Profitability Ratios: ROE, ROA, Gross Margin, Operating Margin, Net Margin Liquidity Ratios: Current Ratio, Quick Ratio, Cash Ratio
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…
Financial data can be provided as: CSV with financial line items JSON with structured financial statements
Results include: Calculated ratios with values Industry benchmark comparisons (when available)
"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"
calculateratios.py: Main calculation engine for all financial ratios interpretratios.py: Provides interpretation and benchmarking
# 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
…作者原文负责流程事实；流狐只索引当前章节、要点、文件与命令。
章节 -> Capabilities → How to Use → Input Format → Output Format → Example Usage → Scripts
要点 -> Profitability Ratios · Liquidity Ratios · Leverage Ratios · Efficiency Ratios · Valuation Ratios · Per-Share Metrics · Input Data · Select Ratios
文件/命令 -> calculateratios.py · interpretratios.py · P/E · P/B · P/S · EV/EBITDA
内容 SHA-256 -> 2730813d37ea
原文结构
适用与边界
原文中的明确线索
calculateratios.py、interpretratios.py、P/E、P/B、P/S、EV/EBITDA