Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

Add together all the cash flows you have put in the spreadsheet to calculate a total. Divide the total by the number of historical entries to calculate the mean average cash flow.