look-05-balance-sheet-health

Analyze multi-year balance-sheet data for cashflow coverage, debt, and leverage trends.

2|1|Updated Apr 17, 2026
One-click install
npx skills add https://github.com/shadowinlife/nano_quant_skills --skill look-05-balance-sheet-health
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: look-05-balance-sheet-health
Source: https://github.com/shadowinlife/nano_quant_skills/tree/main/2min-company-analysis/look-05-balance-sheet-health
Command: npx skills add https://github.com/shadowinlife/nano_quant_skills --skill look-05-balance-sheet-health

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, and includes scripts (resource) components.

What problem does it solve?

本技能聚焦于对企业资产负债表健康状况的独立评估,整合经营现金流、负债结构及隐性负债的证据,帮助分析师快速发现潜在风险并进行针对性核验。

Core Features & Use Cases

  • 提供结构化指标系列:现金流覆盖、债务水平、偿债能力与杠杆趋势,覆盖多年度数据并给出可操作结论。
  • 隐性负债证据收集(可选):对年报附注中对外担保、表外融资等信息进行证据提取与标注,支持人机协同审核。
  • 针对金融类公司不适用的处理:在发现公司类型为金融行业时给出明确非适用提示,避免误用。

Quick Start

Run the look-05 balance sheet health analysis with stock code, as-of date, and lookback years to generate the report.

Frequently Asked Questions about look-05-balance-sheet-health

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze balance sheet health using multi-year financial data?

You can analyze balance sheet health by running this skill with a stock code, as-of date, and lookback years. It calculates cashflow coverage, debt levels, and leverage trends across the specified years to produce an assessment report.

What financial metrics are used to assess debt levels and leverage trends?

The skill uses structured metric series covering cashflow coverage, debt levels, solvency, and leverage trends. By applying these across multiple years of financial data, it evaluates the company's ability to cover debts and identifies leverage trajectories.

Can I extract evidence of hidden liabilities from annual report notes?

Yes, this skill optionally extracts evidence of hidden liabilities like external guarantees and off-balance-sheet financing from annual report notes. It supports human-in-the-loop review to annotate and verify the extracted hidden liability evidence.

Does this balance sheet analysis tool work for financial sector companies?

No, this balance sheet analysis tool is not suitable for financial sector companies. Upon detecting a financial industry company, it issues an explicit non-applicable prompt to avoid misuse and prevent misleading financial analysis results.

Do I need DuckDB to calculate cashflow coverage and debt metrics?

Yes, DuckDB is a required dependency to calculate cashflow coverage and debt metrics. The skill relies on DuckDB to implement data retrieval and perform metric calculations on structured financial data for the analysis.