Inflation Calculator (Enhanced Version - 50 countries)
Originally published: 16/09/2020 16:31
Last version published: 03/03/2021 08:41
Publication number: ELQ-45839-3
View all versions & Certificate
certified

Inflation Calculator (Enhanced Version - 50 countries)

An Inflation Calculator in Microsoft Excel covering 50 countries.

Description
This enhanced and updated version of the model includes two calculators:
• year-on-year inflation calculator
• flat rate inflation calculator

The first one calculates the equivalent value of a specified amount in any year going back to 1960 (or earliest available date), based on the average annual CPI (Consumer Price Index) for the selected Country and the selected period.

Additionally, through the drop-down window, you can visualize either the average inflation rate or the cumulative inflation for the selected period. Moreover, the historical inflation rate for the desired period is provided in chart form.

The second one calculates future or backward inflation, based on the specified inflation rate for the selected period and amount. By default, the model selects the average inflation rate of the past 20 years, but it can be changed as needed.

Update of the inflation rates for future periods can be done through the ‘Master’ sheet, with the model allowing look-back for a maximum of 63 years (due to Excel formula constraints). This means that up to 2023 you’ll be able to visualize from 1960 to 2023, in 2024 from 1961 to 2024 and so on.

Editable version of the file is available upon request.

The 50 Countries covered include:
• Australia
• Austria
• Belgium
• Brazil
• Canada
• Chile
• China
• Cyprus
• Czech Republic
• Denmark
• Egypt
• Estonia
• Finland
• France
• Germany
• Great Britain
• Greece
• Hungary
• Iceland
• India
• Indonesia
• Ireland
• Israel
• Italy
• Japan
• Latvia
• Lithuania
• Luxembourg
• Malaysia
• Mexico
• The Netherlands
• New Zealand
• Norway
• Pakistan
• Poland
• Portugal
• Russia
• Saudi Arabia
• Singapore
• Slovakia
• Slovenia
• South Africa
• South Korea
• Spain
• Sweden
• Switzerland
• Thailand
• Turkey
• United Arab Emirates
• United States

This Best Practice includes
1 Excel Workbook

Domenico Cristarella offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Domenico Cristarella

See all
keyboard_arrow_leftkeyboard_arrow_right

Related categories


See all

Any questions on Inflation Calculator (Enhanced Version - 50 Countries)?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...