This can be a Nationwide Pension Scheme Fund Screener to shortlist constantly performing NPS schemes. You too can determine NPS schemes that supply the next return than the benchmark whereas sustaining decrease threat. That is related in design to the freefincal Fairness Mutual Fund Efficiency Screener.
Inside, you get discounted hyperlinks to our robo advisory software and two programs: Tips on how to get individuals to pay in your abilities (aka earn from abilities) and the lectures on goal-based portfolio administration.
The benchmarks used are given under.
Benchmarks Used
| Class | Benchmark (index) |
| Various Property | CRISIL Composite Index, CRISIL HYBRID 85:15 |
| Atal Pension Yojana | CRISIL Composite Index, CRISIL HYBRID 85:15 |
| Company bond | CRISIL Composite Index, CRISIL HYBRID 85:15 |
| Fairness | N200TRI, N50TRI |
| Gilt | IBEX (I-Sec Sovereign Bond Index) |
| Authorities | CRISIL HYBRID 85:15, IBEX (I-Sec Sovereign Bond Index) |
| Hybrid max 10% -25% fairness | CRISIL Composite Index, CRISIL HYBRID 85:15 |
Observe: The benchmarks used for non-equity schemes are solely notional. They might not be good representatives of the asset class. Person discretion is suggested.
Use this screener file to shortly determine the best-performing NPS schemes that constantly outperform class benchmarks/indices with ample draw back safety (improved efficiency when the index is down) and upside efficiency (improved efficiency when the index is up).
Observe: Opposite to in style perception, NPS schemes usually are not index funds! They’ve a benchmark and are anticipated to beat it.
What does this NPS Efficiency Screener cowl?
It provides you three outputs:
- Rolling return outperformance consistency: the NPS scheme/fund returns are in contrast with class benchmark returns over each attainable 1Y, 2Y, 3Y, 4Y, and 5Y interval. The upper the consistency of outperformance, the higher. Suppose 876 fund returns have been in contrast with 876 benchmark returns, and the fund has crushed the benchmark 675 occasions. The consistency rating might be 675/876 ~ 77%.
- Upside efficiency consistency over each attainable 1Y, 2Y, 3Y, 4Y, and 5Y: The upper, the higher. A rating of 70% signifies that 7 out of 10 occasions, the NPS fund outperformed the class benchmark when the benchmark elevated. This can be a measure of reward.
- Draw back efficiency consistency over each attainable 1Y, 2Y, 3Y, 4Y, and 5Y: The upper, the higher. A rating of 60% means 6 out of 10 occasions, the NPS fund carried out higher than the class benchmark when the benchmark was shifting down. This can be a measure of threat safety.
If you happen to open the screener file, you see column headings like this.


You might have the scheme class, benchmark, NPS scheme identify, variety of 1Y returns of the benchmark(index), variety of 1Y returns of the fund, variety of occasions the fund’s 1Y return is above the index’s 1Y return, the 1Y rolling return consistency, upside efficiency consistency and draw back safety consistency. These columns are repeated for 2Y, 3Y, 4Y, and 5Y.
You may display by filtering out funds with return outperformance consistency of >=60%, a draw back safety consistency of >= 60% and so forth. That is solely an instance. You may apply your screening standards.
Display for NPS schemes with increased than benchmark returns and decrease threat
Right here, you may display for funds with an extra return larger than 0 within the final 1, 2, 3, 4, or 5-year trailing intervals. This implies the fund return is bigger than the index return. You too can add extra threat < 0 filters for a similar intervals. Which means that the fund threat is lower than the index threat. Therefore, the surplus threat is destructive.
Take, for instance, ICICI PRUDENTIAL PENSION FUND SCHEME E – TIER I
- Trailing Benchmark Return 1Y: 22.704%
- Trailing Fund Return 1Y: 35.089%
- Extra return 1Y: 12.385% (constructive extra return is sweet!)
- Index customary deviation (NAV volatility) 1Y: 3.732%
- Scheme customary deviation 1Y: 3.592%
- Extra threat of the scheme: -0.140% (destructive extra threat is sweet!)
Subsequently, over the past 12 months, the NPS scheme has considerably outperformed the index, with decrease NAV volatility (that is solely an instance and doesn’t signify present knowledge).
The concept right here is to seek out funds which have crushed the index when it comes to increased returns (extra return >0) and decrease threat (extra threat <0) within the final 1,2,3,4,5 12 months interval. You may loosen up it to three, 4, or 5-year intervals if you want.
This can be a screenshot of the info.


Reward measure: Rolling returns outperformance consistency.
Rolling returns are a easy estimate of how constantly a fund has outperformed a benchmark.
Take the ICICI PRUDENTIAL PENSION FUND SCHEME E – TIER II for instance. There are 476 five-year rolling returns compared with the Nifty 200 TRI. Out of those, the fund beat the benchmark 220 occasions. So the Rolling returns outperformance consistency = 220/476 = 46.2%. Naturally, the upper the rolling return outperformance consistency, the higher.
Reward and Danger Measure: Upside Efficiency & Draw back Seize
Upside efficiency consistency over each attainable 1Y,2Y,3Y,4Y, 5Y: Increased the higher. A rating of 70% means, 7 out of 10 occasions, the Fund carried out higher than the class benchmark when the benchmark elevated. This can be a measure of reward. It’s computed from rolling upside seize knowledge.
Draw back efficiency consistency over each attainable 1Y, 2Y, 3Y,4Y, and 5Y. The upper, the higher. A rating of 60% means 6 out of 10 occasions, the Fund carried out higher than the class benchmark when the benchmark was shifting down. This can be a measure of threat safety. It’s computed from rolling draw back seize knowledge.
If you happen to want to perceive how these are calculated, please learn this: Introduction to Draw back and Upside Seize Ratios and proceed to this one, for instance. For some funds, a excessive draw back seize consistency will result in higher returns; for some funds, a excessive upside seize consistency will result in higher returns. The screener might help distinguish between the 2 varieties of performers. Advocate studying: What’s mutual fund draw back safety, and why is it vital?
Tips on how to use the NPS Efficiency Screener
There are a number of methods to display for mutual funds. I’ll focus on two examples.
Then, methodology A: Set the 3Y and 5Y rolling return outperformance consistency to be above 60% or 70% or so. That ought to offer you a pleasant shortlist to select from. Then, you may visually search for funds with the fitting draw back safety consistency and choose one. Technique B: Search for funds above 60% or 70% draw back safety consistency over 3Y and 5Y and select one. Keep in mind, by no means set slim filters and don’t be too demanding. Wanting to pick the fund with the most effective previous efficiency is apparent immaturity. Your screening standards ought to yield 5-6 funds always. Why ought to I exploit this screener? Why can’t I take a look at trailing returns and display? Trailing returns are 3Y or 5Y returns calculated with the final enterprise date (3Y and 5Y prior). This is only one knowledge level to contemplate. Right here, we discover much more to find out consistency.
Extra Danger vs Extra Return Screener: The concept right here is to seek out funds which have crushed the index when it comes to increased returns (extra return >0) and decrease threat (extra threat <0) within the final 1,2,3,4,5 12 months interval. You may loosen up it to three, 4, or 5-year intervals if you want.
Necessary Info
- This screener prices Rs. 150 and is supposed for private use solely.
- Inside, you get a reduced hyperlink to our robo advisory software and two programs: Tips on how to get individuals to pay in your abilities (aka earn from abilities) and the lectures on goal-based portfolio administration.
- The fee solely applies to the info within the sheet.
- You’ll get an Excel file with the info. You may allow knowledge filters and display it as you want. You may add this file to any spreadsheet software program.
- Whereas freefincal will do its finest to publish up to date screener sheets every month, it can’t assure that it’ll achieve this.
- The file accommodates no purchase or promote suggestions and solely has the abovementioned knowledge.
- Sufficient care and energy have been put into removing errors. Nonetheless, we can’t assure that the sheet is error-free.
- The client should analysis utilizing the data within the spreadsheet. No suggestions or help are included within the sheet and won’t be offered individually.
- We is not going to present any additional assist or help in utilizing the sheet.
- The sheet bought is for private use solely and shouldn’t be shared, both privately or publicly. A purchase order implies that you simply conform to the phrases within the Necessary Info part.
Click on right here to pay Rs. 150 and obtain (instantly) the newest Freefincal NPS Fund Screener.
Are you residing exterior India? You may pay through this PayPal hyperlink (5 USD) and electronic mail us: freefincal at Gmail.
Do share this text with your mates utilizing the buttons under.


Use our Robo-advisory Software to create a whole monetary plan! ⇐Greater than 3,000 buyers and advisors use this! Use the low cost code: robo25 for a 20% low cost. Plan your retirement (early, regular, earlier than, and after), in addition to non-recurring monetary targets (corresponding to baby schooling) and recurring monetary targets (like holidays and equipment purchases). The software would assist anybody aged 18 to 80 plan for his or her retirement, in addition to six different non-recurring monetary targets and 4 recurring monetary targets, with an in depth money circulate abstract.
🔥You too can avail huge reductions on our programs and the freefincal investor circle! 🔥& be a part of our neighborhood of 8000+ customers!
Observe your mutual funds and inventory investments with this Google Sheet!
We additionally publish month-to-month fairness mutual funds, debt and hybrid mutual funds, index funds, and ETF screeners, in addition to momentum and low-volatility inventory screeners.
You may observe our articles on Google Information


We’ve over 1,000 movies on YouTube!


Be part of our WhatsApp Channel


Podcast: Let’s Get RICH With PATTU! Each single Indian CAN develop their wealth!


You may watch podcast episodes on the OfSpin Media Buddies YouTube Channel.


🔥Now Watch Let’s Get Wealthy With Pattu தமிழில் (in Tamil)! 🔥
- Do you’ve got a remark concerning the above article? Attain out to us on Twitter: @freefincal or @pattufreefincal
- Have a query? Subscribe to our publication utilizing the shape under.
- Hit ‘reply’ to any electronic mail from us! We don’t provide personalised funding recommendation. We will write an in depth article with out mentioning your identify you probably have a generic query.
Be part of 32,000+ readers and get free cash administration options delivered to your inbox! Subscribe to get posts through electronic mail! (Hyperlink takes you to our electronic mail sign-up type)
About The Writer

Dr M. Pattabiraman (PhD) is the founder, managing editor and first creator of freefincal. He’s an affiliate professor on the Indian Institute of Know-how, Madras. He has over 13 years of expertise publishing information evaluation, analysis and monetary product growth. Join with him through Twitter(X), LinkedIn, or YouTube. Pattabiraman has co-authored three print books: (1) You may be wealthy too with goal-based investing (CNBC TV18) for DIY buyers. (2) Gamechanger for younger earners. (3) Chinchu Will get a Superpower! for youths. He has additionally written seven different free e-books on numerous cash administration matters. He’s a patron and co-founder of “Payment-only India,” an organisation selling unbiased, commission-free, AUM-independent funding recommendation.
Our flagship course! Study to handle your portfolio like a professional to attain your targets no matter market circumstances! ⇐ Greater than 3,500 buyers and advisors are a part of our unique neighborhood! Get readability on easy methods to plan in your targets and obtain the mandatory corpus irrespective of the market situation!! Watch the primary lecture free of charge! One-time cost! No recurring charges! Life-long entry to movies! Scale back worry, uncertainty and doubt whereas investing! Learn to plan in your targets earlier than and after retirement with confidence.
Improve your revenue by getting individuals to pay in your abilities! ⇐ Greater than 800 salaried staff, entrepreneurs and monetary advisors are a part of our unique neighborhood! Learn to get individuals to pay in your abilities! Whether or not you’re a skilled or small enterprise proprietor searching for extra shoppers by on-line visibility, or a salaried particular person in search of a aspect revenue or passive revenue, we are going to present you easy methods to obtain this by showcasing your abilities and constructing a neighborhood that trusts and pays you. (watch 1st lecture free of charge). One-time cost! No recurring charges! Life-long entry to movies!
Our e book for youths: “Chinchu Will get a Superpower!” is now out there!


Most investor issues may be traced to an absence of knowledgeable decision-making. We made dangerous selections and cash errors after we began incomes and spent years undoing these errors. Why ought to our youngsters undergo the identical ache? What is that this e book about? As mother and father, what wouldn’t it be if we needed to groom one potential in our youngsters that’s key not solely to cash administration and investing however to any side of life? My reply: Sound Choice Making. So, on this e book, we meet Chinchu, who’s about to show 10. The narrative revolves round what he desires for his birthday and the way his mother and father plan for it, in addition to educating him a number of key concepts of decision-making and cash administration. What readers say!


Should-read e book even for adults! That is one thing that each dad or mum ought to educate their youngsters proper from their younger age. The significance of cash administration and determination making primarily based on their desires and desires. Very properly written in easy phrases. – Arun.
Purchase the e book: Chinchu will get a superpower in your baby!
Tips on how to revenue from content material writing: Our new e-book is for these focused on getting a aspect revenue through content material writing. It’s out there at a 50% low cost for Rs. 500 solely!
Do you need to verify if the market is overvalued or undervalued? Use our market valuation software (it’s going to work with any index!), or get the Tactical Purchase/Promote timing software!
We publish month-to-month mutual fund screeners and momentum, low-volatility inventory screeners.
About freefincal & its content material coverage. Freefincal is a Information Media organisation devoted to offering authentic evaluation, stories, critiques and insights on mutual funds, shares, investing, retirement and private finance developments. We achieve this with out battle of curiosity and bias. Observe us on Google Information. Freefincal serves greater than three million readers a 12 months (5 million web page views) with articles primarily based solely on factual data and detailed evaluation by its authors. All statements made might be verified with credible and educated sources earlier than publication. Freefincal doesn’t publish paid articles, promotions, PR, satire or opinions with out knowledge. All opinions might be inferences backed by verifiable, reproducible proof/knowledge. Contact Info: To get in contact, please use our contact type. (Sponsored posts or paid collaborations is not going to be entertained.)
Join with us on social media
Our publications
You Can Be Wealthy Too with Objective-Primarily based Investing

Printed by CNBC TV18, this e book is designed that will help you ask the fitting questions and discover the right solutions. Moreover, it comes with 9 on-line calculators, permitting you to create customized options tailor-made to your life-style. Get it now.
Gamechanger: Overlook Startups, Be part of Company & Nonetheless Stay the Wealthy Life You Need

This e book is designed for younger earners to get their fundamentals proper from the beginning! It’ll additionally provide help to journey to unique locations at a low value! Get it or present it to a younger earner.
Your Final Information to Journey

That is an in-depth exploration of trip planning, together with discovering reasonably priced flights, finances lodging, and sensible journey ideas. It additionally examines the advantages of travelling slowly, each financially and psychologically, with hyperlinks to related net pages and steerage at each step. Get the PDF for Rs 300 (immediate obtain)
