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

Ready to run

npx skills add https://github.com/hmzainjamil/claude-office-skills --skill dcf-valuation-hmzainjamil

💬 Prompt for ChatGPT / Claude Chat▼

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.