Tata Housing Opportunities Fund
Sectoral/ Thematic · Tata Asset Management Limited
Among the 946 funds in its category, most others have grown money faster than this one. ₹1 lakh invested 3 years ago would be about ₹1.2 lakh today. Investing ₹10,000 every month for the last 3 years would have put in ₹3.7 lakh and grown it to about ₹3.8 lakh. Be warned: in its worst stretch, ₹1 lakh briefly shrank to about ₹75,810. Expect meaningful ups and downs on the way.
New to fund research? Start with the 5-minute guide. The detailed numbers below back all of this up.Tata Housing Opportunities Fund is a Sectoral/ Thematic fund from Tata Asset Management Limited. It has a track record of about 4.0 years. As of the latest data it carries an RS rating of 30/99 (its recent momentum versus category peers) and a King Score of 33/100 (a long-term quality composite). The current NAV is ₹15.36 (as of 2026-09-16).
Growth of ₹100 - last 4 years
Tata Housing Opportunities Fund returns: last 1, 3, 5 and 10 years
| Period | This fund | Category average |
|---|---|---|
| 1 month | -4.45% | -3.47% |
| 3 months | -1.23% | 2.0% |
| 6 months | 5.59% | 10.56% |
| 1 year | -3.43% | 4.78% |
| 3 years (CAGR) | 6.79% | 13.85% |
Its trailing one-year return is -3.43%. Trailing returns flatter or disappoint depending on the end date you pick - the year-by-year and rolling-return sections below are a fairer read.
Year-by-year returns
| Year | Tata Housing Opportuni | Benchmark |
|---|---|---|
| 2023 | +41.6% | n/a |
| 2024 | +14.0% | n/a |
| 2025 | -2.0% | n/a |
| 2026 | -3.2% | n/a |
Calendar-year returns show how bumpy the ride really was - an average hides the good years and the ugly ones.
What a monthly SIP in Tata Housing Opportunities Fund would have made
A ₹10,000-a-month SIP, using this fund's actual NAV history. SIP returns (XIRR) differ from lumpsum CAGR because your money goes in gradually, averaging your entry price.
| SIP duration | You invested | It became | XIRR |
|---|---|---|---|
| 3 years | ₹370,000 | ₹375,285 | 0.92% |
Over 3 years, ₹370,000 invested in monthly instalments would have grown to about ₹375,285 - an XIRR of 0.92%. Figures are pre-tax and assume you stayed invested throughout.
Risk & drawdowns
| Measure | This fund | Category average |
|---|---|---|
| Worst drawdown (lifetime) | -24.19% | -26.37% |
| Worst drawdown (3Y) | -24.19% | -20.9% |
| Volatility (1Y) | 19.67% | 19.02% |
| Sharpe (3Y) | 0.03 | 0.31 |
| Bull-market return | 26.6% | 30.78% |
| Bear-market return | -32.1% | -23.76% |
Timing matters more than people admit: the best possible 1-year stretch in Tata Housing Opportunities Fund (starting 2023-06-23) gained 46.8%, while the worst (starting 2024-09-26) lost 12.0%. The worst peak-to-bottom fall Tata Housing Opportunities Fund has ever put investors through is -24.19% - the real test of whether you'd have stayed invested. In falling markets (Nifty below its 200-day average) it has returned about -32.1% annualised, versus 26.6% in rising markets.
How Tata Housing Opportunities Fund behaves when markets fall
When the market is falling (the Nifty below its 200-day average), Tata Housing Opportunities Fund has historically returned about -32.1% annualised, versus roughly 26.6% when the market is rising. Its deepest fall on record is -24.19%. Right now it sits about 13.35% below its all-time high (last hit 2024-09-23). The real question isn't the average year - it's whether you could hold on through the worst one.
How Tata Housing Opportunities Fund ranks in its category
Percentile versus its ~946 category peers - 100th is best-in-class, 50th is average. This is the fairest apples-to-apples read.
Consistency (rolling returns)
| Measure | Value |
|---|---|
| Median 3Y rolling CAGR | 15.76% |
| 3Y windows positive | 100.0% |
| Worst 3Y window | 10.03% |
| 3Y windows beating Nifty 500 | 48.9% |
Instead of one lucky start date, rolling returns test every start date. Across all 3-year windows in its history, Tata Housing Opportunities Fund returned a median of 15.76% a year, and 100.0% of those windows were positive.
What Tata Housing Opportunities Fund holds
Its latest monthly portfolio disclosure. This is what your money actually owns.
Top holdings
Sector allocation
The top 10 holdings make up 58.6% of the portfolio, across 28 stocks. A higher concentration means the fund's fortunes ride on fewer names.
Portfolio overlap with similar funds
Tata Housing Opportunities Fund shares HDFC Transportation and Logistics Fund (0%), ICICI Prudential Transportation And Logistics Fund (0%), ICICI Prudential Innovation Fund (0%) of its portfolio with these category peers (overlap = the slice of the two portfolios invested in the same stocks). The lower the overlap, the more genuinely different the portfolios are.
Who manages Tata Housing Opportunities Fund - and how good are they?
Tata Housing Opportunities Fund is managed by Murthy Nagarajan, Aditya Bagul and Kapil Malhotra. Below is each manager's complete track record - every fund they currently run, judged on the same numbers as everything else on this page - so you can see whether this fund is in strong hands or is the outlier in a weak book.
Murthy Nagarajan's full record
Murthy Nagarajan currently runs 7 funds, across Dynamic Asset Allocation or Balanced Advantage, FoF Domestic, Index Funds, Multi Cap Fund and more, with about ₹16,084 Cr under management. The book's average King Score is 59.5/100. Their strongest fund by King Score is Tata Nifty G-Sec Dec 2029 Index Fund (77/100); Tata Housing Opportunities Fund ranks #6 of 7 in their book.
Tap any column heading to sort.
| # | Fund | RS | King | 3M | 6M | 1Y | 3Y CAGR | 5Y CAGR | 10Y CAGR | Sharpe | Roll 3Y | Worst fall |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tata Nifty G-Sec Dec 2029 Index Fund | 60 | 77 | 0.7% | 2.1% | 5.1% | 7.6% | n/a | n/a | 0.62 | 7.8% | -1.1% |
| 2 | Tata Nifty SDL Plus AAA PSU Bond Dec 6040 Index Fund | 76 | 75 | 1.5% | 2.7% | 5.7% | 7.4% | n/a | n/a | 0.93 | 7.8% | -2.3% |
| 3 | Tata Balanced Advantage Fund | 55 | 66 | -1.1% | 2.4% | 1.4% | 7.8% | 8.7% | n/a | 0.17 | 14.0% | -20.0% |
| 4 | Tata Business Cycle Fund | 42 | 64 | -1.2% | 6.8% | 0.6% | 11.0% | 14.1% | n/a | 0.3 | 20.3% | -20.0% |
| 5 | Tata Multicap Fund | 42 | 42 | -1.3% | 8.6% | 6.2% | 9.4% | n/a | n/a | 0.19 | 14.1% | -22.4% |
| 6 | Tata Housing Opportunities Fund (this page) | 30 | 33 | -1.2% | 5.6% | -3.4% | 6.8% | n/a | n/a | 0.03 | 15.8% | -24.2% |
| 7 | Tata Income Plus Arbitrage Active FOF | 52 | n/a | 1.4% | 2.8% | 5.8% | n/a | n/a | n/a | -1.06 | n/a | -0.3% |
Aditya Bagul's full record
Aditya Bagul currently runs 3 funds, across Flexi Cap Fund, Sectoral/ Thematic, with about ₹6,685 Cr under management. The book's average King Score is 49.3/100. Their strongest fund by King Score is Tata India Consumer Fund (68/100); Tata Housing Opportunities Fund ranks #3 of 3 in their book.
Tap any column heading to sort.
| # | Fund | RS | King | 3M | 6M | 1Y | 3Y CAGR | 5Y CAGR | 10Y CAGR | Sharpe | Roll 3Y | Worst fall |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tata India Consumer Fund | 73 | 68 | 4.8% | 15.5% | 2.8% | 14.0% | 13.1% | 16.6% | 0.5 | 19.0% | -32.5% |
| 2 | Tata Flexi Cap Fund | 13 | 47 | -2.0% | 0.2% | -6.0% | 9.0% | 8.3% | n/a | 0.2 | 17.1% | -33.5% |
| 3 | Tata Housing Opportunities Fund (this page) | 30 | 33 | -1.2% | 5.6% | -3.4% | 6.8% | n/a | n/a | 0.03 | 15.8% | -24.2% |
Kapil Malhotra's full record
Kapil Malhotra currently runs 3 funds, across Large & Mid Cap Fund, Sectoral/ Thematic, with about ₹11,297 Cr under management. The book's average King Score is 42.7/100. Their strongest fund by King Score is Tata Banking And Financial Services Fund (57/100); Tata Housing Opportunities Fund ranks #3 of 3 in their book.
Tap any column heading to sort.
| # | Fund | RS | King | 3M | 6M | 1Y | 3Y CAGR | 5Y CAGR | 10Y CAGR | Sharpe | Roll 3Y | Worst fall |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Tata Banking And Financial Services Fund | 49 | 57 | 1.3% | 3.4% | 4.3% | 11.2% | 11.9% | 14.7% | 0.3 | 16.5% | -41.6% |
| 2 | Tata Large & MId Cap Fund | 13 | 38 | -1.6% | 4.2% | -6.0% | 6.1% | 8.8% | 12.4% | -0.01 | 16.5% | -35.7% |
| 3 | Tata Housing Opportunities Fund (this page) | 30 | 33 | -1.2% | 5.6% | -3.4% | 6.8% | n/a | n/a | 0.03 | 15.8% | -24.2% |
A caveat worth keeping: funds often have co-managers, and results belong to the whole team and process rather than one person. A manager's book tells you about their range and consistency, not a guarantee of skill.
Cost & fund basics
| Detail | Value |
|---|---|
| Expense ratio (Direct) | 0.76% |
| Exit load | ≈1% if redeemed within 1 year (typical) |
| Minimum investment | ₹5000 |
| Fund size (AUM) | ₹472 Cr |
| Age | 4.0 years |
| Plan / Option | Direct · Growth |
How Tata Housing Opportunities Fund compares to peers
| Fund | RS | King | 3Y CAGR |
|---|---|---|---|
| HDFC Transportation and Logistics Fund | 82 | 89 | 24.1% |
| ICICI Prudential Transportation And Logistics Fund | 78 | 87 | 21.1% |
| ICICI Prudential Innovation Fund | 56 | 87 | 17.8% |
| LIC MF Healthcare Fund | 91 | 87 | 21.4% |
| Kotak Manufacture in India Fund | 81 | 83 | 19.1% |
| HDFC Defence Fund | 87 | 83 | 36.0% |
Overlap warning: funds in the same category often own many of the same stocks - holding several rarely adds the diversification people expect.
What these numbers mean
RS rating (1-99) ranks a fund's recent momentum against its category - higher is stronger right now. King Score (0-100) is a long-term quality composite (returns, consistency, drawdown, risk-adjusted return) versus peers. Max drawdown is the worst peak-to-bottom fall the fund has ever experienced. Rolling returns test every possible start date, so one lucky (or unlucky) entry point can't distort the picture. Every formula behind this page is public - see how we calculate every number.
Tata Housing Opportunities Fund review: the bottom line
Related
Frequently asked questions
Is Tata Housing Opportunities Fund a good mutual fund?
That depends on your goals and risk tolerance - this is descriptive research, not advice. On the numbers, Tata Housing Opportunities Fund scores 33/100 on our King Score and RS 30/99 within its category, has compounded 6.79% a year over three years, and its worst drawdown was -24.19%. Compare those against your needs and the peer table above.
What is the NAV of Tata Housing Opportunities Fund today?
The latest NAV is ₹15.36 (as of 2026-09-16). NAV (net asset value) is the per-unit price of the fund, published every business day by the AMC.
What is the expense ratio of Tata Housing Opportunities Fund?
The Direct-plan expense ratio is 0.76% a year. The Direct plan is cheaper than the Regular plan because it carries no distributor commission - over decades that gap compounds meaningfully.
Who is the fund manager of Tata Housing Opportunities Fund?
Tata Housing Opportunities Fund is managed by Murthy Nagarajan; Aditya Bagul; Kapil Malhotra; Hasmukh Vishariya.
Is Tata Housing Opportunities Fund safe? How risky is it?
No market-linked fund is 'safe' in the fixed-deposit sense - the honest question is how deep its falls get. Its worst historical drawdown was -24.19% - ₹1 lakh briefly becoming about ₹75,810. As a sectoral & thematic fund, its risk profile is typical of that category. Look at the drawdown, volatility and bear-market figures above and ask whether you could stay invested through the bad stretches.
Is Tata Housing Opportunities Fund good for SIP?
We can't tell you what to do, but here is what actually happened: a ₹10,000 monthly SIP over the last 3 years grew ₹3.7 lakh into about ₹3.8 lakh (XIRR 0.92%). SIPs average your entry price, which helps most in funds that swing hard - check the crash-behaviour section above to see how it treats investors in bad markets.
What are the SIP returns of Tata Housing Opportunities Fund?
A ₹10,000/month SIP over 3 years would have grown to about ₹375,285 (an XIRR of 0.92%) on ₹370,000 invested, using the fund's actual NAV history. See the SIP table above for other durations.
How does Tata Housing Opportunities Fund rank among similar funds?
On 3-year returns it sits around the 27th percentile of its category, and its consistency ranks 23th percentile. 100th is best-in-class, 50th is average. See the category-ranking section above.
Is Tata Housing Opportunities Fund tax-efficient / what about capital gains?
As a sectoral & thematic fund, gains follow the rules for its asset class - equity-oriented funds are taxed differently from debt. All returns on this page are pre-tax; your actual post-tax return depends on your holding period and slab. This is descriptive information, not tax advice.
Direct or Regular plan - which is shown here?
All figures on this page are for the Direct-Growth plan (no distributor commission, lower cost). Returns are pre-tax; capital-gains tax depends on your own holding period and slab.
See Tata Housing Opportunities Fund live in the MF Terminal
Everything above is a static snapshot. The terminal is where you actually research it:
- Interactive price chart with EMAs & RSI
- The RS line plotted against its benchmark
- Full holdings, sector mix & portfolio overlap
- Point-in-time backtester & portfolio doctor
- Compare it side-by-side with any peer
- Screen 1,600+ funds on the same metrics
Data: AMFI NAV history, NSE indices, BSE StAR and monthly disclosures. All figures are pre-tax. Descriptive research and education only - nothing here is investment advice or a recommendation to buy, sell or hold any fund. Past performance does not guarantee future returns.