skills.rest
cwstedctw
cwstedctwCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Generate an Excel DCF valuation model with live formulas and sensitivity tables.

Updated May 27, 2026
Search Tags:#financial modeling#valuation#sensitivity analysis#dcf#equity research#wacc#excel model
One-click install
npx skills add https://github.com/cwstedctw/financial-services-tw --skill dcf-model-cwstedctw
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/cwstedctw/financial-services-tw/tree/main/taiwan-finance/skills/dcf-model
Command: npx skills add https://github.com/cwstedctw/financial-services-tw --skill dcf-model-cwstedctw

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Helps you build an end-to-end DCF (discounted cash flow) valuation model in Excel, including cash flow projections, WACC calculation, and sensitivity analysis, so you can arrive at an implied equity value with audit-ready formulas and structure.

Core Features & Use Cases

  • DCF model builder: Retrieves/uses inputs, projects revenue and margins, and calculates unlevered free cash flow with a consistent methodology.
  • WACC + discounting: Computes cost of capital (CAPM-based equity cost and after-tax cost of debt) and discounts explicit forecast cash flows using a mid-year convention.
  • Terminal value + equity bridge: Calculates terminal value (perpetuity growth with guardrails) and bridges EV to equity value and implied value per share.
  • Full sensitivity grids: Creates multiple WACC/terminal-growth and operating assumption sensitivity tables where every cell recalculates a complete DCF scenario (no placeholders).

Quick Start

Tell the AI: "Build a DCF model for Taiwan stock 2330 with a 5-year forecast, provide bear/base/bull revenue growth and EBIT margin assumptions, and use TWSE MCP data where available."

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 valuation model in Excel with live formulas?▼

A DCF valuation model computes projected free cash flows, WACC, and terminal value to derive an equity-per-share output. This Skill builds the entire Excel model with live formulas, applying mid-year discounting and terminal growth guardrails for audit-ready equity research.

How do I create a WACC and terminal growth sensitivity table in Excel?▼

Creating a WACC and terminal growth sensitivity table requires recalculating full DCF scenarios for each cell. This Skill generates multiple sensitivity grids where every operating assumption, WACC, and terminal growth combination recalculates a complete valuation without placeholders.

Can I use a DCF model for Taiwan stock tickers like 2330?▼

Yes, you can generate a DCF model for Taiwan stock tickers like 2330. The Skill applies Taiwan-local conventions and utilizes TWSE MCP data where available, projecting bear, base, and bull revenue growth and EBIT margin assumptions for 5-year equity research forecasts.

Does the DCF model validate terminal growth against WACC constraints?▼

Yes, the DCF model validates key constraints to ensure terminal growth remains less than WACC. This guardrail prevents invalid perpetuity growth assumptions during terminal value calculation, maintaining the mathematical integrity of the equity-per-share bridge.

How to calculate equity value per share from unlevered free cash flow?▼

Calculating equity value per share from unlevered free cash flow requires discounting explicit forecast cash flows, adding terminal value, and bridging enterprise value to equity. This Skill automates that entire Excel calculation, outputting the implied per-share value.

Related Skills

Explore More Finance & Accounting Skills→
AlexZWANG1AlexZWANG1

Valuation

Compute DCF and comps valuations with bear, base, and bull scenarios.

Community
Advanced
ruiyangruiyiruiyangruiyi

dcf-model

Generate Excel DCF valuation models with live formulas and sensitivity grids.

Community
Advanced
JoelLewisJoelLewis
164

quantitative-valuation

Estimate intrinsic company value using DCF, DDM, multiples, and residual income models.

Community
Advanced
haomingzhaomingz
12

cashflow-valuation

Compute enterprise value from projected free cash flows using DCF.

Community
Advanced