Understanding Results¶
Learn how to interpret the output from the Systematic Investment Analysis Framework.
Result Overview¶
The framework generates comprehensive results in multiple formats. Here's how to understand what each component means.
CSV Output Structure¶
Key Columns¶
Column | Range | Description |
---|---|---|
Ticker |
Text | Stock symbol (e.g., AAPL, GOOGL) |
Sector |
Text | Business sector classification |
Market_Cap_B |
Number | Market capitalization in billions USD |
Current_Price |
Number | Current stock price in USD |
Passes_Filters |
Y/N | Whether stock meets all screening criteria |
Composite_Score |
0-100 | Overall investment attractiveness score |
Quality_Score |
0-100 | Financial strength and stability score |
Value_Score |
0-100 | Valuation attractiveness score |
Growth_Score |
0-100 | Business growth prospects score |
Risk_Score |
0-100 | Risk level (lower is better) |
Financial Metrics¶
Column | Description |
---|---|
P_E |
Price-to-Earnings ratio |
P_B |
Price-to-Book ratio |
ROE |
Return on Equity (decimal format) |
ROIC |
Return on Invested Capital (decimal format) |
Revenue_Growth |
Revenue growth rate (decimal format) |
Debt_Equity |
Debt-to-Equity ratio |
Score Interpretation¶
Composite Score (0-100)¶
The composite score combines all dimensions:
- 90-100: Exceptional stocks - Strong across all metrics
- 80-89: Very good stocks - Minor weaknesses only
- 70-79: Good stocks - Some areas of concern
- 60-69: Average stocks - Notable issues present
- 50-59: Below average - Significant weaknesses
- Below 50: Poor stocks - Multiple serious issues
Individual Score Dimensions¶
Quality Score (0-100)¶
Measures financial strength and business stability:
- 90-100: Excellent - Strong ROE/ROIC, low debt, good liquidity
- 70-89: Good - Solid fundamentals with minor concerns
- 50-69: Average - Acceptable quality but room for improvement
- 30-49: Poor - Weak fundamentals, higher risk
- Below 30: Very poor - Significant financial issues
Key factors: - Return on Equity (ROE) - Return on Invested Capital (ROIC) - Debt-to-equity ratio - Current ratio (liquidity)
Value Score (0-100)¶
Assesses whether stock is attractively priced:
- 90-100: Excellent value - Trading below intrinsic worth
- 70-89: Good value - Reasonable pricing
- 50-69: Fair value - Appropriately priced
- 30-49: Expensive - Trading above fair value
- Below 30: Very expensive - Significantly overvalued
Key factors: - Price-to-Earnings ratio - Price-to-Book ratio - EV/EBITDA multiple - Price-to-Free Cash Flow
Growth Score (0-100)¶
Evaluates business expansion and future prospects:
- 90-100: Exceptional growth - Strong, sustainable expansion
- 70-89: Good growth - Solid business momentum
- 50-69: Moderate growth - Steady but unremarkable
- 30-49: Slow growth - Limited expansion
- Below 30: Declining - Shrinking business
Key factors: - Revenue growth rate - Earnings growth rate - Free cash flow growth - Market expansion potential
Risk Score (0-100)¶
Assesses investment risk levels (lower is better):
- 0-20: Very low risk - Stable, predictable business
- 21-40: Low risk - Some variability but manageable
- 41-60: Moderate risk - Normal business volatility
- 61-80: High risk - Significant uncertainties
- Above 80: Very high risk - Highly unpredictable
Key factors: - Stock price volatility (beta) - Financial leverage - Business model stability - Sector-specific risks
Filter Status Analysis¶
Passes_Filters = Y (Yes)¶
Stock meets all minimum thresholds:
Quality Requirements Met:
- ✅ ROE ≥ minimum threshold
- ✅ ROIC ≥ minimum threshold
- ✅ Debt levels within acceptable range
- ✅ Adequate liquidity ratios
Value Requirements Met: - ✅ P/E ratio ≤ maximum threshold - ✅ P/B ratio ≤ maximum threshold - ✅ Other valuation metrics acceptable
Growth Requirements Met: - ✅ Revenue growth ≥ minimum threshold - ✅ Earnings growth ≥ minimum threshold
Risk Requirements Met: - ✅ Beta ≤ maximum threshold - ✅ Overall risk score acceptable
Passes_Filters = N (No)¶
Stock fails one or more criteria. Common failure reasons:
Quality Failures¶
- Low ROE/ROIC: Poor profitability and capital efficiency
- High debt levels: Excessive financial leverage
- Poor liquidity: Insufficient short-term assets
Value Failures¶
- High P/E ratio: Stock trading at premium multiple
- Excessive P/B ratio: Price significantly above book value
- Rich valuations: Multiple metrics suggest overvaluation
Growth Failures¶
- Declining revenues: Business is shrinking
- Negative earnings growth: Profitability decreasing
- Stagnant business: No meaningful expansion
Risk Failures¶
- High volatility: Stock price very unpredictable
- Excessive leverage: Dangerous debt levels
- Sector concerns: Industry-specific risks
Sector Comparisons¶
Sector Benchmarks¶
Different sectors have different normal ranges:
Technology Sector¶
- Typical P/E: 20-40 (higher acceptable)
- Expected Growth: 10-30% revenue growth
- Debt Tolerance: Generally lower debt levels
- Volatility: Higher beta acceptable (1.2-1.8)
Utilities Sector¶
- Typical P/E: 15-25 (lower range)
- Expected Growth: 2-8% revenue growth
- Debt Tolerance: Higher debt acceptable
- Volatility: Lower beta expected (0.6-1.0)
Financial Sector¶
- Metrics Differ: Different debt interpretation
- Interest Sensitivity: Rate environment crucial
- Regulatory Impact: Capital requirements matter
Cross-Sector Analysis¶
When comparing stocks from different sectors:
- Focus on relative performance within each sector
- Consider sector-specific factors (growth vs. stability)
- Adjust expectations based on business models
- Account for cyclical patterns in commodity/cyclical sectors
Example Analysis¶
Let's analyze sample results:
Ticker,Sector,Passes_Filters,Composite_Score,Quality_Score,Value_Score,Growth_Score,Risk_Score
GOOGL,Communication Services,Y,98.9,100.0,100.0,100.0,7.2
AAPL,Technology,N,57.9,75.0,0.0,100.0,30.6
TSLA,Consumer Cyclical,N,28.6,50.0,0.0,0.0,9.0
Google (GOOGL) - Score: 98.9¶
✅ Passes all filters - Quality: Excellent (100.0) - Strong ROE, ROIC, low debt - Value: Excellent (100.0) - Attractive valuation metrics - Growth: Excellent (100.0) - Strong revenue/earnings growth - Risk: Very low (7.2) - Stable, predictable business
Investment Thesis: High-quality growth company at reasonable valuation
Apple (AAPL) - Score: 57.9¶
❌ Fails value filters - Quality: Good (75.0) - Solid fundamentals but not exceptional - Value: Poor (0.0) - Overvalued - High P/B ratio, expensive metrics - Growth: Excellent (100.0) - Strong business momentum - Risk: Moderate (30.6) - Some volatility but manageable
Investment Thesis: Great company but expensive - wait for better entry
Tesla (TSLA) - Score: 28.6¶
❌ Fails multiple filters - Quality: Poor (50.0) - Low ROE/ROIC - Capital efficiency concerns - Value: Poor (0.0) - Highly overvalued - Excessive P/E ratio - Growth: Poor (0.0) - Declining revenues - Business momentum lost - Risk: Very low (9.0) - Interestingly, low volatility recently
Investment Thesis: Multiple red flags - avoid until fundamentals improve
Red Flags to Watch¶
Quality Red Flags¶
- ROE below 10% (0.10 in decimal format)
- ROIC below 8% (0.08 in decimal format)
- Debt-to-equity above 200% (high leverage)
- Current ratio below 1.0 (liquidity concerns)
Value Red Flags¶
- P/E ratio above 40 (unless high-growth justified)
- P/B ratio above 10 (asset-heavy businesses)
- Multiple valuation metrics in expensive range
Growth Red Flags¶
- Negative revenue growth for multiple periods
- Declining profit margins
- Market share loss to competitors
Risk Red Flags¶
- Beta above 2.0 (very high volatility)
- Excessive debt in cyclical industries
- Single customer/geographic concentration
Using Results for Investment Decisions¶
Stock Selection Process¶
- Filter by Pass/Fail: Start with stocks that pass all filters
- Rank by Composite Score: Focus on highest-scoring opportunities
- Sector Diversification: Don't concentrate in single sector
- Individual Analysis: Review specific metrics for each candidate
- Qualitative Research: Supplement quantitative analysis
Portfolio Construction Guidelines¶
Core Holdings (70-80% of portfolio): - Composite Score ≥ 80 - Passes all filters - Quality Score ≥ 70
Opportunistic Holdings (10-20% of portfolio): - Composite Score 60-79 - May fail 1-2 filters with good reason - Higher potential upside
Avoid (0-10% speculative only): - Composite Score < 60 - Fails multiple filters - Significant red flags present
Next Steps¶
- Configuration Options - Adjust screening criteria
- Output Formats - Work with different data formats
- Running Analysis - Execute comprehensive analysis