How to calculate inflation adjusted future value in excel
How to Calculate Future Value Using Excel: 1. The process will be easiest if you use the spreadsheet as a table to keep track of the different variables and periods you'll need for your calculation. First, label the cells in column A as follows: A1 = the time period -- in this case, A1 = Months. How to: Calculate Inflation Adjustments in Excel. Posted by oregonaudits. To calculate a inflation adjustment, take your current year CPI (e.g. 237.952 for 2014). Then subtract the index value for the prior year (e.g. 198.7 for 2005). Divide the difference by the prior year index value and you get your adjustment.