Jump to content
Sign in to follow this  
naomi

Adjusting for inflation in Excel

Recommended Posts

Is there a formula for that? Automatically puts it all into today's dollars?

Share this post


Link to post
Share on other sites

No idea how much this helps, as it's a lot of werds and I wasn't about to read them all, but it looks like it might include something that will at least give you a starting point. :ninja:

 

 

 

Link

Share this post


Link to post
Share on other sites

Adjust Numbers for Inflation

 

 

The Consumer Price Index is often used to adjust data for inflation. For example, say you had a monthly salary in 1991 of $5000. What was the equivalent salary in 2001? The CPI in 1991 was 136.2, and in 2001 it was 177.1. The ratio of these two numbers should match the ratio of the salaries in order to keep the buying power the same. Thus, we need to find the salary x such that

 

.

 

Solve this equation for x to find the monthly salary in 2001 equivalent to $5000 in 1991.

Your answer should be somewhat more than $6500. If you earn less than that, you are not keeping up with inflation -- your income on paper may look like it has increased by, say, 25%, but you cannot buy the goods and services you bought before. You need an increase of about 30% to keep up with inflation for this period.

 

The same information about equivalent salaries can be calculated on the Web site of the Bureau of Labor Statistics. Go to Inflation & Consumer Spending and Inflation Calculator.

 

 

 

There ya go. There's a chart in the link I sent you that has it for each of the years. So I suppose you can plug in that formula and it should work. :ninja:

Share this post


Link to post
Share on other sites

Hmmm, might be able to use that. Looks like I'll need to find the values for 99-08/09 since it's the span I have to compare with for each individual year. Was thinking there would be one formula that skips over needing to know the ratios, but I don't know if Excel is that sophisticated.

 

thanks :ninja:

Share this post


Link to post
Share on other sites
Hmmm, might be able to use that. Looks like I'll need to find the values for 99-08/09 since it's the span I have to compare with for each individual year. Was thinking there would be one formula that skips over needing to know the ratios, but I don't know if Excel is that sophisticated.

 

thanks :ninja:

Oh there probably is, I just wasn't about to read through all that math garbage to find out :doh:

Share this post


Link to post
Share on other sites
Oh there probably is, I just wasn't about to read through all that math garbage to find out :P

Not finding it through googling. My prof. gave my class a simple one for population-inflation adjusting. Now I just need to change a chart that's basically showing how much a department was funded through the 99-08/09 budget years.

 

Really hoping the ratio thing isn't the route that needs taking :doh:

 

I'll keep searching though. I was thinking maybe someone who uses Excel all the time would know off the top of their head.

Share this post


Link to post
Share on other sites
Check my link, copycat. <_<

:banana:

 

what link? :headbanger:

 

ETA: crap :wall:

Share this post


Link to post
Share on other sites
Why not just write your own? This is not a difficult question. Use your own inflation adjustment yr/yr. :rolleyes:

Not sure if you mean IN excel or just do the figuring. It's the state and federal funding for a government department over a 10 year period. The data was sent in Excel, so using the same spreadsheet to just automatically adjust all the figures to today's dollars would save a lot of time. 60 cells need adjusting...mass applying the calculation would be :headbanger:

Share this post


Link to post
Share on other sites

future $ / ((1+i)^y)

 

i = inflation

y = years

 

or opposite

$10,000 in 13 years @ 3% inflation = 10000*1.03^13 = $14,685.34

Share this post


Link to post
Share on other sites

Unless you include food and energy in the analysis the results are not valid, your measure will always be too low.

 

That is how the government has hidden true inflation from us for 25 years.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×