Universal Basic Income: Indexation and Inflation
Your real value column is wrong, but only slightly. You are decreasing it by 2% per year, but inflation of 2% doesn't cause real value to decrease by quite 2%. If there is 2% inflation, real value doesn't decrease by 2%; it decreases by 1 - 1/1.02 which is approximately 1.961% .

This is just the way percentages work. Since they are multiplicative, the inverse is different in magnitude:


If you lose 80% of an investment you have to gain 400% to break even. 
If you lose 50% of an investment you have to gain 100% to break even. 
If you lose 20% of an investment you have to gain 25% to break even. 
If you lose about 1.961% of an investment you have to gain 2% to break even. 


If you change your real value formula to =F6/(1+$F$4) you will get the correct values. You can also calculate the real value column by just calculating what portion of the buying power is left (1000/H26) and multiplying it by the nominal value: =1000*1000/H26. Both methods will give you the same result.