creating-financial-models

Builds DCF valuations, sensitivity analyses, Monte Carlo simulations, and scenario plans for investment decisions.

Updated Aug 28, 2026
One-click install
npx skills add https://github.com/listentomi/Orcajack --skill creating-financial-models-listentomi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: creating-financial-models
Source: https://github.com/listentomi/Orcajack/tree/main/skills/finance/creating-financial-models
Command: npx skills add https://github.com/listentomi/Orcajack --skill creating-financial-models-listentomi

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Building rigorous financial models for valuation and risk assessment requires combining multiple methodologies, and doing it manually is slow and error-prone. This Skill generates complete financial models covering DCF valuation, sensitivity testing, Monte Carlo simulation, and scenario planning from your financial inputs. ## Core Features & Use Cases - DCF Valuation: Builds full discounted cash flow models with WACC calculation, terminal value via perpetuity growth or exit multiples, and enterprise/equity value summaries. - Sensitivity & Scenario Analysis: Produces sensitivity tables, tornado charts, and best/base/worst case comparisons with probability-weighted outcomes. - Monte Carlo Simulation: Runs thousands of iterations with probability distributions to generate confidence intervals, VaR, and risk metrics. - Use Case: An analyst evaluating an acquisition target provides three years of financial statements and asks for a DCF model plus a Monte Carlo simulation with 5,000 iterations to quantify valuation uncertainty. ## Quick Start Build a DCF model for this technology company using the attached financial statements and include a sensitivity analysis on growth rate and WACC.

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?▼

Provide 3-5 years of historical financial statements plus assumptions for revenue growth, operating margins, capital expenditure, and working capital. The model computes free cash flows, WACC, terminal value, and outputs enterprise and equity valuations.

What inputs are needed for a Monte Carlo valuation simulation?▼

Monte Carlo simulation requires probability distributions for uncertain variables, correlation assumptions between variables, and an iteration count, typically 1,000 to 10,000. Output includes valuation distributions, confidence intervals, and risk metrics like VaR.

What model types does this financial modeling skill support?▼

It supports corporate valuation for mature and growth companies, project finance for infrastructure and real estate, M&A analysis with synergy and accretion/dilution modeling, and LBO models with IRR and MOIC returns analysis.

What are the limitations of DCF and Monte Carlo financial models?▼

Models are only as good as their assumptions, and past performance does not guarantee future results. Market conditions, regulatory changes, and tax shifts can affect outcomes, so results require professional judgment and are not a substitute for financial advice.

How does sensitivity analysis identify key valuation drivers?▼

Sensitivity analysis tests how changes in assumptions like growth rate and WACC affect valuation, producing data tables and tornado charts that rank variables by impact. It also includes break-even analysis to show where value thresholds are crossed.