Methodology & Formulas
Complete transparency into how The AlphaLens analyzes your portfolio
Quick Navigation — 14 Sections
The AlphaLens is a comprehensive mutual fund portfolio analyzer that processes your Consolidated Account Statement (CAS) from CAMS/Kfintech or manual uploads to deliver institutional-grade analysis. Here's how the pipeline works:
Parse & Identify
Extract fund names, transaction history, NAV data, and scheme metadata from your CAS
Enrich Data
Fetch real-time NAV, historical returns, volatility, and benchmark data for each fund
Compute Metrics
Calculate XIRR, CAGR, Sharpe, Sortino, Alpha, Beta, VaR, and 20+ risk/return metrics
Generate Insights
Apply rule-based + quantitative logic to produce BUY/HOLD/SWITCH/EXIT recommendations
All calculations use actual NAV historywhen available (marked as "actual" data source), falling back to category-level benchmarks when historical data is insufficient (marked as "estimated").
We use two primary return measures:
XIRR (Extended Internal Rate of Return)
XIRR accounts for irregular cash flows (SIPs on different dates, lump sums, partial redemptions). It's the true annualized return on your actual money invested. We use Newton-Raphson numerical method with convergence tolerance of 10⁻⁷ and cap results at -100% to +500% to handle edge cases.
CAGR (Compound Annual Growth Rate)
CAGR shows the smoothed annualized growth rate assuming a single lump sum investment. Unlike XIRR, it doesn't account for timing of individual cash flows. Best used as a quick portfolio-level summary metric.
Absolute Return
Simple total return without annualization. Useful for short holding periods (< 1 year) where annualized metrics can be misleading.
CostBasis Handling:When CAS data includes a "CostBasis" entry (prior investments before the statement period), we backdate that amount by 2 years from the earliest visible transaction to approximate the original investment timing for XIRR accuracy.
Sharpe Ratio
Measures excess return per unit of total risk. A Sharpe > 1.0 is good, > 1.5 is excellent. We use the 10-year G-Sec yield (~7%) as the risk-free rate for Indian markets.
Sortino Ratio
Like Sharpe, but only penalizes downside volatility. A fund that swings upward isn't 'risky' — Sortino captures this distinction. Higher is better.
Alpha & Beta
Alpha measures fund manager skill (excess return over benchmark). Beta measures sensitivity to market movements. We use category-specific benchmarks: Nifty 50 for large-cap, Nifty Midcap 150 for mid-cap, etc.
Maximum Drawdown
The worst peak-to-trough decline. Shows the maximum pain you'd have experienced. A fund with -15% max drawdown fell 15% from its highest point before recovering.
Tracking Error & Information Ratio
Tracking Error measures how much a fund deviates from its benchmark. Information Ratio shows whether that deviation generates positive returns — higher IR means the fund manager's active bets are paying off.
Up/Down Capture Ratio
Up Capture > 100% means the fund gains more than the market in rallies. Down Capture < 100% means it falls less in crashes. The best funds have high Up Capture and low Down Capture.
The risk score is a composite metric (1 = very conservative, 10 = very aggressive) based on multiple portfolio characteristics:
Risk Score Computation
A 100% equity portfolio in small-cap funds might score 8-9, while a balanced portfolio of large-cap + debt funds scores 3-4. The score helps you understand whether your portfolio matches your risk appetite.
Diversification Score
HHI (Herfindahl-Hirschman Index) is the standard concentration measure used by regulators. A score of 8+ means well-diversified across categories, fund houses, and market caps. Below 4 suggests dangerous concentration.
Each fund is evaluated against its category benchmark using a multi-factor decision tree:
EXIT — Underperforming, consider exiting
XIRR < -5% for equity funds
Significant capital destruction. Negative returns in equity over meaningful period warrant exit.
Alpha < -5% AND Sharpe < 0.3
Consistently underperforms benchmark with poor risk-adjusted returns. Fund manager not adding value.
Regular plan AND direct plan available
Paying unnecessary commission. Switch to direct plan to save 0.5-1.5% annually in expense ratio.
Expense ratio > category average + 0.5%
Overpaying for management. High expense ratio erodes compounding over time.
SWITCH — Better alternatives exist
Alpha < -3% AND holding period > 2 years
Persistent underperformance. Sufficient time to judge — better alternatives available in same category.
Sharpe < 0.5 AND volatility > benchmark + 5%
Taking more risk without proportional return. Switch to a fund with better risk-adjusted returns.
Consistency score < 4/10
Inconsistent performance across market cycles. Unreliable for long-term wealth creation.
INCREASE SIP — Strong performer, allocate more
Alpha > 3% AND Sharpe > 0.8 AND holding > 1 year
Proven outperformer with good risk management. Increasing allocation improves portfolio quality.
XIRR > benchmark + 5% with consistency > 7/10
Strong, consistent outperformance. Higher conviction warrants larger allocation.
HOLD — On track, continue
Performance within ±3% of benchmark
Performing as expected for its category. No action needed — stay the course.
Holding period < 1 year
Insufficient data to judge. Continue holding and review after 1 year of SIP data.
Confidence Score
Higher confidence means the recommendation is backed by more data points and longer track record. Recommendations with confidence > 0.85 use actual historical NAV data.
Investment horizon fundamentally changes which fund categories are appropriate. Our engine maps horizons to suitable categories:
| Horizon | Recommended Categories | Rationale |
|---|---|---|
| ≤ 6 months | Liquid, Short Duration, Balanced Advantage | Capital preservation is priority. Equity volatility too high for this period. |
| 1 year | Balanced Advantage, Large Cap Index, Short Duration | Limited equity exposure. Low-volatility options protect against market timing risk. |
| 2 years | Large Cap, Index Funds, Flexi Cap | Moderate equity okay. Focus on large, stable companies with lower drawdowns. |
| 3 years | Large Cap, Flexi Cap, ELSS, Index | Full equity suitable. Diversified funds with consistent alpha generation. |
| 4-5 years | Flexi Cap, Mid Cap, Large Cap, ELSS | Mid-cap potential unlocked. Historical data shows mid-caps outperform over 5+ years. |
| 6 years | Mid Cap, Flexi Cap, Small Cap, ELSS | Higher growth categories. Small-cap allocation justified by longer recovery window. |
| 7+ years | Small Cap, Mid Cap, Flexi Cap | Maximum growth. Small/mid caps historically deliver 3-5% higher CAGR over 7+ years vs large cap. |
Fund Scoring Within Each Horizon
Funds are scored and ranked within each horizon. Short horizons heavily penalize volatility, while long horizons reward growth potential. This is why the same fund may be 'Best' for 7 years but 'Poor' for 6 months.
Value at Risk (VaR) — Parametric Method
VaR answers: 'What's the most I could lose in a day/month/year with 95% or 99% confidence?' A daily VaR₉₅ of ₹5,000 means there's only a 5% chance of losing more than ₹5,000 in a single day.
Expected Shortfall (Conditional VaR)
Expected Shortfall (ES) goes beyond VaR — it tells you the average loss in the worst 5% of scenarios. It's a more conservative risk measure that captures tail risk.
Monte Carlo Simulation
We run 1,000 random simulations of your portfolio's future using geometric Brownian motion. This gives you a probability distribution of outcomes — from worst case (P5) to best case (P95) for each time horizon.
Scenario Analysis
Each scenario adjusts expected returns and volatility to simulate different market environments. Shows how your portfolio would behave in a 2008-style crash vs a 2020-21 bull run.
Mutual Fund Taxation (Budget 2024 Rules)
We compute estimated tax liability on unrealized gains for each fund based on holding period and fund category. This helps you understand the real after-tax return and plan exits during low-tax windows.
Overlap Detection
Holding 3 large-cap funds doesn't give 3x diversification — they likely hold the same 30-40 stocks. We identify such overlaps and suggest consolidation to reduce expense ratios while maintaining diversification.
Rebalancing Logic
Rebalancing brings your portfolio back to target allocation. We generate signals based on drift from optimal allocation, considering your risk profile derived from existing portfolio composition.
SIP Frequency Adjustment
When you select a different SIP frequency, the amount automatically adjusts to maintain the same total annual investment. Quarterly SIP of ₹30,000 = Monthly SIP of ₹10,000 in terms of yearly outflow.
SIP vs Lumpsum Comparison
SIP benefits from rupee cost averaging in volatile markets — buying more units when prices are low. Lumpsum outperforms in consistently rising markets. We compare both for your actual transaction history.
Goal Calculation
Each goal gets a probability score based on simulations. The system suggests optimal fund allocation based on your risk profile and time horizon — shorter goals get more debt, longer goals get more equity.
Risk-Based Asset Allocation
Your risk profile is auto-determined from age (younger = more aggressive) and can be overridden. The blended return drives SIP calculations — conservative investors need higher SIPs to reach the same goals.
Data Sources:
Daily NAV data for all mutual fund schemes
Your actual transaction history, folio details, and current holdings
30+ benchmarks covering every SEBI-defined mutual fund category with expected returns, volatility, expense ratios
1Y, 3Y, 5Y rolling returns, volatility, drawdown computed from actual NAV history when available
Important Limitations
- • Past performance does not guarantee future returns. All projections are estimates.
- • Actual fund overlap requires stock-level data (not available in CAS). Our overlap is category-based estimation.
- • Tax calculations are estimates based on current rules and may not cover all edge cases (indexation, grandfathering).
- • Monte Carlo simulations assume log-normal returns — extreme events (black swans) may not be fully captured.
- • Benchmark comparisons use category-level data when fund-specific benchmarks are unavailable.
- • This is not SEBI-registered investment advice. Consult a qualified financial advisor before making investment decisions.
The AlphaLens — Built for transparency. Every metric, formula, and recommendation logic is documented above.
Questions or suggestions? Reach out at support@alphamarket.co.in