Skip to content
analyzing-financial-statements logo

Financial Ratio Calculator Skill

analyzing-financial-statements

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

SKILL.md

Full skill instructions

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

More skills from majiayu000

xiaohongshu logo
majiayu000/claude-arsenal

xiaohongshu

xiaohongshu

286 148
View
agent-task-conductor logo
majiayu000/claude-skill-registry

agent-task-conductor

Conduct multi-agent task orchestration and workflow coordination.

663 1
View
conductor-setup logo
majiayu000/claude-skill-registry

conductor-setup

Initialize project with Conductor artifacts (product definition,

663 1
View
animation-designer logo
majiayu000/claude-skill-registry

animation-designer

Expert in web animations, transitions, and motion design using Framer Motion and CSS

663 1
View
diagramming logo
majiayu000/claude-skill-registry

diagramming

Creates Mermaid and ASCII diagrams for flowcharts, architecture, ERDs, state machines, mindmaps, and more. Use when user mentions diagram, flowchart, mermaid, ASCII diagram, text diagram, terminal diagram, visualize, C4, mindmap, architecture diagram, sequence diagram, ERD, or needs visual docume...

663 1
View
h3-pg logo
majiayu000/claude-skill-registry-data

h3-pg

PostgreSQL bindings for H3 hexagonal grid system. Use when working with H3 cells in Postgres, including spatial indexing, geometry/geography integration, and raster analysis.

23 1
View
conductor-development logo
majiayu000/claude-skill-registry

conductor-development

Context-Driven Development skill for projects using Conductor. Use this skill when you detect a `conductor/` directory in the project, when working on tasks defined in a `plan.md` file, or when the user asks about tracks, specs, or plans. Automatically applies TDD workflow, tracks task completion...

663 1
View
conductor-status logo
majiayu000/claude-skill-registry

conductor-status

Display project status, active tracks, and next actions

663 1
View
dockerization logo
majiayu000/claude-skill-registry

dockerization

Official Stakpak application containerization standard operating procedure, a step-by-step guidline to properly dockerize applications. This is a rule book curated by the Stakpak Team.

663 1
View

Popular AI tools

Kaiber logo
Video

Kaiber

Generate, edit, and beat-sync AI video with leading models in one workspace.

Paid
View
Vimcal logo
Productivity

Vimcal

The world's fastest calendar for remote work

Free
View

Transform Your Design with AI Designer by ImgCreator.ai

Freemium
View
Akool AI logo
Content & writing

Akool AI

Revolutionizing Video Production with AI-Powered Creativity

Paid
View

Extend an image past the frame and let AI fill the new aspect ratio.

Freemium
View
StarByFace logo
Security

StarByFace

Discover your celebrity doppelgänger with StarByFace!

Free
View
C

ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.

Freemium
View
Opus Clip logo
Coding & apps

Opus Clip

Opus.ai: Revolutionize Your Web Experience

Free
View