skills.rest
executiveusa
executiveusaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

dcf-model

Build Excel-ready DCF equity valuation models with live formulas and sensitivity grids.

1|Updated May 16, 2026
Search Tags:#financial forecasting#sensitivity analysis#dcf#equity valuation#wacc#excel modeling#capm
One-click install
npx skills add https://github.com/executiveusa/Cheggie-trade-V2 --skill dcf-model-executiveusa
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/executiveusa/Cheggie-trade-V2/tree/main/core/financial-skills/plugins/vertical-plugins/financial-analysis/skills/dcf-model
Command: npx skills add https://github.com/executiveusa/Cheggie-trade-V2 --skill dcf-model-executiveusa

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

DCF model creation is complex, error-prone, and time-consuming when you need internally consistent cash flows, WACC, terminal value, and sensitivity analysis. This skill helps you produce a professional equity valuation model that updates cleanly as assumptions change.

Core Features & Use Cases

  • Real DCF model construction: Builds institutional-quality unlevered free cash flow projections with proper tax, D&A, CapEx, and working capital logic.
  • WACC + CAPM guardrails: Computes cost of equity via CAPM inputs, cost of debt with after-tax adjustment, and weights based on enterprise value.
  • Terminal value + valuation bridge: Applies a perpetuity growth terminal value method with a terminal growth < WACC constraint and converts EV to equity value per share using diluted shares.
  • Three-scenario support (Bear/Base/Bull): Uses a scenario selector pattern to drive assumptions consistently across the model.
  • Sensitivity analysis: Generates full DCF recalculation grids (no placeholder/linear approximations), with the base case centered and highlighted.

Quick Start

Use the dcf-model skill to generate an Excel DCF equity valuation for the company you specify, then confirm the raw inputs and the projected schedule before finalizing sensitivity tables.

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 equity valuation model with proper WACC and terminal value calculations in Excel?▼

To build a DCF equity valuation model, this skill programmatically projects unlevered free cash flows, calculates WACC using CAPM inputs, and applies a perpetuity growth terminal value to output an Excel-ready deliverable with live formulas.

How do I generate sensitivity analysis grids for a DCF model without using placeholder approximations?▼

Generating sensitivity analysis grids for a DCF model requires full recalculation across assumptions, which this skill performs programmatically to populate complete grids with the base case centered and highlighted, avoiding linear approximations.

What is the best way to structure Bear, Base, and Bull scenarios for financial forecasting in Excel?▼

Structuring Bear, Base, and Bull scenarios for financial forecasting is handled via a scenario selector pattern that consistently drives growth and margin projections across the entire DCF model before exporting to Excel.

Does this DCF modeling approach apply mid-year discounting and a full enterprise value to equity value bridge?▼

Yes, this DCF modeling approach applies mid-year discounting to projected cash flows and includes a complete terminal value bridge to equity value per share using diluted shares, ensuring consistent accounting logic.

Can I use openpyxl to create Excel models with live formulas for intrinsic value estimates?▼

Yes, you can use openpyxl to create Excel models, as this skill leverages it to generate an Excel-ready deliverable featuring live formulas, fully populated sensitivity grids, and per-share equity outputs.

How does CAPM calculate the cost of equity for WACC in institutional-grade equity valuation?▼

CAPM calculates the cost of equity for WACC by applying standard market inputs, which this skill combines with an after-tax adjusted cost of debt and enterprise value weights to produce institutional-grade equity valuation outputs.

Related Skills

Explore More Finance & Accounting Skills→
hmzainjamilhmzainjamil
1

financial-modeling

Build integrated three-statement financial models with linked projections and balance-sheet reconciliation.

Community
Advanced
xfs96192xfs96192

dcf-model

Build a DCF equity valuation model with Excel workbook output.

Community
Advanced
ruiyangruiyiruiyangruiyi

dcf-model

Generate Excel DCF valuation models with live formulas and sensitivity grids.

Community
Advanced
hck717hck717

valuation-analysis

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

Community
Advanced