This post showcases a presentation by Aparna C K to her office colleagues on Sep. 19th 2014. I am delighted that she kindly consented to let me share this here. Regular readers maybe aware that Aparna has written two guest posts for freefincal which became instant hits:
I have chosen to post the PowerPoint slides as individual .jpeg figures with the authors notes (mildly edited for public consumption) and relevant hyperlinks.
Author Note:Personal finance is more to do with you as person than finance. It is not finance in the conventional sense. You must participate actively to get max return on your time invested. Let us find out what you guys expect from this.
Author Note:Not “making” money. What suits one person may not suit the other. Avoid copying others. Personal comes first rather than Finance, precisely because it is Personal.
Author Note: What if your vehicle meets with an accident and goes for repair, What if you die due to accident or illness? What happens if you lose jobs? Now you have income, but when it stops, how are you going to live How are you going to finance your dreams/goals which are a few years away Before really getting into deep waters, knowing one’s inclinations, attitudes is very important.
Author Note: When you already have so many genuine expenses, not spending on unnecessary things is very important. Not needed also applies to financial products.
Author Note: Once you start DIY, it is hard not to enjoy it. It is equally hard to trust someone else with our hard earned money. Only advantage with hiring someone to handle our finance is, they may help you to take balanced decision, but this may or may not happen. Many a times, they get interested only in their commission. Link in the slide:What does it take to do your own financial planning? Author Note: One may not realize the importance if staying in parents house, parents still working Check if you live within the budget. Don’t purchase anything on a whim, without understanding. In finance, this results in loss of investible surplus, which is formally termed as an opportunity cost. If you are already stuck with one, don’t try to avoid current loss, when you know further investments in bad products will only lead to more future losses. -Credit card is not bad if you exploit all its advantages and do not get spoilt
If you get tempted to spend, transfer it to another account. Best to keep one more account other than salary account. Let the salary account be expenses account and the other one savings. As soon as you receive salary, transfer the surplus to savings
When I say cutdown, I am not saying lead an ascetic life. As I said earlier, evaluate needs and wants. My own experience: I used to record my expenses right from my highschool days, as a result, once I started earning, I completely stopped it. I did it on and off after marriage, since December 2013, religiously doing it. Link in the slide:Budgeting Gets Your Financial Act in Place
Author Note: Touch it only for real emergencies-unforeseen events. Accident, house collapse, or forgetting wife’s birthday! Business people may keep more emergency fund, like 12 month expenses. On Life insurance: Go for it only if you have dependents/loans that too if your net worth is not sufficient to take care of them in your absence. Term + PPF/ELSS is superior to Endowment/ULIPs. Health insurance is a complicated product, be careful when you buy. Read exclusions, pre-existing illness cover, co-pay.
Author Note: An example. 1000 rupees invested today. After a year get back 1100. But what costed 1000 rupee today costs 1090 next year. Still net gain is 10 rupee, but this 10 rupee next year is not the same as this year’s 10 rupee. It is only 10/1.09 = 9.1 rupee. So your real return is 9.1 rupee for 1000 rupee invested.
CII Started in 1981-82, at 100. In 2014-15: 1024 => Over 33 years, 7.3% annualized inflation – At this rate, after 33 yrs, your 20k becomes 2L expenses. Collect actual data from your parents. My own experience: When I started in 2002, with rented home, my expenses were 10k per month, but now it is not comparable. Lifestyle itself has totally changed. FDs at 9%, after tax give 6.3%/7.2%/8.1% (Fixed Depreciation) So, don’t be fooled by how banks present their interest rates. Would you really love to save money in FDs if banks all over put banners saying, “we give -1% real returns”. It is just the way numbers are presented makes us not see the reality.
Author Note: If you are 60 today and your monthly expenses are 11900, you can retire with a corpus of 40Lakh, provided, the returns from corpus matches inflation. For 50 yr old, In 10 yr duration, due 40L gets inflated to 74L. For 22 yr old boy, in 38 yr duration, it gets inflated to 5.23Cr. This is the reason for the difference in the corpus needed. (Numbers entered in the fields of jagoinvestor calculator: 11900, years, 7,7,8.07,30,7,7)
Author Note: Set your personal priorities first. If you do not like grand weddings, do not have one, worse, do not take a loan for it. In general, do not plan for unnecessary expenses to please parents, relatives or friends. If your parents are ignorant and made mistakes, does not mean out of respect for them you must repeat them. Be logical. Another point. Do all these activities ASAP, before marriage, otherwise you need to please one more person. (At the same time, be flexible, and accept if the other person has better suggestions) If you are in single ready to mingle state, it makes sense to talk about finances at some stage while dating. It can start indirectly initially and go deeper with a few more meets. Converging on a common finance philosophy becomes very important in marriage. Do you want to be fighting about money every day? Own home in Bangalore, as of now does not make any financial sense. Renting is far sensible than buying. That is a different analysis by itself. We can take it up later. People are uncomfortable with huge cash, for the fear of spending them. Due to lack of familiarity with other avenues, they get into EMIs. This should be avoided.
Author Note: Short term : Buying a bike/car, house renovation, Big amounts of charity for a cause you believe in Medium term: Child education, downpayment for home/land for future home Long term: Retirement
Author Note: There are some more lesser known advantages of PPF apart from Govt backing It can be extended by 5 year blocks, after maturity, for n number of times. There are some fine rules to be adhered to. At any time after crossing 7 yrs, you can withdraw half the balance 4 yrs ago. But go for it only for matter of life and death PPF balance is safe, lenders can not claim it. Fact about PPF: Interest rates are volatile. Till 2002 it was around 11%!
On tax evasion TDS is not same as paying tax. Bank cuts at nominal rate of 10%, but you need to pay as per tax bracket. Also the 10k exemption is only on SB interest, not on FDs and RDs. To be paid on accrual basis If you do not pay tax and get caught, you may be fined 3 times the hidden income. Scrutiny is random. Author Note: Debt mutual funds: These could be superior to FDs especially for 20 and 30% bracket people, for short and medium term goals, due to indexation benefit after 3 years. Index funds: Do not choose blindly still. See AUM, expense ratio and tracking error. Buy it from reputed fund house.
Important point: SIP: Any time is a good time to start. Rupee cost averaging works independent of start and end points. Some numbers. Consider 1000 rupee SIP. Buy 100 units at 10 rupee Next month, say it falls to 9.5 rupee. Investment value has fallen to 950 rupees., But you get 105.26 units. Now your investment chart reads as 1950 Say next month it fell to 8 rupee. You get 125 units for 1000 rupees and your cost value 3000, investment value now reads as 2642. Do not panic. Wait patiently. Consider next month, increasing to 11 rupee, due to some factors. You get 90.9 units, your cost value is 4000, but the investment worth is 4631. You can either cry you got 90.9 units, or celebrate you gained 632 overall due to jump. Do not redeem. Let the SIPs continue.
Author Note: Once invested, focus on learning basics. Read books/blogs written by qualified people (not necessarily finance people). My list of Personal finance teachers (names not important): An old wise CA, Computer Sc Engineer turned financial planner, Physics Prof in IITM, Chemical Engineer, Doctor and all the active folks in an FB closed group called “Asan Ideas For Wealth” whom I’ve never met in my life and might not meet. For motivated people inspiration can come from anywhere, just have the willingness to learn. To be financially intelligent, you do not need to have a degree in finance. Do not listen to TV channels or read newspapers on market movements. Rebalance, not profit booking. Periodically move back and forth based on asset allocation ratio. With active funds, one needs to evaluate its performance wrt benchmark index, not as absolute performance. At least in the case of index funds, there is not even the need to check if the fund is performing poor, unless there’s a big change due to which the basic parameters started drifting.
It is found that if r is small enough, then any MF does a good job with SIP, but same cannot be said about lumpsum. Only in sideways markets SIPs wont work, but nor will the lumpsum.
Author Note: Do not link happiness and money. Also, frugal doesn’t mean miser. Clearly distinguish between needs and desires. Miser compromises on needs, frugal controls his desires, but spends on needs. When you do not know what it means to be in financial stress, it is hard to guess what will happen if you do not have enough in the retirement. This is just accumulation phase. During retirement, one can treat blocks of 5 yrs as a separate goal and keep aside money from the total corpus.
Story of a finance person, a CA getting into mess in her own personal finance, when her husband in early 30s dies. When there is a death (Unable to locate the original post. Pity that so many people have published this story but none of them seem to point to the original sour)
Please share your views on this presentation and any questions that you have in the comments section. If you found it useful, do share it with fellow young earners.
It is raining closed-ended mutual fund NFOs. Here is why one should avoid this category of mutual funds.
There are many articles that describe the features of closed-ended mutual funds. Therefore, I will not mention them here. Let us focus on the titular suggestion alone.
1) The first and foremost rule of purchasing – be it a financial product or a bottle of shampoo. Never buy anything based on unsolicited recommendations.
There is usually a pretty good reason why a product is recommend to you without your asking for it and it has nothing to do with you!
Bank branch mangers/relationship managers or mutual fund distributor are eager to push closed-ended mutual funds because of high commissions! In a closed-ended mutual fund, the intermediary is paid the entire commission of the tenure upfront, unlike a SIP or lump sum investment in an open-ended mutual fund.
This is the reason for the aggressive selling.
Yes, yes, yes, not all distributors are like that and all that sort of thing.
Let us choose to believe that investors read the SID cover to cover and chose, of their own free will, to invest an insignificant AUM of 4,500 Crore in such funds. Naturally no one made any promises of high returns to these investors.
Here is a simple way to ensure your relationship manager does not even recognise you as a human being: Invest before you spend and reduce the balance in your SB account to something small asap.
2)What are you doing with a lump sum in the first place? If you are considering a closed-ended fund, you have a lump sum free to be invested (who on Earth would invest a small amount in such funds?!).
Ask yourself where does this lump sum figure in your scheme of things? Has it been tagged to a financial goal?
A person who has budgeted efficiently, accounted for all present and future expenses (foreseen and unforeseen) will not have any lump sum lying around to invest each time an NFO pops up.
3) Do you know how to expect when you are expecting?
Let us face it. Be it a sector fund or a fixed deposit, every investor has expectations. What are the expectations of a closed-ended mutual fund investor? Especially the ones who choose predominantly equity-based closed ended funds for 3 or 5 years.
Surely it is not a single digit return!
Just because redemptions are not allowed does not make a fund better. What matter is intelligent stock selection and the necessary time for the stocks to perform. There is no evidence that closed-ended funds have performed better than open-ended funds (you can check at VR online).
A skilled, experienced fund manager is certainly a plus for any active fund – closed or open. Unfortunately, that cannot guarantee returns. Equity as an asset class is too volatile for such short periods of time to have any kind of return expectations.
A ‘veteran’ fee-based financial planner revered by his colleagues stated to a reporter that closed-ended funds are good because the money is locked-in therefore enabling many investors to spend time in the market. What utter bollocks!
If anyone says three years is long-term for equity investing, they are either trying to sell a product or are clueless about risk.
They call it advisory ‘business’ for a pretty good reason!
Launching equity-based closed-ended mutual funds is an opportunistic exercise by AMCs to lure investors clueless about equity investing. All things that look good on paper (acche din) do not turn out that way. At least not within a definite time frame.
Bottom Line: Closed-ended mutual funds are utterly unsuitable for goal-based financial planning. Stay away …. unless you like clutter.
This post details a backtesting analysis based on the investment strategy to be adopted by the NFO IDFC Dynamic Equity Fund. It is inspired by a thread in facebook group Asan Ideas for Wealth started by Anup Maheswari.
IDFC Dynamic Equity Fund (IDEF) is a quantitative tactical asset allocation fund along the lines of Franklin’s PE fund and DSP BR Dynamic Asset allocation fund (see details here)
From scheme information document Excuse the long verbatim extract.
The scheme aims to dynamically manage equity and debt exposure in the portfolio. We are of the belief that such strategy will minimize the risk and optimize the risk return proposition for a long term investor.
The extent of equity exposure would be guided by an underlying quantitative model. The balance will be invested in debt and money market securities. The fund managers will follow a passive investment strategy and take equity exposure depending on opportunities available at various points in time based on the month-end weighted average PE ratio and 200 Day Moving Averages of the CNX Nifty Index.
Equity market exposure will be taken as per the quantitative model outputs. These exposures will then be passively maintained by tracking any of the market indices (subject to tracking error). The Scheme will endeavour to invest in stocks in a proportion that it is as close as possible to the weightages of these stocks in the underlying Index, taking into account the change in weights of stocks in the index as well as the incremental collections/redemptions from the Scheme.
The index to be invested in (tracked) will be determined on relative valuation of indices (month-end weighted average P/E ratio of the respective index) amongst themselves. The scheme proposes to track (subject to tracking error) CNX Nifty and CNX Nifty Junior indices as its investment universe. The Scheme will switch between indices when the current ratio of the indices’ PE ratios (PE of CNX Nifty/PE of CNX Nifty Junior) is above or below its 18 month standard deviation.
The scheme shall invest in various types of permitted debt and money market securities (including G-Sec) across maturities. The allocation to various types of debt / money market securities would be based on the fund manager’s view on interest rates and the market conditions.
Use of equity derivatives:
Under normal circumstances, the scheme shall primarily invest in equity and equity related instruments in the range of 65% to 100% and fixed income securities including money market instruments in the range of 0% to 35% for capital appreciation. The scheme will vary its investment in equity and equity related instruments and move towards exposure to equity derivatives when it needs to bring down the equity exposure below 65% depending upon the quantitative model.
In the periods where the model indicates a bullish market, the exposure of the scheme in equity and equity related instruments will increase of up to 100%. However, if the market movement reflects a bearish tint, the scheme will restrict its investment in equity to 65% and if necessary shall hedge this equity exposure in underlying stocks up to the extent of 35% of the portfolio by taking offsetting position in the derivative segment, therefore resulting into an equity market exposure going below 65% bringing it down up to 30%. In such a scenario the balance will be invested into debt market instruments.
Determining the equity exposure:
A quantitative model will be used to determine the exposure in equity and debt markets. The portfolio shall be rebalanced on the last working day of the second week of every month.
The quantitative model approach used to determine the equity and debt allocation employs valuation and momentum factors namely month-end weighted average P/E Ratio and 200 Day Moving Averages (“DMA”) of CNX Nifty index. Valuation (P/E ratio) is used to determine whether markets are cheap or expensive relative to their 10 year history. We believe that the P/E ratio captures broader market valuations very well and thus helps judge market cycles while the moving average (200 DMA) help determine near term market sentiment.
The funds asset allocation will follow a two step approach. First, the band in which monthly average of the Nifty PE falls is determined. Then depending on the 200 day daily moving average, the equity allocation will be fixed.
I was curious to check how this strategy works using past Nifty data. I have used the same asset allocation strategy but with only one index – the Nifty.
Unlike the fund I have assumed changes to the equity allocation on a daily basis (possible only on Excel!).
1) Monthly average of Nifty PE was computed.
2) The equity allocation was determined with this on the above basis
3) The daily index returns were computed.
4) The daily fund-strategy return was computed according to the calculated equity allocation.
5) The 1-year and 5-year rolling returns for the index and the fund-strategy were computed.
Note: This analysis brings out the flavour of the funds strategy and is not an attempt to replicate what the fund aims to do.
The 200 Day Daily Moving Average (DMA)
Notice that when the Nifty is above the 200-DMA, it represents an upward trend and when the Nifty is below the 200-DMA, it represents a downward trend. In a sideways market, the Nifty could repeatedly cross the DMA either way.
The 1-year rolling returns
Notice that outlined strategy is less volatile than the Nifty. It has good downside protection and at the same time does not lose out too much when there is an upswing.
The 5-year rolling returns
This results in superior ‘long-term’ (relative to 1-year!) performance. The outlined strategy seems to have comfortably beaten the Nifty.
I will discuss more about such tactical asset allocation strategies (including Franklin’s PE fund) in future posts.
IDFC Dynamic Equity Fund seems to be a better bet than DSP BR Dynamic Asset Allocation Fund (which in my opinion is a dud. The yield gap strategy it follows is too conservative and will lose out during bull runs).
IDEF’s strategy appears to be much better in this regard. Unlike the DSP BR fund (which is a fund of fund) this is an ‘active’ index fund!
Franklin’s PE fund has a decent track record and it will be interesting to see how IDEF compares with it down the line.
Existing equity mf investors can give this fund a miss. For first time investors, this could be a suitable entry fund, provided they do not mindlessly buy other funds down the line.
It is frustrating to see individuals having difficulty in choosing insurance policies – be it life, health or accident insurance. Their minds are cluttered with so many product features (some necessary and others not so) that they keep delaying the purchase.
Here is a step-by-step guide to purchasing a health insurance policy. I am no expert on the subject. I am writing this partly from experience (3 claims + handling multiple hospitalizations) and partly from online information accrued over the last few years.
I wrote a version of this post some months back, but did not feel enthused to post. After Jignesh Acharya suggested I write about this in, facebook Asan Ideas for Wealth (AIFW), I would like to give it another shot.
First let us decide on the type of product.
Floater or individual plans?
Choose individual plans for all members if you can afford it. Each persons risk profile is different and there could be multiple hospitalizations in a year. Most insurers fix the premium based on the oldest person in the group. Steer clear of this and get individual plans.
For senior citizens individual plan is mandatory. Get the same for younger members if you can afford it, after all there are tax benefits!
Now let us ask,
What are the essential features of an ideal health insurance policy?
1) No sub-limits on room rent and ICU.
Sub-limits can be a pain if the room rent is quite steep (typically in North India and not in South India as learnt at AIFW). If the room rent even for a non-AC single room is quite high (a relative notion), having no sub-limits is crucial.
Everything in life is a trade-off. No sub-limits implies a higher premium.
If the room-rents are nominal (several hospitals in Chennai), I would recommend a policy with sub-limits, typically sold by PSU companies – United India, New India and Oriental Insurance Cos.
Get a policy for a sum insured as high as possible initially, and be sure to increase the sum insured as much as possible each year upon renewal. I have been doing this for the past 9 years. I have individual cover for self, wife, son and mother from United India.
2) No increase in premium if a claim is made (aka loading).
Thankfully IRDA has mandated that there should be no claim-based loading. See page 83 (last line) here (Nikhil Verma shared this at AIFW)
“The loading on renewals shall be in terms of increase or decrease of premiums offered for the entire portfolio and shall not be based on any individual claim experience”.
According to Nikhil, portfolio here refers to the entire client base. Two individuals of the same age cannot have different premiums based on their claim experience.
Trade off: Higher premium from the start!
Please cite the IRDA ruling and confirm with the insurer, NOT the agent.
Nikhil Verma shared the following policy wordings of L&T insurance
“Based on the experience of the Product, Premium, Terms and Conditions may be revised subject to prior approval of Insurance Regulatory and Development Authority. Such revision shall be intimated to you 3 months in advance with an option of renewal under any similar Policy being issued by us. However, benefits payable shall be subject to the terms contained in such other Policy. Individual Claims experience loading is not applicable under the Policy.”
ICICI Lombard also has a similar policy as confirmed by Nikhil.
3) No Co-payment
The insurer should not shift part of the claim expenses to the policy holder by pre-arrangement. Since no co-payment implies higher premium, it might be okay to accept co-payment in the case of very senior citizens.
4) Minimum exclusion period for pre-existing diseases
The minimum tenure that I have heard of is 2 years. The maximum is 4 years.
This is important for everyone, even those who do not have any diseases at the start of the policy. If a disease is diagnosed say, after 6 policy years, the additional sum insured (if any) will be eligible only after the exclusion period.
Trade off: again price!
5) Lifelong renewability
IRDA has mandated that all insurers should provide lifelong renewability (see pages 78 bottom para and page 79 first para in the above attachment)
So this is not an issue. Best to confirm with the insurer though.
6) Minimal Exclusions
Again obvious but difficult to compare one insurer with another. Read the exclusions list after making a short-list and check if any hereditary or existing condition is excluded.
Trade off: probably again price.
In my opinion, if a policy is satisfactory in the above six areas, it will make my short-list.
Now that we have covered the core of the policy, let us look at the window dressing.
Insurers reward policy holders if no claim arises by either offering a discount on the premium or by increasing the sum insured.
If the sum insured increases each year by 5% for every claim free year, it will also decrease by the same amount when a claim is made. See page 80 of above attachment. Please confirm with the the insurer.
The premium will typically increase up to 50% of the sum insured and no further.
For each claim-free year, there is a discount in the premium when the policy is renewed.
Which is better?
I prefer the no-claim discount. It is simpler. I have seen many people who do not increase the sum insured each year and rely only on the bonus from claim-free years.
It does not matter which you choose as long as you increase the sum insured by as much as possible each year.
What about the restore benefit that an insurer offers?
Read the fine print and write down a typical situation in which the restore benefit will be useful. If you think it is useful, shell out the extra premium. I don’t think much of it though.
Never buy a policy because pregnancy is covered. Dumb! Pay for happy (God willing) non-recurring visits to the hospital. Remember the tradeoff mentioned above.
Out-patient Cover, Dental Cover, Spectacles and other goodies
Read the fine print. Are you willing to change doctors that you knew for ages just to get this benefit?
So now how do we shortlist policies?
1. Check out hospitals near your neighbourhood for room rent rates and if they accept cashless. This will help you decide whether you need a policy with no sub-limits or not. Whether they accept cashless or not, start mobilizing funds for a medical emergency corpus. Never forget that cashless is a privilege that need not be granted.
2. Decide on your budget and on whether you are going to choose a floater policy or individual policy. You can use the premium calculator of any insurer to get an idea.
3. Sub-limits and budget should help filter out many policies.
4.Choose your poison.I prefer PSUs. No logic behind that. Just a deep-rooted mis-trust of privates, regulator or no regulator.
If you like privates, find out who owns the company and how old they are. I suggest choosing a player who is at least 10 years old.
5. A few years back policy comparison portals were user-friendly. Nowadays they are annoying to use and some do not list certain policies. Better to stay away.
6.How about buying via an intermediary like medimanage? If I want to buy fruit, I would like to pick and choose the fruits I need. I will not leave the choice to the fruit-seller.
What about their help during claim processing?
Overrated. Rules are simple and laid out clearly. If I don’t or won’t read rules, I don’t deserve insurance.
7. Once you single out 2-3 insurers, read their policy documents and compare features to single out your future insurer.
8. Now you will need to take a call. Insurance buying is all about taking a risk. It is however a much lower risk than not having any insurance. You need confidence to choose an insurer.
9. Never ask others about their claim experience or ask which is the best policy to buy. That is a one-way ticket to despair.
All this should be done over one weekend, within about 2-3 hours. The longer it takes, the more confusing it becomes.
This is one of my favorite Van Gogh painting. Not relevant to the post but I have been itching to include this for a very long time!
This is a guest post by Krishna Kishore who writes a refreshing blog on stock investing at tyroinvestor.com. He readily agreed to write this post, explaining the features of a stock screener, upon my request.
There are many stock screeners available online like the ones from Google Finance, Reuters, Equity master and paid services from Bloomberg as well. Out of them all, www.screener.in is one of the best and the one that I personally use and recommend because of its salient features.
But why to use it in the first place?
Okay, to understand that let me give you an example.
You got a “tip” from a very good investor. He is very bullish about the stock. Now you wanted to know about the company. What will you do?
Following are the steps!!
1) Open Moneycontrol.com and type the company’s name.
2) Check the company’s current market price.
3) Click on 3 months, 6 months, 1 year, 2 years to know how the company is doing from past few quarters.
4) Quickly check EPS, PE, Dividend yield, Price to Book etc.
5) Get an idea of the company’s performance (without even knowing what are the products & services that the company offers).
But Krishna, What is wrong in doing so?
Nothing wrong in it but you will be “Biased”. Being in so called “Bull Market”, this can be dangerous to our portfolio. Every stock will make new heights these days. Hence, your mind takes the shortcut to process this least available information to say whether this company is doing great, good, bad or ugly. You start your analysis with a biased mode. We are not sure why that stock went up/down. Is it because of any sectorial momentum, Tailwind or Headwind? No idea, but we will start thinking that the stock price has went up, so something good happened/going to happen to the company (Shortcut processing of information).
Recently I watched a movie called “Drishyam”. The tagline of the movies goes something like this “Visuals can be deceiving”.
This particular tagline with a small change can be aptly suited for markets. “Stock Prices can be deceiving”!!!
But, also at the same time, we do not have enough time on earth to go through Annual reports of each and every company to understand the financial health of it. (Remember in olden days, Ben Graham, Peter Lynch, Buffett and many other legends actually did so)
This is where Stock Screeners comes into picture to serve the purpose.
Stock Screeners gives the fundamental view of the company (not in-depth information) which will be very useful and enough to get an initial idea of its health condition.
As already said I prefer using www.screener.in and now let’s try to understand the functionalities of it.
This is my stock screener page and I am taking example of one of India’s most consistent compounder, “Pidilite Industries”!!!
(Please do register to access all the functionalities and type which ratios you want to have in your page under “Manage Quick Ratios” section)
1) From this screen shot, I can get the following info. (In order to understand a stock more than just looking at the price, you need to know about the terms stated in the above screen shot)
a) Market Capitalization: Market capitalization is calculated by multiplying a company’s shares outstanding by the current market price of one share. This is used to tell us the size of the company, what are the future prospects of the company to grow further at a good rate.
I highly recommend you to please go through the videos of 2 min each for better understanding for these terms. Fun Learning!!!
d) Price to Earnings ratio: This is one of the most important ratios to consider. Leaving the technical terms aside, this gives the “Confidence of the Investors on the Company”. High PE says, Investors are expecting the company to generate above average earnings for the longer period of times. Sometimes this confidence turns in “Over confidence” & if it happens welcome to the Bull Market.
Just to give you an example, during the time of Reliance Power IPO, the oversubscription of this went viral and people are ready to pay 5000 (Five thousand) PE for this company. This kind of ratios is highly unsustainable. If you ask me what PE is cheap and what PE is costly. These are mostly considered by Relative valuations and preferably from same sectors. (Read more about Reliance IPO here)
e) Dividend Yield: This is calculated by ratio between Annual Dividend per share to the current market price.
j) Price to Free Cash Flow: A valuation metric that compares a company’s market price to its level of annual free cash flow. This is similar to the valuation measure of price-to-cash flow but uses the stricter measure of free cash flow, which reduces operating cash flow by capital expenditures.
There are much more ratios that this Screener provides, but as I told you, for the initial analysis of a company, these is good enough to start.
2) Later, it provides an amazing screen which states the Pros and Cons of the company.
3) In this screen, it provides the information of Individual stock performance vis-a-vis Index along with the shareholding pattern.
Only one small issue is, here we will not know if any of the promoter holdings have been pledged or not. This is critical information in terms of analyzing a company. Promoter pledging is not a good sign while analyzing the current condition of the company.
4) Relative Valuation is very important for any company. This screen allows us to understand the financials of the company with respect to its peers.
5) As already discussed above, this particular section gives us the first glance of the company’s financials on Quarterly & Annual basis for both Standalone and Consolidated.
As you can see below that some of the terms below are in “BOLD” which states the importance of it. Let’s have a quick understanding of them:
Operating Profit:The profit earned from a firm’s normal core business operations. This value does not include any profit earned from the firm’s investments (such as earnings from firms in which the company has partial interest) and the effects of interest and taxes.
EBIDTA: EBITDA is essentially net income with interest, taxes, depreciation, and amortization added back to it, and can be used to analyze and compare profitability between companies and industries because it eliminates the effects of financing and accounting decisions.
Profit Before Tax: As the name suggests, it is a profitability measure that looks at a company’s profits before the company has to pay corporate income tax.
Net Income: This is Very Very critical number to look for in the company’s Income statement. Net income is calculated by taking revenues and adjusting for the cost of doing business, depreciation, interest, taxes and other expenses. The measure is also used to calculate earnings per share.
Let me take a moment and try to explain what is first 2 rows (Equity Share capital & Reserves) of any balance sheet tell us.
Example: Let’s say company ABC came up with an IPO and wanted to raise 10 crore rupees. It shares are prices at a band of 170-180 rupees with a Face value of 10 each. Total number of issuing shares is 1 Lac.
Working Capital: A measure of both a company’s efficiency and its short-term financial health.
Formula: Working capital = Current Assets – Current Liabilities
8) Cash Flow statement: Even though Cash flow statements are the critical ones to check where and how the money is flowing in & out. This gives info of Cash Flow from Operations (CFO), Cash Flow from Investments (CFI) & Cash flow from Financing (CFF)
Cash Flow from Operations: The amount of cash generated by a company’s normal business operations. Operating cash flow is important because it indicates whether a company is able to generate sufficient positive cash flow to maintain and grow its operations, or whether it may require external financing.
This section gives the information on recent activities like AGM, Corporate actions like Dividends, Splits. It also provides us with the latest information of Annual reports and credit ratings for the Debentures or Bonds issued by the company.
Also, another great feature of this is, this allows us to export all the above information into an Excel sheet. It takes all the data from www.bseindia.com.
You can also customize many things and create your own stock wish list.
Go & Explore the amazing stuff available at www.screener.in
Happy Learning & Investing
Do join me in thanking Krishna for a comprehensive review of a stock screener.
Nifty at 10000 in a year? Before the next budget? Pretty sure most of you must have seen such headlines somewhere. Here is a layman’s attempt at trying to figure out if these projections make any sense.
Nifty vs. EPS YoY Growth Rate
First let us look at the way in which Nifty earnings per share (EPS) has grown year on year (YoY). To calculate this, first the EPS is computed (closing price divided by index PE) and then the growth rate is rolled over 1 year intervals.
Notice that the EPS growth rate (right axis) has been quite range bound in the last 5 years. Looking at past growth rates during rallies, it seems to me that the rate at which Nifty has risen in the past 12 months is not as rapid as one would suggest. The rise is a sight for sore eyes, but one cannot trust sore eyes to make sound judgement.
Nifty EPS vs. Nifty PE
The nifty EPS (left axis) has pretty much increased at a steady pace of about 12% per year since Sep. 2002, barring the period during the 2008 crash and recovery. More on this here: State of the Markets – April 2014
So I think one can safely project it for the next 12 months, assuming the same rate of growth (red line).
The EPS on Sep. 16th 2014 is ~ 376.
Projected EPS on Sep. 16th 2015 is ~ 397. Let us make it an even 400.
This corresponds to an EPS growth rate of about 6%.
This is perhaps a little too conservative estimate, but let us run with it.
Now if the Nifty touches 10000 on 16th Sep. 2015 for the first time, the PE corresponding to an EPS of 400, will be 25.
Meaning: close to what experts would call, “extremely high valuations”.
Therefore, if the Nifty hits 10000 in the next 12 months with an annual EPS growth rate of less than 10%, the PE will become dangerously high. Meaning the so called ‘bull run’ will sooner or later come to crashing halt.
If the Nifty has to breach 10000, and stay there for a decent amount of time, the PE will have to be much lesser than 25.
If we assume the PE in a year to be about 22 with Nifty at 10000, the EPS has to be ~ 450.
This means that the EPS has to grow by 20% from what it is today (16th Sep.).
Since the EPS has grown only by 8% in the last year, I am not too optimistic that there would be such a sudden surge in growth.
The current PE is ~ 21 (10Y average ~ 18.9). So even if the Nifty is at 10000, the PE is likely to be much higher than 22 as assumed above.
Let us hope/pray that I am proved wrong and that the Nifty comfortably breaches 10000 in a year and heads further northward
If my financial goal is 15-plus years away, PPF is an obvious and pretty good choice for a debt instrument while tying to put together a diversified portfolio. ‘Which debt mutual fund should I choose for the same purpose, if my goal is less than 15 years away?’, is a question that is asked often enough.
I was quite astonished to see debt funds with high average maturity (typically medium and long-term gilt funds) had a 10 year CAGR comparable to liquid funds!
So why bother taking on volatility that does not pay? Why not be content with simple accrual type ultra-short term funds? As reader Deep pointed out in response to this graph, “no brainer to go for liquid funds as both credit risk and volatility risk are lowest”.
Let us now look at returns of all debt mutual funds categorized as per Value Research Online. The horizontal axis represents the number of mutual funds in each category and is not shown. Data is take from Value Research.
Last 10 year CAGR
Notice that liquid fund returns of all mutual funds are typically the same. So it does not matter which AMC you choose. What a relief! of course, this is just one data point. If we stare at rolling returns, there will be some variation (see below).
Clearly funds with low average maturity (liquid, ultra short-term and short-term) are less volatile across AMCs. Many comfortably best the Debt-Income (including dynamic bond funds), Gilt-Short-term and Gilt-Medium and Long-term categories.
7 year average CAGR
Here is the average of the rolling 7 year CAGR.
Note: It is unfair to include funds that hold bonds with maturity period greater than the duration over which we calculate returns. Therefore, when the duration is decreased the long-term funds lose relevance. However, I have included them in the graphs for an overall perspective.
Amusingly, this graph (and the ones to come) look similar to the 10Y return graph! The conclusions do not change!
5 year average CAGR
Average of the rolling 5 year CAGR.
Again, you can buy a liquid fund, liquid-plus fund or ultra short-term fund and relax!
3 year average CAGR
Average of the rolling 3 year CAGR.
The next time an ‘expert’ says, ‘match the average maturity of a debt fund with the duration of your financial goal’, Let us ignore them!
Let us now look at rolling returns of two funds: a long-term gilt fund and a liquid fund.
Long-term Gilt fund
Notice the progressive decrease in returns. The 15 year returns are steady but not spectacular. Considering the volatility and associated emotional stress, I don’t think they are good enough.
Perhaps since the economy is supposedly reviving as we speak, interest rates will fall and the gilts will shine again!
However, 10+ years is more than one market cycle. So what one gains when rate fall, one could lose when they rise again! I am no expert, but I am willing to wager that this is the reason long-term gilt funds, if held for a long time, fail to impress.
Liquid funds are not angels either! Their returns can vary quite a bit.
Please do not believe any ‘expert’ who says that liquid funds are better than fixed or recurring deposits. There is no guarantee that post-tax liquid fund returns would beat post-tax FD returns, irrespective of the duration. For ‘short time periods, liquid funds are suitable when the redemption date and amount are uncertain.
Many invest for their child’s future by opening minor accounts. That is they invest in the child’s name. Here is why I think this practice is unhealthy and offers no great monetary advantage in most cases.
This post is inspired by a thread on the subject at Facebook group, Asan Ideas for Wealth.
First, let us get the monetary aspects out of the way.
Investing in the child’s name while he/she is a minor (less than 18 years of age) has no tax benefits. Tax on interest income or capital gains will have to paid by the parent as per income clubbing rules.
Many invest in the hope that the tax liability passes onto the child once they turn 18 and not yet started earning.
This makes sense only if the child turns 18 before he/she graduates from school. Most kids finish school before they turn 18. Therefore, a major chunk of the money is likely to be redeemed before they turn 18.
In addition, if one had started investing in equity and debt mutual funds several years prior to school graduation, the tax liability would be minimal and more importantly the same irrespective of who pays the tax.
Either the long-term capital gain is not taxed (equity) or is taxed at a fixed rate with indexation (for debt funds as per current rules!).
Therefore, there is no great advantage in investing in the child’s name.
The tax liability is reduced only if the gain/interest income is taxed as per slab (eg. Fixed deposit), assuming the child starts earning at a lower slab than the parent does.
However, in the case of fixed deposits, tax on interest income is typically (not necessarily!) paid and declared each financial year. Therefore, for the most part of the investment tenure, the parent would be paying the tax.
Of course, anyone who understands the concept of a real return would stay away from fixed deposits.
What about investing in the child’s name for their marriage expenses? Nothing disadvantageous in this case from an operational point of view. Nothing spectacularly advantageous either, for the above reasons.
Why mixing finances? I would like to pay taxes on the gains I make with my money.
It is our duty to ensure our children pursue their dreams. We should allow them to perceive their calling when young, and fund their calling (either a college degree or seed capital for an enterprise) at the appropriate time.
Therefore, we need to invest enough time, affection, attention, and of course money to make this possible, all the while not ignoring our own retirement plans. A tough balancing act!
While from the parent’s point of view the duty is unconditional, it cannot be so from the point of view of the child.
That is the child can (if not should) expect financial support from parents provided,they have displayed enough evidence that they are worthy of such support.
I think as parents we must make this quite clear to them from an early age.
All well to say “I am interested in pursuing X/Y/Z degree”. That interest should be backed by effort, focus and a sense of purpose during school years.
The same goes for those who wish to become an entrepreneur with or without going to college.
If I do not see evidence of effort and a sense of purpose in my children, I will not blindly fund their future.
I did not say that I won’t fund their future, just that I will not do so unconditionally.
By investing for my child’s future in my name, I legally reserve that right over the accumulated corpus.
Trust and love are two different things. I love my son unconditionally. If he turns out be an axe murder, I will do what Mr. Brooks did in the movie, Mr. Brooks (read story here).
Trust in certain matters cannot be unconditional. I will not blindly fund a lazy bum. Especially one who shares my DNA.
Most parents believe that ‘good parenting’ would result in a ‘good’ child who will not disappoint them. Parenting with expectations is beyond naïve.
Also, some believe that investing in the child’s name is a good way of teaching them money management and making them feel responsible. I fail to see any logic such thought processes.
What factors should we consider before choosing a mutual fund or evaluating a mutual that we hold? Should we only look at star ratings? Should we consider only returns? Risk-adjusted returns perhaps? Should we track the actions of the fund manager? Should I understand the kind of stocks that he/she has picked or is likely to pick? Such questions drift past our minds from time to time.
In this post let us look at some quantitative and qualitative methods of analysing mutual funds. Obviously, we need both types of analysis before choosing a fund or evaluating a fund holding. The extent to which we use each type depends on our aptitude and experience.
We will also look at the bare minimum knowledge of each type necessary for the newbie investor or the typical retail investor.
Quantitative analysis is the study of easily accessible and perhaps tangible information associated with a mutual fund. This is most often the NAV history, which is compared with its benchmark history in several ways.
Quantitative analysis treats the mutual fund like a black box. Funds are clubbed together based on the market cap of the portfolio and relative performance is evaluated.
All star ratings fall under this category.
The style of investing (for e.g. Growth stocks or Value stocks – see below) is not explicitly taken into account in the analysis. However the fund categories take care of that to a certain extent. For example, large cap funds typically have majority of growth stocks in their portfolio.
We can say nothing about the future performance of the fund as we only use past data (NAV history).
We can however evaluate past performance in different ways:
Absolute volatility (standard deviation) and volatility relative to the benchmark (beta) (see this for more details)
Correlate NAV movement with benchmark movement (R-squared). For example, holding two funds with high R-squared wrt the same benchmark is diworsification.
There are many more methods, which we shall hopefully discuss in the future.
We pay so much attention to past performance because pedigree is important to us. We do not want to invest our money in an unknown fund.
Of course, it is important to keep in mind that good pedigree does not mean good performance in the future.
While quantitative methods help build investor confidence while choosing a fund, they are vital while evaluating a holding and for portfolio analysis.
If our portfolio return sudden changes (either positively or negatively), quantitative methods help us to locate the hero or culprit and more importantly, the extent of outperformance or underperformance, as the case maybe.
However, identifying and analyzing culprits (assuming heroes are not analyzed like in the current bull run!) is one thing. Exiting a fund or stopping investments based on this data is quite another.
One should not exit the fund unless we are clear about the investment strategy, the nature of stocks in the portfolio, the market outlook (and of course, when we need the money). The fund managers track record during a market cycle, and the AMCs pedigree in terms of strategy are also important.
Also, while choosing a fund, it is important to understand what kind of fund it is. What is the investment strategy. If an identical fund exists in the portfolio. Will the portfolio become more diversified if we buy this fund.
This is where qualitative analysis helps us make better decisions.
Qualitative analysis is the study of the internal machinery associated with a mutual fund. The nature of the portfolio. The type of stocks chosen. How often the fund manager makes changes. The overlap with the benchmark. What is the strategy of the fund? Has it remained true to its mandate. Has the stock-picking style changed with fund manager (or fund house after a take-over or merger!).The pedigree of fund house.
Both methods use mathematics. The word qualitative does not imply that math is not used!
For example, a fund is classified as a ‘growth fund’ or ‘value fund’ by studying the price-to-earnings (PE) and price-to-book (PB) ratios of the stocks in the portfolio.
Growth stocks are those which are expected to grow at a faster pace than the market. They belong to established companies. They typically have higher PE and PB ratios than value stocks. Value stocks are potential growth stocks. That is they are available at prices much lower than what investors think they are worth.
The simplest qualitative method an investor encounters is the classification of funds on the basis of market capitalization: large cap, mid/small-cap, multicap, large and mid-cap etc.
Within each category the nature of the stocks can be found out by looking the fund style box.
Morning Stars equity style box looks like this. Value Research online also has a similar style box.
Debt fund style boxes have interest rate sensitivity and credit quality instead of market cap and stock type.
Some investors believe they should hold 2/3 large cap funds and 2/3 small/mid-cap funds in the hope of reducing downside risk. This thinking is devoid of logic.
Not only might the funds have significant overlap of actual stocks, they would also have significant overlap in investment styles. So this is just diworsification. Keeping it simple when it comes to portfolio construction is vital to portfolio health (see below).
Many aspects of qualitative analysis require knowledge of the fund portfolio and its history.
The performance of the fund manager can be dissected in many ways. Was his/her success a result of intelligent decisions or luck? Which sectors in the portfolio resulted in the highest gains. Which sectors or stocks led to the biggest fall etc.
Here is a write up on the subject by those who run thefundoo.com. This analysis is available for premium subscribers (typically advisors) at thefundoo.com. Update: Fundoo CEO, Sharad Singh just announced in FB group, asan ideas for wealth that attribution analysis is also available free from today!
The extent of active management can be determined in various ways. While all of them are in terms of numbers, some require knowledge of the portfolio. Active Share is one such measure. I would therefore classify it as a qualitative method.
To quote investopedia,
Active Share is a measure of the percentage of stock holdings in a manager’s portfolio that differ from the benchmark index.
….managers with high Active Share outperform their benchmark indexes and that Active Share significantly predicts fund performance.
I am more of a quantitative person and don’t know more about qualitative methods. Hope to learn and write more on this in the future.
One of my personal finance influencers, Ramesh Mangal is partial to qualitative analysis. Anyone who has read his comments in the facebook group, Asan Ideas for Wealth will testify to that.
Vidya Bala of FundsIndia does a commendable job of balancing both approaches well. As long as one does not tinker with ones portfolio each time she reviews an NFO or makes changes to their ‘select funds’ list, one can learn much from her writings.
Value Research Online offers only quantitative analysis (star ratings). Morning Star India offers both: Star ratings and what they call analyst ratings.
The analyst ratings vary from Gold (best), Silver, Bronze, Neutral to Negative (worst).
The analyst rating is a qualitative analysis in which they evaluate the future potential for outperformance. More about this hereand here
Amusingly I once found a five star-rated fund with a negative analyst rating!
While an analyst rating should not be used in isolation, I will stick my neck out and say that I find it much more level-headed than star ratings.
When HDFC Top 200 and HDFC Equity was underperforming (relative to other funds), investors were all ready to quit them. Morning Star analyst ratings urged them to remain calm keep the faith.
When Reliance Growth underperformed, Morning Star analyst research pointed to a change in character of the fund (more large cap exposure possibly because of fund size). If I am not wrong, they downgraded the rating to neutral.
Such a negative review, combined with poor performance (see quantitative analysis here) is enough to exit the fund. NAV is just a number. It is irrelevant to me that funds NAV has climbed to 700.
Unfortunately, like star ratings, analyst ratings is not available for all funds. I am not happy with Morning Star in this regard. They seem to pick and choose funds that they want to qualitatively analyze.
What should a newbie investor or the typical retail investor do?
Obviously use both strategies. However, there is hardly any need to go in-depth either qualitatively or quantitatively.
If we keep it simple, either choose a single balanced fund or just one large-cap fund and one small/mid-cap fund or just one large and mid-cap fund, we do not have to worry about investing styles of the funds.
The pedigree of the fund house is important to an extent (Morning Stars analyst research of any fund from that fund house can be used for this). The tenure of the fund manager is also important. If a new fund manager has just taken over, should I choose the fund(?), is a reasonable question. Tough to answer though. Some funds are independent of fund managers. The fund house has a clear mandate and the manager usually follows this. Typically such managers are not stars. Some fund houses seem to rely on one person a little too much. Not sure if that is good or bad. Perhaps a star fund house is better than a star fund manager.
I think that should do for choosing a good fund or evaluating an existing holding. Believe me, it is easier that it appears.
Any prolonged underperformance must be taken seriously. Qualitative methods gain importance during such times since a decision (hold/buy/sell) will have to be taken.
Which is why it is always a good idea to collect the monthly portfolios of the funds that you hold and stare at them from time to time!
A little too much is made of the importance of investing in PPF before the 5th of the month. How important is this? What if I fail to invest before 5th for a few months? Should I beat myself up about it?
Final Maturity value if all the monthly investments are made before the 5th of the month: Rs. 45, 04, 384
Final Maturity value if all the monthly investments are made after the 5th of the month: Rs. 44, 73, 197
Difference: Rs. 31, 187
I hope you will agree with me that this difference of Rs. 31,18 7, to be realized after 15 years is trivial. The person who always invested before the 5th gained about 2.5 times the monthly investment compared to the person who always invested after the 5th.
Of course 44-45 Lakhs after 15 years is not a great achievement either, even if it is tax-free.
But then again, PPF fans are oblivious to such realities.
Investing once a year
There are those who believe that it is best to make PPF investments between April 1st -5th of each financial year. Let us find out how beneficial this is.
Maturity value if yearly investment of Rs. 1.5L is made before April 5th for 15 years: Rs. 46,75, 914
If monthly investments of Rs. 12,500 are made before the 5th of the month for 15 years, the maturity value (as seen above) is: Rs. 45, 04, 384
The difference is 1,71,529 . This is indeed significant.
However, how many members of the PPF fan club can afford to shell out Rs. 1.5 Lakhs in one shot?
They can always delay the opening of the account by a year, until they have enough to make annual investments and then ensure they invest once a year before April 5th. How practical would that be (wrt to the financial goal), is something that each person will have to decide.
Also, the delay of a year should be taken into account if someone wants to compare ‘benefits’.
Maturity value if yearly investment of Rs. 1.5L is made after April 5th for 15 years: Rs. 46,44, 726
Again, the difference between ‘before 5th’ and ‘after 5th’ yearly investments is only Rs. 31, 187
Bottom Line (for PPF fans)
Forget about the ‘before 5th’ vs. ‘after 5th’ nonsense. Invest what you can, when you can.
Bottom Line (for investors)
There is more to investing than tax-saving and EEE instruments. Invest according to an asset allocation suitable for financial goals. PPF can certainly be part of a portfolio with investments in line with the asset allocation.
Let us not forget that securing 8-9% growth over 15 years could well result in a negative real return!
The CafeMutual article pointed out that only one time period was considered by the ET correspondent and that dividends from the Sensex were ignored.
Therefore in order to disprove the ET article three different dividend yields were added to the Sensex CAGR of 9.15% to ensure it is higher than PPF.
Now everyone can rest easy. Equity is the better instrument! So why write another post on the subject?
Fair question. Let us begin by quoting some important lines from the ET article which seems to have escaped the attention of those who found it troubling.
“While this study is no suggestion that a PPF is a far better option than equities at all times, it just reinforces the fact that timing is critical in the capital market. Despite the recent rally, Sensex’s annualised return for a period of seven years is only 8.10%, if you have entered at the fag end of the previous rally (i.e., in August 2007).” “….retail investors who are entering the ring now need to be mindful of the fact that they may not get the kind of returns from equities as seen in the recent past. In some instances, it also doesn’t make much sense being a long-term investor in equities”
Amusingly, the Cafe Mutual article has the following to say:
“…. our attempt is not to prove that equity would always outperform PPF for periods as long as 20 years, since we have also presented only one data point. The idea is not to prove equity as superior to anything else, but to highlight the fact that if some part of the data is ignored (dividends) , a totally different picture may emerge. Equity is a risky asset class and hence one should not expect 100% guarantee of positive returns, whatever the period.”
Then it goes on to state, “PPF investment can beat Sensex returns over 20-year period – it can, but not this time…” (in the above mentioned period)
Now let us satisfy our curiosity by looking at all possible 20 year CAGR constructed out of Senex returns for all financial years from 1979-80. The period covered is different that considered above, but that should not make too much of a difference.
A notional 2% dividend was added. It does not matter though. I think it is safe to say that PPF has beat the Sensex over only one 20Y period (the one surrounded by a green rectangle).
So shall we rejoice? Rest easy and assume that our equity SIPs will definitely beat PPF returns? Shall we emphatically state that equity will beat returns from fixed income instruments?
Not so fast. Do so at your own peril.
Let us you will have to pick a stone, eyes closed, from a box containing black and white stones. Pick a white stone, you win. Pick a black stone you lose. History suggests that white stones were picked more often than black stones.
I cite this fact and persuade you to pick a stone. Will you pick with the confidence that you cannot lose because most people who have picked in the past have not lost?
Equity investing is not very different.
Notice the spread in the above returns. The maximum return (before dividends) is 20% and the minimum return is 7%.
So clearly the return depends on when the investment begins. It does not matter whether it is a lump sum or SIP. In equity investing, the sequence of returns determines the final returns. This is crudely referred to as ‘luck’ or ‘market timing’.
This is the main message of the ET article: returns depend on when you start investments. Sometimes one can beat PPF and sometimes not. Past performance is irrelevant.
If I were a mutual fund distributor, I will choose to ignore this fact. Since I am a retail investor, I cannot afford to ignore it.
The huge spread in returns observed in the past is the reason why equity investments must be regularly monitored and course-corrected.
It is beyond naive to assume that letting a SIP run in a mutual fund for years will get the job done.
Comparing a fixed income instrument with an unmonitored equity instrument serves only one purpose: It serves as a reminder that volatile instruments must be monitored!
Thanks to suggestions from Sundaram Anathakrishnan, Hemanth Chandra, Basavaraj Tonagatti and Deepak Rao the following changes have been incorporated.
1) The logic associated with withdrawal limits and loan availability has been checked and updated. They are now in sync with this resourcesent by Mr. Sundaram Anathakrishnan.
2) The user now has an option to input whether the investment was made before or after the 5th of the month. I forgot all about this earlier!
3) The user can now input the exact month in which the withdrawal is made
4) An extension tracker for a user who has extended the tenure by 5 years. Two extension blocks are covered.
Please check the sheets and let me know if there are errors and if any more features need to be included. I would like to thank Karthikeyan Chellappa for making the original calculator (included) from which the tracker was made. It would not have been possible without his effort.
The markets are on fire this year. For many, including me, this is the first bull market. We have all made phenomenal gains and hope the run will continue. However, between early Jun to early Aug 2014, the market went nowhere. All though relative to the long history of the market and relative to any long-term goal like retirement, this period is like a blink of the eye many were concerned!
When the markets moved northward after that they were worried about the ‘new highs’. Soon followed questions like, ‘should I continue investing?’, ‘can I start a SIP now?’, ‘should I book some profit?’, ‘should I rebalance now?’ etc.
If this is a bull market, we have been in one since the middle of 2012. If this is a bull market, I think it would serve us all well if we examined the previous bull run. Hopefully, this will prepare us better.
First let us start at a plot of the Nifty and it PE between 25th April 2003 to 14th Dec. 2007.
Notice the prominent dips as the market moved up. They were mini crashes as they occurred with a month. Investors who got scared and pulled out during these dips would not have benefited from the rest of the run.
Who could blame them? Have a look at the monthly gain or loss chart
During the bull run, the market moved up by about 10% each month on an average, but there were prominent losses. Over some months, the Nifty lost close to 10% (4 time), 20% (once) and 30%(once).
Now let us look at how the CAGR of a lump sum investment made at the start of the ‘bull run’ would have evolved.
From euphoric triple digit highs the CAGR sharply dropped to settle down around 50-60% range! With each prominent monthly loss, the CAGR dropped down noticeably.
The final CAGR at the end of the period was 56%.
This is how a SIP made during this period would have evolved.
Total investment: 1000 x 55 (months) = 55000
Total Value: 1,53,511
CAGR (final): 46%
This is how the CAGR evolved after each installment of the SIP
The initial high values observed are normal. CAGR becomes reliable only after 1 year.
Notice that at one point the CAGR dropped to 11%. Again with each prominent monthly loss, the CAGR dropped down noticeably.
A bull market is no joyride.
The market is likely to correct itself from time to time, consolidate and only then move up.
The corrections would be violent, leading to significant losses. Whether these losses or notional or real depends on the grit of the investor.
I will conclude with two relevant quotes:
“I’m not telling you it’s going to be easy – I’m telling you it’s going to be worth it.” ― Art Williams
“Fasten your seatbelts, it’s going to be a bumpy night” ― From the movie “All about Eve”
From time to time I would like to review mutual funds using Excel tools published. The main objective behind this exercise is to illustrate the mutual fund review process, showcase the utility of the Excel tools and provide alternative investment alternatives if relevant. If you like the funds reviewed, please consider their place in your portfolio before choosing them.
Fund Name: Franklin India Prima Plus (FIPP)
Type: “Primarily a large cap fund with some allocation to small / mid cap stocks”
Inception Date: 29 Sept 1994 (another Franklin fund approaching 20th anniversary!)
FIPP is investing for growth of capital primarily through a diversified portfolio of wealth creating companies across market capitalisation ranges. Wealth creating companies are defined as those, which have the potential to produce returns consistently in excess of their cost of capital. The ability to achieve this is derived from sustainable competitive advantages emanating from intellectual property rights, proprietary technologies, well known brands, sound business strategies, management quality and so on. The intrinsic value of these companies rises with time. The stock market sooner or later acknowledges their unique contribution and rewards investors in such companies.
Investment objective and policies
The investment objective of Prima Plus is to provide growth of capital plus regular dividend through a diversified portfolio of equities, fixed income securities and money market instruments. Asset allocation pattern
Under normal market circumstances, the investment range would be as follows:
The fund managers will follow an active investment strategy taking defensive/aggressive postures depending on opportunities available at various points in time. The scheme may enter into derivatives in line with the guidelines prescribed by SEBI from time to time. The scheme may take exposure in derivatives up to a maximum of 50% of its AUM. The exposure limit per scrip/instrument shall be to the extent permitted by the SEBI Regulation for the time being in force. These limits will be reviewed by the AMC from time to time. Trading in derivatives by the scheme shall be restricted to hedging and portfolio balancing purposes.
It must be clearly understood that the percentages stated above are only indicative and not absolute and that they can vary substantially depending upon the perception of the Investment Manager, the intention being at all times to seek to protect the interests of the Unit holders. The asset allocation pattern described above may alter from time to time on a short-term basis on defensive considerations, keeping in view market conditions, market opportunities, applicable regulations and political and economic factors. However, if the asset allocation pattern is to be altered for other reasons, as this is a fundamental attribute, the procedure outlined in the paragraph on fundamental attributes below, shall be followed.
Impression: FIPP appears to be an older cousin of Quantum long term equity both in terms of portfolio and investment style. Let us check its track record.
A score above 50% implies FIPP has done better than QLTE. Thus FIPP has outperformed QLTE in the last4 years. Before that QLTE has triumphed.
The returns comparison also paints a similar picture.
Fund A (FIPP) has better downside protection than Fund B (QLTE). This is the reason FIPP has a superior capture ratio.
If we go by the NAV movement, QLTE seems to be better than FIPP. However, the Ulcer index of FIPP is lower than QLTE. Especially during the 2008. crash. This implies that FIPP has better downside protection.
Franklin India Prima Plus is a terrific Large and Mid-cap fund. Instead of having separate larg-cap and mid/small-cap funds, one can consider holding just this fund. Due to its dynamic asset allocation strategy, it has the potential to offer better risk-adjusted returns.
A few years back, I took my entire M. Sc class to lunch. Don’t remember why. They probably coerced me into it! As someone who never eats outside, I was clueless about pricing and was trying to get a rough estimate as they wanted to go to a high-end place (relative to the campus cafeteria!). One of the students said, “Why worry sir! Just use your credit card. Swipe karo!” The student was no kid. He was about 22!
Is that how credit cards work?! You swipe and forget about it!? I ask because I don’t own one. Perhaps we should ask those who use credit cards for emergencies.
I think the need to get kids interested in money management cannot be overemphasised. Interested, not teach. You start teaching and they run away.
Here are a few thoughts on this subject. I am a father of a 4.5 year old. So let me not pretend to know much about parenting children above that age. That said, I am fairly convinced that the following would work.
1) Let them touch and feel money at an early age. Let them see it change hands. Let us try not to use credit or debit cards in their presence because they should feel a sense of loss when a purchase is made.
2) Sooner or later they are going to want something or the other. Be it a fancy tablet, mobile, i-pod, whatever, if we can’t afford it, let us say a firm ‘no’.
If we can afford it, let us ask our kids to research on similar products available for at least a week. They would need to first make a short-list, compare features, watch product reviews on youtube, check out the manuals, discuss it with us and then decide. Obviously this applies to big ticket purchases only. One need not research over a bar of chocolate (although it won’t hurt to do so!).
It has to be their call, but an informed one. The benefits of insisting on this early in their lives will show up when they are ready to plan for taxes and make their first investments.
If we succeed in this regard, we can declare ourselves victorious for all practical purposes.
They will teach themselves the importance of not making impulsive buys, of research for product features, of reading fine print etc.
If it is a big-ticket or affordable purchase, we can ask them to wait a few months while we save for it. Start an RD or invest in a liquid fund etc. If the kid is interested, we can ask him/her to use a goal planner and figure out the amount needed. They will need to worry about interest rates. They can search for this as well. We can push as much as they are willing to take it.
Even in this day and age of online spending and investing, this little guy has a special place in instilling discipline. 3) I am not a big fan of paying kids money for doing chores or even giving them pocket money.
Participating in household chores is mandatory for all family members and one cannot put a price tag to it.
As regards pocket money, I don’t think it helps in anyway. I think it is a bad idea to give kids some , ‘do whatever you want money’.
4) Budgetting should be a family activity. It was until a couple of years back in my family. When my kid grows up a bit, I should restart that. Kids should see (hopefully observe; they usually do) how the monthly income is segregated into different compartments (expenses, investments and liabilities). Hopefully, they might ask a nice question like, “why do you invest?”. Perhaps we should also throw in some light jargon like, investing, saving, wants, needs etc to get them curious.
5) What about investing? There is no flaming hurry to teach about equity, stocks, PPF etc. I think it is enough if the parents discuss investments in their presence.
6) The importance of giving is more important than spending or investing. We will need to regularly engage them and ourselves in charity events, donate to organisations, volunteer if possible.
We choose a type of instrument almost solely based on the kind of returns that it can yield. Thus, our expectation is governed by past history. While there is nothing wrong with this, past returns can vary quite a bit, and depends on the period chosen for evaluation.
While it is a good idea to base expectations on past history, only must also understand and appreciate the uncertainty associated with the expectation. The uncertainty will depend on the type of instrument and the duration of intended investment.
The standard deviation listed by mutual fund portals like Value Research, Money Control, Morning Star etc. are typically based on monthly/weekly returns. While they can be used to represent the expected volatility associated with an instrument, they are not an accurate representation of the volatility or the uncertainty associated with past returns and therefore with future returns.
1) consider past annual returns of an instrument,
2) calculate the arithmetic average (not CAGR which is the geometric average),
3) calculate the associated standard deviation of the annual return,
4) Assume the arithmetic average ~ the expected future return from the instrument, plus or minus the standard deviation.
An example might help:
Let us consider the annual returns of Kotak Liquid Fund (source Value Research online)
The arithmetic mean or average = 7.33%
The standard deviation is 1.91%
So if I wanted to invest in Kotak Liquid, I will expect a return of about 7% give or take 2% (1.91 is approximated to 2%)
That is I will expect a return from 7% -2 % = 5% to 7%+2% = 9%
Calculating standard deviation this way, gives me a better idea of the range over which returns have fluctuated in the past. Although past performance may not repeat in the future, I have a foot hold with respect to expectations.
According to VR online, the fund has a standard deviation of 0.26%. Since this is calculated with monthly/weekly returns, it does not help me much since I am interested in annual returns.
The value of 0.26% when compared with corresponding data of other debt fund categories gives me an idea of relative volatility.
The value of 1.91% calculated with annual returns gives me an idea of absolute volatility.
This is how the standard deviation calculated with monthly/weekly returns evolves with respect to the average maturity of all debt fund portfolios.
Notice that region inside the red rectangle (< 1% standard deviation and < 1 year maturity) is heavily populated. These are liquid funds, ultra-short term funds, short-term income and gilt funds.
If the standard deviation of annual returns is used instead (below), notice that most of the points are outside the red rectangle.
Thus, if we use the standard deviation of annual returns, we find that even liquid funds are quite volatile. That is their annual returns can vary by a significant amount.
Higher the average maturity, higher the standard deviation in both cases.
Amusingly the 10 year CAGR (geometric average) is 7.31%. Not very different from the arithmetic average.
The difference between the two averages is another measure of relative volatility. The difference will be zero for a fixed deposit. Higher the difference, higher the volatility.
When the difference between the arithmetic average and the CAGR is plotted versus the average maturity in years of all debt fund portfolios, this is how it looks like.
Notice that the difference between the arithmetic average and CAGR is negligibly small for average maturity periods less than 1 year. Beyond that duration, the difference rapidly increases. However, even for the longest maturity periods (long term gilt funds), the difference is less than 1%.
Therefore, the simpler arithmetic average of annual returns is a pretty good alternative for the CAGR and could be set as the average return one can expect from a debt mutual fund.
The same will not be true for equity funds due to their much high volatility. We will consider these in another post.
The relative volatility (difference between arithmetic mean and CAGR) shares an interesting relationship with the absolute volatility (standard deviation of the annual return).
Notice how smoothly the curve evolves for all debt mutual funds. The evolution is faster than a straight line. Thus, the difference between the arithmetic average of returns and CAGR becomes more prominent at higher standard deviations.
Finally, a look at the CAGR of all debt mutual funds 10 years or older. This would give us an idea while planning for goals.
That does not paint a pretty picture at all!. The long-term return of funds with high average maturity (eg. long-term gilt funds) is comparable to funds with low average maturity (eg. ultra-short funds, short-term funds or even liquid funds)!!
Thus, if one wishes to invest in funds with high average maturity, they should actively manage the fund. That is, they should shift gains (to equity, for example) when interest rates drop, or invest more when the interest rates rise. A ‘buy and hold’ strategy with such funds may not be beneficial.
7) Am I monitoring my net portfolio value and returns for each goal at least once a year? Do I know if I am on track wrt each goal and if not, have I determined the cause? If my goal is to build wealth, am I tracking the CAGR and taking steps to
10) Am I going to be a ‘buy and hold’ investor or am I going to use ‘tactical asset allocation’? If I am going to make tactical calls, have I decided on what basis am I going to act? PE ratio, PEG ratio, FearGreedIndex, GDP? How am I going to ascertain the ‘state of the market’?
Let me add one more which can be handled down the line.
11) Have I started thinking about an exit strategy for each goal?