AI Agent Hub
Back to skills
Financial Statement Analysis and Securities Valuation icon

Financial Statement Analysis and Securities Valuation

Professional Updated 2026.08.30

Paste the following prompt into your AI chat to install this skill:

Please install @user_231765ee/django-v2 according to https://skillhub.cn/install/skillhub.md.

About this skill

What problem it addresses

Individual stock valuation is often distorted by the latest EPS print, market narratives, and sentiment-driven pricing. Traditional PE is sensitive to earnings cycles, one-off items, and changes in dividends or buybacks, so a single latest-period multiple can mistake a cycle peak for fundamental improvement. This skill separates the analysis into two auditable layers: first, a behavioral and institutional review of whether the price is being pushed by narrative; second, a quantitative anchor using CAPE / P/E10.

How it works and where it applies

  • Core metric: compute ten-year inflation-adjusted E10, then CAPE = P / E10; when data allows, use Total Return CAPE to correct for dividend-policy changes.
  • Cross-checks: combine ECY, dividend yield, the Buffett indicator, and Tobin’s Q to reduce single-metric misjudgment.
  • Output: structured sections covering qualitative analysis, inflation-adjusted EPS, historical percentile, buy/sell thresholds, limitations, and a final conclusion.
  • Scope: US, A-share, HK, and listed index analysis; single stocks need at least ten years of trading history.
  • Limitations: CAPE does not capture fundamental changes in future growth, and structural industry shifts, accounting differences, and cross-market variance can weaken its signal; it is better used as a valuation anchor than a short-term timing tool.

Use Cases

  • A securities analyst tests whether a stock is narrative-driven by calculating `CAPE` from ten-year real earnings.
  • A portfolio manager reviews index valuation by comparing `CAPE` percentile, buy thresholds, and sell thresholds.
  • A fund manager compares equities with bonds by calculating `ECY` and cross-checking the Buffett indicator.
  • A wealth advisor explains cyclicals to clients by showing why the latest `PE` can mislead.

Best For

  • Securities analyst: needs to anchor stock valuation to ten-year inflation-adjusted earnings.
  • Portfolio manager: needs to review holdings for historical overvaluation or undervaluation.
  • Wealth advisor: needs to explain `CAPE` versus `PE` and buy/sell thresholds to clients.
  • Industry analyst: needs to assess how earnings-cycle volatility affects valuation signals.