# Creating Financial Models

Provides an advanced financial modeling suite with DCF analysis, sensitivity testing...

- Repository: https://github.com/anthropics/claude-cookbooks (54066 stars)
- Category: Testing
- License: MIT
- Last updated: 2026-10-29
- Runs scripts: yes, review before use

## Install

Claude Code: `npx skills add anthropics/claude-cookbooks --skill creating-financial-models -g -a claude-code -y`
Codex: `npx skills add anthropics/claude-cookbooks --skill creating-financial-models -g -a codex -y`
Cursor: `npx skills add anthropics/claude-cookbooks --skill creating-financial-models -g -a cursor -y`
Gemini CLI: `npx skills add anthropics/claude-cookbooks --skill creating-financial-models -g -a gemini-cli -y`

## Description

This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

# Financial Modeling Suite

A comprehensive financial modeling toolkit for investment analysis, valuation, and risk assessment using industry-standard methodologies.

## Core Capabilities

### 1. Discounted Cash Flow (DCF) Analysis
- Build complete DCF models with multiple growth scenarios
- Calculate terminal values using perpetuity growth and exit multiple methods
- Determine weighted average cost of capital (WACC)
- Generate enterprise and equity valuations

### 2. Sensitivity Analysis
- Test key assumptions impact on valuation
- Create data tables for multiple variables
- Generate tornado charts for sensitivity ranking
- Identify critical value drivers

### 3. Monte Carlo Simulation
- Run thousands of scenarios with probability distributions
- Model uncertainty in key inputs
- Generate confidence intervals for valuations
- Calculate probability of achieving targets

### 4. Scenario Planning
- Build best/base/worst case scenarios
- Model different economic environments
- Test strategic alternatives
- Compare outcome probabilities

## Input Requirements

### For DCF Analysis
- Historical financial statements (3-5 years)
- Revenue growth assumptions
- Operating margin projections
- Capital expenditure forecasts
- Working capital requirements
- Terminal growth rate or exit multiple
- Discount rate components (risk-free rate, beta, market premium)

### For Sensitivity Analysis
- Base case model
- Variable ranges to test
- Key metrics to track

### For Monte Carlo Simulation
- Probability distributions for uncertain variables
- Correlation assumptions between variables
- Number of iterations (typically 1,000-10,000)

### For Scenario Planning
- Scenario definitions and assumptions
- Probability weights for scenarios
- Key performance indicators to track

## Output Formats

The rest: https://github.com/anthropics/claude-cookbooks/blob/HEAD/skills/custom_skills/creating-financial-models/SKILL.md