creating-financial-models

Build DCF models with sensitivity analysis and Monte Carlo simulations.

Updated Jan 23, 2026
One-click install
npx skills add https://github.com/LisaPullman/foxai_skills --skill creating-financial-models-lisapullman
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: creating-financial-models
Source: https://github.com/LisaPullman/foxai_skills/tree/main/skills/creating-financial-models
Command: npx skills add https://github.com/LisaPullman/foxai_skills --skill creating-financial-models-lisapullman

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill provides an advanced toolkit for rigorous financial valuation and risk assessment, enabling users to build end-to-end models and analyze investment opportunities.

Core Features & Use Cases

  • DCF analysis for enterprise and equity valuations with scenario-aware projections.
  • Sensitivity analysis to identify key drivers and break-even conditions.
  • Monte Carlo simulations to quantify uncertainty and generate confidence intervals.
  • Scenario planning to compare base, optimistic, and pessimistic cases for strategic decisions.
  • Use Case: Evaluate an acquisition target by modeling revenue growth, margins, capex, and debt scenarios to derive EV and per-share values.

Quick Start

Build a five-year DCF model using the attached financials and run a Monte Carlo simulation to assess risk.

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 Monte Carlo simulations for risk analysis?

DCF modeling with Monte Carlo simulations uses historical financials and revenue growth inputs to quantify uncertainty, generating enterprise value estimates and confidence intervals for risk assessment.

What is scenario planning in financial modeling and when should I use it?

Scenario planning in financial modeling compares base, optimistic, and pessimistic cases to evaluate strategic decisions. Use it to assess how revenue growth, margins, and capex variations impact equity valuation.

How do I calculate enterprise value and per-share metrics from historical financials?

Calculating enterprise value and per-share metrics requires historical financials, discount rate components, and working capital inputs. The process projects future cash flows to derive equity value and per-share metrics.

Can I run sensitivity testing and break-even analysis using numpy and pandas?

Sensitivity testing using numpy and pandas identifies key valuation drivers and break-even conditions. It manipulates financial data arrays to isolate how individual margin and capex variables shift enterprise value outputs.

Does this financial modeling approach work for project appraisal and equity research?

This financial modeling approach supports project appraisal and equity research by applying DCF analysis and risk assessment across corporate finance workflows to generate enterprise value and equity value metrics.