skills.rest
claude-office-skills
claude-office-skillsOFFICIAL
Explore all skills by this author →
GitHub

dcf-valuation

Automates DCF valuation models and calculates intrinsic value per share.

368|75|Updated Jan 29, 2026
Search Tags:#financial modeling#valuation#investment analysis#dcf#intrinsic value#wacc
One-click install
npx skills add https://github.com/claude-office-skills/skills --skill dcf-valuation-claude-office-skills
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-valuation
Source: https://github.com/claude-office-skills/skills/tree/main/dcf-valuation
Command: npx skills add https://github.com/claude-office-skills/skills --skill dcf-valuation-claude-office-skills

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the complex process of building Discounted Cash Flow (DCF) valuation models, enabling users to estimate a company's intrinsic value based on its future cash flows.

Core Features & Use Cases

  • DCF Model Construction: Builds comprehensive DCF models from historical financial data and user-defined assumptions.
  • WACC Calculation: Computes the Weighted Average Cost of Capital using CAPM and other relevant financial metrics.
  • Terminal Value Estimation: Calculates terminal value using both the Gordon Growth Model and Exit Multiples.
  • Sensitivity Analysis: Provides insights into how changes in key assumptions affect the valuation.
  • Use Case: An investment analyst can use this Skill to quickly generate a DCF valuation for a target company, compare it to market price, and understand the key drivers of value.

Quick Start

Build a DCF model for a SaaS company with current revenue of $500M, revenue growth of 25% declining to 15% over 5 years, EBITDA margin of 20% improving to 30%, current stock price of $45, and 100M shares outstanding.

Frequently Asked Questions about dcf-valuation

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

FAQPage Schema
How do I calculate intrinsic value using a DCF model?▼

To calculate intrinsic value with a DCF model, you project future free cash flows, estimate terminal value, and discount them back to present value using WACC. This Skill automates that entire process directly from historical financial data.

How do I build a multi-stage DCF valuation with sensitivity analysis?▼

DCF valuation supports standard, two-stage, and three-stage models to handle varying growth phases. Sensitivity analysis is included to automatically measure how changes in revenue growth, margins, and discount rates impact the final valuation.

What is the best way to calculate WACC for investment analysis?▼

The best way to calculate WACC for investment analysis is using the CAPM method combined with relevant financial metrics. This Skill computes the Weighted Average Cost of Capital automatically to determine the proper discount rate for your cash flows.

How does terminal value estimation work in financial modeling?▼

Terminal value estimation in financial modeling captures a company's value beyond the explicit forecast period. This Skill calculates terminal value using both the Gordon Growth Model and Exit Multiples to provide a comprehensive valuation range.

Can I use pandas and numpy to automate financial modeling for investment analysis?▼

Yes, you can automate financial modeling for investment analysis using pandas and numpy. This Skill leverages these dependencies to process historical financial data and compute complex DCF valuations without manual spreadsheet errors.

When should I not use a DCF model for company valuation?▼

You should not use a DCF model when a company has unpredictable cash flows, inconsistent margins, or lacks sufficient historical financial data. DCF valuations rely heavily on accurate revenue growth and margin assumptions, making it less reliable for highly volatile businesses.

Related Skills

Explore More Finance & Accounting Skills→
claude-office-skillsclaude-office-skills
368

financial-modeling

Build integrated 3-statement financial models with projections for income statement, balance sheet, and cash flow.

Official
Advanced
carterwayneskhizeinecarterwayneskhizeine
19

dcf-model

Generate an Excel DCF valuation model 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
20YN0420YN04

dividend-analysis

Analyze dividend sustainability using cash flow coverage, payout ratios, and balance sheet metrics.

Community
Intermediate