Back to Details

analyzing-financial-statements

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Financial Ratio Calculator Skill

财务比率计算器Skill

This skill provides comprehensive financial ratio analysis for evaluating company performance, profitability, liquidity, and valuation.
该Skill提供全面的财务比率分析，用于评估公司的业绩、盈利能力、流动性和估值。

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
计算并解读：
  • 盈利能力比率：ROE、ROA、毛利率、营业利润率、净利润率
  • 流动性比率：流动比率、速动比率、现金比率
  • 杠杆比率：债务权益比、利息保障倍数、债务偿还保障倍数
  • 效率比率：资产周转率、存货周转率、应收账款周转率
  • 估值比率：P/E、P/B、P/S、EV/EBITDA、PEG
  • 每股指标：EPS、每股账面价值、每股股息

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
  1. 输入数据：提供财务报表数据（利润表、资产负债表、现金流量表）
  2. 选择比率：指定要计算的比率，或使用“全部”进行全面分析
  3. 解读：该Skill将计算比率并提供行业标准解读

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
财务数据可通过以下形式提供：
  • 包含财务项目的CSV文件
  • 结构化财务报表的JSON数据
  • 关键财务数据的文字描述
  • 包含财务报表的Excel文件

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
结果包括：
  • 计算得出的比率及对应数值
  • 行业基准对比（若有数据）
  • 趋势分析（若提供多个期间的数据）
  • 解读与洞察
  • 带有格式化结果的Excel报告

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"
“根据附件中的财务报表计算该公司的关键财务比率”
“若股价为50美元，年每股收益为2.50美元，那么P/E比率是多少？”
“使用资产负债表数据分析流动性状况”

Scripts

脚本

  • calculate_ratios.py
    : Main calculation engine for all financial ratios
  • interpret_ratios.py
    : Provides interpretation and benchmarking
  • calculate_ratios.py
    ：所有财务比率的主计算引擎
  • interpret_ratios.py
    ：提供解读与基准对比

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
  1. 计算前务必验证数据的完整性
  2. 妥善处理缺失值（使用行业平均值或排除）
  3. 解读比率时需结合行业背景
  4. 包含期间对比以进行趋势分析
  5. 标记异常或值得关注的比率

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
  • 需要准确的财务数据
  • 行业基准仅为通用指南
  • 部分比率可能不适用于所有行业
  • 历史数据无法保证未来业绩