Utilize your financial knowledge, give your answer or opinion to the input question or subject . Answer format is not limited.

irr calculation on stock with dividends
I use the following method. For each stock I hold long term, I have an individual table which records dates, purchases, sales, returns of cash, dividends, and way at the bottom, current value of the holding. Since I am not taking the income, and reinvesting across the portfolio, and XIRR won't take that into account, I build an additional column where I 'gross up' the future value up to today() of that dividend by the portfolio average yield at the date the dividend is received. The grossing up formula is divi*(1+portfolio average return%)^((today-dividend date-suitable delay to reinvest)/365.25) This is equivalent to a complex XMIRR computation but much simpler, and produces very accurate views of return.  The 'weighted combined' XIRR calculated across all holdings then agrees very nearly with the overall portfolio XIRR. I have done this for very along time.  TR1933 Yes, 1933 is my year of birth and still re investing divis!