skills.rest
heximao
heximaoCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Create DCF equity valuation models with WACC and sensitivity analysis using Python and openpyxl.

Updated May 11, 2026
Search Tags:#openpyxl#financial analysis#Python#equity valuation#DCF modeling
One-click install
npx skills add https://github.com/heximao/agents --skill dcf-model-heximao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/heximao/agents/tree/main/skill-archive/web/dcf-model/skill
Command: npx skills add https://github.com/heximao/agents --skill dcf-model-heximao

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation of institutional-quality DCF (Discounted Cash Flow) models for equity valuation, saving time and reducing errors in financial analysis.

Core Features & Use Cases

  • Automated DCF Modeling: Generates comprehensive DCF models based on financial data, including cash flow projections, WACC calculations, and sensitivity analysis.
  • Data Sourcing: Retrieves financial data from SEC filings, analyst reports, and user-provided inputs.
  • Use Case: Ideal for valuing a company or conducting intrinsic value analysis, with the ability to handle various scenarios like Bear, Base, and Bull cases.

Quick Start

Use the dcf-model skill to create a DCF model for 'Company XYZ' with a 5-year projection period.

Frequently Asked Questions about dcf-model

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

FAQPage Schema
How do I automate DCF modeling for equity valuation using Python?▼

Automating DCF modeling for equity valuation using Python involves processing financial data to generate cash flow projections, applying WACC calculations, and performing sensitivity analysis. This Skill handles these steps to output institutional-quality models directly into spreadsheets.

Can I generate financial sensitivity analysis in Excel using openpyxl?▼

Generating financial sensitivity analysis in Excel using openpyxl is supported by this Skill. It processes financial data, applies WACC calculations, and writes the resulting Bear, Base, and Bull case scenarios directly into spreadsheet files for investment analysis.

What data do I need to create a DCF model with WACC calculations?▼

Creating a DCF model with WACC calculations requires financial data sourced from SEC filings, analyst reports, or user-provided inputs. The Skill processes this data to calculate the weighted average cost of capital and project future cash flows for intrinsic value analysis.

Does Python work for institutional-quality equity valuation and cash flow projections?▼

Python works effectively for institutional-quality equity valuation and cash flow projections through this Skill. It automates the creation of comprehensive DCF models, handling data sourcing, WACC calculations, and sensitivity analysis to reduce errors in financial modeling.

What is the best way to handle Bear, Base, and Bull cases in financial modeling?▼

Handling Bear, Base, and Bull cases in financial modeling is best achieved by automating scenario generation within a DCF model. This Skill processes financial data to apply various scenarios, calculating intrinsic value and performing sensitivity analysis for investment decisions.

Related Skills

Explore More Finance & Accounting Skills→
mouseqiao85mouseqiao85
1

dcf-model

Generate DCF models with WACC calculations and sensitivity analysis.

Community
Advanced
projectedanxprojectedanx
1

dcf-model

Generate institutional-quality DCF valuation models in Excel with openpyxl.

Community
Advanced
rpoole-devrpoole-dev

dcf-model

Automate DCF model creation with SEC filings and analyst reports.

Community
Advanced
hck717hck717

valuation-analysis

Construct valuation models and price targets using DCF, multiples, and scenario analysis.

Community
Advanced