Builds a discounted cash-flow valuation with operating assumptions, WACC, terminal value, and sensitivity analysis.
---
name: dcf-model
description: 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.
---
# DCF Model Builder
## Overview
Institutional-quality DCF models for equity valuation following investment banking standards.
Each analysis produces a detailed Excel model (with sensitivity analysis at bottom of DCF sheet).
## Preflight: Dependency Check
Before starting, verify required libraries and tools are installed and install any that are missing.
```bash
python3 -c "import openpyxl" 2>/dev/null || python3 -m pip install openpyxl
command -v soffice >/dev/null 2>&1 || command -v libreoffice >/dev/null 2>&1 || ls /Applications/LibreOffice.app/Contents/MacOS/soffice >/dev/null 2>&1 || echo "WARNING: LibreOffice not found. Install: brew install --cask libreoffice (macOS) or apt install libreoffice (Linux). Required for scripts/recalc.py."
```
**Important**: Do not skip this step — `scripts/recalc.py` and `scripts/validate_dcf.py` need these tools to verify sensitivity tables and TV-as-%-of-EV sanity checks.
## Scripts
- `scripts/recalc.py` — Force formula recalculation via headless LibreOffice. Run after building: `python scripts/recalc.py <model.xlsx>`… load the full skill through Skill Me