china-datapack-builder

china-datapack-builder

Purpose

Build professional A股投行数据包 (Data Pack) for investment banking workflows — M&A due diligence, IC review, deal execution.

Data Sources

Primary: AkShare MCP

get_financials(ticker, "income", "annual")   → P&L history
get_financials(ticker, "balance", "annual")  → Balance sheet
get_financials(ticker, "cashflow", "annual") → Cash flow
get_quote(ticker)                            → Current valuation
get_historical_data(ticker)                  → Trading history
get_industry_stocks(industry="...")           → Peer comparison
get_stock_info(ticker)                       → Company profile

Secondary Sources

• 巨潮资讯 — mandatory filings (年报, 中报, 季报)
• 上交所 / 深交所 — announcements, filings
• 公司官网 — investor materials
• 企查查 / 天眼查 — corporate structure
• Wind / Choice — comprehensive data

Workflow

Step 1: Define Pack Scope

Data pack types:

Pack Type	Purpose	Typical Content
Company overview	Initial target screening	Financials, profile, peers
Due diligence	Pre-deal deep dive	3-statement, quality of earnings, debt
IC preparation	Investment committee	Executive summary, model, risks
M&A comps	Comparable transactions	Precedent deals, trading comps
Sector deep dive	Market context	Industry overview, competitive map

Step 2: Gather Source Materials

Financial data collection:

# 3-5 years historicals
for year in range(2020, 2025):
    get_financials(ticker, "income", "annual")
    get_financials(ticker, "balance", "annual")
    get_financials(ticker, "cashflow", "annual")

Corporate information:

• 公司股权结构 (ownership structure)
• 子公司/参股公司 (subsidiaries / associates)
• 关联交易 (related party transactions)
• 对外担保 (guarantees)
• 诉讼仲裁 (litigation / arbitration)

Market data:

• Current and historical share price
• Trading volumes and liquidity
• Ownership breakdown (institutional, retail, 北向)
• Shareholder changes over time

Step 3: Normalize & Structure

Data normalization standards:

1. Currency: All figures in CNY (人民币)
2. Units: Consistent (亿元 preferred for large companies)
3. Periods: Align fiscal years (typically Dec 31)
4. Adjustments: Normalize for one-time items

Standard data pack sections:

Section 1: Executive Summary

• 1-page overview
• Key investment highlights
• Valuation summary
• Critical risks

Section 2: Company Overview

• Business description
• History and milestones
• Organizational structure
• Management team
• Shareholder structure

Section 3: Financial Summary

• Income statement (3-5 years)
• Balance sheet (3-5 years)
• Cash flow statement (3-5 years)
• Key ratios and metrics
• Revenue bridge

Section 4: Operating Metrics

• Revenue by segment
• Volume / unit data (if relevant)
• Capacity / utilization
• Geographic breakdown

Section 5: Quality of Earnings

• Revenue quality (cash conversion)
• Margin analysis
• One-time items identification
• Earnings sustainability

Section 6: Balance Sheet Analysis

• Asset quality
• Working capital efficiency
• Debt structure
• Off-balance sheet items

Section 7: Peer Comparison

• Trading multiples
• Financial metrics
• Operating metrics
• Valuation dispersion

Section 8: Transaction History

• Historical M&A
• Capital raising history
• Major corporate actions

Section 9: Risk Factors

• Company-specific risks
• Industry risks
• Regulatory risks
• Market risks

Step 4: Excel Workbook Structure

Recommended tabs:

Tab	Content
封面 (Cover)	Pack title, date, confidentiality
摘要 (Summary)	Key data points, valuation
利润表 (Income Statement)	Historical + projected
资产负债表 (Balance Sheet)	Historical + projected
现金流量表 (Cash Flow)	Historical + projected
财务指标 (Key Metrics)	Ratios, growth rates
可比公司 (Comparable Cos)	Peer analysis
估值 (Valuation)	DCF, multiples, football field
运营数据 (Operating Data)	Volume, capacity, etc.
公司治理 (Governance)	Ownership, management, related party
风险 (Risks)	Risk factor analysis

Step 5: Quality Standards

Data integrity:

• All figures sourced from 巨潮 PDF or AkShare
• Cross-referenced against multiple sources where possible
• Adjustments documented
• No transcription errors

Formatting:

• Consistent formatting throughout
• Clear section headers
• Source citations in cell comments
• Professional appearance

Completeness:

• All sections relevant to deal type included
• Key risks identified and documented
• Valuation analysis complete
• Peer comparison adequate

China-Specific Considerations

Regulatory Filings

Filing	Frequency	Source	Key Data
年报 (Annual report)	Annual	巨潮	Full financials, MD&A, risks
中报 (Semi-annual)	Semi-annual	巨潮	Condensed financials
季报 (Quarterly)	Quarterly	巨潮	Condensed financials
业绩预告	As required	巨潮	Directional guidance
重大事项公告	Ad-hoc	巨潮	M&A, contracts, etc.

Common Data Issues

Issue	Solution
千元 vs 元 units	Check 财务报表附注 for units
合并 vs 母公司报表	Use 合并报表 for group analysis
非经常性损益	Flag and normalize
政府补助	Identify and separate
关联交易占比高	Flag for due diligence

Industry-Specific Data

Industry	Special Data Needs
白酒	批价数据, 渠道库存, 经销商数量
半导体	产能数据, 晶圆出货, 客户结构
新能源	装机量, 产能, 技术参数
医药	管线数据, 临床进展, 集采中标
房地产	可售资源, 去化率, 土储

Quality Checks

Before delivering:

• Data pack scope clearly defined
• All financials complete and accurate
• Source materials documented
• Adjustments transparent
• Peer comparison relevant
• Valuation analysis included
• Risk factors comprehensive
• Excel workbook well-structured
• Confidentiality notices included