Home
cd ../playbooks
Finance & AccountingIntermediate

DCF Model Builder for Equity Valuation

Create institutional-quality discounted cash flow models with WACC calculations, sensitivity analysis, and professional Excel output for equity valuation.

5 minutes
By anthropicSource
#DCF#discounted cash flow#equity valuation#WACC#terminal value#financial modeling

Building a defensible DCF model requires getting dozens of assumptions right — from revenue projections and margin trajectories to WACC components and terminal value methodology — and a single misstep in the discount rate or growth assumption can swing the valuation by billions.

Who it's for: investment banking analysts, equity research analysts, corporate development teams, private equity professionals, valuation specialists

Example

"Build a DCF model for Microsoft with 10-year projections" → Professional Excel workbook with unlevered free cash flow projections, WACC buildup, terminal value (both perpetuity growth and exit multiple methods), sensitivity tables, implied share price, and executive summary

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add fa-dcf-model
# DCF Model Builder

## Overview

This skill creates institutional-quality DCF models for equity valuation following investment banking standards. Each analysis produces a detailed Excel model (with sensitivity analysis included at the bottom of the DCF sheet).

## Tools

- Default to using all of the information provided by the user and MCP servers available for data sourcing.

## Critical Constraints - Read These First

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Creates institutional-quality DCF (Discounted Cash Flow) models for equity valuation following investment banking standards. Retrieves financial data, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs a professional Excel model with an executive summary.


Quick Start

Step 1: Create a Project Folder

Create a folder for your DCF analysis and place the downloaded template inside as CLAUDE.md.

Step 2: Download the Template

Click Download above, then move the file into your project folder as CLAUDE.md.

Step 3: Start Working

"Build a DCF model for Apple with a 10-year projection period"
"Create a discounted cash flow analysis for Tesla — use both perpetuity growth and exit multiple terminal values"
"DCF valuation for Amazon with sensitivity on WACC and terminal growth rate"

Model Components

The DCF model includes:

  • Unlevered Free Cash Flow projections with detailed revenue, margin, and CapEx assumptions
  • WACC buildup with cost of equity (CAPM), cost of debt, and capital structure weights
  • Terminal value calculated via both perpetuity growth method and exit multiple method
  • Sensitivity analysis tables varying WACC and terminal growth rate / exit multiple
  • Implied share price with equity bridge (Enterprise Value to Equity Value)

Key Constraints

  • Every calculation is an Excel formula — never hardcoded computed values
  • Terminal growth rate must not exceed WACC (the model validates this)
  • All formulas use proper cell references so the model updates dynamically when assumptions change
  • Sensitivity tables use odd dimensions (5x5 or 7x7) with the base case at the center cell

Tips & Best Practices

  • Use formula-driven cells throughout — the model must be dynamic and update when any input changes
  • Break circular references by using beginning-of-period balances for interest calculations
  • Cross-check terminal value — it typically represents 60-80% of total enterprise value; if it is outside this range, revisit assumptions
  • Run both terminal value methods (perpetuity growth and exit multiple) and compare results for reasonableness
  • Sensitivity tables should show different values in every cell — if values are identical, the formulas are not properly linked to the varying inputs

Dependencies

  • Python (openpyxl) for Excel file generation
  • Financial data from SEC filings or analyst reports

$Related Playbooks

Finance & Accounting

Presentation Deck Number Refresh

Update numbers across an existing presentation deck — quarterly refreshes, earnings updates, comp rolls, and rebased market data — while preserving all formatting.

5 minutes
Beginner
Finance & Accounting

Investment Banking Deck Quality Checker

Comprehensive QC review of pitch decks and client presentations covering number consistency, data-narrative alignment, language polish, and visual formatting.

5 minutes
Beginner
Finance & Accounting

LBO Model Builder for Private Equity

Build leveraged buyout models in Excel with Sources & Uses, operating projections, debt schedules, returns analysis (IRR/MOIC), and sensitivity tables following investment banking standards.

5 minutes
Intermediate
Finance & Accounting

PowerPoint Template Skill Creator

Turn a branded PowerPoint template into a reusable skill that can generate on-brand presentations programmatically, with precise placeholder mapping and layout documentation.

5 minutes
Beginner
Finance & Accounting

Expense Report Generator

Organize business expenses into categorized reports for reimbursement, accounting, and tax preparation.

10 minutes
Intermediate
Finance & Accounting

Expense Tracker & Categorizer

Automate expense tracking, receipt processing, approval workflows, and reimbursement management

10 minutes
Advanced
Finance & Accounting

Personal Finance Manager — AI Budget Tracker from Bank Statements

Import bank statements (CSV or PDF) and get instant spending breakdowns, budget analysis using the 50/30/20 rule, savings recommendations, and interactive charts. All data stays local on your machine.

10 minutes
Beginner
Finance & Accounting

Financial Statement Generator

Generate P&L, balance sheet, and cash flow statements from financial data

10 minutes
Advanced
Finance & Accounting

Grow Sustainably (Without VC)

Evaluate every business decision — spending, hiring, fundraising, scaling — through the lens of profitability and infinite runway. The anti-burnout, anti-blitzscaling operating manual.

5 minutes
Intermediate
Finance & Accounting

Journal Entry Preparer

Prepare journal entries with proper debits, credits, and supporting documentation

10 minutes
Intermediate
Finance & Accounting

Invoice Processing Automation

Automate invoice generation, sending, tracking, and payment reconciliation across accounting platforms

10 minutes
Advanced
Finance & Accounting

Professional Invoice Generator

Create professional invoices with proper formatting for freelancers and small businesses. Supports multiple currencies and tax calculations.

10 minutes
Advanced

Browse all Finance & Accounting playbooks →