Spreadsheet Problem: Growth Rates Oil prices have increased a great deal in the last decade. The following table shows the average oil price for each year since 1949. Many companies use oil products as a resource in their own business operations (like airline firms and manufacturers of plastic products). Managers of these firms will keep a close watch on how rising oil prices will impact their costs. The interest rate in the PV/FV equations can also be interpreted as a growth rate in sales, costs, profits, and so on (see Example 4-5 ).

a. Using the 1949 oil price and the 1969 oil price, compute the annual growth rate in oil prices during those 20 years.

b. Compute and compare the annual growth rate between 1969 and 1989 and between 1989 and 2020.

c. Given the average price of oil in 2020 and your computed growth rate between 1989 and 2020, compute the estimated future price of oil in 2023 and 2028.

Transcribed Image Text:

1 A B C D E Average Oil Prices LL F G H 2 3 Year per barrel Year per barrel Year per barrel Year per barrel 4 1949 $2.54 1969 $3.09 1989 $15.86 2009 $53.48 5 1950 $2.51 1970 $3.18 1990 $20.03 2010 $71.21 6 1951 $2.53 1971 $3.39 1991 $16.54 2011 $87.04 7 1952 $2.53 1972 $3.39 1992 $15.99 2012 $93.02 8 1953 $2.68 1973 $3.89 1993 $14.25 2013 $97.91 9 1954 $2.78 1974 $6.87 1994 $13.19 2014 $93.26 10 1955 $2.77 1975 $7.67 1995 $14.62 2015 $48.69 11 1956 $2.79 1976 $8.19 1996 $18.46 2016 $43.14 12 1957 $3.09 1977 $8.57 1997 $17.23 2017 $50.88 13 1958 $3.01 1978 $9.00 1998 $10.87 2018 $65.23 14 1959 $2.90 1979 $12.64 1999 $15.56 2019 $56.99 15 1960 $2.88 1980 $21.59 2000 $26.72 2020 $39.23 16 1961 $2.89 1981 $31.77 2001 $21.84 17 1962 $2.90 1982 $28.52 2002 $22.51 18 1963 $2.89 1983 $26.19 2003 $27.54 19 1964 $2.88 1984 $25.88 2004 $38.93 20 1965 $2.86 1985 $24.09 2005 $46.47 21 1966 $2.88 1986 $12.51 2006 $58.30 22 1967 $2.92 1987 $15.40 2007 $64.67 23 1968 $2.94 1988 $12.58 2008 $91.48