Agent Skills
› Microck/ordinary-claude-skills
› analyzing-financial-statements
analyzing-financial-statements
GitHub计算并解读关键财务比率，支持盈利能力、流动性等分析。输入财务报表数据，输出比值、基准对比及洞察，辅助投资决策。
Trigger Scenarios
用户请求计算财务比率
提供财务报表进行投资分析
询问特定财务指标如PE或流动比率
Install
npx skills add Microck/ordinary-claude-skills --skill analyzing-financial-statements -g -y
SKILL.md
Frontmatter
{
"name": "analyzing-financial-statements",
"description": "This skill calculates key financial ratios and metrics from financial statement data for investment analysis"
}
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
Version History
- 1056d29 Current 2026-07-24 18:11
