- Two Companies Data Are Here I Apex Footwear Ltd And Ii Brac Bank Ltd Two Companies Stock Prices And Dividends 1 (148.22 KiB) Viewed 26 times
Two companies' data are here: (i) Apex Footwear Ltd. and (ii) BRAC Bank Ltd. Two companies' stock prices and dividends,
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Two companies' data are here: (i) Apex Footwear Ltd. and (ii) BRAC Bank Ltd. Two companies' stock prices and dividends,
Two companies' data are here: (i) Apex Footwear Ltd. and (ii) BRAC Bank Ltd. Two companies' stock prices and dividends, along with the Dhaka Stock Exchange (DSE) Index, are given here for the period 2016-2021. The DSE Index data are adjusted to include dividends. Data as given in the problem are shown in the following table (Note that the data here may mismatch with the original data of the companies.): In BDT Year Apex Footwear Ltd. BRAC Bank Ltd. Market Index Stock Price Dividend Stock Price Dividend Includes Divs. 2016 34.625 1.600 53.750 1.600 5,447.00 2017 31.375 2.766 52.500 2.300 4,524.28 2018 32.350 1.750 54.000 3.650 6,244.03 2019 31.400 1.540 51.750 4.550 8,192.98 2020 33.550 2.500 54.300 2.500 7,584.70 2021 31.250 1.600 55.750 2.500 9,650.98 Requirements: 1. Use the data given to calculate annual returns for Apex Footwear, Brac Bank, and the Market Index, and then calculate average returns over the five-year period. Hints: (i) Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the index. Also, you cannot calculate the rate of return for 2016 because you do not have 2015 data.) (ii) How to calculate average returns over the five-year period? Add the annual returns of every year and then divide by the number of years. Here you will get annual returns of five years. You will not get annual return of the year 2016, because you don't have the data of 2015. 2. Calculate the standard deviation of the returns for Apex Footwear, BRAC Bank, and the Market Index. Hints: 1. Use the sample standard deviation formula to get standard deviations for both Apex Footwear, Brac Bank. The formula is given below: Note: this can also be solved with the help of STDEV function in MS Excel. N Σ(α; – 3)? - S = N-1