About Storing CPI (Consumer Price Index) Rates
- Nancy Cohn (Deactivated)
The system stores the monthly index values used to measure inflation as variable rate records for the Index Security ID in the Variable Rates table, rather than storing them for the Inflation Linked Security Primary Asset Identifier. The values that are specified in Eagle Accounting are three-month trailing values for the CPI index. This means that the processing of a TIPS security in Eagle Accounting for the month of May uses the CPI-U data available in February.
Eagle Accounting calculates the daily CPI index rates based on the monthly values stored in the Variable Rate table. Calculation of the daily values is discussed later in this section. In Eagle Accounting, only the CPI value for the first day of each month is needed to perform this calculation. You should not enter the intermediate daily CPI rates because doing so can cause incorrect calculations in Eagle Accounting.
Use Reference Data Center to view the CPI rates entered in the table. Or if you use Issue Viewer, use the List Variable Rates panel to view the CPI rates entered in the table. The calculated daily CPI rates are also available for review in the income table and Cost object.Â
Monthly values for the United States CPI-U are available from the US Treasury Department:
This site contains the published CPI values (in PDF format) for every day since 6/1/98, broken down by month. Additionally, the PDF document contains the calculated daily CPI values for all of the active TIPS securities for that month.
Monthly values for the Canadian CPI are available at the Bank of Canada website:
Monthly Values for the French CPI is located at the following website:
Daily Mexican UDIS Rate is located on the following website: