skills.rest
anthropics
anthropicsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

creating-financial-models

Automate financial valuation models with DCF, sensitivity, and Monte Carlo analysis.

51.2k|6.1k|Updated Aug 15, 2023
Search Tags:#financial modeling#valuation#DCF#investment analysis#sensitivity analysis#Monte Carlo#corporate finance
One-click install
npx skills add https://github.com/anthropics/claude-cookbooks --skill creating-financial-models
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: creating-financial-models
Source: https://github.com/anthropics/claude-cookbooks/tree/main/skills/custom_skills/creating-financial-models
Command: npx skills add https://github.com/anthropics/claude-cookbooks --skill creating-financial-models

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires numpy, pandas, and includes scripts (resource) components.

What problem does it solve?

Building complex financial models like DCF, running sensitivity analyses, and performing Monte Carlo simulations are time-consuming and require specialized expertise. This skill automates these advanced financial tasks, allowing users to quickly generate robust models and insights without manual spreadsheet work.

Core Features & Use Cases

  • Discounted Cash Flow (DCF) Analysis: Construct full DCF models, calculate WACC, and derive enterprise/equity valuations.
  • Sensitivity & Scenario Planning: Test key assumptions, create data tables, and model best/base/worst-case scenarios to understand risk.
  • Monte Carlo Simulations: Run thousands of iterations to model uncertainty and generate confidence intervals for valuations.
  • Use Case: An investment analyst needs to quickly value a target company, assess the impact of varying growth rates and discount rates, and understand the probability distribution of potential outcomes. This skill allows them to input financial data and assumptions to generate a comprehensive valuation report in minutes.

Quick Start

Build a DCF model for 'Acme Corp' using the attached historical financials and these assumptions: 5 projection years, 10% average revenue growth, 20% EBITDA margin, 3% terminal growth, and a WACC of 8%.

Frequently Asked Questions about creating-financial-models

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a DCF model to value a company?▼

DCF modeling constructs a discounted cash flow valuation by projecting future financials, calculating WACC as your discount rate, and deriving enterprise and equity value. This skill automates projection setup, WACC computation, and valuation calculation from historical data and your assumptions.

What's the best way to test financial model assumptions?▼

Sensitivity analysis tests how changes in key assumptions—like growth rates or discount rates—affect valuation outcomes. This skill generates sensitivity tables and scenario comparisons (best/base/worst case) to show which assumptions drive value most.

Can I model uncertainty in financial projections?▼

Monte Carlo simulation runs thousands of iterations across uncertain variables to generate probability distributions and confidence intervals for valuations. This skill automates the simulation setup and produces risk metrics from your input ranges.

Do I need specialized software to run financial models?▼

You need numpy and pandas for numerical computation and data handling. This skill provides the modeling logic; Excel workbooks and charts are generated as outputs for further analysis or reporting.

How does WACC factor into enterprise valuation?▼

WACC (weighted average cost of capital) is the discount rate applied to projected cash flows to calculate present value. This skill computes WACC from your inputs and applies it to derive both enterprise and equity valuations.

What financial scenarios can I model for M&A or LBO analysis?▼

This skill supports DCF analysis across corporate valuation, project finance, M&A, and LBO contexts. You input historical financials, projection assumptions, and risk parameters to generate comprehensive valuations and scenario outputs.

Related Skills

Explore More Finance & Accounting Skills→
hmzainjamilhmzainjamil
1

financial-modeling

Build integrated three-statement financial models with linked projections and balance-sheet reconciliation.

Community
Advanced
thevibeworksthevibeworks
28

creating-financial-models

Create financial models with DCF, sensitivity analysis, and Monte Carlo simulation.

Official
Advanced
zk-b612zk-b612
53

creating-financial-models

Build, validate, and compare financial models using Python and numpy.

Community
Advanced
kadurmkadurm
1

creating-financial-models

Build DCF, sensitivity, Monte Carlo, and scenario models with Python scripts.

Community
Advanced