Solved

Adjusting for inflation

Posted on 2015-02-17
6
76 Views
Last Modified: 2015-03-08
What are the calculations necessary to adjust a particular dollar value for inflation?

E.g. I have $A in today's dollars. 35 years from now, assuming inflation is 2.5%, that will be like having $X

And the reverse:

E.g. I anticipate that my investment portfolio will have a value of $B in 35 years. Assuming 2.5% inflation, that's $Y in today's dollars

Is it just as simple as X = A * (1.025^35), and Y = B / (1.025^35) ? Or is it more complicated than that?
0
Comment
Question by:Frosty555
6 Comments
 
LVL 84

Expert Comment

by:ozo
ID: 40615580
$X=$A*(1+2.5/100)^35
$B=$Y*(1+2.5/100)^35
0
 
LVL 4

Accepted Solution

by:
Brad Rubin earned 250 total points
ID: 40615616
You should be using finance calculations for both Future Value and Net Present values. These are prepackaged calculations in Excel. You can also find them in the Finance formula sections in the formula builder.

Example:
=FV(2.5%,35,0,-$A)
=PV(2.5%,35,0,-$B)
0
 
LVL 25

Assisted Solution

by:nickg5
nickg5 earned 250 total points
ID: 40616606
Inflation the last two years has been around 1.7 to 1.8%

There are simple compound interest calculators which take less time than maybe even opening Excel.

Here is one and I made up numbers:
$30,000 savings
30 years
compounded yearly at 2.5%
After 30 years your $30,000 would be $62,927.

You can change the numbers as you like.
http://www.csgnetwork.com/interestcomplexsavcalc.html

p
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 31

Author Comment

by:Frosty555
ID: 40622060
So you can treat inflation calculations the same way you would treat a compound interest calculation?
0
 
LVL 84

Expert Comment

by:ozo
ID: 40622289
Modulo whether percentage is reported as nominal APR, effective APR, APY, AER, and which index is used to measure inflation
0
 
LVL 25

Expert Comment

by:nickg5
ID: 40652913
Here is a great article on how to calculate inflation.
http://inflationdata.com/inflation/Inflation_Articles/CalculateInflation.asp

The rate of inflation that the U.S. government calculates decides the cost of living raises for retired people, etc.
Last year the rate was calculated to be 1.7%
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question