DCF Model Builder

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

概要

The DCF Model Builder is an AI agent skill designed for professional equity valuation, available within the fivetaku/claude-office-skills repository. It automates the creation of Discounted Cash Flow models by extracting financial data directly from SEC filings and analyst reports. The tool constructs detailed cash flow projections and calculates the Weighted Average Cost of Capital (WACC) to determine intrinsic value. Beyond basic modeling, it performs multi-variable sensitivity analysis to test various financial scenarios. The final output is a structured Excel workbook accompanied by a concise executive summary. Compatible with Claude and Claude-code, this skill streamlines the transition from raw financial data to investment-grade analysis, ensuring technical accuracy through data-driven validation and Python-based processing.

ユースケース

Automating the extraction of historical financial data from SEC filings for valuation modeling.

Generating comprehensive Excel-based DCF models with integrated WACC and sensitivity tables.

Producing executive summaries and valuation reports for investment analysis and decision-making.

導入方法

# Review source first
open https://github.com/fivetaku/claude-office-skills/blob/main/claude-in-excel/dcf-model/SKILL.md

Copy or clone the skill folder into your agent skills directory after reviewing its instructions and scripts.

セキュリティ

This skill processes financial data from external sources like SEC filings and analyst reports to generate Excel models. Users should ensure that any proprietary data handled by the agent complies with their organization's data privacy policies. The skill relies on the execution environment provided by the host agent to perform data retrieval and file generation.