本文へ移動
cccskills
無料GitHub で公開

"data-financial-analysis"

"Interpret the three core financial statements (income statement, balance sheet, cash flow statement) to assess business health and performance. Use this skill when the user needs to read financial statements, understand profitability vs cash flow, evaluate a company's financial position, or prepare for investor/board meetings — even if they say 'explain these financials', 'are we making money', 'read this annual report', or 'what do these numbers mean'.".

インストール方法を見る

含まれるファイル(2)

  • SKILL.md4.3 KB
  • examples/sample_scenario.md5.2 KB

SKILL.md(原文)

インストールする前に、エージェントに与えられる指示の中身を確認できます。

Financial Statement Analysis

Framework

IRON LAW: Read All Three Statements Together

A company can be profitable (Income Statement) but cash-poor (Cash Flow Statement).
A company can have high assets (Balance Sheet) funded entirely by debt.
Reading one statement alone gives an incomplete — and potentially misleading — picture.
ALWAYS read all three and check for consistency.

The Three Statements

Income Statement (損益表) — Did we make money THIS PERIOD?

  • Revenue → Gross Profit → Operating Income → Net Income
  • Key: Revenue recognition ≠ cash received. Accrual accounting records revenue when earned, not when paid.

Balance Sheet (資產負債表) — What do we own and owe RIGHT NOW?

  • Assets = Liabilities + Shareholders' Equity
  • Key: This is a SNAPSHOT at one point in time, not a period.

Cash Flow Statement (現金流量表) — Where did cash come from and go?

  • Operating activities (core business cash generation)
  • Investing activities (capex, acquisitions, asset sales)
  • Financing activities (debt, equity, dividends)
  • Key: Operating cash flow is the most important — it shows if the core business generates cash.

Red Flags Across Statements

Red FlagWhat It Means
Revenue growing but operating cash flow decliningPossible revenue recognition issues, rising receivables
Net income positive but free cash flow negativeEarnings driven by accruals, not cash; heavy capex
Assets growing faster than revenueInefficient asset utilization
Debt growing faster than equityIncreasing leverage risk
Inventory growing faster than revenuePossible obsolescence, demand slowdown

Analysis Steps

  1. Read Income Statement: Is the company profitable? At which level (gross, operating, net)?
  2. Read Balance Sheet: What's the capital structure? How liquid is it?
  3. Read Cash Flow: Is operating cash flow positive? Where is cash going?
  4. Cross-check: Revenue growth vs cash flow growth, net income vs operating cash flow
  5. Trend: 3-5 year trend for key metrics
  6. Benchmark: Compare to industry peers

Output Format

# Financial Statement Analysis: {Company} — {Period}

## Income Statement Highlights
| Metric | Current | Prior Year | Change |
|--------|---------|-----------|--------|
| Revenue | ${X} | ${X} | {%} |
| Gross Margin | {%} | {%} | {±pp} |
| Operating Margin | {%} | {%} | {±pp} |
| Net Income | ${X} | ${X} | {%} |

## Balance Sheet Highlights
| Metric | Current | Prior Year |
|--------|---------|-----------|
| Total Assets | ${X} | ${X} |
| Total Debt | ${X} | ${X} |
| D/E Ratio | {X} | {X} |
| Current Ratio | {X} | {X} |

## Cash Flow Highlights
| Category | Amount |
|----------|--------|
| Operating CF | ${X} |
| Investing CF | ${X} |
| Financing CF | ${X} |
| Free Cash Flow | ${X} |

## Red Flags
- {any detected}

## Overall Assessment
{Financial health verdict with key rationale}

Gotchas

  • Revenue ≠ cash: Under accrual accounting, revenue is recorded when earned (product delivered), not when cash is received. Check accounts receivable to see how much revenue is still uncollected.
  • EBITDA is not cash flow: EBITDA ignores capex, working capital changes, and taxes — all of which are real cash costs. Use free cash flow for cash analysis.
  • One-time items distort trends: Restructuring charges, asset sales, legal settlements create one-time spikes or dips. Use "adjusted" or "normalized" figures for trend analysis.
  • Taiwan IFRS vs US GAAP: Taiwan-listed companies use IFRS (TIFRSs). Some treatment differs from US GAAP (lease accounting, revenue recognition details). Note which standard applies.

References

  • For financial ratio analysis deep-dive, see the biz-financial-ratios skill
  • For DuPont ROE decomposition, see the biz-dupont skill

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

"Implement and select ad bidding strategies from manual CPC to automated target-CPA and target-ROAS. Use this skill when the user needs to choose a bidding strategy, set up automated bidding, or optimize bid parameters — even if they say 'what bidding strategy should I use', 'target CPA setup', or 'smart bidding configuration'.".

日本語の概要は準備中です。原文の説明を表示しています。

charlieviettq/awesome-agent-skill262026年7月20日 更新

"Optimize advertising budget allocation across campaigns using marginal returns analysis. Use this skill when the user needs to distribute budget across multiple campaigns, optimize spend pacing, or maximize overall ROAS under budget constraints — even if they say 'how to split my ad budget', 'campaign budget optimization', or 'diminishing returns on ad spend'.".

日本語の概要は準備中です。原文の説明を表示しています。

charlieviettq/awesome-agent-skill262026年7月20日 更新

"Build CTR prediction models for estimating ad click-through rates from features. Use this skill when the user needs to predict click probability, build an ad ranking model, or evaluate ad creative performance — even if they say 'predict click rate', 'ad relevance scoring', or 'which ad will get more clicks'.".

日本語の概要は準備中です。原文の説明を表示しています。

charlieviettq/awesome-agent-skill262026年7月20日 更新

"Implement Generalized Second Price auction for ad slot allocation and pricing. Use this skill when the user needs to understand search ad auctions, compute ad positions and costs-per-click, or analyze bidding dynamics — even if they say 'how does Google Ads auction work', 'ad rank calculation', or 'second price auction for ads'.".

日本語の概要は準備中です。原文の説明を表示しています。

charlieviettq/awesome-agent-skill262026年7月20日 更新

"Implement VCG mechanism for incentive-compatible ad slot allocation with truthful bidding. Use this skill when the user needs to design a truthful auction mechanism, compute externality-based payments, or understand why platforms may prefer GSP over VCG — even if they say 'truthful auction design', 'VCG payments', or 'incentive-compatible mechanism'.".

日本語の概要は準備中です。原文の説明を表示しています。

charlieviettq/awesome-agent-skill262026年7月20日 更新

"Explain blockchain fundamentals including distributed ledger architecture, consensus mechanisms, and block structure. Use this skill when the user needs to understand blockchain concepts, evaluate whether blockchain fits a use case, or design a blockchain-based solution — even if they say 'how does blockchain work', 'do I need blockchain', or 'distributed ledger'.".

日本語の概要は準備中です。原文の説明を表示しています。

charlieviettq/awesome-agent-skill262026年7月20日 更新

charlieviettq のスキルをすべて見る

このスキルの問題を報告する