Purchase Solution

Stock Market Index (using Polish stock prices)

Not what you're looking for?

Ask Custom Question

The accompanying table shows the complete history of stock prices on the Polish stock exchange for 9 weeks in 1991. At that time only 5 stocks were traded. Construct two market indexes, one using weights as calculated in the Dow Jones Industrial Average, the other using weights as calculated in the Standard and Poor's Composite
Index.

Prices (in zlotys) for the first 9 weeks' trading on the Warsaw Stock Exchange beginning in April 1991. There was one trading session per week. Only five stocks were listed in the first 9 weeks.

Stock
Tonsil Prochnik Krosno Exbud Kable
(Electronics) (Garments) (Glass) (Construction) (Electronics)
Week 1500 1500 2200 1000 1000
1 85 56 59.5 149 80
2 76.5 51 53.5 164 80
3 69 46 49 180 80
4 62.5 41.5 47 198 79.5
5 56.5 38 51.5 217 80
6 56 41.5 56.5 196 80
7 61.5 45.5 62 177 80
8 67.5 50 60 160 80.5
9 61 45.5 54 160 72.5

Use the MS Excel AVERAGE function to calculate the average price of stocks for the DJIA method and use the MS Excel SUM function to calculate the total market value for the S&P 500 method.

Dow Jones Method

Average % change Index
price in average (using
of stocks stock DJIA
Week in market price method)
1 FORMULA
2 FORMULA #DIV/0! FORMULA
3 FORMULA #DIV/0! FORMULA
4 FORMULA #DIV/0! FORMULA
5 FORMULA #DIV/0! FORMULA
6 FORMULA #DIV/0! FORMULA
7 FORMULA #DIV/0! FORMULA
8 FORMULA #DIV/0! FORMULA
9 FORMULA #DIV/0! FORMULA

S&P 500 Method

Total % change Index
Market in total using
Value of market S&P
Week Stocks value Method
1 FORMULA
2 FORMULA #DIV/0! FORMULA
3 FORMULA #DIV/0! FORMULA
4 FORMULA #DIV/0! FORMULA
5 FORMULA #DIV/0! FORMULA
6 FORMULA #DIV/0! FORMULA
7 FORMULA #DIV/0! FORMULA
8 FORMULA #DIV/0! FORMULA
9 FORMULA #DIV/0! FORMULA

Purchase this Solution
Solution Summary

Constructs two market indexes (for stock prices on the Polish stock exchange), one using weights as calculated in the Dow Jones Industrial Average, the other using weights as calculated in the Standard and Poor's Composite

Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

View More Free Quizzes
Related BrainMass Solutions

  • Indexes

    Construct a price-weighted market index using the three stocks, X, Y, and Z. What is the index's value on date 1? Price Weighted Index on date 1 = (16+5+24)/3=15 b. What is the price-weighted index's value on date 2?

  • Time-series plots and stock prices

    523461 Time-series plots and stock prices The S&P 500 Index tracks the overall movement of the stock market by considering the stock prices of 500 large corporations.

  • Analysis of Stock and Index Prices for Ross Stores

    344317 Analysis of Stock and Index Prices for Ross Stores I have been using Ross Stores, Inc. (ROST) for past projects.

  • What is an index

    Common examples of indices include: Stock Indices (average of stock prices that allows users and businesses to track how the market is performing) Dow Jones (an average of 30 stock prices), S&P 500 (an average of 500 stocks) Quantity Indices (

  • stock index futures

    Explain why stock index futures may reflect investor expectations about the market more quickly than stock prices. A stock index future takes the total average value of all of the stocks that make up that index at any point in time.

  • Thomson One Stock Analysis: does stock beta predict change in stock price

    Next, find each stock's percentage stock price change for the past year. Also, find the percentage change in the S&P 500 index (i.e., the proxy for the market index) for the past year.

  • Price weight; market efficiency; performance of stocks

    It shows how to calculate price weighted and value weighted index. It discusses concept of market efficiency. It shows how to describe the performance of stock. Using data of WMT, TGT, KR etc.

  • S & P 500 Stock Market Index

    45897 S & P 500 Stock Market Index If the S & P 500 Stock Market Index is 879 and declining, what does this mean? First we have to understand how the index is constructed.

  • Stock Market Index

    45806 Standard & Poor's 500 Stock Market Index Unfortunately, I do not know how Standard & Poor creates the stock market index. I do not know what would be a good index or a weak one.

View More Related Solutions