creating-financial-models

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

28|5|Updated Jun 24, 2025
One-click install
npx skills add https://github.com/thevibeworks/claude-code-docs --skill creating-financial-models-thevibeworks
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: creating-financial-models
Source: https://github.com/thevibeworks/claude-code-docs/tree/main/content/github/claude-cookbooks/skills/custom_skills/creating-financial-models
Command: npx skills add https://github.com/thevibeworks/claude-code-docs --skill creating-financial-models-thevibeworks

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill solves the problem of producing rigorous, assumption-driven financial valuations and risk assessments without manually stitching together complex spreadsheets from scratch.

Core Features & Use Cases

  • Discounted Cash Flow (DCF) Analysis: Forecast cash flows, compute terminal value (perpetuity growth or exit multiple), calculate WACC, and summarize enterprise/equity valuation.
  • Sensitivity Analysis: Quantify how key assumptions change valuation via data tables and tornado charts to identify the biggest value drivers.
  • Monte Carlo Simulation & Scenario Planning: Model uncertainty with thousands of iterations and compare best/base/worst cases using probability-weighted outcomes.

Quick Start

Generate a DCF model with WACC, run sensitivity analysis on growth rate and discount rate, and execute a Monte Carlo simulation with 5,000 iterations for the provided financial assumptions.

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 with WACC and terminal value calculations?

A DCF model with WACC forecasts cash flows, computes terminal value via perpetuity growth or exit multiple, and summarizes enterprise/equity valuation. This skill automates those calculations from your financial assumptions to produce decision-ready valuation outputs.

What is Monte Carlo simulation in financial modeling and when is it needed?

Monte Carlo simulation in financial modeling quantifies uncertainty by running thousands of iterations to produce probability-weighted outcomes. It is needed when you require confidence intervals and risk metrics for investment valuation rather than relying on static forecasts.

How do I run sensitivity analysis and create tornado charts for valuation?

Sensitivity analysis quantifies how key assumptions change valuation via data tables and tornado charts. You identify the biggest value drivers by testing variations in growth rates and discount rates, which this skill generates automatically alongside your DCF model.

Can I use this financial modeling skill for LBO and M&A analysis?

Yes, you can use this financial modeling skill for LBO modeling and M&A analysis. It applies to corporate valuation and project finance, generating scenario comparison tables and probability-weighted outcomes from your provided transaction inputs.

What's the best way to compare best, base, and worst case scenarios in a valuation model?

The best way to compare valuation scenarios is using probability-weighted outcomes across best, base, and worst cases. This skill runs Monte Carlo simulations and generates scenario comparison tables to show how different assumptions impact enterprise and equity values.