skills.rest
Walter102202
Walter102202COMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Automate end-to-end DCF valuation modeling with Python and openpyxl.

1|Updated Feb 28, 2026
Search Tags:#valuation#financial-modeling#dcf#sensitivity-analysis#equity#wacc#terminal-value
One-click install
npx skills add https://github.com/Walter102202/Finance --skill dcf-model-walter102202
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/Walter102202/Finance/tree/main/.claude/skills/financial-analysis/dcf-model
Command: npx skills add https://github.com/Walter102202/Finance --skill dcf-model-walter102202

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Streamlines end-to-end equity valuation by producing a programmatic, recalculating DCF model ready for investment analysis.

Core Features & Use Cases

  • End-to-end DCF modeling: Produces a complete model including revenue, margins, free cash flow, WACC, terminal value, and equity value.
  • Automated data ingestion: Pulls data from SEC filings and analyst reports to feed inputs.
  • Integrated sensitivity analysis: Offers three 5-year scenario tables and bottom-of-sheet sensitivity grids, with full recalculation.
  • Professional outputs: Exports a ready-to-deliver Excel workbook with executive summary.

Quick Start

Provide a target company ticker and key inputs, and the skill will generate a complete DCF model ready for delivery.

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 with WACC and terminal value in Excel?▼

DCF modeling automates revenue, margin, and free cash flow forecasting to calculate equity value. It uses openpyxl to export a fully recalculating Excel workbook with integrated WACC, terminal value, and sensitivity grids for investment analysis.

How do I automate DCF sensitivity analysis for multiple scenarios?▼

Automate DCF sensitivity analysis by generating three 5-year scenario tables and bottom-of-sheet sensitivity grids. The model fully recalculates within the exported Excel workbook for reproducible multi-scenario equity valuation.

Can I use yfinance to automate data ingestion for financial modeling?▼

Yes, financial modeling uses yfinance and requests to automate data ingestion. It pulls data from SEC filings and analyst reports to feed model inputs, generating a complete DCF valuation ready for delivery.

Does this DCF modeling approach work for institutional equity research?▼

Yes, DCF modeling targets institutional equity research, investment banks, and portfolio teams. It produces programmatic, recalculating valuation models with executive summaries, satisfying professional forecast and sensitivity analysis requirements.

What is the best way to generate a recalculating Excel workbook for equity valuation?▼

Generate equity valuation workbooks using openpyxl to programmatically build integrated WACC, FCF, and terminal value calculations. This approach outputs a recalculating Excel model with scenario blocks and executive summaries for investment analysis.

Related Skills

Explore More Finance & Accounting Skills→
AlexZWANG1AlexZWANG1

Valuation

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

Community
Advanced
nvmohinaninvmohinani

dcf-model

Build DCF valuation models with WACC, terminal value, and sensitivity analysis.

Community
Advanced
Oscar-Ivan-SalasOscar-Ivan-Salas

Tesla HTML-to-Excel Converter

Convert Tesla HTML quotations and reports into Excel workbooks with formatting.

Community
Advanced
thevibeworksthevibeworks
28

creating-financial-models

Create financial models with DCF, sensitivity analysis, and Monte Carlo simulation.

Official
Advanced