:: Subscribe to our newsletter
 
Articles / Directory
06/17/2013
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



06/17/2013
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



09/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



09/08/2007
Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.



1/02/2009
Launch of NeuralCode(v1.0) for
Neural Networks Trading.



Free Inflation Calculator

When people talk about the effects of their money getting smaller over time, they are talking about the effects of inflation. The question is of course, why our money gets smaller. Economists offer several schools of thoughts. For example, if a country prints more money to solve problems in a time of crisis, the supply of money will go up. This in turn will lead to the money becoming smaller. Another reason could be the production costs of goods and services have gone up, this will also lead to our money being smaller. We know that inflation causes our money to become smaller over time, which is one of the reasons that people put money in the bank to earn interests to counter the effects of inflation.

The impact of inflation on financial modeling

In financial modeling, there are typically discussions on the nominal value versus the real value of something. The real value of something basically takes into account the effects of inflation. For example, if you have $1000 today, what is the real value in 5 years time? The real value of the $1000 in 5 years time is to take into account the effects of the yearly inflation. We can use the Time Value of Money concepts to discount the $1000 using the inflation rate over a period of 5 years. This leads us to question what the inflation rate is and how do we calculate the inflation rate?

Consumer Price Index

Many countries periodically measure the average price of goods and services purchased by households. This data is in turn published on official government websites. This data allow us to calculate the rate of inflation.

Inflation

Inflation is defined as the rise in the general level of prices of goods and services purchased by households. Or in other words, it is a measure of the percent change in the consumer price index (CPI). For example, to measure the inflation in year 2008, we can ue the following formula:

(CPI at 2008 - CPI at 2007) / CPI at 2007



Inflation Calculator and Spreadsheet

The U.S. Department Of Labor (Bureau of Labor Statistics) published the Consumer Price Index (CPI) of United States periodically. This data can be used to calculate the inflation rate.

Calculating Monthly Inflation

The Inflation Calculator and Spreadsheet (InflationCalculator.xls) provided can be used to calculate the rate of inflation quickly and easily. By default the Inflation&CPI-Monthly worksheet already contains the monthly consumer price index from January 1913 to July 2009. The latest consumer price index can be keyed into the spreadsheet labelled “Consumer Price Index” to calculate the latest inflation.
Consumer Price Index input
The website to obtain updated data on consumer price index (CPI) is located at :

http://www.bls.gov

Inflation Calculation
The month to month inflation is calculated up to 3 decimal points and shown below.



Download Free Inflation Calculator - v1.0

System Requirements

Microsoft® Windows XP®, Microsoft® Windows Vista®, Windows 7 or Windows 8
Windows Server 2003, 2008, 2012
512 MB RAM
5 MB of Hard Disk space
Excel 2002, 2003, XP, 2007, 2010, 2013

License

By downloading this software from our web site, you agree to the terms of our license agreement.

Download

FreeInflationCalculator.zip (Zip Format - 81 KB)

Get the Professional version

Benefits
  • Unlocked
  • Allows removal of copyright message in the template
  • Allows commercial use within the company
  • Supports yearly inflation calculation
  • Performs nominal and real returns calculation based on the Fisher Effect
  • Full source code
Details PDF Specifications

Price

USD9.90 - Purchase








 

Copyright (c) 2007-2014, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners