I am not sure about Valuerrsearch but I do it manually on my own
@govindarajanv can you please a template if you do have any ?
May be the below link can help you calculate returns on your own:
Please go through the entire file patiently once.
Best regards
First, let me congratulate you on amazing CAGR returns. This is what most of us only dream to achieve.
One minor issue, one post above this one, 1Yr return is -7.5 %; In this post it is 78%. Is there a typo? Do you mind sharing the current portfolio and current CAGR.
Hi Ferrari,
I guess what you are mentioning is my dividend per unit growth rate and the other one is my PF CAGR. My current PF CAGR has fallen to 22.3% CAGR over the period of 6Y9M and has undergone time correction. Cut off date for my DPU calculation is year end(Dec 13th) which happens to be my PF anniversary day.
I will post my PF in a few hours.
Regards,
Govind
1 Like
Below is my current PF.
| Stock | % Allocation |
|---|---|
| IDFC FIRST BANK LIMITED | 8.27% |
| CITY UNION BANK LTD | 8.03% |
| TORRENT PHARMACEUTICALS LTD | 7.35% |
| BAJAJ HOLDINGS & INVESTMENT LI | 6.20% |
| ESAB INDIA LTD | 6.05% |
| HDFC LIFE INSURANCE COM LTD | 5.75% |
| PIDILITE INDUSTRIES LTD | 5.32% |
| ITC LIMITED | 5.24% |
| BSE LIMITED | 4.16% |
| ORACLE FINANCIAL SERVICES SOFT | 4.15% |
| LUPIN LIMITED | 4.07% |
| TECH MAHINDRA LIMITED | 3.89% |
| GODREJ CONSUMER PRODUCTS LTD | 3.56% |
| SATLUJ JAL VIDYUT NIGAM LTD | 3.31% |
| GUJARAT MINERAL DEVELOPMENT CO | 3.03% |
| ACCELYA SOLUTIONS INDIA LTD | 2.53% |
| PTC INDIA LIMITED | 2.37% |
| VSTTILLERS TRACTORS LTD | 2.32% |
| ORIENTAL CARBON & CHEMICALS LT | 1.93% |
| SIEMENS LTD | 1.88% |
| EID PARRY (INDIA) LTD | 1.60% |
| KOVAI MEDICAL CENTER & HOSPITA | 1.31% |
| KMC SPECIALITY HOSPITALS INDIA | 1.24% |
| EIMCO ELECON INDIA LTD | 1.22% |
| RALLIS INDIA LTD | 1.08% |
| CARE RATINGS LIMITED | 1.08% |
| NMDC LIMITED | 1.06% |
| THYROCARE TECHNOLOGIES LIMITED | 0.96% |
| ADOR FONTECH LTD | 0.61% |
| COFFEE DAY ENTERPRISES LTD | 0.41% |
| Grand Total | 100.00% |
1 Like
Interestingly Dividend Per Unit also converges closer to my PF CAGR. I have projected my dividend cashflow based on the history (after excluding exceptional dividend payouts) as I am only in Sep 19 now and I will take into account all my dividend cashflow by end of the year to calculate my DPU
| Year | DPU | Sequential Growth% | CAGR |
|---|---|---|---|
| 2012 | 0.143 | ||
| 2013 | 0.226 | 58.04 | 58.04% |
| 2014 | 0.28 | 23.89 | 39.93% |
| 2015 | 0.296 | 5.71 | 27.44% |
| 2016 | 0.499 | 68.58 | 36.68% |
| 2017 | 0.417 | -16.43 | 23.87% |
| 2018 | 0.746 | 78.9 | 31.69% |
| 2019 | 0.56 | -25.07 | 21.50% |
Hi All,
It has been 7 years since I started this thread. Portfolio data and returns is more or less same if you look at my update on Sep 25, 2019
Here is the current portfolio which is my personal portfolio. I have started using my other demat account to build a microcap portfolio as the prices are very attractive but it will be more of a learning exercise than an investing exercise.
Wish you all advanced happy and prosperous investing year ahead.
1 Like
Hey! Have you churned the portfolio in the current fall? Would love to see how the portfolio has performed and maybe look at the updated weightages.
Cheers
Harsh
Thanks Harsh. I will share the updated portfolio and performance shortly. I had sold some low conviction bets and added a few.
1 Like
Current PF
| Stocks | % Allocation |
|---|---|
| TORRENT PHARMACEUTICALS LTD | 10.70% |
| ITC LIMITED | 7.38% |
| ORACLE FINANCIAL SERVICES SOFT | 5.54% |
| GODREJ CONSUMER PRODUCTS LTD | 4.84% |
| LUPIN LIMITED | 4.70% |
| PIDILITE INDUSTRIES LTD | 4.65% |
| IDFC FIRST BANK LIMITED | 4.59% |
| ALEMBIC PHARMACEUTICALS LIMITE | 4.55% |
| HCL TECHNOLOGIES LIMITED | 4.28% |
| HDFC LIFE INSURANCE COM LTD | 4.08% |
| ESAB INDIA LTD | 4.04% |
| CITY UNION BANK LTD | 3.56% |
| BAJAJ HOLDINGS & INVESTMENT LI | 3.39% |
| VSTTILLERS TRACTORS LTD | 3.31% |
| ACCELYA SOLUTIONS INDIA LTD | 3.28% |
| VEDANTA LIMITED | 3.14% |
| EID PARRY (INDIA) LTD | 2.95% |
| CARE RATINGS LIMITED | 2.74% |
| HDFC ASSET MANAGEMENT CO LTD | 2.35% |
| SIEMENS LTD | 2.07% |
| LAKSHMI MACHINE WORKS LIMITED | 1.94% |
| KMC SPECIALITY HOSPITALS INDIA | 1.92% |
| ORIENTAL CARBON & CHEMICALS LT | 1.78% |
| KOVAI MEDICAL CENTER & HOSPITA | 1.69% |
| RALLIS INDIA LTD | 1.56% |
| SATLUJ JAL VIDYUT NIGAM LTD | 1.51% |
| THYROCARE TECHNOLOGIES LIMITED | 1.14% |
| THE RAMCO CEMENTS LIMITED | 0.91% |
| MOTHERSON SUMI SYSTEMS LIMITED | 0.74% |
| INDIAN OIL CORPORATION LIMITED | 0.52% |
| COFFEE DAY ENTERPRISES LTD | 0.15% |
1 Like
Recent crash has brought down the CAGR a lot. Here is the latest figure.
CAGR since 13-Dec-2012
PF: 16.89%
I was comparing performance of funds for the given period from valueresearchonline.com which gave me 4 funds which have performed better than my PF.
https://www.valueresearchonline.com/funds/point-to-point-returns/primary-category/1/equity/?start-date=13-Dec-2012&end-date=18-May-2020&end-type=1&tab=snapshot
-
Motilal Oswal Nasdaq 100 ~ 23.08%
-
Franklin US Opp ~ 18.13%
-
SBI Small Cap ~ 17.74%
-
Mirae Asset Emerging Blue Chip ~ 17.36%
-
Nifty BeeS - 6.79%
-
Nifty Jr - 9.53%
1 Like
Contrary to my post on 19/May/20 post, the recent bounce back has lifted the CAGR a lot. Look like a pure luck to have a roaring market on my cut off date for updating this thread.
Here is the latest figure.
CAGR since 13-Dec-2012
PF: 20.75%
I was comparing performance of funds for the given period from valueresearchonline.com 1 which gave me 5 funds which have performed better than my PF.
https://www.valueresearchonline.com/funds/point-to-point-returns/primary-category/1/equity/?start-date=13-Dec-2012&end-date=18-May-2020&end-type=1&tab=snapshot 5
All of those funds are predominantly thematic. Mirae Asset Emerging bluechip can be considered to a certain extent a diversified fund (weight average marketcap is 82k crore
-
Motilal Oswal Nasdaq 100 ~ 25.52%
-
SBI Small Cap ~ 23.90%
-
Mirae Asset Emerging Blue Chip ~ 22.63%
-
ICICI Pru Technology - 21.67%
-
ABSL Digital India - 20.87%
My PF is a diversified multicap portfolio, comparing against diversified benchmark would make sense
-
Nifty BeeS - 12.2%
-
Nifty Jr - 13.16%
I have to complete 2 more years to see how well I fare as an investor spanning across multiple market cycles (even 10 years is also very short).
DPU Growth
Being a dividend growth investor myself, I regularly track how my PF fares with respect to dividend growth (which is a sort of EPS for me)
- My Dividend per unit (DPU) was 0.14 in 2012
- Current DPU stands at 0.7 implying a CAGR 21.96%
I have created a bluechip portfolio for my family and a microcap focussed small cap portfolio in Zerodha. The former is a buy and hold portfolio with blended approach aiming at buy and hold with relatively lesser chrun. The latter is for learning purpose and try out very active way of investing. These PFs are relatively small compared with my personal PF. May be these PFs if performing well over longer term would help me switch my investments from mutual funds to these PF based on goals and needs.
5 Likes
Sir Can you provide NAV based calculation on Google Sheet?
Its difficult for us to make it from scratch.