这个技能能做什么
Capabilities- 计算盈利能力比率（ROE、ROA、毛利率等）
- 计算流动性和杠杆比率（流动比率、速动比率、债务权益比等）
- 计算效率和估值比率（资产周转率、P/E、EV/EBITDA等）
- 提供比率解读和行业基准比较
- 支持趋势分析并生成Excel报告
触发与调用
Trigger在对话中 @mention 以下触发词，技能内容会即时注入当前上下文；智能体挂载后也会在命中场景时自动调用。
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?
技能定义
Definition技能是 Markdown + frontmatter 的纯文本资产，可版本化、可 Review、可跨智能体复用。
--- 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 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 - `interpret_ratios.py`: Provides interpretation and benchmarking ## Best Practices 1. Always validate data completeness before calculations 2. Handle missing values appropriately (use industry averages or exclude) 3. Consider industry context when interpreting ratios 4. Include period comparisons for trend analysis 5. 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