skills.rest
carterwayneskhizeine
carterwayneskhizeineCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Generate an Excel DCF valuation model with live formulas and sensitivity grids.

19|4|Updated Apr 22, 2026
Search Tags:#openpyxl#sensitivity analysis#wacc#dcf valuation#excel modeling#terminal value
One-click install
npx skills add https://github.com/carterwayneskhizeine/hermes-agent-windows-R --skill dcf-model-carterwayneskhizeine
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/carterwayneskhizeine/hermes-agent-windows-R/tree/main/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/carterwayneskhizeine/hermes-agent-windows-R --skill dcf-model-carterwayneskhizeine

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps you generate a complete Discounted Cash Flow (DCF) valuation model in Excel, including multi-scenario assumptions and full sensitivity tables, so you can estimate intrinsic value instead of doing ad-hoc spreadsheet math.

Core Features & Use Cases

  • Institutional DCF Excel build: Creates revenue projections, FCF build, WACC framework, terminal value, and an equity value bridge to implied share price.
  • Bear/Base/Bull scenario modeling: Produces scenario blocks for growth and operating assumptions and uses a scenario selector to drive the consolidated case outputs.
  • Validation-ready, formula-driven model: Enforces live Excel formulas for all projections and valuation outputs (no “computed in Python then pasted as values”).
  • Three full sensitivity grids: Populates WACC vs terminal growth, revenue growth vs EBIT margin, and beta vs risk-free rate with recalculating DCF formulas per cell, using the base case centered cell highlighted for quick auditing.

Quick Start

Tell the Skill to build a DCF model for your target company using your historical inputs and chosen scenario assumptions, and then recalculate the resulting Excel file before review.

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 in Excel with live formulas?▼

To build a DCF valuation model in Excel with live formulas, you can use this Skill to generate a headless openpyxl workbook containing revenue projections, FCF build, WACC framework, and terminal value computations without pasting Python-calculated constants.

Can I generate sensitivity analysis tables for WACC and terminal growth in Excel?▼

Yes, you can generate sensitivity analysis tables for WACC and terminal growth in Excel. This Skill populates three full sensitivity grids, including WACC vs terminal growth and revenue growth vs EBIT margin, with recalculating DCF formulas per cell.

How do I create Bear, Base, and Bull scenario assumptions for an intrinsic value estimation?▼

You create Bear, Base, and Bull scenario assumptions for intrinsic value estimation by defining growth and operating assumption blocks, which this Skill uses to drive a scenario selector for consolidated case outputs and implied per-share pricing.

Does openpyxl support writing live Excel formulas for financial modeling instead of static values?▼

Yes, openpyxl supports writing live Excel formulas for financial modeling instead of static values. This Skill leverages openpyxl to enforce a validation-ready, formula-driven layout where all projections and valuation outputs recompute dynamically in Excel.

What is the best way to automate equity intrinsic value estimation across multiple scenarios?▼

The best way to automate equity intrinsic value estimation across multiple scenarios is to programmatically generate a structured openpyxl workbook with a scenario selector, equity value bridge, and fully populated sensitivity grids that recompute DCF for each assumption combination.

Why use openpyxl over manual Excel modeling for DCF valuation and sensitivity analysis?▼

Using openpyxl over manual Excel modeling for DCF valuation automates the generation of institutional-grade layouts and sensitivity grids, eliminating ad-hoc spreadsheet math and ensuring live Excel formulas are consistently enforced across all valuation outputs.

Related Skills

Explore More Finance & Accounting Skills→
daloopadaloopa
482

dcf

Assemble cash flow and balance sheet inputs for a DCF model by ticker.

Official
Advanced
AnandaAnugrahHandyantoAnandaAnugrahHandyanto

dcf-model

Automates DCF valuation modeling in Excel with deterministic formulas and Bear/Base/Bull scenarios.

Community
Advanced
nadicodeainadicodeai

dcf-model

Computes a full DCF valuation in Excel with five-year projections and sensitivity analysis.

Official
Advanced
519lab519lab
2

dcf-model

Automate DCF valuation model construction and analysis with financial calculations.

Official
Advanced