Figure 9.6 illustrates the Excel calculation procedure to calculate the required indices for the average annual oil price.

Transcribed Image Text:

EEEEEEEERRIN Example Figure 9.6 Year 1100 1101 1932 1963 1584 1905 1106 1907 1100 1909 1990 1991 1992 1993 1994 1995 1500 1997 1996 1900 2000 7091 2002 7003 2004 2005 2008 2007 2000 2100 2010 Average price ofon St $37.42 221.75 53185 $25.08 $28.75 $21.02 51444 $17.75 $1407 518 33 $23.19 $20.20 $16.25 $18.75 $15.66 $16.75 521 46 $1864 $11.91 $16.56 $27.39 $22.00 322 01 $27.68 $37.66 $50 04 553.30 58420 59140 553 40 $7121 $97.04 index Years 1860-101 100 85.54 85.16 77.71 76.83 71.94 30.19 47.43 39.74 48.98 51.97 53.95 51.44 44.76 41.35 44.76 5488 49.31 31.43 4425 73.70 61.46 60.96 74.00 10054 13373 165.20 171.57 244 47 142.32 190 30 232.60 Formulae HERESA 100. -C31/5054100 -C355054100 Index Year base 1992-100 194.39 10571 185.55 15106 14935 13004 75.31 9221 77.25 95.22 12047 104.94 100.00 67.31 81.35 07.01 105.29 96.13 61337 5613 14229 11948 11049 14384 19564 25995 20288 23351 475.22 277.02 169.92 45216 Fome CSCS100 -CIS/CS16-100 -C17/5C516-120 -C31/5C516100 C35/5516100