Use this Excel sheet to automatically calculate rolling upside capture, downside capture and rolling returns for equity mutual funds by comparing them with 72 BSE/NSE Indices. While the rolling returns provide a consistency measure for overall reward (return), the upside/downside captures provide a consistency measure for outperformance during up-market periods and protection during down-market periods…
Continue reading →Under certain circumstances, long-term or short-term capital gains tax to be paid can be significantly reduced. It is not routinely possible and therefore important to recognize this possibility if and when it arises. This post stems from a discussion at Facebook Group Asan Ideas for Wealth, started by Subrat Dash, with the circumstances explained by…
Continue reading →Readers may be aware that I often use rolling returns, where anualized return is calculated between two dates and the calculation dates are shifted to the next possible business day. I have developed a rolling downside and upside capture calculator and before publishing it, would like to discuss what they are in simple terms. A…
Continue reading →Have you not read the mutual fund past performance disclaimer? Then how can we select mutual funds using past performance alone? In this post, I discuss this question asked by Swati Joshi. It is no secret many in the financial services dislike me. So their favorite approach to criticism is to claim that my “fund…
Continue reading →Here are two simple mutual fund screeners to automatically create a shortlist from a chosen mutual fund category. I have combined the monthly screener data – 3,5,7 year performance consistency and 1,2,3,4,5,6,7,8,9,10,11Y SIP and lump sum data to create this screener. Do give this a go and let me know what you think. Why Did…
Continue reading →Will a life insurance claim be denied if the insured died in an accident where he was the driver without a valid driver’s license or valid vehicle insurance? Thanks to a question by Ganapathy Krishnan at Facebook group, Asan Ideas for Wealth, I was able to obtain an authoritative answer to this question from the insurance…
Continue reading →Use this tool to analyse the consistency in the performance of your mutual fund holdings with respect to their benchmarks (72 indices from BSE and NSE). You can also use this to evaluate new funds that you want to invest in. This is a major update (version 5 ) to the freefincal mutual fund rolling…
Continue reading →Financial products get mis-sold every minute of every day. Interpretations of what constitutes miss-selling depend on who you ask. They range from persuasion (bending the rules) to outright fraud (breaking them). In this case, the victim is the buyer. There is yet another form of miss-selling where both the buyer and seller are victims. In this…
Continue reading →In this post, I discuss what investors need to know before reaching for Best/Top mutual funds with a past vs future performance study along the lines of the one made earlier: Mutual Fund Investing: Does Past Performance Matter? So this post is more of an update to that analysis. Let us assume that you make a lump…
Continue reading →This is an update to the fantastic Nifty One-stop shop created by Pranav Date. Now you can download historical total returns index (TRI) data (dividends assumed to be reinvested) of 52 NSE Indices. You can also download the price history, from 59 Indices, PE, PB and Div Yield data of 51 NSE Indices and the…
Continue reading →In this guest post, R. Srivatsan discusses the pros and cons of using a stock valuation technique known as Earnings Power Box, introduced by Hewitt Heiserman, Jr, in his book, “It’s Earnings That Count: Finding Stocks with Earnings Power for Long-Term Profits”. Regular readers maybe aware that Srivatsan has already introduced the technique in his first post: It’s…
Continue reading →Shall we try out the following experiment? Pick a fund that you invest in. Say Quantum Long Term Equity or PPFAS LTVF or HDFC Balanced. Enter all the transactions in that fund(s) in a portfolio tracker. Then add a couple of index mutual funds like Franklin Nifty Fund or ICICI Nifty Next 50 fund. Use the same…
Continue reading →The media is blaring at full blast about the number of jobs (not just IT) that could be lost in 2017 and beyond and how it could be “bigger” than 2008. Whether there is merit in such speculation remains to be seen. What should be clear to anyone working in a non-government establishment is that…
Continue reading →If you’ve been through the last few posts, you’ll know that my new book co-authored with Pranav Surya is out for pre-order and we’re running a crazy small experiment of eliminating the middleman (aka Amazon). This enables us to provide you the book at a discounted price of 180 as compared to 249 on Amazon…
Continue reading →In this post, my GameChanger co-author, Pranav Surya offers a sneak peak into the book. The hard copy is now available for pre-order for just Rs. 180 (offer closes Sunday 21st midnight) before it retails at Amazon Rs. 249 from Monday. We also have two exciting add-ons at a small additional cost. This will be announced…
Continue reading →