Microsoft Office Tutorials and References
In Depth Information
Case 12: The Brewery Index Calculation
THE BREWERY INDEX CALCULATION
Decision Support with Access and Excel
A regional stock exchange has a number of listed stocks from area breweries. The exchange wants to create
that tracks the performance of the brewery stocks. In this case, you will use Access and Excel to
create the index.
Review database and spreadsheet concepts discussed in class and in your textbook.
Complete any exercises that your instructor assigns.
Complete any parts of Tutorials B, C, and D that your instructor assigns, or refer to them as
Review file-saving procedures for Windows programs, as discussed in Tutorial C.
Refer to Tutorial E as necessary.
The New York Stock Exchange (NYSE) is not America’s only stock exchange. Other large U.S. cities are home
to stock exchanges of their own. Such exchanges generally list stocks of companies that are prominent in the
region. Your city is home to a regional stock exchange.
Beer and ale brewing is popular in your part of the country, and many small and medium-sized breweries
are based in the region. These companies have listed their common stocks on your city
s exchange, which
lets investors buy and sell shares in the listed stocks.
Frequently, the most common question of investors is whether stock values have gone up or down. Some
investors do not like to search the hundreds of listed stocks to find out. Therefore, the exchange needs an
index: a single number that describes the price movement for a group of stocks over a period of time.
Perhaps the best-known index is the NYSE’s Dow Jones Industrial index. “The Dow” captures the price
movement of shares of 30 large companies listed on the NYSE. The Standard & Poor
s 500 index performs
the same function for 500 important NYSE companies.
Your city’s regional exchange wants to create an index devoted to the price movement of its listed
brewery stocks, and you have been asked to help. First you must understand how this kind of index is calculated.
For example, consider the stock price data for three companies, as shown in Figure 12-1.
Example stock price data