Financial Analysis Suite
A comprehensive financial analysis toolkit combining ratio analysis, valuation modeling, and risk assessment using industry-standard methodologies.
Core Capabilities
1. Financial Ratio Analysis
Calculate and interpret key financial metrics:
- Profitability: ROE, ROA, Gross Margin, Operating Margin, Net Margin
- Liquidity: Current Ratio, Quick Ratio, Cash Ratio
- Leverage: Debt-to-Equity, Interest Coverage, Debt Service Coverage
- Efficiency: Asset Turnover, Inventory Turnover, Receivables Turnover
- Valuation: P/E, P/B, P/S, EV/EBITDA, PEG
- Per-Share: EPS, Book Value per Share, Dividend per Share
2. Valuation Models
Discounted Cash Flow (DCF)
- 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
Comparable Company Analysis
- Identify peer companies
- Analyze trading multiples (P/E, EV/EBITDA, P/S)
- Calculate valuation ranges
Precedent Transactions
- Review similar deals for valuation benchmarks
- Analyze transaction premiums
3. Sensitivity & Scenario Analysis
- One-way and two-way sensitivity testing
- Tornado charts for sensitivity ranking
- Best/Base/Worst case scenario planning
- Monte Carlo simulation with probability distributions
- Breakeven analysis
4. Risk Assessment
- Identify and quantify key risks
- Calculate confidence intervals
- Stress test extreme cases
- Consider correlation effects
Methodology
Data Collection
- Gather historical financial statements (income statement, balance sheet, cash flow)
- Verify data sources for accuracy and completeness
- Identify anomalies or missing data points
Analysis Workflow
- Calculate financial ratios with industry benchmarking
- Build appropriate valuation models
- Perform sensitivity analysis on key assumptions
- Generate comprehensive report with recommendations
Input Formats
- CSV with financial line items
- JSON with structured financial statements
- Text description of key financial figures
- Excel files with financial statements
Key Outputs
- Executive Summary: High-level findings and recommendations
- Financial Model: Detailed projections with documented assumptions
- Valuation Range: Multiple methods with sensitivity analysis
- Risk Assessment: Key risks and mitigation factors
- Visualizations: Charts, tornado diagrams, scenario comparisons
Scripts
Located in scripts/ directory:
calculate_ratios.py: Financial ratio calculation engineinterpret_ratios.py: Industry benchmarking and interpretationdcf_model.py: Complete DCF valuation enginesensitivity_analysis.py: Sensitivity and scenario testing framework
Example Usage
Ratio Analysis:
"Calculate key financial ratios for this company based on the attached financial statements"
"Analyze the liquidity position using the balance sheet data"
Valuation:
"Analyze Tesla's financials and provide a DCF valuation"
"Evaluate this startup's unit economics and runway"
Sensitivity:
"Run sensitivity analysis showing impact of growth rate and WACC on valuation"
"Create tornado chart ranking key value drivers"
Scenario Planning:
"Develop three scenarios for this expansion project with probability weights"
"Run Monte Carlo simulation with 5,000 iterations"
Best Practices
Modeling Standards
- Consistent formatting and structure
- Clear assumption documentation
- Separation of inputs, calculations, outputs
- Error checking and validation
Valuation Principles
- Use multiple methods for triangulation
- Apply appropriate risk adjustments
- Validate against trading multiples
- Consider both quantitative and qualitative factors
Risk Management
- Use conservative assumptions when uncertain
- Include probability-weighted scenarios
- Clearly document all assumptions and rationale
- Present results with appropriate caveats
Limitations
- Models are only as good as their assumptions
- Past performance doesn't guarantee future results
- Industry benchmarks are general guidelines
- Not a substitute for professional financial advice
1---2name: financial-analysis3description: Comprehensive financial analysis suite including DCF modeling, ratio analysis, sensitivity testing, Monte Carlo simulations, and financial statement evaluation for companies and investment opportunities4---56# Financial Analysis Suite78A comprehensive financial analysis toolkit combining ratio analysis, valuation modeling, and risk assessment using industry-standard methodologies.910## Core Capabilities1112### 1. Financial Ratio Analysis13Calculate and interpret key financial metrics:14- **Profitability**: ROE, ROA, Gross Margin, Operating Margin, Net Margin15- **Liquidity**: Current Ratio, Quick Ratio, Cash Ratio16- **Leverage**: Debt-to-Equity, Interest Coverage, Debt Service Coverage17- **Efficiency**: Asset Turnover, Inventory Turnover, Receivables Turnover18- **Valuation**: P/E, P/B, P/S, EV/EBITDA, PEG19- **Per-Share**: EPS, Book Value per Share, Dividend per Share2021### 2. Valuation Models2223#### Discounted Cash Flow (DCF)24- Build complete DCF models with multiple growth scenarios25- Calculate terminal values using perpetuity growth and exit multiple methods26- Determine weighted average cost of capital (WACC)27- Generate enterprise and equity valuations2829#### Comparable Company Analysis30- Identify peer companies31- Analyze trading multiples (P/E, EV/EBITDA, P/S)32- Calculate valuation ranges3334#### Precedent Transactions35- Review similar deals for valuation benchmarks36- Analyze transaction premiums3738### 3. Sensitivity & Scenario Analysis39- One-way and two-way sensitivity testing40- Tornado charts for sensitivity ranking41- Best/Base/Worst case scenario planning42- Monte Carlo simulation with probability distributions43- Breakeven analysis4445### 4. Risk Assessment46- Identify and quantify key risks47- Calculate confidence intervals48- Stress test extreme cases49- Consider correlation effects5051## Methodology5253### Data Collection541. Gather historical financial statements (income statement, balance sheet, cash flow)552. Verify data sources for accuracy and completeness563. Identify anomalies or missing data points5758### Analysis Workflow591. Calculate financial ratios with industry benchmarking602. Build appropriate valuation models613. Perform sensitivity analysis on key assumptions624. Generate comprehensive report with recommendations6364## Input Formats65- CSV with financial line items66- JSON with structured financial statements67- Text description of key financial figures68- Excel files with financial statements6970## Key Outputs711. **Executive Summary**: High-level findings and recommendations722. **Financial Model**: Detailed projections with documented assumptions733. **Valuation Range**: Multiple methods with sensitivity analysis744. **Risk Assessment**: Key risks and mitigation factors755. **Visualizations**: Charts, tornado diagrams, scenario comparisons7677## Scripts7879Located in `scripts/` directory:80- `calculate_ratios.py`: Financial ratio calculation engine81- `interpret_ratios.py`: Industry benchmarking and interpretation82- `dcf_model.py`: Complete DCF valuation engine83- `sensitivity_analysis.py`: Sensitivity and scenario testing framework8485## Example Usage8687**Ratio Analysis:**88```89"Calculate key financial ratios for this company based on the attached financial statements"90"Analyze the liquidity position using the balance sheet data"91```9293**Valuation:**94```95"Analyze Tesla's financials and provide a DCF valuation"96"Evaluate this startup's unit economics and runway"97```9899**Sensitivity:**100```101"Run sensitivity analysis showing impact of growth rate and WACC on valuation"102"Create tornado chart ranking key value drivers"103```104105**Scenario Planning:**106```107"Develop three scenarios for this expansion project with probability weights"108"Run Monte Carlo simulation with 5,000 iterations"109```110111## Best Practices112113### Modeling Standards114- Consistent formatting and structure115- Clear assumption documentation116- Separation of inputs, calculations, outputs117- Error checking and validation118119### Valuation Principles120- Use multiple methods for triangulation121- Apply appropriate risk adjustments122- Validate against trading multiples123- Consider both quantitative and qualitative factors124125### Risk Management126- Use conservative assumptions when uncertain127- Include probability-weighted scenarios128- Clearly document all assumptions and rationale129- Present results with appropriate caveats130131## Limitations132- Models are only as good as their assumptions133- Past performance doesn't guarantee future results134- Industry benchmarks are general guidelines135- Not a substitute for professional financial advice
sangrokjung