skills.rest
dgkngk
dgkngkCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Builds DCF models with WACC calculations and Excel outputs from SEC filings and analyst reports.

Updated Feb 26, 2026
Search Tags:#financial modeling#valuation#excel automation#dcf#equity research#wacc
One-click install
npx skills add https://github.com/dgkngk/super-kit --skill dcf-model-dgkngk
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/dgkngk/super-kit/tree/main/skills/tech/financial-modeling/skills/dcf-model
Command: npx skills add https://github.com/dgkngk/super-kit --skill dcf-model-dgkngk

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation of institutional-quality Discounted Cash Flow (DCF) models for equity valuation, transforming raw financial data into actionable investment insights.

Core Features & Use Cases

  • Comprehensive DCF Modeling: Builds detailed cash flow projections, calculates Weighted Average Cost of Capital (WACC), and performs sensitivity analysis.
  • Data Integration: Retrieves financial data from SEC filings, analyst reports, and user-provided sources.
  • Professional Output: Generates Excel models with executive summaries and sensitivity tables, adhering to investment banking standards.
  • Use Case: When a user needs to determine the intrinsic value of a company, understand its future growth potential, or perform a detailed financial analysis for investment decisions.

Quick Start

Use the dcf-model skill to build a DCF valuation for Apple Inc. (AAPL) using its latest SEC filings and current market data.

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 model using SEC filings and Excel automation?▼

DCF valuation automates institutional-grade equity analysis by retrieving financial data from SEC filings, calculating WACC, projecting cash flows, executing sensitivity analysis, and outputting professional Excel models with executive summaries for investment decisions.

Can I use yfinance to pull SEC data for WACC calculations and equity research?▼

Yes, yfinance retrieves current market data to supplement SEC filing data for WACC calculations and equity research. The Skill integrates these sources to construct detailed cash flow projections and perform comprehensive financial analysis.

What's the best way to perform sensitivity analysis for DCF valuation in Excel?▼

The best way to perform sensitivity analysis for DCF valuation is to programmatically generate Excel formulas using openpyxl, adhering to strict formatting and error-checking standards. This produces institutional-grade sensitivity tables within the output model.

Does this DCF modeling approach work with user-provided financial data from analyst reports?▼

Yes, this DCF modeling approach works with user-provided financial data from analyst reports. It retrieves and integrates financial data from SEC filings, analyst reports, and user-provided sources to build comprehensive cash flow projections for equity valuation.

Why do I need openpyxl to generate DCF models instead of using standard Excel templates?▼

You need openpyxl to generate DCF models because it enables programmatic Excel formula generation and strict error-checking standards. Standard templates lack the automation required to dynamically retrieve SEC data, calculate WACC, and construct institutional-grade sensitivity tables.

Related Skills

Explore More Finance & Accounting Skills→
babdulhakim2babdulhakim2

Corporate Filings Search

Retrieve SEC and state corporate filings with governance and financial data.

Community
Intermediate
open-nekoopen-neko
11

dcf-model

Build DCF valuation models with live Excel workbooks and sensitivity tables.

Official
Advanced
zeronx798zeronx798

dcf-model

Generate multi-scenario DCF valuation models with Excel formulas and sensitivity analysis.

Community
Advanced
ganoroganoro

Valuation Analysis

Perform fair value analysis for PE/VC portfolio companies using DCF, comparables, and precedent transactions.

Community
Advanced