naomi 356 Posted April 15, 2008 Is there a formula for that? Automatically puts it all into today's dollars? Share this post Link to post Share on other sites
Me_2006 14 Posted April 15, 2008 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. Link Share this post Link to post Share on other sites
Me_2006 14 Posted April 15, 2008 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. Share this post Link to post Share on other sites
naomi 356 Posted April 15, 2008 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 Share this post Link to post Share on other sites
Me_2006 14 Posted April 15, 2008 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 Oh there probably is, I just wasn't about to read through all that math garbage to find out Share this post Link to post Share on other sites
naomi 356 Posted April 15, 2008 Oh there probably is, I just wasn't about to read through all that math garbage to find out 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 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
IndyTom 0 Posted April 15, 2008 http://mathdl.maa.org/mathDL/4/?pa=content...Id=506&pf=1 Share this post Link to post Share on other sites
Me_2006 14 Posted April 15, 2008 http://mathdl.maa.org/mathDL/4/?pa=content...Id=506&pf=1 Check my link, copycat. Share this post Link to post Share on other sites
IndyTom 0 Posted April 15, 2008 Check my link, copycat. what link? ETA: crap Share this post Link to post Share on other sites
Me_2006 14 Posted April 15, 2008 what link? ETA: crap Great minds. Share this post Link to post Share on other sites
Let Da Big Dog Eat 40 Posted April 15, 2008 Why not just write your own? This is not a difficult question. Use your own inflation adjustment yr/yr. Share this post Link to post Share on other sites
naomi 356 Posted April 15, 2008 Why not just write your own? This is not a difficult question. Use your own inflation adjustment yr/yr. 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 Share this post Link to post Share on other sites
Quickolas1 80 Posted April 15, 2008 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
RLLD 4,143 Posted April 15, 2008 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