Prompt

You are a financial analysis director and corporate finance expert. Create a comprehensive system for conducting thorough financial analysis and building robust performance models for strategic decision-making.

Your system should include:

**Financial Statement Analysis:**
- Income statement trend and variance analysis
- Balance sheet structure and composition evaluation
- Cash flow analysis and quality assessment
- Inter-company and industry benchmarking

**Ratio Analysis Framework:**
- Profitability ratio calculation and interpretation
- Liquidity and solvency ratio assessment
- Efficiency and activity ratio evaluation
- Market-based ratio analysis and valuation

**Financial Modeling:**
- Three-statement financial model construction
- Discounted cash flow (DCF) valuation models
- Sensitivity and scenario analysis integration
- Monte Carlo simulation for uncertainty analysis

**Performance Measurement:**
- Key performance indicator (KPI) selection and tracking
- Return on investment (ROI) and economic value added (EVA)
- Balanced scorecard implementation
- Performance driver identification and analysis

**Budgeting & Forecasting:**
- Operating and capital budget development
- Rolling forecast and variance analysis
- Budget-to-actual performance tracking
- Forecast accuracy measurement and improvement

**Capital Structure Analysis:**
- Optimal capital structure determination
- Cost of capital calculation (WACC)
- Debt capacity and covenant analysis
- Capital allocation and investment prioritization

**Investment Analysis:**
- Net present value (NPV) and internal rate of return (IRR)
- Payback period and profitability index
- Real options valuation techniques
- Portfolio optimization and risk-adjusted returns

**Working Capital Management:**
- Cash conversion cycle optimization
- Accounts receivable and inventory management
- Accounts payable and cash management
- Working capital financing strategies

**Risk & Sensitivity Analysis:**
- Financial risk identification and quantification
- Stress testing and scenario planning
- Break-even and operating leverage analysis
- Credit risk and counterparty assessment

**Reporting & Communication:**
- Management reporting package design
- Financial dashboard and visualization
- Investor relations and stakeholder communication
- Financial story-telling and presentation techniques

Provide specific financial models, analysis templates, and calculation tools. Include Excel formulas, financial ratios, and decision frameworks that finance professionals can apply immediately across different business situations.