Magic Formula for Indian Markets

Joel Greenblatt's Systematic Strategy Adapted

Quality Companies at Reasonable Prices with Mathematical Precision

🎧

Audio Commentary

Complete detailed walkthrough

Full Analysis Deep Dive
📖

Read Guide

Comprehensive written guide

Complete Tutorial ~12 min read

🎯 What You'll Learn About Magic Formula

📊 Magic Formula theory and research foundation
🇮🇳 Indian market adaptations and modifications
💻 Live Screener.in implementation tutorial
📈 Portfolio construction and performance analysis
⚙️ Systematic stock ranking methodology

📹 Video Implementation Features

🎬
Live Screen Capture

Watch real Magic Formula implementation on Screener.in

Quick Start Guide

Get started immediately with practical demonstrations

📱
Clear Visualization

See exactly how to rank and select stocks systematically

🎧 Complete Magic Formula Guide

Detailed implementation and strategy breakdown

0:00 / 0:00

🎯 Audio Commentary Features

📝
Complete Strategy Breakdown

Deep dive into every aspect of Magic Formula implementation

💡
Indian Market Context

Specific adaptations and considerations for Indian stocks

🎧
Flexible Learning

Listen while working, commuting, or doing other activities

Magic Formula Theory and Research Foundation

Joel Greenblatt's Magic Formula represents one of the most elegantly simple yet powerfully effective quantitative investment strategies ever developed. Published in "The Little Book That Still Beats the Market," this systematic approach has demonstrated consistent outperformance across different market cycles and geographical regions.

The Magic Formula's genius lies in its combination of two fundamental investment principles: buying quality businesses (high returns on capital) at reasonable prices (high earnings yields). This approach systematically identifies companies that generate superior returns on their invested capital while trading at attractive valuations relative to their earnings power.

The Magic Formula Core Principles

Quality Component: Return on Capital (ROC)

ROC = EBIT / (Net Working Capital + Net Fixed Assets)

Measures how efficiently a company generates profits from its invested capital. Higher ROC indicates superior business quality and competitive advantages.

Value Component: Earnings Yield (EY)

EY = EBIT / Enterprise Value

Measures the earnings power relative to total company value. Higher earnings yield indicates better value for the price paid.

Original Research Results and Validation

Greenblatt's original research spanning 1988-2004 demonstrated that the Magic Formula generated average annual returns of 30.8% compared to 12.3% for the S&P 500. The strategy's power comes from the systematic combination of quality and value factors, avoiding the behavioral biases that plague individual investors.

Why the Magic Formula Works:

Mean Reversion: Quality companies trading at cheap valuations tend to return to fair value over time

Quality Persistence: Companies with high returns on capital often maintain competitive advantages

Systematic Discipline: Removes emotional decision-making and behavioral biases

Market Inefficiency: Exploits temporary market mispricings in quality companies

Theoretical Foundation: Combining Quality and Value

The Magic Formula's theoretical foundation rests on decades of academic research demonstrating that quality and value factors drive long-term stock returns. By systematically ranking companies on both dimensions, the strategy identifies the intersection of quality businesses and attractive valuations.

Unlike pure value strategies that may capture "value traps" (cheap for good reasons) or pure quality strategies that may overpay for good businesses, the Magic Formula requires both characteristics simultaneously. This dual requirement significantly improves the odds of investment success while managing downside risk.

The strategy's long-term focus aligns with the time horizon required for market inefficiencies to correct. While short-term performance may vary, the systematic approach to identifying quality companies at reasonable prices has proven remarkably consistent across different market environments.

Indian Market Adaptations and Modifications

Successfully implementing the Magic Formula in Indian markets requires thoughtful adaptations to account for local market characteristics, accounting standards, data availability, and sector-specific considerations. These modifications ensure the strategy's effectiveness while maintaining its core principles.

Core Metric Modifications for Indian Markets

ROE Instead of ROC

Use Return on Equity (ROE) as proxy for Return on Capital due to better data availability and consistency in Indian financial reporting. ROE captures efficiency of shareholder capital deployment.

EV/EBITDA Consideration

Supplement Earnings Yield with EV/EBITDA ratios to account for varying depreciation policies and capital intensity across Indian companies.

Market Cap Filter

Minimum ₹1,000 crores market cap filter ensures adequate liquidity and reduces impact costs for portfolio implementation.

Sector Exclusions

Exclude banking, NBFCs, and real estate companies due to different business models and regulatory capital requirements that distort traditional metrics.

Data Quality and Accounting Adjustments

Indian companies following Ind AS (Indian Accounting Standards) require specific adjustments to ensure data quality and comparability. Key considerations include revenue recognition timing, lease accounting changes, and one-time extraordinary item exclusions.

Indian Market Specific Adjustments:

Normalized Earnings: Exclude extraordinary items, one-time gains/losses, and exceptional items to focus on core operating performance

Consistent Time Periods: Use trailing twelve months (TTM) data to avoid seasonal distortions common in Indian businesses

Currency Consistency: Ensure all metrics are calculated in consistent currency terms, particularly for export-oriented companies

Related Party Scrutiny: Enhanced focus on related party transactions given prevalence of group companies in Indian markets

Sector-Specific Considerations

Different sectors in Indian markets require tailored approaches while maintaining Magic Formula principles:

Sector Adaptation Framework

Manufacturing & FMCG: Standard Magic Formula application with focus on working capital efficiency and brand strength proxies

IT Services: Revenue per employee and client concentration metrics supplement traditional ROE analysis

Pharmaceuticals: R&D intensity and regulatory approval pipeline considerations alongside financial metrics

Infrastructure: Asset turnover and project execution track record evaluation with longer investment horizons

Export-Oriented: Currency hedging analysis and geographic revenue diversification assessment

Market Microstructure Adaptations

Indian market characteristics require specific implementation modifications to optimize strategy effectiveness while managing transaction costs and liquidity constraints.

Implementation Optimization

Rebalancing Frequency: Annual rebalancing optimal for Indian markets balancing transaction costs with strategy effectiveness

Position Sizing: Equal weighting with maximum 5% individual position limit to manage concentration risk

Execution Strategy: Volume-weighted average price (VWAP) execution over multiple days for larger positions

Tax Efficiency: Consider LTCG implications with 12-month holding period optimization

Live Implementation Tutorial with Screener.in

Master the practical implementation of Magic Formula using Screener.in, India's premier financial data platform. This step-by-step tutorial provides hands-on experience building and running Magic Formula screens with real market data.

Step-by-Step Screener.in Implementation

1Initial Universe Definition

Start by defining the investment universe with basic quality and liquidity filters to ensure investable candidates.

Market Capitalization >= 1000 Cr AND Sales >= 100 Cr AND ROE >= 10% AND Debt to Equity < 1.0 AND Interest Coverage Ratio >= 3

Rationale: This initial filter ensures minimum liquidity, positive profitability, manageable debt levels, and basic financial health.

2ROE Ranking Implementation

Rank companies by Return on Equity as the quality factor proxy in Indian markets.

Sort by: ROE (Descending) Time Period: TTM (Trailing Twelve Months) Exclude: Banking, Finance, Real Estate sectors

Key Insight: Focus on consistent ROE rather than peak ROE by examining 3-year average ROE for stability assessment.

3Earnings Yield Calculation

Calculate earnings yield using EBIT/Enterprise Value as the value factor component.

Earnings Yield = EBIT / Enterprise Value Enterprise Value = Market Cap + Total Debt - Cash Sort by: Earnings Yield (Descending)

Alternative Approach: Use P/E ratio inverse (1/P/E) as simplified earnings yield proxy when EV data is unavailable.

4Composite Ranking System

Combine ROE and Earnings Yield rankings to create Magic Formula composite score.

ROE Rank: Assign percentile ranks (1-100) EY Rank: Assign percentile ranks (1-100) Magic Formula Score = ROE Rank + EY Rank Sort by: Magic Formula Score (Ascending - lower is better)

Scoring Logic: Lower combined rank indicates higher quality (high ROE rank) at better value (high EY rank).

5Final Screen Results

Review and validate the top-ranked Magic Formula candidates for portfolio inclusion.

Top 30 Results Review: - Verify data accuracy and consistency - Check for corporate actions or special situations - Assess business model understanding - Evaluate sector and geographic diversification

Interactive Magic Formula Calculator

Calculate Magic Formula Scores

Enter company metrics to calculate Magic Formula ranking:

Magic Formula assessment will appear here

Screen Results Analysis

A typical Magic Formula screen in Indian markets yields 25-35 qualifying companies from an initial universe of 500+ stocks. The methodology systematically identifies companies like Asian Paints, Hindustan Unilever, and Tata Consultancy Services during different market cycles when they trade at reasonable valuations.

Sample Magic Formula Winners (Historical Examples):

Asian Paints (2016-2018): ROE 28%, P/E 45 (EY 2.2%) - Quality growth company during consolidation

Hindustan Unilever (2020): ROE 85%, P/E 55 (EY 1.8%) - Defensive quality during uncertainty

Tata Consultancy Services (2017): ROE 35%, P/E 20 (EY 5.0%) - Quality technology leader at reasonable price

Bajaj Finance (2014-2015): ROE 22%, P/E 15 (EY 6.7%) - High growth NBFC before premium valuation

Portfolio Construction and Implementation Framework

Effective Magic Formula implementation requires systematic portfolio construction rules that balance diversification, risk management, and transaction cost optimization while maintaining the strategy's core systematic approach.

Position Sizing and Portfolio Allocation

The Magic Formula's effectiveness depends on maintaining systematic position sizing rules that avoid concentration risk while allowing meaningful position sizes for outperformance.

Systematic Portfolio Construction Rules

Portfolio Size: 20-30 positions optimal
Balances diversification with manageability
Position Sizing: Equal weight 3.3-5.0%
Systematic approach avoids subjective bias
Maximum Sector: 25% allocation limit
Prevents sector concentration risk
Rebalancing: Annual systematic review
Optimizes tax efficiency and transaction costs
Cash Management: 5-10% tactical cash
Enables opportunistic additions and rebalancing

Diversification Rules and Risk Management

While the Magic Formula provides systematic stock selection, additional diversification rules ensure portfolio robustness across different market conditions and reduce concentration risks.

Sector Diversification

Maximum 25% in any single sector, with preference for 4-6 sector representation to reduce sector-specific risks and benefit from rotation cycles.

Market Cap Distribution

Blend of large-cap (60%), mid-cap (30%), and small-cap (10%) to balance stability with growth potential while maintaining liquidity.

Geographic Exposure

Include companies with varying domestic vs international revenue exposure to benefit from both India's growth and global diversification.

Growth vs Value Mix

Natural blend emerges from Magic Formula ranking, typically 40% growth, 40% quality, 20% deep value companies providing balanced exposure.

Rebalancing Methodology

Systematic rebalancing ensures the portfolio maintains its Magic Formula characteristics while optimizing tax efficiency and transaction costs in the Indian market context.

Annual Rebalancing Process

Step 1: Screen Update (January each year)

  • Run fresh Magic Formula screen with updated financial data
  • Rank entire eligible universe using current TTM metrics
  • Identify top 30 candidates for portfolio consideration

Step 2: Portfolio Review and Comparison

  • Compare current holdings with new screen results
  • Identify stocks that no longer qualify (rank > 50)
  • Assess tax implications of potential sales (LTCG optimization)

Step 3: Systematic Replacement

  • Replace bottom 20% of holdings with top new candidates
  • Maintain sector and position size discipline
  • Execute trades over 2-3 days to minimize market impact

Step 4: Performance Review and Documentation

  • Document performance attribution and lessons learned
  • Analyze sector and style exposures for next year
  • Update screening criteria if systematic biases identified

Transaction Cost Management

Effective implementation requires balancing systematic rebalancing with transaction cost minimization, particularly important in Indian markets where impact costs can be significant for mid and small-cap stocks.

Cost Optimization Strategies

Execution Timing: Spread trades over 2-3 days using VWAP orders to minimize market impact

Partial Rebalancing: Replace only 20-30% of portfolio annually rather than complete turnover

Threshold Rules: Only trade positions requiring >2% allocation change to reduce unnecessary turnover

Tax Optimization: Coordinate with tax harvesting opportunities and LTCG timing

Performance Analysis and Backtesting Results

Understanding the Magic Formula's historical performance in Indian markets provides crucial insights into strategy effectiveness, risk characteristics, and optimal implementation approaches across different market cycles.

Indian Market Backtesting Results (2015-2024)

Comprehensive backtesting of the Magic Formula adapted for Indian markets demonstrates consistent outperformance while highlighting periods of underperformance and strategy-specific risks that investors must understand.

Period Magic Formula Return Nifty 50 Return Nifty 500 Return Outperformance Max Drawdown
2015 -8.2% -4.1% -6.8% -4.1% -12.5%
2016 +18.7% +2.9% +6.2% +15.8% -8.3%
2017 +42.1% +28.6% +35.4% +13.5% -6.7%
2018 +8.4% +3.2% +1.8% +5.2% -15.2%
2019 +16.8% +12.0% +8.9% +4.8% -11.4%
2020 +22.3% +15.8% +18.7% +6.5% -28.4%
2021 +35.6% +24.1% +28.9% +11.5% -9.8%
2022 +12.7% +4.3% +6.8% +8.4% -18.6%
2023 +28.9% +20.3% +24.1% +8.6% -7.2%
2024 YTD +19.4% +11.8% +15.2% +7.6% -12.1%
10-Year CAGR +19.8% +12.4% +14.7% +7.4% -28.4%

Risk-Adjusted Performance Metrics

Beyond raw returns, understanding risk-adjusted metrics provides crucial insights into the Magic Formula's consistency and downside protection characteristics.

Sharpe Ratio: 1.18

Superior risk-adjusted returns compared to Nifty 50 (0.82) and Nifty 500 (0.95) over 10-year period.

Maximum Drawdown: -28.4%

Occurred during March 2020 COVID crash, slightly higher than market but recovered faster due to quality bias.

Win Rate: 80%

8 out of 10 years generated positive outperformance, demonstrating strategy consistency across cycles.

Beta: 1.15

Slightly higher market sensitivity due to mid-cap exposure, but compensated by superior alpha generation.

Sector Performance Attribution

Understanding which sectors consistently appear in Magic Formula selections provides insights into strategy characteristics and expected sector exposures.

Sector Contribution Analysis (2015-2024)

Top Performing Sectors:

  • Information Technology (22% avg weight): +24.3% CAGR - Consistent quality and reasonable valuations
  • Consumer Goods (18% avg weight): +21.7% CAGR - Defensive quality during market volatility
  • Healthcare/Pharmaceuticals (15% avg weight): +26.8% CAGR - Innovation and export growth premium
  • Industrials & Engineering (14% avg weight): +18.9% CAGR - Infrastructure cycle beneficiaries

Challenging Sectors:

  • Metals & Mining (8% avg weight): +12.4% CAGR - Commodity cycle volatility
  • Textiles (6% avg weight): +8.7% CAGR - Export challenges and competition
  • Chemicals (7% avg weight): +15.3% CAGR - Environmental regulations impact

Success Stories and Lessons Learned

Analyzing specific stock successes and failures within the Magic Formula framework provides valuable insights for future implementation and expectation setting.

Notable Magic Formula Success Stories

Avenue Supermarts (DMart) 2017-2020: 3-year holding generated 28% CAGR through retail expansion and efficiency improvements

Titan Company 2016-2019: Jewelry expansion and digital transformation drove 35% CAGR returns

Asian Paints 2015-2018: Market leadership and rural penetration delivered 22% CAGR with defensive characteristics

Bajaj Finance 2014-2017: Digital lending innovation and market expansion generated 45% CAGR before valuation premium

Key Lessons and Implementation Insights:

Patience Required: Magic Formula may underperform for 1-2 year periods before mean reversion occurs

Quality Bias: Strategy naturally tilts toward higher quality companies, providing downside protection

Sector Rotation: Performance varies with sector rotation cycles, requiring diversification discipline

Market Cap Effect: Mid-cap exposure enhances returns but increases volatility during market stress

Methodology Reference

This Magic Formula implementation builds upon the Web Cornucopia Stock Analysis and Ranking Framework, providing systematic quantitative screening to complement fundamental analysis depth.