Skip to content
cccskills
FreePublished on GitHub

analyzing-financial-statements

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

The English summary is being prepared. Showing the original description.

Works withExcel
See how to install

Files included (2)

  • SKILL.md2.4 KB
  • metadata.json633 B

SKILL.md (original)

Review the instructions the agent will receive before you install.

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

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Testing patterns for PHPUnit and Playwright E2E tests. Use when writing tests, debugging test failures, setting up test coverage, or implementing test patterns for ActivityPub features.

The English summary is being prepared. Showing the original description.

Microck/ordinary-claude-skills406Updated Sep 7, 2026

Cloud laboratory platform for automated protein testing and validation. Use when designing proteins and needing experimental validation including binding assays, expression testing, thermostability measurements, enzyme activity assays, or protein sequence optimization. Also use for submitting experiments via API, tracking experiment status, downloading results, optimizing protein sequences for better expression using computational tools (NetSolP, SoluProt, SolubleMPNN, ESM), or managing protein design workflows with wet-lab validation.

The English summary is being prepared. Showing the original description.

Microck/ordinary-claude-skills406Updated Sep 7, 2026

Add unsigned integer (uint) type support to PyTorch operators by updating AT_DISPATCH macros. Use when adding support for uint16, uint32, uint64 types to operators, kernels, or when user mentions enabling unsigned types, barebones unsigned types, or uint support.

The English summary is being prepared. Showing the original description.

Microck/ordinary-claude-skills406Updated Sep 7, 2026

This skill should be used when the user asks to "create an agent", "add an agent", "write a subagent", "agent frontmatter", "when to use description", "agent examples", "agent tools", "agent colors", "autonomous agent", or needs guidance on agent structure, system prompts, triggering conditions, or agent development best practices for Claude Code plugins.

The English summary is being prepared. Showing the original description.

Microck/ordinary-claude-skills406Updated Sep 7, 2026

Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and distributed systems integration. Use when building distributed AI systems, multi-agent coordination, or advanced vector search applications.

The English summary is being prepared. Showing the original description.

Microck/ordinary-claude-skills406Updated Sep 7, 2026

Create and train AI learning plugins with AgentDB's 9 reinforcement learning algorithms. Includes Decision Transformer, Q-Learning, SARSA, Actor-Critic, and more. Use when building self-learning agents, implementing RL, or optimizing agent behavior through experience.

The English summary is being prepared. Showing the original description.

Microck/ordinary-claude-skills406Updated Sep 7, 2026

See all skills by Microck

Report a problem with this skill