name: creating-financial-models description: This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions

Financial Modeling Suite

A comprehensive financial modeling toolkit for investment analysis, valuation, and risk assessment using industry-standard methodologies.

Core Capabilities

1. Discounted Cash Flow (DCF) Analysis

• Build complete DCF models with multiple growth scenarios
• Calculate terminal values using perpetuity growth and exit multiple methods
• Determine weighted average cost of capital (WACC)
• Generate enterprise and equity valuations

2. Sensitivity Analysis

• Test key assumptions impact on valuation
• Create data tables for multiple variables
• Generate tornado charts for sensitivity ranking
• Identify critical value drivers

3. Monte Carlo Simulation

• Run thousands of scenarios with probability distributions
• Model uncertainty in key inputs
• Generate confidence intervals for valuations
• Calculate probability of achieving targets

4. Scenario Planning

• Build best/base/worst case scenarios
• Model different economic environments
• Test strategic alternatives
• Compare outcome probabilities

Output Formats

DCF Model Output

• Complete financial projections
• Free cash flow calculations
• Terminal value computation
• Enterprise and equity value summary
• Valuation multiples implied
• Excel workbook with full model

Sensitivity Analysis Output

• Sensitivity tables showing value ranges
• Tornado chart of key drivers
• Break-even analysis
• Charts showing relationships

Monte Carlo Output

• Probability distribution of valuations
• Confidence intervals (e.g., 90%, 95%)
• Statistical summary (mean, median, std dev)
• Risk metrics (VaR, probability of loss)

Scenario Planning Output

• Scenario comparison table
• Probability-weighted expected values
• Decision tree visualization
• Risk-return profiles

Model Types Supported

1. Corporate Valuation

   • Mature companies with stable cash flows
   • Growth companies with J-curve projections
   • Turnaround situations

2. Project Finance

   • Infrastructure projects
   • Real estate developments
   • Energy projects

3. M&A Analysis

   • Acquisition valuations
   • Synergy modeling
   • Accretion/dilution analysis

4. LBO Models

   • Leveraged buyout analysis
   • Returns analysis (IRR, MOIC)
   • Debt capacity assessment

Best Practices Applied

Modeling Standards

• Consistent formatting and structure
• Clear assumption documentation
• Separation of inputs, calculations, outputs
• Error checking and validation
• Version control and change tracking

Valuation Principles

• Use multiple valuation methods for triangulation
• Apply appropriate risk adjustments
• Consider market comparables
• Validate against trading multiples
• Document key assumptions clearly

Risk Management

• Identify and quantify key risks
• Use probability-weighted scenarios
• Stress test extreme cases
• Consider correlation effects
• Provide confidence intervals

Scripts Included

• dcf_model.py: Complete DCF valuation engine
• sensitivity_analysis.py: Sensitivity testing framework

Limitations and Disclaimers

• Models are only as good as their assumptions
• Past performance doesn't guarantee future results
• Market conditions can change rapidly
• Regulatory and tax changes may impact results
• Professional judgment required for interpretation
• Not a substitute for professional financial advice

Quality Checks

The model automatically performs:

1. Balance sheet balancing checks
2. Cash flow reconciliation
3. Circular reference resolution
4. Sensitivity bound checking
5. Statistical validation of Monte Carlo results

Updates and Maintenance

• Models use latest financial theory and practices
• Regular updates for market parameter defaults
• Incorporation of regulatory changes
• Continuous improvement based on usage patterns