Financial Statement Analysis and Securities Valuation
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, thenCAPE = P / E10; when data allows, use Total ReturnCAPEto correct for dividend-policy changes. - Cross-checks: combine
ECY, dividend yield, the Buffett indicator, and Tobin’sQto 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:
CAPEdoes 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.
Related Skills
Analyze corporate financial statements with DuPont, solvency, operations, profitability, cash-flow quality, Z-Score, and EVA.
Provides compliance self-check and remediation guidance for medical aesthetics and jewelry businesses, covering tax categories, invoicing, and private-account risk.
Covers literature review, data analysis, visualization, drug discovery, paper writing, and grant writing workflows.
A retrieval assistant for Chinese laws and regulations, supporting semantic queries, validity checks, clause location, and regulation comparison with CLI-based output.