skills.rest
LuizEduPP
LuizEduPPCOMMUNITY
Explore all skills by this author →
GitHub

creating-financial-models

Build DCF, sensitivity, and Monte Carlo financial models with numpy and pandas.

Updated Apr 10, 2026
Search Tags:#risk-management#valuation#financial-modeling#dcf#monte-carlo#sensitivity-analysis#scenario-planning
One-click install
npx skills add https://github.com/LuizEduPP/skills --skill creating-financial-models-luizedupp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: creating-financial-models
Source: https://github.com/LuizEduPP/skills/tree/main/creating-financial-models
Command: npx skills add https://github.com/LuizEduPP/skills --skill creating-financial-models-luizedupp

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires numpy, pandas.

What problem does it solve?

Investors and strategic teams often juggle fragmented spreadsheets to value companies, leaving them without a cohesive way to model cash flows, risk, and scenarios that can stand up to due diligence and stakeholder review.

Core Features & Use Cases

  • Discounted Cash Flow Modeling: The suite generates projection drivers, calculates WACC, and delivers enterprise and equity valuations with terminal value options for both growth and multiple methods.
  • Sensitivity, Scenario, and Monte Carlo Analytics: Use the scripts to stress-test assumptions, build data tables, run tornado diagrams, and simulate thousands of outcomes that quantify confidence intervals and risk metrics such as VaR.
  • Integrated Risk and Best-Practice Controls: Built-in checks ensure balance sheet consistency, cash flow reconciliation, and circular reference handling while documenting assumptions clearly for corporate, project finance, M&A, and LBO decisions.
  • Use Case: Assemble a full valuation package for a technology acquisition by combining DCF modeling, sensitivity of WACC vs. growth, and scenario-weighted Monte Carlo outcomes to present to the investment committee.

Quick Start

Build a DCF valuation for the acquisition target using the supplied statements and run a Monte Carlo confidence analysis.

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 valuation model for an M&A acquisition?▼

To build a DCF valuation, the Skill uses historical financials and assumption sets to project cash flows, calculate WACC, and deliver enterprise and equity valuations with terminal value options for M&A decisions.

Can I run Monte Carlo simulations for financial risk assessment using numpy and pandas?▼

Yes, Monte Carlo simulations for financial risk assessment run on numpy and pandas scripts, simulating thousands of outcomes to quantify confidence intervals and risk metrics like VaR for corporate and project finance scenarios.

What is sensitivity analysis and how does it handle scenario planning in corporate finance?▼

Sensitivity analysis and scenario planning in corporate finance stress-test assumptions by building data tables and tornado diagrams, ensuring valuation models withstand due diligence and stakeholder review across different risk scenarios.

Does this financial modeling approach support LBO and project finance scenarios?▼

Yes, the financial modeling approach supports LBO and project finance scenarios, providing integrated risk controls, balance sheet consistency checks, and cash flow reconciliation to handle circular references for complex corporate decisions.

What historical financials and probability distributions do I need for cash flow projections?▼

Cash flow projections require historical financials, assumption sets, and probability distributions as inputs, allowing the numpy and pandas-based scripts to accurately project cash flows and compute valuations for investment committee review.

Related Skills

Explore More Finance & Accounting Skills→
yf8578yf8578
1

flowio

Parse and create FCS files, converting event data to NumPy arrays or Pandas DataFrames.

Community
Intermediate
thevibeworksthevibeworks
28

creating-financial-models

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

Official
Advanced
hmzainjamilhmzainjamil
1

financial-modeling

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

Community
Advanced
mbarnes-codembarnes-code

creating-financial-models

Build DCF models with sensitivity testing and Monte Carlo simulations.

Community
Advanced