Question

In: Finance

You are provided with the following information on four stocks. Assume that the base year is...

You are provided with the following information on four stocks. Assume that the base year is Dec 2010 and all splits take place on this date. That is after close of trading on December 31, 2010. Stock A and B have a 2 for 1 split at the end of trading on December 31, 2010. Use this information to answer the questions listed below.

31-Dec-10

31-Dec-10

31-Dec-11

31-Dec-11

31-Dec-10

Dec-11

Split

Stock

Price

Shares

Price

Shares

MV

MV

A

$ 150.00

10,000

$ 50.00

20,000

$1,500,000

$1,000,000

2

B

$ 50.00

4,000

$ 35.00

8,000

$200,000

$280,000

2

C

$ 25.00

15,000

$ 30.00

15,000

$375,000

$450,000

1

D

$ 140.00

20,000

$ 130.00

20,000

$2,800,000

$2,600,000

1

  1. Calculate the rate of return on a price weighted average of the four stocks for the period December 31, 2010 to December 31, 2011. Remember to adjust for changes in the divisor.
  2. Calculate the rate of return on a market value weighted index of the four stocks for the period December 31, 2010 to December 31, 2011.
  3. Calculate the rate of return on an equally weighted index of the four stocks for the period December 31, 2010 to December 31,2011.

Solutions

Expert Solution

a) Rate of return based on price weighted average

In this rate of return based on prices, total price of all stocks is divided by number of stocks to find out average price and then return calculated over previous period.

Stock Price as on 31st Dec 2010 Price as on 31st Dec 2011 Return
Stock A            150               50 -67%
Stock B               50               35 -30%
Stock C               25               30 20%
Stock D            140            130 -7%
Total            365            245 -33%

Average price

& Rate of return

91.25 61.25 -33%

b) Rate of return based on Market Value

In this method, rate of return is based on Market value of Stocks as on different period and then return calculated over previous period.

Stock MV as on 31st Dec 2010 MV as on 31st Dec 2010 Return
Stock A          1,500,000          1,000,000 -33%
Stock B              200,000              280,000 40%
Stock C              375,000              450,000 20%
Stock D          2,800,000          2,600,000 -7%
Total Market Value Index          4,875,000          4,330,000
Index Return -11%

c) Rate of return based on equal weighted index

In equal weighted index Rate of return is simple arithmetical average of all returns.

Stock Price as on 31st Dec 2010 Price as on 31st Dec 2011 Return
Stock A            150               50 -67%
Stock B               50               35 -30%
Stock C               25               30 20%
Stock D            140            130 -7%
Rate of Return -84%

Related Solutions

Assume you are provided the following 3 types of information and for each case you are...
Assume you are provided the following 3 types of information and for each case you are assigned to calculate a 90% confidence interval around the sample mean. Answer the questions below based on the provided information. An airline wants to estimate the number of tickets sold for a daily flight between Los Angeles and New York. Suppose a sample of 40 flights gives a sample mean of 125.5  (Assume that the sample standard deviation is σ = 20.5 and the population...
You are given the following information concerning two stocks that make up an index. Assume the...
You are given the following information concerning two stocks that make up an index. Assume the value-weighted index level was 280.98 at the beginning of the year. What is the index level at the end of the year? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Price per Share Shares Outstanding Beginning of Year End of Year Kirk, Inc. 40,000 $ 64 $ 70 Picard Co. 35,500 114 122 Index level
A property owner has provided you with the following information. Assume the owner has no other...
A property owner has provided you with the following information. Assume the owner has no other assets or liabilities. The annual gross revenue is $3,275,000. The debt service payment on the loan is $147,000 per month. The capitalization rate is 8%. Assets: Cash $ 1,000,000 Land 1,500,000 Building 29,500,000 Total Assets $ 32,000,000 Liabilities & Equity: Nonrecourse Liabilities $ 25,000,000 Partner’s Capital 7,000,000 Total Liabilities & Capital $ 32,000,000 14. What is the property’s NOI? Calculate the Debt Service Coverage...
Consider the following information about stocks I and II. Assume both stocks are correctly priced. The...
Consider the following information about stocks I and II. Assume both stocks are correctly priced. The market risk premium is 7.5 percent, and the risk-free rate is 4 percent. Rate of return if state occurs State of the economy Probability of state of the economy Stock I Stock II Recession 0.15 0.11 -0.25 Normal 0.55 0.18 0.11 Irrational exuberance 0.30 0.08 0.31 a) Compute the systematic risk and total risk for each of the two stocks. b) From the perspective...
Consider the following information.                      2010 (base year)             &n
Consider the following information.                      2010 (base year)                            2011               Price     Quantity                    Price     Quantity Car           $100       400                      $120       420 Rice          $25       2,000                       $36     2,005                       2012                  Price     Quantity Car              $130      450 Rice              $38    2,100 Compute nominal GDP, real GDP, and the GDP deflator for each year, using 2010 as the base year. Compute the percentage change in nominal GDP, real GDP, and the GDP deflator in 2011 and 2012 from the preceding year. Did economic well-being rise more in...
QUESTION FOUR You have been provided with the following information for a small private company, Formosa...
QUESTION FOUR You have been provided with the following information for a small private company, Formosa Pty Ltd, whose competitors are predominately large public companies. 2017 2018 2019 Industry average 2019 Net profit margin 8.2% 7.5% 6.8% 8.0% Return on equity 13.1% 12.3% 11.1% 13.5% Current ratio 1.8 2.1 2.4 2.0 Quick ratio 1.2 1.1 0.9 1.2 Receivables turnover 12.2 12.6 13.0 13.0 Inventory turnover 4.7 4.5 4.2 4.8 REQUIRED: Comment on the trend of each of the six ratios...
You are provided with the following information related to class 8 assets for the current​ year:...
You are provided with the following information related to class 8 assets for the current​ year: Undepreciated Capital Cost​ (UCC) Beginning​ Balance: $82,000 Cost of​ additions: ​$2,000 Dispositions​ (i.e. reduction for​ disposals): $15,000 The class 8 rate is​ 20%. Using only this​ information, what is the maximum capital cost allowance​ (CCA) deduction for the current year for class​ 8?
Assume that a market comprises four stocks: Monash, Deakin, La Trobe and Flinders. Current information about...
Assume that a market comprises four stocks: Monash, Deakin, La Trobe and Flinders. Current information about each of these stocks is provided in the table below: Monash Deakin La Trobe Flinders Price at time t $20 $12 $8 $6 Number of Shares on Issue (mill) 1500 800 600 400 Market Capitalisation ($ mill) $30,000 $9,600 $4,800 $2,400 Price at time t+1 $21 $13 $6 $6 You are developing a new index fund with $2 million to invest. Calculate the number...
The Foxboro Manufacturing Company provided you with the following information for the fiscal year end December...
The Foxboro Manufacturing Company provided you with the following information for the fiscal year end December 31 Work-in-process inventory, 12/31 57,900 Finished goods inventory, 1/1 307,400 Direct labor costs incurred 1,004,300 Manufacturing overhead costs 2,693,400 Direct materials inventory, 1/1 250,800 Finished goods inventory, 12/31 511,000 Direct materials purchased 1,750,200 Work-in-process inventory, 1/1 101,000 Direct materials inventory, 12/31 169,400 A) Compute the total manufacturing costs incurred during the year. B) Compute the total work-in-process during the year. C) Compute cost of...
Create a portfolio using the four stocks and information below:
Create a portfolio using the four stocks and information below: (Do not round intermediate calculations. Record your answers in decimal form and round your answers to 4 decimal places. Ex. X.XXXX)What is the variance of A?What is the variance of B?What is the variance of C?What is the variance of D?What is the Correlation (A,A)?What is the Correlation (B,B)?What is the Correlation (C,C)?What is the Correlation (D,D)?What is the Covariance (A,A)?What is the Covariance (A,B)?What is the Covariance (A,C)?What is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT