240 likes | 321 Views
CPI continued. Or … Cost of Living index continued. Graphing. Let’s say you make $100 every year for 10 years. Non Constant Dollar Graph. Non Constant vs. Constant Dollar.
E N D
CPI continued Or … Cost of Living index continued
Graphing Let’s say you make $100 every year for 10 years.
Non Constant vs. Constant Dollar • Since the value of the dollar decreased each year, this graph is not a realistic depiction of your salary over this period. • Nominal cost or Non constant dollar cost is represented • Constant dollar cost is not represented
Creating the Spreadsheet • Let’s say inflation brought the cost of living up 3% each year. • Is your $100 increasing or decreasing in value?
Creating the Spreadsheet • How might you represent the 3% inflation on the excel spreadsheet?
Creating the Spreadsheet Nice! We know that our $100 is decreasing in value, but can we see by how much?
To Constant Dollar 2010 Salary • To translate what our 2000 salary would be if it were transported to 2010…. • To see the relative salary in 2000 in terms of 2010dollars….
What if? • You got a 1% raise? • Non – Constant Dollar graph?
What if? • You got a 3% raise? • Non – Constant Dollar Graph? • Constant Dollar Graph?
What if? • 4% raise? • Non – Constant Dollar Graph? • Constant Dollar Graph?
Graphing Has electricity become more expensive?
To Constant Dollar 1997 Price • To translate what our 1986 Price would be if it were transported to 1997…. • To see the relative expense of electricity in 1986 in terms of 1997 dollars….
Scenario for Electricity • We saw what the graph looked like when the constant dollar price of Electricity went down relative to the cost of inflation. • What would the constant dollar graph look like if electricity increased at the same rate as inflation?