I am calculating Rolling IRR by using both the RATE and Harmonic Mean function in Excel. This method is assuming same cash flows at regular intervals. I got it from this thread here:viewtopic.php?p=5038754#p5038754
I am having Shiller's US Stock Market going back to 1871 and I use the method for calculating Rolling IRR on the "Real Total Return Price" Index that Shiller is having in his Excel sheet. Am I correct in that I am assuming constant inflation adjusted cash flows by doing so? Is this also correct method to calculate Rolling 15 Year Real IRR? Link to excel sheet if interested.
Thanks.
Creating 15 Year Rolling Real IRR
Creating 15 Year Rolling Real IRR
Land/Real Estate:89.4% (Land/RE is Inheritance which will be recieved in 10-20 years) Equities:7.6% Fixed Income:1.7% Gold:0.8% Cryptocurrency:0.5%