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
Overview
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.
Use Cases
Install Notes
# Review source first
open https://github.com/fivetaku/claude-office-skills/blob/main/claude-in-excel/dcf-model/SKILL.mdCopy or clone the skill folder into your agent skills directory after reviewing its instructions and scripts.
Security Notes
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.
Related Skills
Xlsx
anthropics/skills
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scr...
Experience Lwc Widget Migrate
forcedotcom/sf-skills
Convert a specific existing Lightning web component (LWC) into a declarative HXL / Agentforce widget, end to end. Gates on experience-lwc-widget-assess and stops when a widget cannot serve the LWC's purpose; otherwise hands the derived field shape to platform-widget-generate and wires the widget as the Lightning Typ...
Experience Lwc Widget Assess
forcedotcom/sf-skills
Assess whether a specific Lightning web component can serve its user's purpose as an HXL declarative widget. Use for LWC-to-widget feasibility, portability audits, and candidate screening; use experience-lwc-widget-migrate when the user wants the widget built.
Service De Channel Consent Configure
forcedotcom/sf-skills
Configure consent (opt-in/opt-out) on an Enhanced `MessagingChannel` so activation will accept it. Given a `{CHANNEL_ID}`, sets the channel's `ConsentType` (ImplicitOptIn / ExplicitOptIn / DoubleOptIn) and the `OptInPrompt` / `DoubleOptInPrompt` prompt fields, then creates or updates one `MsgChannelLanguageKeyword`...
Clean Data
fivetaku/claude-office-skills
Clean up messy spreadsheet data — trim whitespace, fix inconsistent casing, convert numbers-stored-as-text, standardize dates, remove duplicates, and flag mixed-type columns. Use when data is messy, inconsistent, or needs prep before analysis. Triggers on "clean this data", "clean up this sheet", "normalize this data",
3-Statement Financial Model Template Completion
fivetaku/claude-office-skills
Complete, populate and fill out 3-statement financial model templates (Income Statement, Balance Sheet, Cash Flow Statement). Use when asked to fill out model templates, complete existing model frameworks, populate financial models with data, complete a partially filled IS/BS/CF framework, or link integrated financial