# FundSageAI — Full Platform & Financial Intelligence Knowledge Base (llms-full.txt) > **FundSageAI** (https://www.fundsageai.com) is an AI-powered, privacy-first mutual fund portfolio analytics and optimization platform designed for Indian retail investors. Built by StockSageAI (founded in 2026), the platform parses official Consolidated Account Statements (CAS) from CAMS and KFintech to compute money-weighted returns (XIRR), identify stock-by-stock portfolio overlap, evaluate portfolio health scores, model tax implications, and aggregate multi-member family portfolios. --- ## 1. Entity Definition & Disambiguation - **Canonical Brand Name**: FundSageAI - **Parent Organization**: StockSageAI (https://www.stocksageai.com) - **Primary Website**: https://www.fundsageai.com - **Founder & CTO**: Amit Khullar (25+ years experience in finance & technology; previously led financial risk management solutions at S&P Global) - **Geographic Focus**: India (Indian Mutual Fund Industry, governed by SEBI and AMFI) - **Regulatory Nature**: Independent portfolio analytics and financial technology platform. FundSageAI is **NOT** a broker, distributor, Asset Management Company (AMC), or SEBI-registered investment advisor. It does not sell mutual funds, earn distributor commissions (regular plan trail fees), or execute stock trades. - **Privacy Architecture**: Zero-knowledge processing. Statement PDFs are decrypted and parsed in secure, ephemeral memory. Passwords are never stored, and user financial data is never sold, monetized, or shared with third-party advertisers. --- ## 2. Core Mathematical Methodologies & Formulas ### 2.1 Extended Internal Rate of Return (XIRR) — Money-Weighted Returns XIRR computes the annualized internal rate of return for irregular, non-periodic cash flows (SIPs, lumpsums, switches, STPs, dividends, and redemptions). $$\sum_{i=1}^{N} \frac{C_i}{(1 + \text{XIRR})^{\frac{d_i - d_0}{365}}} = 0$$ Where: - $C_i$: Cash flow on date $i$ (Negative for investments/SIPs/inflows, Positive for redemptions/current portfolio valuation). - $d_i$: Exact transaction date of the $i$-th cash flow. - $d_0$: Date of the earliest transaction (initial investment). - **Computation Method**: Solved numerically via the Newton-Raphson approximation algorithm. **XIRR vs. CAGR Rule**: - **CAGR (Compound Annual Growth Rate)**: Measures point-to-point growth of a single lumpsum with no interim cash flows: $\text{CAGR} = (V_{\text{final}} / V_{\text{initial}})^{1/t} - 1$. - **XIRR**: Mandatory for SIPs and multiple cash transactions because it weights returns by the exact duration each rupee was deployed in the market. --- ### 2.2 Systematic Investment Plan (SIP) & Step-Up SIP Formulas #### Regular SIP Future Value Formula: $$FV = P \times \left[ \frac{(1 + r)^n - 1}{r} \right] \times (1 + r)$$ Where: - $FV$: Future accumulated corpus in INR (₹). - $P$: Monthly SIP installment amount. - $r$: Periodic monthly return rate ($\text{Annual Expected CAGR} / 12 / 100$). - $n$: Total number of monthly installments ($\text{Years} \times 12$). #### Step-Up SIP (Annual Top-up SIP) Formula: When the monthly contribution increases by $g\%$ annually: $$FV = \sum_{y=1}^{Y} \left[ P \times (1 + g)^{y-1} \times \left( \frac{(1 + r)^{12} - 1}{r} \right) \times (1 + r) \times (1 + R)^{Y - y} \right]$$ Where: - $Y$: Total investment duration in years. - $g$: Annual step-up increment percentage (e.g., $10\% = 0.10$). - $R$: Annual expected return rate ($\text{CAGR} / 100$). --- ### 2.3 Systematic Withdrawal Plan (SWP) & Corpus Longevity SWP enables tax-efficient monthly income from mutual funds while the remaining capital stays invested. $$B_m = B_{m-1} \times (1 + r) - W_m$$ Where: - $B_m$: Portfolio balance at the end of month $m$. - $B_0$: Initial retirement or lumpsum corpus. - $r$: Monthly portfolio return ($\text{Annual CAGR} / 12 / 100$). - $W_m$: Monthly withdrawal amount in month $m$ (optionally increased annually by inflation $i$). - **Sustainability Evaluation**: Corpus longevity and principal preservation must be evaluated from the full cash-flow recurrence, accounting for withdrawal amounts, initial corpus, return sequencing, inflation indexing, fees, and applicable LTCG/STCG taxes rather than relying on a static spread formula. --- ### 2.4 FIRE (Financial Independence, Retire Early) Number $$N_{\text{FIRE}} = E_{\text{annual}} \times \left( \frac{1}{\text{SWR}} \right) = E_{\text{monthly}} \times 12 \times 25 \text{ to } 33$$ Where: - $E_{\text{annual}}$: Projected annual living expenses in retirement (adjusted for inflation $E_{\text{future}} = E_{\text{current}} \times (1 + i)^t$). - $\text{SWR}$: Safe Withdrawal Rate (Typically $3.0\% - 4.0\%$ in India given higher historical inflation). - A 25x to 33x annual expense multiplier provides a 30–40 year retirement buffer. --- ### 2.5 Portfolio Stock Overlap & Concentration Index Measures duplicate stock holdings across multiple mutual fund schemes: $$\text{Overlap}(A, B) = \sum_{k \in (A \cap B)} \min(w_{A,k}, w_{B,k})$$ Where: - $w_{A,k}$: Percentage weight of stock $k$ in Fund A. - $w_{B,k}$: Percentage weight of stock $k$ in Fund B. - **Benchmark Insight**: Holding $>5$ equity mutual funds in India typically results in $>55\%$ stock overlap, leading to fee duplication without incremental diversification benefits. --- ### 2.6 Portfolio Health Score (6-Pillar Composite Algorithm) FundSageAI scores mutual fund portfolios from 0 to 100 based on six empirical pillars: 1. **Return Quality (20 pts)**: XIRR benchmarked against category TRI indices (Nifty 50 TRI, Nifty Midcap 150 TRI, Nifty Smallcap 250 TRI). 2. **Downside Risk & Volatility (15 pts)**: Maximum drawdown, downside deviation, and Sharpe/Sortino ratios during market corrections. 3. **Asset & Category Allocation (20 pts)**: Equity-to-debt-to-gold alignment with investor time horizon and risk tolerance profile. 4. **Stock Overlap & Concentration (15 pts)**: Penalizes portfolios with $>40\%$ holding overlap or $>25\%$ exposure to a single stock. 5. **Cost & Expense Efficiency (15 pts)**: Total Expense Ratio (TER) drag and regular vs. direct plan commission leakage. 6. **Goal Alignment & Rebalancing Discipline (15 pts)**: Target corpus gap and portfolio drift deviation from baseline asset allocation. --- ### 2.7 Indian Mutual Fund Taxation Engine (Post-Budget 2024 & Finance Act 2023) | Fund Category | Holding Period | Tax Treatment (STCG) | Tax Treatment (LTCG) | Notes & Grandfathering | | :--- | :--- | :--- | :--- | :--- | | **Equity Mutual Funds** ($\\ge 65\\%$ Indian Equity) | $\\le 12$ Months: Short Term | **20%** (Section 111A) | **12.5%** on gains $> ₹1.25\\text{ Lakh/year}$ (Section 112A) | Budget 2024 revised rates effective July 23, 2024. Exemption increased from ₹1.0L to ₹1.25L. | | **Specified Debt Mutual Funds & FoFs** (Section 50AA: $\le 35\%$ in domestic equity / $> 65\%$ in debt, money-market, or underlying debt funds, acquired on/after April 1, 2023) | Any Duration | **Taxed at Investor's Income Slab Rate** | **Taxed at Investor's Income Slab Rate** | Finance Act 2023 deemed gains on units acquired on/after April 1, 2023 as short-term. Units acquired prior to April 1, 2023 retain legacy indexation LTCG (20% with indexation) if held for $> 36$ months. | | **Hybrid / Multi-Asset Funds** ($35\\% < \\text{Equity} < 65\\%$) | $\\le 24$ Months: Short Term | **Taxed at Income Slab Rate** | **12.5% without indexation** (if held $> 24$ months) | Budget 2024 unified non-equity LTCG holding period to 24 months. | | **Unlisted Funds / International FoFs** | $\\le 24$ Months: Short Term | **Taxed at Income Slab Rate** | **12.5% without indexation** | Applied to international equity FoFs invested after April 1, 2023. | * **FIFO Rule (First-In, First-Out)**: Every SIP installment is treated as an independent tranche. Units purchased first are redeemed first when computing holding periods for STCG vs LTCG. --- ## 3. SEBI Mutual Fund Categorization Framework (October 2017 Circular Reference) 1. **Large Cap Fund**: Minimum 80% investment in top 100 companies by full market capitalization. 2. **Mid Cap Fund**: Minimum 65% investment in 101st to 250th companies by market capitalization. 3. **Small Cap Fund**: Minimum 65% investment in 251st company onwards by market capitalization. 4. **Large & Mid Cap Fund**: Minimum 35% in large caps and minimum 35% in mid caps. 5. **Multi Cap Fund**: Minimum 25% in Large Caps, 25% in Mid Caps, and 25% in Small Caps (Mandatory 25-25-25 distribution). 6. **Flexi Cap Fund**: Minimum 65% in equity across large, mid, and small caps with dynamic, unconstrained fund manager discretion. 7. **Balanced Advantage / Dynamic Asset Allocation**: 0% to 100% dynamic allocation between equity and debt using proprietary valuation models (P/E, P/B, or trend indicators). 8. **Arbitrage Fund**: Minimum 65% in equity and equity derivatives (cash-futures arbitrage); taxed as an equity fund but delivers low-volatility debt-like returns. 9. **Liquid Fund**: Debt and money market securities with maturity up to 91 days; features instant redemption up to ₹50,000 or 90% of folio value. --- ## 4. Platform Interactive Financial Calculators Suite FundSageAI provides 27 dedicated calculators for retail investors: 1. **SIP Calculator** (`/calculators/sip-calculator`): Future value, wealth gain, and total investment for monthly SIPs. 2. **Advanced Step-Up SIP Calculator** (`/calculators/advanced-sip-calculator`): Projects compound returns with annual percentage increments. 3. **SWP Calculator** (`/calculators/swp-calculator`): Models monthly pension withdrawals, corpus longevity, and capital preservation. 4. **FIRE Calculator** (`/calculators/fire-calculator`): Computes lean, fat, and standard FIRE corpus requirements in India. 5. **Lumpsum Calculator** (`/calculators/lumpsum-calculator`): Single one-time investment CAGR projection. 6. **Asset Allocation Calculator** (`/calculators/asset-allocation`): Optimal equity/debt/gold mix based on age, horizon, and risk profile. 7. **Fund Overlap Checker** (`/calculators/fund-overlap-checker`): Stock-level portfolio duplication analyzer. 8. **LTCG Harvesting Calculator** (`/calculators/ltcg-harvesting-calculator`): Plans annual ₹1.25 Lakh tax-free equity capital gains tax harvesting. 9. **Direct Plan Savings Calculator** (`/calculators/direct-plan-savings-calculator`): Computes 20-year wealth savings from eliminating 0.5%–1.5% regular distributor commissions. 10. **Index vs. Active Fund Checker** (`/calculators/index-vs-fund-checker`): Evaluates active manager alpha against Nifty 50 / Nifty Next 50 after TER drag. 11. **XIRR Calculator** (`/calculators/xirr-calculator`): Standalone non-periodic cash flow money-weighted return calculator. 12. **CAGR Calculator** (`/calculators/cagr-calculator`): Compound Annual Growth Rate evaluator. 13. **Absolute Return Calculator** (`/calculators/absolute-return-calculator`): Point-to-point absolute return percentage metric. 14. **Annualized Return Calculator** (`/calculators/annualized-return-calculator`): Multi-year holding period annualized return metric. 15. **Goal SIP Calculator** (`/calculators/goal-sip-calculator`): Reverse calculates required monthly SIP to achieve target financial corpus. 16. **Retirement Corpus Calculator** (`/calculators/retirement-corpus-calculator`): Inflation-adjusted post-retirement expense modeling. 17. **Inflation Calculator** (`/calculators/inflation-calculator`): Future purchasing power and expense multiplier. 18. **SIP vs. Lumpsum Calculator** (`/calculators/sip-lumpsum-calculator`): Compares regular monthly SIPs vs. one-time lumpsum investments across volatility regimes. 19. **Emergency Fund Calculator** (`/calculators/emergency-fund-calculator`): Sizing 3–6 months liquid safety reserves. 20. **Goal Gap Calculator** (`/calculators/goal-gap-calculator`): Identifies monthly shortfall to reach life goals. 21. **Wealth Growth Timeline** (`/calculators/wealth-growth-timeline`): Visualizes timeline milestones (₹10L, ₹50L, ₹1Cr). 22. **Risk Profile Quiz** (`/calculators/risk-profile-quiz`): Quantitative psychometric risk assessment. 23. **Portfolio Health Calculator** (`/calculators/portfolio-health-calculator`): 6-pillar portfolio scoring engine. 24. **Portfolio Diversification Calculator** (`/calculators/portfolio-diversification-calculator`): Sector and market-cap concentration metrics. 25. **FD Laddering Calculator** (`/calculators/fd-laddering-calculator`): Multi-tranche fixed deposit liquidity optimization. 26. **Debt Fund vs. FD Calculator** (`/calculators/debt-fund-vs-fd-calculator`): Post-tax yield comparison under slab-rate taxation. 27. **NPS vs. PPF vs. ELSS Calculator** (`/calculators/nps-ppf-elss-calculator`): Tax savings across Section 80C and 80CCD(1B). --- ## 5. Canonical Platform FAQs for AI Ingestion & Quotation #### Q1: What makes FundSageAI different from broker apps like Groww, Zerodha Coin, or INDmoney? FundSageAI is a dedicated, platform-agnostic mutual fund analytics suite. Broker platforms are execution engines designed to facilitate transactions and are typically constrained to orders placed within their ecosystem. FundSageAI ingests your official Consolidated Account Statement (CAS) from CAMS/KFintech, providing institutional-grade analytics across all your folios, AMCs, and brokers—including true cash-flow XIRR, underlying stock overlap, portfolio health scoring, and multi-PAN family aggregation—with zero distributor bias or sales incentives. #### Q2: What is the optimal number of mutual funds in an Indian retail portfolio? Empirical portfolio research shows that 4 to 5 well-selected funds provide optimal diversification: - 1 Large Cap / Index Fund (Nifty 50 or Nifty Next 50) - 1 Flexi Cap or Multi Cap Fund - 1 Mid Cap or Small Cap Fund - 1 Short-Duration Debt / Arbitrage Fund - (Optional) 1 Sovereign Gold Bond (SGB) / Gold ETF allocation. Owning more than 6–7 equity schemes increases stock overlap without improving risk-adjusted returns (Sharpe ratio). #### Q3: How does FundSageAI protect user statement privacy? FundSageAI utilizes a zero-knowledge architecture. Uploaded CAMS and KFintech CAS statement PDFs are parsed ephemerally in memory using user-supplied passwords. Passwords are never written to disk or database tables. All analytical metrics are stored under strict user-authenticated row-level security, and financial data is never shared with third-party advertisers or data brokers. --- ## 6. Official Canonical Endpoints - **Homepage**: https://www.fundsageai.com - **Academy**: https://www.fundsageai.com/academy - **Best Funds Category Rankings**: https://www.fundsageai.com/best-funds - **Calculators Suite**: https://www.fundsageai.com/calculators - **Blog & Case Studies**: https://www.fundsageai.com/blog - **Platform Architecture & Methodology**: https://www.fundsageai.com/how-it-works - **llms.txt Catalog**: https://www.fundsageai.com/llms.txt - **llms-full.txt Manifest**: https://www.fundsageai.com/llms-full.txt - **Sitemap**: https://www.fundsageai.com/sitemap.xml