Overview

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, with max look back period of 62 years), 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 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 visualise 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

 

Reviews Add a review
No reviews yet

More From Domenico Cristarella

Browse our top rated business templates. See All
SIMPLE ASSET ALLOCATION MODEL
1,969
110
This simple model makes it easy to determine how to best structure your asset portfolio, allowing effective risk and volatility…
TRADING SYSTEM
3,785
155
This model is designed to support medium term traders who hold onto positions for days, weeks or even months. It is not intended…
ASSET PORTFOLIO REBALANCING TOOL
2,983
163
THIS TEMPLATE MAKES IT EASY TO PERFORM PORTFOLIO REBALANCING CALCULATIONS, IN ORDER TO DETERMINE QUANTITIES TO BE PURCHASED OR SOLD…
ASSETS CORRELATION MODEL
4,349
209
Achieve greater diversification in your asset allocation by using this tool to calculate the correlation coefficient between any two variables, including…
RENT VS. BUY CALCULATOR
4,094
251
The model compares the net value generated by buying a home vs. renting one, until mortgage pay-off, assuming availability of…
PREPAID EXPENSE & UNEARNED INCOME CALCULATOR
5,709
322
THE MODEL CALCULATES MONTHLY AMORTIZATION FOR PREPAID EXPENSES AND/OR UNEARNED INCOME, GENERATING RELEVANT ACCOUNTING ENTRIES. Prepaid expenses represent expenditures that have been…
See All