Type the Excel formula for CPI inflation with last year’s index in B5 and this year’s in B6.
Type the Excel formula for CPI inflation with last year’s index in B5 and this year’s in B6.
Answer
=B6/B5-1
New ÷ old − 1: 163.2 ÷ 158.4 − 1 = 0.0303. A fall in this rate is disinflation; a negative value is deflation.
OpenStax, Introduction to Business (CC BY 4.0) §1.4 — definitions shape only; Bigel, Introduction to Financial Analysis (CC BY 4.0) §13.4 — the Fisher note; every count, index and rate original