Using an Excel spreadsheet and the data listed below, calculate (i) the amount o

Question

Using an Excel spreadsheet and the data listed below, calculate (i) the amount of revenues per capita in constant dollars for each of the years 2013-2016, and (ii) the annual percentage change in the amount of revenues per capita expressed in constant dollars for each of the years 2014-2016. Please show formulas, I would like to learn the steps to this scenario. Thank you to anyone who can help.

                Revenues Per Capita

         year              (in current dollars) CPI

         2013                         $700                       110

         2014                         $750                      113

         2015                         $790                        118

         2016                         $820                      122

Explanation / Answer

amount of revenue in constant dollars:

2013: 700*100/110 = 636.36

2014: 750*100/113 = 663.72

2015: 790*100/118 = 669.49

2016: 820*100/122 = 672.13

b. % change

2013: not applicable

2014: 663.72/636.36 - 1 = 4.30%

2015: 669.49/663.72 -1 = 0.87%

2016: 672.13/669.49 - 1 = 0.39%

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.