# Adjusting for inflation in Excel

### #1

Posted 14 April 2008 - 07:16 PM

### #2

Posted 14 April 2008 - 07:18 PM

HTH

2008 Geek Bored Football Pick'em Champion

### #4

Posted 14 April 2008 - 07:21 PM

*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.

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.

### #5

Posted 14 April 2008 - 07:32 PM

thanks

### #6

Posted 14 April 2008 - 07:36 PM

Oh there probably is, I just wasn't about to read through all that math garbage to find outHmmm, 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

### #7

Posted 14 April 2008 - 07:41 PM

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.Oh there probably is, I just wasn't about to read through all that math garbage to find out

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

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

### #8

Posted 14 April 2008 - 08:55 PM

### #10

Posted 14 April 2008 - 09:02 PM

Check my link, copycat.

what link?

ETA: crap

### #11

Posted 14 April 2008 - 09:05 PM

Great minds.what link?

ETA: crap

### #12

Posted 14 April 2008 - 11:45 PM

"We're all in this together, I'm pulling for ya." Red Green.

In dog years, I am dead.

### #13

Posted 15 April 2008 - 12:01 AM

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 beWhy not just write your own? This is not a difficult question. Use your own inflation adjustment yr/yr.

### #14

Posted 15 April 2008 - 12:27 AM

i = inflation

y = years

or opposite

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

### #15

Posted 15 April 2008 - 10:52 AM

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

The economy is running about as good as FFToday.com on a Sunday just before 1pm during football season.