Excel Functions in EAC ToolsExcel Functions in EAC Tools\Regulatory limits and other functionsRegulatory limits and other functions\BLS functionsBLS functions\CCPIU

CCPIU

CCPIU returns the Chained Consumer Price Index for All Urban Consumers (C-CPI-U), as published monthly on the internet, and can be downloaded from the BLS web site via the “Special Menu”.

·        U.S. Bureau of Labor Statistics (U.S. city average, All items - SUUR0000SA0)

CCPI-U is used to annually adjust the 219(b)(5)(A) IRA Contribution Limit. For more information, see the following:

·        26 U.S. Code § 219 - Retirement savings.

·        Cost-of-living adjustment determined under section 1(f)(3).

Syntax

CCPIU (Year, [Month])

Parameter Name

Description

Year

Year: a 4 digit number. Or instead of entering a year, you can enter a date as “m/d/y”, and if you omit the Month parameter, then Year = “y”, Month = “m”, and “d” is ignored.

Month

Month as a number or a 3-letter abbreviation; or “annual”, “half1”, “half2”:

Mo

Description

"jan" or 1

 

"feb" or 2

 

"mar" or 3

 

"apr" or 4

 

"may" or 5

 

"jun" or 6

 

"jul" or 7

 

"aug" or 8

 

"sep" or 9

 

"oct" or 10

 

"nov" or 11

 

"dec" or 12