US: Updated Excel-Based Translation File V8.0

We have updated our CPI/PPI-to-PCE translation Excel file. This is version 8, which can be downloaded here. (Reminder, access to Macrobond is required).

This is a major update following the recent BEA revisions, and we strongly encourage you to contact us if you have any questions. In particular, please make sure to read the Readme tab carefully, as it contains important new instructions on how to use the file.

In this update, we have substantially revised our translation methodology, introducing new translations for Portfolio Management Fees, Software, and Legal Services. In addition, we have developed new models for Nonprofit Institutions Serving Households and Financial Services Furnished Without Payment.

Unfortunately, due to the complexity of the BEA’s methodology and compilation procedures, some of these models cannot be incorporated directly into the Excel translation file without making it excessively complicated. We have therefore also updated our dashboard, which now includes a dedicated PCE Translation section (Section 4) – see screenshot below. There, you will find three models covering Portfolio Management Fees, Nonprofit Institutions Serving Households, and Financial Services Furnished Without Payment, which can be used each month to determine the appropriate inputs for the current month’s translation. (Please, remember this when refreshing the Excel file on CPI or PPI day!).

Some of these models deliver an exceptionally strong in sample fit. For example, our new Portfolio Management Fees model has an R² of 0.98, indicating an almost perfect fit to the historical data. Overall, the accuracy of our translation has improved considerably, and for the latest month our estimates are now virtually identical to the published figures.

Naturally, this remains an ongoing project, and there are still some refinements to be made. Approximately 1% of the components in our translation are still imputed, although we expect to address these remaining gaps over the coming months. More generally, some PCE components remain difficult to model because the BEA provides relatively limited information about their compilation methodology, requiring us to reassess and refine our assumptions as new data become available.

Nevertheless, the updated file is now ready for use. Given the extent of the methodological changes, we once again encourage you to read the new instructions carefully and contact us before using the file if anything is unclear. We will be happy to provide any additional guidance.

You can also find the current translation, including the Excel file, on our website (see below).

Contact

Want something more tailored?

We provide tailored consulting on ad-hoc projects.