I'm looking for a formula that gives me an average unit price value that considers annual inflation. For example:
Inflation is 2%
Year 1, Unit Price is 100.00
Year 2, Unit Price is 102.00 { =100*1.02 } for an average unit price of 101 { =(100+(100*1.02))/2 }.
Year 3, Unit Price is 104.04 {...