Add Monthly CPI Index Rates

Owned by Nancy Cohn (Deactivated)
Last updated: Dec 11, 2023
2 min read

To add a monthly CPI index rate, you can add a variable rate in Reference Data Center. When you add a rate for the CPI, enter values for the fields shown in the following table.

Variable Rate Fields Used for Month CPI Index Rate

Variable Rate Fields Used for Month CPI Index Rate

Option

Description

Source Name

Defaults to Eagle PACE in the panel, but you should enter the variable rate source of the entity. 

Issue Name

Name of the CPI security.

Symbol

Symbol of the CPI security.

Security ID

ID of the CPI security.

Effective Date

CPI Index Date. This value should be the day of the month that corresponds to the rate (for example, if updating the rate for CPI-U for May, the Effective Date should be 5/1).

Variable Rate

Rate of the Monthly CPI Index.

Schedule Period Types

Index reset frequency (optional and for reporting only)

Add Monthly CPI Index Rate in Issue Viewer

If you use Issue Viewer, in the Add Variable Rate panel, you can add a monthly CPI index rate. Note that the source for the CPI-U rates should match the source on the entity record for the security that holds the TIPS bond. If the sources do not match, Eagle Accounting does not calculate the ILB Index Ratio.

To add the monthly CPI index rates:

  1. In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
    You see the Issue Viewer tool.

  2. Open Issue Variable Rates, and then click Add Variable Rate.
    You see the Add Variable Rate panel.

  3. In the Source Name field, enter the variable rate source of the entity.

  4. In the Asset ID Type field, enter the primary asset identifier type for the security, such as CUSIP, ISIN, and SEDOL.

  5. In the Asset ID field, enter the identifier of the CPI index security.

  6. In the Issue Name field, enter the name of the CPI index security.

  7. In the Effective Date field, enter the CPI index date.
    This value should be the day of the month that corresponds to the rate. For example, if you were updating the rate for the CPI-U for May, the effective date would be 5/1.

  8. In the Variable Rate field, enter the rate of the monthly CPI index.

  9. In the Schedule Period Types field, optionally specify the index reset frequency for reporting purposes.

  10. Click Submit.

The following figure shows how to add a rate for the CPI-U table using the Add Variable Rate panel.

Â