creating-financial-models

Perform DCF, sensitivity, Monte Carlo, and scenario analysis for valuations.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/ncy08/clear-claude-code --skill creating-financial-models-ncy08
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: creating-financial-models
Source: https://github.com/ncy08/clear-claude-code/tree/main/tools/skills/creating-financial-models
Command: npx skills add https://github.com/ncy08/clear-claude-code --skill creating-financial-models-ncy08

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires numpy, pandas.

What problem does it solve?

This skill provides a framework for building advanced financial valuation and risk analysis models, automating calculations and scenario testing to support investment decisions.

Core Features & Use Cases

  • DCF analysis with enterprise and equity valuations
  • Sensitivity analysis and scenario testing
  • Monte Carlo simulations to model uncertainty
  • Scenario planning across multiple business contexts
  • Export results to Excel or CSV and generate valuation summaries

Quick Start

Create a 5-year DCF model for a target company using the provided historicals and 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 for corporate valuation using historical financials?

DCF modeling applies historical financial data and projection inputs to calculate enterprise and equity valuations. The skill validates assumptions and automates the workflow to generate robust corporate valuation results.

Can I run Monte Carlo simulations for risk analysis on project appraisal?

Monte Carlo simulations model uncertainty for project appraisal and M&A decisions. The skill applies risk analysis to your financial projections, generating probability distributions to support robust investment valuations.

What's the best way to perform sensitivity analysis and scenario planning for M&A?

Sensitivity analysis and scenario planning test how variable changes impact M&A valuations. The skill applies these techniques across multiple business contexts to evaluate risk and validate investment assumptions.

Do I need numpy and pandas to run financial modeling workflows?

Numpy and pandas are required dependencies for running financial modeling workflows. They support data manipulation and calculation processes for DCF, Monte Carlo simulations, and sensitivity analysis.

How does scenario planning work across different business contexts?

Scenario planning models multiple business contexts by adjusting projection inputs and assumptions. The skill validates these inputs to compare outcomes and generate valuation summaries for corporate valuation or project appraisal.

Can I export financial modeling results to Excel or CSV?

Financial modeling results export to Excel or CSV. The skill generates valuation summaries from your DCF, sensitivity analysis, and Monte Carlo simulations for reporting and further investment analysis.