skills.rest
projectedanx
projectedanxCOMMUNITY
Explore all skills by this author →
𝕏@ALifeInArtifyAIGitHub

dcf-model

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

1|Updated May 12, 2026
Search Tags:#finance#excel#modeling#valuation#dcf#investment-banking
One-click install
npx skills add https://github.com/projectedanx/hermes-agent --skill dcf-model-projectedanx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/projectedanx/hermes-agent/tree/main/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/projectedanx/hermes-agent --skill dcf-model-projectedanx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill solves the complexity and inconsistency of building manual financial valuation models by automating the creation of institutional-quality Discounted Cash Flow (DCF) analyses in Excel.

Core Features & Use Cases

  • Automated Modeling: Generates structured DCF models including revenue projections, FCF builds, and WACC calculations.
  • Sensitivity Analysis: Programmatically populates 5x5 sensitivity tables to stress-test valuation assumptions.
  • Scenario Planning: Supports Bear, Base, and Bull case modeling with centralized consolidation logic.
  • Use Case: An investment analyst needs to value a public company; this skill fetches the necessary financial data and builds a complete, audit-ready Excel model with sensitivity tables in minutes.

Quick Start

Use the dcf-model skill to build a five-year valuation model for the company with ticker AAPL using the base case scenario.

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 valuation modeling in Excel?▼

This skill automates DCF valuation in Excel by programmatically generating revenue projections, free cash flow builds, and WACC calculations using openpyxl for spreadsheet manipulation.

What is the best way to build institutional-grade DCF models with sensitivity analysis?▼

Building institutional-grade DCF models is best achieved by automating Excel spreadsheet creation to programmatically populate 5x5 sensitivity tables, stress-testing valuation assumptions for equity research.

Can I run Bear, Base, and Bull case scenarios in a DCF model?▼

Yes, you can run Bear, Base, and Bull case scenarios in a DCF model by applying centralized consolidation logic to structure your intrinsic value assessment across multiple market conditions.

Does openpyxl support programmatic Excel manipulation for investment banking workflows?▼

Yes, openpyxl supports programmatic Excel manipulation for investment banking workflows, serving as the required dependency to generate structured DCF models and populate sensitivity tables.

What is needed to generate audit-ready DCF models for equity research?▼

Generating audit-ready DCF models for equity research requires openpyxl for spreadsheet manipulation and adherence to standardized financial modeling constraints for rigorous intrinsic value assessment.

Related Skills

Explore More Finance & Accounting Skills→
jwangkunjwangkun
705

china-dcf

Compute Chinese CAS-compliant DCF valuations for A-share stocks using Wind, iFind, or AkShare data.

Community
Advanced
open-nekoopen-neko
11

dcf-model

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

Official
Advanced
MarbleSodasMarbleSodas

dcf-model

Build institutional-quality DCF valuation models in Excel with live formulas.

Community
Advanced
davpatel605-beepdavpatel605-beep

dcf-model

Build Excel-based discounted cash flow valuation models with WACC and scenario analysis.

Community
Advanced