Monday, August 8, 2016

How to Book Profits in Mutual Fund Growth or Dividend-Reinvestment Schemes SIP

Respected Readers, 

If you make a long term SIP in mutual fund growth or dividend reinvestment schemes and unfortunately the market is fall like 1992 2008 2013 2016, then most of your profit goes back and your portfolio value may down below your primary investment (principal investment). 
For example:- 
On 21 Jan 2013, 
Suppose you accumulated 1000 units of HDFC top 200 G mutual fund scheme, and your average buying price is 200 per unit, so your basic investment is 1000*200=INR 2,00,000 NAV of HDFC Top 200 Growth fund on 21 Jan 2013 was 234.759 So market value or value on NAV of your 1000 units was 1000*234.759=INR 2,34,759 
So on 21 Jan 2013, you are happy to see that you get INR 34759 Profit (17.37% Return) on your investment of INR 2,00,000.
Unfortunately, the market is fall and NAV of your mutual fund are also fall.
( For more details, please refer Chapter 24 of my book because I write this article give more insight on chapter 24 "How to Book Profits in Mutual Fund SIP" of my book "The Winning Theory in Stock Market"). 
So after this market fall as on 21 Aug 2013 NAV of HDFC Top 200 Growth fund was 187.204.
That time market value or NAV value of your units was:- 1000*187.204=1,87,204 
Now you lost all of your profit 34759 also lost your basic principal amount 12796 That time you worried that why not you sell your units on 21 Jan 2013. 
So I innovate a profit booking formula for mutual fund SIP. You read his method in chapter 24 of my book. 
Those who not buy my book, please refer this earlier article: - Sharegenius Formula of Mutual Fund Profit Booking 
As per this formula "When your total portfolio value grows 11% then book your 33% corpus and continue you’re SIP." 
Some of my followers still not understand this formula clearly and demand that I upload an excel sheet to clear this formula.
So I make an excel sheet of Last 5 Year 2000 per month SIP in HDFC Top 200 G Fund, In this excel sheet I show how you book your profits using my sharegenius formula download this sheet from this link:-
Now you may still argue that instead of profit booking if we continue to hold these units then we get more return if they compare profit booking of INR 22885.68 in above sheet.
So please remember:- 
1. Currently, the market is high, and when the market is correct then most of your notional profit also run away from your portfolio but if you book your profit 22885.68, then it never went in any situation. 
2. If we re-invest this total amount of INR 74576 (which we get through the selling of units see the last row in above excel sheet), then this amount also earn from bank FD or individual stocks. 
3. Finally, I have other revolutionary Idea that if you do not want to use this money INR 74576 which we get by selling of units. Then revert this formula and re-invest last profit booking again when your portfolio value down 11%. It means sell units when portfolio value rises 11% and reinvest this money when portfolio value down -11%. 
I make this excel sheet again with this reverse sharegenius formula, and you wonder that this time, our total profit is INR 41127.29 
Download this 2nd excel sheet here:- 
Please remember this formula is only for growth schemes and dividend re-investment plans, new readers, please read this article to understand that why I prefer dividend reinvestment instead of growth plans:- 
One other thing that If you want regular tax free income from mutual funds then use this formula:- 
Some of my followers have very suspicious nature, so they comment on my earlier posts and doubt on my historical NAV data. 
They think my data are wrong so this time, I provide the link where I download data of past NAV which I used in above excel sheet, You may also use this link to download past NAV history of any mutual fund scheme and check my theory in your mutual fund scheme:- https://www.personalfn.com/tools-and-resources/mutual-funds/nav-history.aspx 
Finally, This is your time to comments, better what you think about it? If you try different % in above sheet and better % ratio, then do not forget to share it in comments.

3 comments:

Admin said...

Sir ji namaste, TODAY I completed reading your book share bazaar me Safal kaise ho..
Chapter 24. Sip profit booking at 11%. I also read your blog today and study your excel sheet.. But sir my portfolio is above 11%. I have 5 mutual funds and profits of every funds are 24%,23%,15%,17%,9%. How to book profit in more than 11% sir. Please suggest sir, I hubble request you sir

Admin said...

Sir ji namaste, TODAY I completed reading your book share bazaar me Safal kaise ho..
Chapter 24. Sip profit booking at 11%. I also read your blog today and study your excel sheet.. But sir my portfolio is above 11%. I have 5 mutual funds and profits of every funds are 24%,23%,15%,17%,9%. How to book profit in more than 11% sir. Please suggest sir, I hubble request you sir

Admin said...

Sir ji, my portfolio has 5 funds and every fund grows more than 20%, is there is any way to book profit.. Please suggest sir thank

Matched Content