dcf-model

Build real-valued DCF models with WACC and terminal value frameworks.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill dcf-model-brianping7
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/brianping7/volc-financial-services-skill-sets/tree/main/financial-analysis/dcf-model
Command: npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill dcf-model-brianping7

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill enables equity valuation by building real-valued DCF models from cash flow forecasts using domestic financial data and analyst research, incorporating proper WACC calculations and terminal value analysis to deliver professional Excel outputs with executive summaries.

Core Features & Use Cases

  • End-to-end DCF modeling with bear/base/bull scenario blocks, integrated WACC and terminal value, and detailed cash flow forecasts.
  • Outputs include an investor-grade Excel workbook with sensitivity analyses, scenario comparison, and a clear equity value summary.
  • Use cases include equity valuations, intrinsic value analyses, and M&A due diligence support for companies across China A-share, Hong Kong, and ADR markets.

Quick Start

输入公司数据并启用熊市、基准、牛市情景,以生成完整的DCF估值及敏感性分析。

Frequently Asked Questions about dcf-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a DCF model with WACC and terminal value for equity valuation?

To build a DCF model, input projected cash flows and apply a disciplined WACC and terminal value framework to derive equity valuations, generating an investor-grade Excel output with an executive summary.

Can I generate sensitivity analysis for bear, base, and bull scenarios in an Excel model?

Yes, you can generate sensitivity analysis by enabling bear, base, and bull scenario blocks, which produces a professional Excel workbook comparing scenarios and summarizing equity value.

How does DCF modeling apply to companies across China A-share, Hong Kong, and ADR markets?

DCF modeling applies to these markets by using domestic financial statements and analyst reports to project cash flows, ensuring accurate equity valuation and M&A due diligence support.

What is the best way to automate intrinsic value analysis and output it to Excel?

Automate intrinsic value analysis by inputting company data to generate real-valued DCF models, which outputs a detailed Excel workbook with cash flow forecasts and sensitivity analyses.

Do I need openpyxl to generate professional Excel outputs for investment banking workflows?

Yes, openpyxl is required to generate the professional Excel workbook containing the DCF model, sensitivity analyses, and executive summary for investment banking workflows.

What are the limitations of using DCF models for corporate finance scenarios?

DCF models rely on projected cash flows and analyst reports, meaning valuations are constrained by the accuracy of domestic financial data inputs and terminal value assumptions.