skills.rest
hmzainjamil
hmzainjamilCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

dcf-valuation

Build discounted cash flow valuation models from historical financials and forecast assumptions.

1|Updated May 18, 2026
Search Tags:#valuation#sensitivity analysis#dcf#intrinsic value#wacc#free cash flow
One-click install
npx skills add https://github.com/hmzainjamil/claude-office-skills --skill dcf-valuation-hmzainjamil
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-valuation
Source: https://github.com/hmzainjamil/claude-office-skills/tree/main/dcf-valuation
Command: npx skills add https://github.com/hmzainjamil/claude-office-skills --skill dcf-valuation-hmzainjamil

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you turn financial statements and assumptions into a defensible discounted cash flow valuation, reducing manual spreadsheet work and making it easier to estimate intrinsic value.

Core Features & Use Cases

  • DCF Model Building: Create full valuation models from historical financial data and forward assumptions.
  • Core Finance Calculations: Compute WACC, project free cash flow, and estimate terminal value using Gordon Growth or exit multiple methods.
  • Analysis and Reporting: Produce valuation summaries, sensitivity tables, and professional report-style outputs for investment analysis.

Quick Start

Build a DCF valuation model for a company using its historical financials, shares outstanding, current price, and my assumptions for growth, margins, capex, working capital, WACC, and terminal value.

Frequently Asked Questions about dcf-valuation

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

FAQPage Schema
How do I build a discounted cash flow valuation model from historical financials?▼

To build a discounted cash flow valuation model, you input historical financial statements and forward assumptions to project free cash flow, calculate WACC, and estimate terminal value for intrinsic value estimation.

What is the best way to calculate intrinsic value using the DCF method?▼

Calculating intrinsic value using the DCF method requires projecting free cash flows, discounting them by the weighted average cost of capital, and estimating terminal value via Gordon Growth or exit multiple approaches.

Can I generate sensitivity tables for WACC and terminal value assumptions in a DCF model?▼

Yes, you can generate sensitivity tables for WACC and terminal value assumptions. The DCF valuation process produces sensitivity analysis outputs alongside valuation summaries for professional investment reporting.

How does terminal value estimation work in a free cash flow projection?▼

Terminal value estimation in a free cash flow projection captures value beyond the forecast period using either the Gordon Growth method or an exit multiple method to finalize the intrinsic value calculation.

Do I need forward-looking assumptions to estimate company intrinsic value, or are historical financials enough?▼

You need both historical financials and forward-looking assumptions to estimate company intrinsic value. Historical data anchors the model, while growth, margin, capex, and working capital assumptions drive the free cash flow projection.

When should I use an exit multiple instead of Gordon Growth for terminal value estimation?▼

Use an exit multiple for terminal value estimation when market-driven valuation benchmarks are more reliable than perpetuity assumptions, whereas Gordon Growth suits stable, predictable long-term growth scenarios in DCF analysis.

Related Skills

Explore More Finance & Accounting Skills→
modelscopemodelscope
4.4k

Creating Financial Models

Build financial valuation models with DCF, sensitivity analysis, and Monte Carlo simulations in Excel.

Official
Advanced
mouseqiao85mouseqiao85
1

dcf-model

Generate DCF models with WACC calculations and sensitivity analysis.

Community
Advanced
JoelLewisJoelLewis
164

quantitative-valuation

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

Community
Advanced
GeeksfinoGeeksfino
271

high-dividend-strategy

Analyze China A-share dividend strategies to identify sustainable high-dividend stocks.

Community
Intermediate