creating-financial-models

Compute financial valuations and risk analysis with DCF, sensitivity, and Monte Carlo simulation.

Updated Mar 1, 2026
One-click install
npx skills add https://github.com/andy-austin/quipu --skill creating-financial-models-andy-austin
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: creating-financial-models
Source: https://github.com/andy-austin/quipu/tree/main/.claude/skills/creating-financial-models
Command: npx skills add https://github.com/andy-austin/quipu --skill creating-financial-models-andy-austin

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Financial modeling for investment decisions is complex and error-prone; this skill provides an advanced toolkit to build robust valuation models, test risk, and automate scenario planning.

Core Features & Use Cases

  • DCF Analysis: Build and value enterprises with multiple growth scenarios, terminal value methods, and WACC-based valuations.
  • Sensitivity & Scenario Analysis: Test key inputs (growth, margins, capex) and compare best/base/worst cases under uncertainty.
  • Monte Carlo Simulation: Run thousands of stochastic scenarios to quantify risk and generate confidence intervals.
  • Use Case: Evaluate an acquisition or project with alternative financing structures and risk profiles.

Quick Start

Provide historical financials and key assumptions to generate a full DCF valuation with scenario 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 with sensitivity analysis?

To build a DCF valuation, you provide historical financials, growth projections, WACC inputs, and capex assumptions to generate enterprise value, equity value, and sensitivity testing across best, base, and worst case scenarios.

What is Monte Carlo simulation used for in financial modeling?

Monte Carlo simulation in financial modeling runs thousands of stochastic scenarios to quantify risk and generate confidence intervals, providing a probability distribution of valuation outcomes rather than a single static estimate.

Can I test multiple financing structures for an acquisition valuation?

Yes, you can evaluate an acquisition or project using alternative financing structures and risk profiles by adjusting variable inputs within the scenario planning framework to compare different corporate valuation outcomes.

What inputs do I need for a discounted cash flow analysis?

DCF analysis requires inputs for historical financials, revenue projections, operating margins, WACC parameters, capital expenditure, and working capital assumptions to calculate terminal value and derive enterprise and equity value.

When should I use scenario planning instead of Monte Carlo simulation?

Use scenario planning to compare discrete best, base, and worst cases under specific assumptions, whereas Monte Carlo simulation is better for quantifying continuous risk across thousands of stochastic trials to generate confidence intervals.