Data Extraction & FinanceUpdated October 2026
Mutual Fund & ETF Factsheet Analysis Assistant
A comprehensive analytical prompt for reviewing mutual fund and ETF monthly factsheets, assessing risk-adjusted returns, evaluating portfolio concentration, and generating clear investor summaries.
Target Users: Individual Investors, Financial Advisors, Wealth Managers, and Personal Finance Writers
Supported Workflow: Portfolio due diligence, fund comparison, client advisory memos, and investment research
Interactive Prompt Builder
Customize & Generate Your Prompt
Adjust the variables below. Your customized prompt updates live in real-time ready to copy with zero setup.
Input Variables (6)runs 100% locally
System / Role Prompt
You are a chartered financial analyst (CFA) and fiduciary portfolio researcher. You evaluate mutual funds, index funds, and ETFs with objective quantitative rigor, emphasizing expense drag, tracking error, and downside risk metrics.
Assembled User Prompt (Live Preview)1796 chars
Please conduct a comprehensive, objective analytical evaluation of this mutual fund / ETF factsheet. ### Fund Overview - **Fund Name**: Vanguard 500 Index Fund / Mirae Asset Large Cap Fund - **Fund Category & Asset Class**: Large Cap Equity (Active) - **Benchmark Index**: Nifty 50 TRI / S&P 500 TR Index - **Expense Ratio & Exit Load**: 0.85% (Direct Plan) / 1.75% (Regular Plan); 1% exit load if redeemed within 365 days - **Historical Returns**: - 1-Year: 18.4% (Fund) vs 16.2% (Benchmark) - 3-Year CAGR: 14.8% (Fund) vs 13.9% (Benchmark) - 5-Year CAGR: 16.2% (Fund) vs 15.1% (Benchmark) - **Top Portfolio Holdings**: 1. HDFC Bank (8.8%) 2. Reliance Industries (7.9%) 3. ICICI Bank (6.5%) 4. Infosys (5.2%) 5. Tata Consultancy Services (4.1%) Top 5 Holdings constitute 32.5% of total portfolio. Sector exposure: Financials (34%), IT (16%), Energy (11%). ### Evaluation Framework 1. **Performance vs. Benchmark**: - Compare the fund's 1-year, 3-year, and 5-year annualized returns against **Nifty 50 TRI / S&P 500 TR Index**. - Calculate or estimate the alpha generated relative to category peers. 2. **Cost Drag & Expense Evaluation**: - Evaluate whether the **0.85% (Direct Plan) / 1.75% (Regular Plan); 1% exit load if redeemed within 365 days** is justified by historical alpha, especially compared to passive index alternatives. 3. **Concentration & Sector Risk**: - Analyze the top 10 holdings. Is the portfolio excessively concentrated in a single sector or top 3 stocks? 4. **Investor Profile Fit**: - What type of investor is this fund suited for (e.g. long-term SIP, risk-averse wealth preservation, aggressive tactical growth)? 5. **Executive Summary & Actionable Verdict**: - Conclude with a clear summary: [Strengths, Primary Risks, Bottom-Line Recommendation].
How to Use This Prompt Effectively
- 1Fill in the fund name, benchmark index, expense ratio, and trailing returns from the monthly factsheet PDF.
- 2Provide the top holdings and sector breakdown from the factsheet table.
- 3Submit the prompt to your AI assistant to generate a balanced investment evaluation report.
Representative AI Output
Sample output produced when using frontier AI models with the default parameters:
### Executive Factsheet Evaluation - **Benchmark Alpha**: The fund has delivered a modest positive alpha of +0.9% to +1.1% CAGR over 3-year and 5-year periods. - **Cost Drag Analysis**: In the Regular plan (1.75%), the 0.9% alpha is completely wiped out by distributor commissions. The Direct plan (0.85%) marginally outperforms, but a low-cost Nifty 50 Index Fund (0.10% expense ratio) delivers virtually identical net returns with zero manager risk. - **Portfolio Concentration**: 32.5% in top 5 holdings and 34% in financials is standard for large-cap mandates, but presents single-sector vulnerability. **Bottom-Line Verdict**: Suitable for core equity allocation via Direct SIP, but cost-conscious investors may prefer a passive index ETF for identical large-cap beta at a fraction of the cost.
Pro Optimization & Edge-Case Tips
- Always compare active large-cap funds against low-cost direct index ETFs; over 10-year horizons, the majority of active large-cap funds underperform their benchmark net of fees.
- Check portfolio turnover ratio in the factsheet; a turnover above 80% indicates aggressive short-term trading which may increase trading transaction costs.
- Review whether the fund manager has personal skin-in-the-game invested in the fund.