# dcf-model

> Claude/Codex skill by [@anthropics](https://omgskills.com/library/anthropics/index.md) · 34k stars · Updated 2026-08-04

Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need to value a company using DCF methodology, request intrinsic value analysis, or ask for detailed financial modeling with growth projections and terminal value calculations.

## Install

```sh
git clone https://github.com/anthropics/financial-services /tmp/financial-services && ln -s /tmp/financial-services/plugins/agent-plugins/pitch-agent/skills/dcf-model ~/.claude/skills/dcf-model
```

## From README

DCF Model Builder Overview This skill creates institutional-quality DCF models for equity valuation following investment banking standards. Each analysis produces a detailed Excel model (with sensitivity analysis included at the bottom of the DCF sheet). Tools Default to using all of the information provided by the user and MCP servers available for data sourcing. Critical Constraints - Read These First These constraints apply throughout all DCF model building. Review before starting: Environment: Office JS vs Python/openpyxl: If running inside Excel (Office Add-in / Office JS environment): Use Office JS directly — do NOT use Python/openpyxl. Write formulas via range.formulas = \[\["=D19(1+$B$8)"\]\]. No separate recalc step needed; Excel calculates natively. Use range.format. for styling. The same formulas-over-hardcodes rule applies: set .formulas, never .values for derived cells.

## Links

- HTML page: https://omgskills.com/skills/anthropics/financial-services-plugins/dcf-model/
- GitHub: https://github.com/anthropics/financial-services-plugins
- Author: [@anthropics](https://omgskills.com/library/anthropics/index.md)

## More from this repo

- [bond-futures-basis](https://omgskills.com/skills/anthropics/financial-services-plugins/bond-futures-basis/index.md) — Used to analyze the bond futures basis by pricing futures, identifying the cheapest-to-deliver, and comparing with...
   - [@anthropics](https://omgskills.com/library/anthropics/index.md) · 34k stars
- [clean-data-xls](https://omgskills.com/skills/anthropics/financial-services-plugins/clean-data-xls/index.md) — Clean up messy spreadsheet data — trim whitespace, fix inconsistent casing, convert numbers-stored-as-text, standardize...
   - [@anthropics](https://omgskills.com/library/anthropics/index.md) · 34k stars
- [comps-analysis](https://omgskills.com/skills/anthropics/financial-services-plugins/comps-analysis/index.md) — Used to build institutional-grade comparable company analyses with operating metrics, valuation multiples, and...
   - [@anthropics](https://omgskills.com/library/anthropics/index.md) · 34k stars