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)
- 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 ratios - INLINECODE1 : Provides interpretation and benchmarking
Best Practices
- 1. 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
财务报表比率计算技能
本技能提供全面的财务报表比率分析，用于评估公司业绩、盈利能力、流动性和估值。
功能
计算并解读：
- - 盈利能力比率：净资产收益率、总资产收益率、毛利率、营业利润率、净利润率
- 流动性比率：流动比率、速动比率、现金比率
- 杠杆比率：资产负债率、利息保障倍数、偿债覆盖率
- 效率比率：资产周转率、存货周转率、应收账款周转率
- 估值比率：市盈率、市净率、市销率、企业价值倍数、市盈增长比率
- 每股指标：每股收益、每股账面价值、每股股息
使用方法
- 1. 输入数据：提供财务报表数据（利润表、资产负债表、现金流量表）
- 选择比率：指定需要计算的比率，或使用全部进行全面分析
- 解读结果：技能将计算比率并提供行业标准解读
输入格式
财务数据可通过以下方式提供：
- - 包含财务项目的CSV文件
- 结构化财务报表的JSON格式
- 关键财务数据的文本描述
- 包含财务报表的Excel文件
输出格式
结果包括：
- - 计算出的比率及其数值
- 行业基准对比（如可用）
- 趋势分析（如提供多个期间数据）
- 解读与分析洞察
- 格式化的Excel报告
使用示例
根据附带的财务报表计算该公司的关键财务比率
如果股价为50美元，每股年收益为2.50美元，市盈率是多少？
利用资产负债表数据分析流动性状况
脚本
- - calculateratios.py：所有财务比率的主要计算引擎
- interpretratios.py：提供解读和基准对比
最佳实践
- 1. 计算前务必验证数据完整性
- 适当处理缺失值（使用行业平均值或排除）
- 解读比率时考虑行业背景
- 包含期间对比以进行趋势分析
- 标记异常或令人担忧的比率
局限性
- - 需要准确的财务数据
- 行业基准仅为一般性指导
- 部分比率可能不适用于所有行业
- 历史数据不能保证未来表现
