A series of earthquakes were registered under Iceland's Katla volcano over the past couple of days. Judging by the depth of some of the earthquakes, fresh magma is making its way upward. There were more than 10 earthquakes in total, including M3.6 at 18:36 UTC on June 20, 2017, the strongest so far.
ââThinking that in a low-inflation environment is dreaming,â he said.â. Beyond that, the long-term data for the stock market points to that 7% number as well. For the period 1950 to 2009, if you adjust the S&P 500 for inflation and account for dividends, the average annual return comes out to exactly 7.0%. Check the data for yourself.
Then you could average those 14 annual returns in column D. I get 6.47% as an average annual return. Another way to do it is to Sum all 25 of your monthly returns and then divide the total by two and one twelfth (or 2.0833 or 25/12).=SUM(C1:C25) / (25/12) = 10.96%.Source(s):Cozmosis Â· 6 years ago.nswers. Best Answer: annual return can mean different things to different people. It could mean the return over any 12 month period (not necessarily Jan to Dec.). So if your Monthly percentages are in column C (C1 to C25), put this in D1 =SUM(C1:C12) Copy D1 and paste it in D2 to D14.