dcf-modellisted

# 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>` - `scripts/validate_dcf.py` — DCF-specific validation (terminal growth < WACC, WACC in 5-20% range, TV as 40-80% of EV, formula errors). Run after recalc: `python scripts/validate_dcf.py <model.xlsx>` ## Tools - Default to using all information provided by the user and MCP servers available for data sourcing. ## Critical Constraints - Read These First ### Environment: Office JS vs Python/openpyxl - Office JS: Use r