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
Requirements for Outputs
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, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or fr
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
Audit Spreadsheet
fivetaku/claude-office-skills
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model, including financial-model integrity checks like BS balance, cash tie-out, and logic sanity. Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreads
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",