Last Updated on August 30, 2021 at 3:24 pm
In this post, let us consider how to calculate returns from ‘dividend’ and ‘dividend reinvestment’ mutual funds.
This post represents an understanding of an issue which has always troubled me since the (first) manual version of mutual fund tracker (notice the frequent revisions).
I thought I finally had it right in the automated version, until Mr. Deepak Rao wrote in saying that the way dividends were handled for CAGR calculation in the tracker was wrong.
He was kind enough to share his understanding of how mutual fund dividends must be accounted for, and sent his account statements for me to work on.
Join 32,000+ readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! (Link takes you to our email sign-up form)
🔥Enjoy massive discounts on our robo-advisory tool & courses! 🔥
The following post and the subsequent corrections to the automated tracker would not have been possible without his efforts.
Unfortunately, the bad news is that existing users of the tracker who use dividend option mutual funds will have to download the new one from trackers main page.
I apologize for this inconvenience.
Now, on with the explanations. This article is based on the NCFM Advanced Mutual Fund Module. The study material referred for this post is from here (Chapter 6, section 6.1)
Warning: The following is some heavy stuff. If you don’t find the following arguments confusing at first, something is wrong with you!
If you are not interested in details, then please proceed to downloading the latest version of the automated mutual fund and financial goal tracker.
If you are interested in how stock dividends should be accounted for while calculating returns, see: Understanding the Nature of Stock Market Returns
If you are interested in this subject matter, you have no option but to read and re-read the following to obtain clarity. I will be delighted if you could take the trouble of reading this and share your thoughts in the comments section.
I Mutual Funds with ‘dividend’ payout option
In this case, fund houses offer dividends from time to time when they have enough to disburse. When a dividend is declared, the net asset value (NAV) decreases by an amount equal to the dividend rate – (typically few rupees per unit).
This lower NAV is known as Ex-dividend NAV
(Ex-dividend NAV + Div. Rate = Cum-Dividend NAV)
There are many ways of calculation returns from dividends, and there is enough confusion and debate on this. However, SEBI has mandated that dividends should be deemed as reinvested at ex-dividend NAV for calculating returns.
So we will just use this convention.
The essential idea is that, while calculating returns only the actions of the investor must be accounted for explicitly. A dividend is an action by the instrument and should only be accounted for implicitly.
Since my understanding is entirely based on the NCFM module, I will simply use the dates they use. The discussion here is however considerably different from the one there.
Let us consider the following example.
Consider the following actions taken by an investor
- Rs. 14,000 invested in a fund at a NAV of 14 on 15-Jan. 2011. Units: obtained: 1000
- On 01-Jul-2011, the fund declares a dividend on Rs. 2 per unit. Dividend received Rs. 2000
- On 10-Dec.-2011, the fund declares a dividend of Rs. 1.5 per unit. Dividend received Rs. 1500
- On 01-Feb-2012, The 1000 units are sold at a NAV of 14.85. Amount received Rs. 14,850.
How do we calculate the return for such a scenario?
Now, there are two ways to do this:
- Using Excels XIRR function
- Using the formula for CAGR
return = [total-value/investment]^(1/duration in years) -1
Let us start with the XIRR function.
Let us recall that dividends are assumed to be reinvested. So
- On 15-01-2011, investment of Rs. 14,000. Total units = 1000.
- On 01-07-2011, a dividend at the rate of Rs. 2 per unit was declared. So dividend = 2 x total units = 2 x 1000 = Rs. 2000
- This dividend is assumed to be reinvested at ex-dividend NAV of 12.5 (on 01-07-2011). Units ‘purchased’ = 160. Total units 1160
- On 10-12-2011, a dividend at the rate of Rs. 1.5 per unit was declared. So dividend = 1.5 x total units = 1.5 x 1160 = Rs. 1740 (this is entirely imaginary used only for calculating returns)
- This is the key step that eluded me previously. Any dividend should be calculated by assuming all past dividends are reinvested. This should reflect in the total units
- So this imaginary dividend of Rs. 1740 is assumed to be reinvested at ex-dividend NAV of 13.594 (on 10-12-2011). Units ‘purchased’ = 127.998. Total units = 1160 + 127.998 = 1287.998
- On 01-02-2012, these (imaginary) units were redeemed at a NAV of 14.85. So redemption amount is 19126.77
Implementation in Excel using XIRR
This can be a bit tricky. Dividends are assumed to be reinvested and this must reflect in the maturity value. However, a dividend is considered as an action by the instrument and not by the investor. Therefore such actions should be not explicitly included as part of the cash flow!
I know that sounds confusing! Join the club.
Here are two ways to implement this in Excel. Both will give you the same answer for the return = 34.74%
On the left, an additional cash flow entry is include – the value today. On the right this term is omitted.
Since all the units have been redeemed, whether you calculate returns today or as on 01- Feb-2012, the answer is the same, as it should be. This is the advantage of XIRR.
Implementation using CAGR
Here again, we assume that dividends are reinvested but do not explicitly include in as as cash flow entries.
We invested Rs. 14, 000 and we got Rs. 19,126.77, 382 days later
So using, CAGR = [total-value/investment]^(1/duration in years) -1
We get CAGR = [19126.77/14000]^(365/382) -1 = 34.74%
So we obtain the same answer as the XIRR function. Well, not quite! This is the return 382 days after investment. That is on 01-Feb-2012.
Try answering, what is return today (11 Apr 2014), that is after 1182 days after the investment?!
You will immediately agree that XIRR is a better and simpler choice! In any case, if the investor makes multiple purchases or redemptions, only XIRR can used.
Summary: For mutual funds with ‘dividend’ payout option, the dividends are assumed to be reinvested at ex-dividend NAV. Such ‘reinvestments’ must reflect in the ‘value’ of the investment. However, dividends are considered to be actions on part of the instrument and not the investor. Therefore, they should not be accounted for explicitly in the cash flow.
II Mutual Funds with ‘dividend reinvestment’ option
For such instruments, the dividends are actually reinvested by the investor on the dividend date at ex-dividend NAV!
So we have two actions here:
- The dividend: action by the instrument and to be taken into account implicitly as above
- The dividend reinvestment: action by the investor. This results in an actual increase in number of mutual fund units held. Therefore, this must be explicitly taken into account in the cash flow.
Consider the following actions taken by an investor
- Rs. 14,000 invested in a fund at a NAV of 14 on 15-Jan. 2011. Units obtained: 1000
- On 01-Jul-2011, the fund declares a dividend on Rs. 2 per unit. Dividend received = 2 x 1000 = Rs. 2000 as dividend.
- This is (actually) reinvested in the fund at ex-dividend NAV of 12.5. Units received: 160; Total number of units: 1160
- On 10-Dec.-2011, the fund declares a dividend of Rs. 1.5 per unit. Dividend received = 1.5 X 1160 = Rs. 1740 as dividend.
- This is (actually) reinvested in the fund at ex-dividend NAV of 13.594 Units received: 127.998; Total number of units: 1160 =127.998 =1287.998
- On 01-Feb-2012, All 1287.998 units are sold at a NAV of 14.85. Amount received = Rs. 19126.77
In this situation, there are 3 actual purchases. So the CAGR formula cannot be used. One will have to use only the XIRR function.
Here is how the above investor actions will be accounted for, when we set out to calculate returns (take a deep breath!)
- 15-Jan. 2011: Rs, 14,000 invested. Units obtained: 1000
- 01-Jul-2011: Dividend of Rs. 2 per unit declared. Dividend received: Rs. 2000
- This dividend is assumed to be reinvested on the same day at ex-dividend NAV of 12.5. Units ‘purchased’ = 160. Total units 1160.
- The dividend reinvestment done on the same day is an action by the investor leading to purchase of actual units. Therefore, this has to be explicitly accounted for.
- Dividend reinvestment: Rs. 2000 at NAV of 12.5. Actual units purchased = 160. Total units: 1160 + 160 = 1320.
- 10-12-2011: Dividend of Rs. 1.5 per unit declared. Dividend ‘received’: 1320 X 1.5 = 1980 (notice that this imaginary dividend is different from actual dividend of 1740).
- This dividend is assumed to be reinvested on the same day at ex-dividend NAV of 13.594. Units ‘purchased’ = 145.652. Total units: =1320 + 145.652 = 1465.652.
- Again the dividend reinvestment is an investor action. So we will have to use the real dividend value of 1740 for the investment
- Dividend reinvestment: Rs. 1740 at NAV of 13.594. Actual units purchased = 127.998. Total units: 1465.652. + 110.343 = 1593.650
- 01-02-2012: Since the investor redeemed all units, all the imaginary units are assumed to be redeemed at NAV of 14.85. Redemption amount: 23665.705
Again, here are two ways to implement this in Excel. Both give the same answer for the return = 36.84%
On the left, an additional cash flow entry is included – the value today. On the right this term is omitted.
Since all the units have been redeemed, whether you calculate returns today or as on 01- Feb-2012, the answer is the same, as it should be.
Summary: For mutual funds with ‘dividend reinvestment’ option, we will need to deal with dividends and dividend reinvestments separately.
- Dividends are actions by the instruments and are assumed to be reinvested. They are not explicitly taken into account as a cash flow entry
- The dividend reinvestment is an actual investment leading to an increase in the number of units held. So this has to be explicitly accounted for as a cash flow entry.
- Both dividends and dividend reinvestments must be taken into account for XIRR calculation.
This method of accounting for dividends and dividend reinvestments has been incorporated in the current version of the automated mutual fund and financial goal tracker.
I would appreciate your feedback on this post. If you are an expert and disagree with any of the above, please do spare a few moments to let me know your concerns.
Download the latest version of the automated mutual fund and financial goal tracker
🔥Enjoy massive discounts on our courses, robo-advisory tool and exclusive investor circle! 🔥& join our community of 7000+ users!
Use our Robo-advisory Tool for a start-to-finish financial plan! ⇐ More than 2,500 investors and advisors use this!
Track your mutual funds and stock investments with this Google Sheet!
We also publish monthly equity mutual funds, debt and hybrid mutual funds, index funds and ETF screeners and momentum, low-volatility stock screeners.
- Do you have a comment about the above article? Reach out to us on Twitter: @freefincal or @pattufreefincal
- Have a question? Subscribe to our newsletter using the form below.
- Hit 'reply' to any email from us! We do not offer personalized investment advice. We can write a detailed article without mentioning your name if you have a generic question.
Join 32,000+ readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! (Link takes you to our email sign-up form)
About The Author
Dr M. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. He has over ten years of experience publishing news analysis, research and financial product development. Connect with him via Twitter(X), Linkedin, or YouTube. Pattabiraman has co-authored three print books: (1) You can be rich too with goal-based investing (CNBC TV18) for DIY investors. (2) Gamechanger for young earners. (3) Chinchu Gets a Superpower! for kids. He has also written seven other free e-books on various money management topics. He is a patron and co-founder of “Fee-only India,” an organisation promoting unbiased, commission-free investment advice.Our flagship course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! ⇐ More than 3,000 investors and advisors are part of our exclusive community! Get clarity on how to plan for your goals and achieve the necessary corpus no matter the market condition is!! Watch the first lecture for free! One-time payment! No recurring fees! Life-long access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
Our new course! Increase your income by getting people to pay for your skills! ⇐ More than 700 salaried employees, entrepreneurs and financial advisors are part of our exclusive community! Learn how to get people to pay for your skills! Whether you are a professional or small business owner who wants more clients via online visibility or a salaried person wanting a side income or passive income, we will show you how to achieve this by showcasing your skills and building a community that trusts and pays you! (watch 1st lecture for free). One-time payment! No recurring fees! Life-long access to videos!
Our new book for kids: “Chinchu Gets a Superpower!” is now available!
Must-read book even for adults! This is something that every parent should teach their kids right from their young age. The importance of money management and decision making based on their wants and needs. Very nicely written in simple terms. - Arun.Buy the book: Chinchu gets a superpower for your child!
How to profit from content writing: Our new ebook is for those interested in getting side income via content writing. It is available at a 50% discount for Rs. 500 only!
Do you want to check if the market is overvalued or undervalued? Use our market valuation tool (it will work with any index!), or get the Tactical Buy/Sell timing tool!
We publish monthly mutual fund screeners and momentum, low-volatility stock screeners.
About freefincal & its content policy. Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on mutual funds, stocks, investing, retirement and personal finance developments. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than three million readers a year (5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified with credible and knowledgeable sources before publication. Freefincal does not publish paid articles, promotions, PR, satire or opinions without data. All opinions will be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
- Twitter @freefincal
- Subscribe to our YouTube Videos
- Posts feed via Feedburner.
Our publications
You Can Be Rich Too with Goal-Based Investing
Published by CNBC TV18, this book is meant to help you ask the right questions and seek the correct answers, and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now.Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want
This book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at a low cost! Get it or gift it to a young earner.Your Ultimate Guide to Travel
This is an in-depth dive into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, and how travelling slowly is better financially and psychologically, with links to the web pages and hand-holding at every step. Get the pdf for Rs 300 (instant download)