Does the skill generate working Excel formulas or just static values?

The skill is designed to produce professional Excel models with full formula transparency, allowing users to modify assumptions directly within the spreadsheet after export.

What data sources does the DCF model use?

The skill prioritizes real-time and historical financial data fetched via MCP tools, supplemented by web searches for current market benchmarks and user-provided research assumptions.

Can I perform scenario analysis with this skill?

Yes, the skill automatically builds pessimistic, baseline, and optimistic scenarios by adjusting revenue growth, net margins, and terminal value assumptions.

How does the skill calculate the discount rate for Chinese markets?

The skill uses the Capital Asset Pricing Model (CAPM) adapted for the Chinese market, utilizing the China 10-year Treasury yield as the risk-free rate and A-share specific Beta and Market Risk Premiums.

A-Share DCF Financial Modeler

Name: A-Share DCF Financial Modeler
Author: ccq1

byccq1

•

Data Science & ML

Generates institutional-grade DCF valuation models for A-share companies using local financial data and RMB-denominated risk metrics.

The A-Share DCF Financial Modeler is a specialized Claude Code skill designed for financial analysts and investors focusing on the Chinese equity market. It automates the end-to-end process of intrinsic value estimation by fetching real-time and historical financial data via MCP, calculating local WACC using Chinese 10-year treasury yields, and building comprehensive 5-10 year cash flow forecasts. The skill produces professional-grade Excel models complete with 5x5 sensitivity analysis and scenario planning, ensuring alignment with domestic brokerage and international investment banking standards.

Key Features

01Localized WACC calculation using RMB risk-free rates, A-share Beta, and China-specific equity risk premiums.

02Dynamic 5x5 sensitivity analysis tables for WACC, growth rates, and terminal margins.

0315 GitHub stars

04Automated financial data retrieval for Income Statements, Balance Sheets, and Cash Flow via MCP tools.

05Standardized Excel export with formula-based cell linking and professional financial formatting.

06Multi-stage growth forecasting with customizable terminal value methods including Perpetuity and Exit Multiples.

Use Cases

01Performing stress tests and scenario analysis on corporate valuations under different macroeconomic conditions.

02Automating the creation of detailed financial models for equity research reports.

03Valuing listed companies on the Shanghai and Shenzhen stock exchanges (A-shares) for investment research.

Key Features

01Localized WACC calculation using RMB risk-free rates, A-share Beta, and China-specific equity risk premiums.

02Dynamic 5x5 sensitivity analysis tables for WACC, growth rates, and terminal margins.

0315 GitHub stars

04Automated financial data retrieval for Income Statements, Balance Sheets, and Cash Flow via MCP tools.

05Standardized Excel export with formula-based cell linking and professional financial formatting.

06Multi-stage growth forecasting with customizable terminal value methods including Perpetuity and Exit Multiples.

Use Cases

01Performing stress tests and scenario analysis on corporate valuations under different macroeconomic conditions.

02Automating the creation of detailed financial models for equity research reports.

03Valuing listed companies on the Shanghai and Shenzhen stock exchanges (A-shares) for investment research.