跳到正文
cccskills
Claude 官方免费在 GitHub 公开

analyzing-financial-statements

Calculate financial ratios from company statements to assess profitability, ability to cover obligations, efficiency, and valuation. Results include explanations, comparisons across periods, available industry benchmarks, and a formatted Excel report.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

anthropics/claude-cookbooks
集成工具Excel
查看安装方法

适用场景

  • Comparing profitability across reporting periods
  • Assessing ability to cover short-term obligations
  • Calculating valuation ratios for investment analysis
  • Preparing an Excel report of financial ratios

包含的文件（3）

  • SKILL.md2.4 KB
  • calculate_ratios.py12.6 KB
  • interpret_ratios.py16.1 KB

SKILL.md（原文）

安装前可以查看交给 AI 代理的指令内容。

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

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护，适用 Google 的隐私权政策和服务条款。

同一仓库的技能

applying-brand-guidelines

Claude 官方免费

Apply corporate brand standards to PowerPoint, Excel, and PDF documents. The skill guides colors, fonts, layouts, logo placement, and writing style, with scripts for applying formatting and checking compliance.

中文简介正在准备中。当前显示英语简介。

  • Creating presentations with consistent corporate branding
  • Standardizing spreadsheet tables and charts
  • Checking PDF layouts and writing style
anthropics/claude-cookbooks5.4万2026年10月17日 更新

cookbook-audit

Claude 官方免费

Review an Anthropic Cookbook notebook for clear explanations, code quality, technical accuracy, and practical usefulness. It combines automated checks, including exposed credential detection, with a scored report and specific recommendations tied to sections and lines.

中文简介正在准备中。当前显示英语简介。

  • Review a Cookbook notebook before publication
  • Check introductions and conclusions against learning objectives
  • Scan for hardcoded API keys and credentials
anthropics/claude-cookbooks5.4万2026年10月17日 更新

creating-financial-models

Claude 官方免费

Build financial models for valuation and investment analysis using discounted future cash flows, assumption testing, and probability simulations. Outputs include Excel models, comparison tables, charts, and valuation ranges to examine possible outcomes and risks.

中文简介正在准备中。当前显示英语简介。

  • Build a company valuation model from financial statements
  • Test how growth and discount rates affect valuation
  • Simulate acquisition valuation under uncertain assumptions
anthropics/claude-cookbooks5.4万2026年10月17日 更新

查看 anthropics 的全部技能

报告此技能的问题