Find the average daily market return (return for Al-Quds index)

Find the average daily return for BoP

Find the average daily return for PALTEL

Find the expected daily return for PEC

Find the standard deviation for OOREDOO

Find the standard deviation for PADICO

Find the coefficient of variation for AIG (calculate it as r/sd)

Find the coefficient of variation for APIC (using the formula r/sd)

Based on the SD, rank the following stocks from the least risky to the highest risk

Highest Risk

The second rank in the highest risk

Lowest Risk

The second rank in the lowest risk

Find Beta for APIC

Find beta for PALTEL

Find beta for PALTEL

The second rank in the lowest beta

Highest Beta

Lowest Bet

The second rank in highest beta

Explain the differences in ranking stocks according to the standard deviation (SD) and beta. This should entail explaining the different aspects that SD and beta measure, and why a stock that has the highest standard deviation might not have the highest beta.

Based on CAPM, and assuming a risk-free rate of 2% and a market return of 5.8%, what is the required return for PEC?

Using CAPM, and assuming a risk-free rate of 2% and a market return of 5.8%, what is the required return for PALTEL?

What is the dividend per share that PALTEL distributed for 2019?

Based on the zero-growth model, what is the intrinsic value of PALTEL stock?

Based on the zero-growth model and taking into consideration the current market price of PALTEL shares, is PALTEL overvalued or undervalued?

Select one:

a. Undervalued

b. Overvalued

Based on the zero-growth model and taking into consideration the current market price of PEC, is PEC stock overvalued or undervalued?

Select one:

a. Undervalued

b. Overvalued

Find the book value per share for OOREDOO (you must look for the required information in OOREDOO annual report for 2019)?

Based on the Book Value Per Share, is OOREDOO overvalued or undervalued?

Select one:

a. Overvalued

b. Undervalued

Using a P/E multiple approach and assuming an average P/E ratio for the investment industry of 12.94, what is PADICO intrinsic value?

Based on the P/E multiple approach, is PADICO overvalued or undervalued?

Select one:

a. Undervalued

b. Overvalued

Select at least two stocks you would not invest in based on the above analysis and their current market price

Please provide a satisfactory analysis (around 300 words) of why the above exercises are not sufficient to make a sound investment decision. The discussion may refer to deficiencies in the models utilized, unrealistic assumptions, theoretical shortcomings, etc. The mark depends on the depth of your analysis and your ability to address new knowledge that was not covered in class.

plz answer all this question plz hurry up

Calculate the data on Excel and find all the following data In a fast and clear manner and all data are complete just Enlarge image for illustration

X Microsoft Excel DSS1 3.7 1.79 0.9 3.75 3.77 3.77 3.78 3.8 3.8 3.8 1.4 1.41 1.4 B 473.62 475.88 476.3 478.89 476.17 475.21 474.77 473.91 474.55 473.77 472.14 472.9 472.56 473.95 563 2020/6/1 564 2020/6/2 565 2020/6/3 566 2020/6/4 567 2020/6/7 568 2020/6/8 569 2020/6/9 570 2020/6/10 571 2020/6/11 572 2020/6/14 573 2020/6/15 574 2020/6/16 575 2020/6/17 576 2020/6/18 577 578 579 1.79 1.85 1.83 1.83 1.84 1.82 1.82 1.82 1.81 1.81 1.8 0.84 0.82 0.84 0.84 0.82 0.83 0.82 0.83 0.83 0.81 0.81 0.81 0.83 0.83 H 0.28 0.28 0.28 0.29 0.29 0.29 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 2.45 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.45 2.46 2.46 2.46 0.89 0.87 0.87 0.84 0.85 0.86 0.84 0.85 0.85 0.86 1.4 1.4 3.8 3.8 3.79 1.4 1.39 X Microsoft Excel DSS1 3.7 1.79 0.9 3.75 3.77 3.77 3.78 3.8 3.8 3.8 1.4 1.41 1.4 B 473.62 475.88 476.3 478.89 476.17 475.21 474.77 473.91 474.55 473.77 472.14 472.9 472.56 473.95 563 2020/6/1 564 2020/6/2 565 2020/6/3 566 2020/6/4 567 2020/6/7 568 2020/6/8 569 2020/6/9 570 2020/6/10 571 2020/6/11 572 2020/6/14 573 2020/6/15 574 2020/6/16 575 2020/6/17 576 2020/6/18 577 578 579 1.79 1.85 1.83 1.83 1.84 1.82 1.82 1.82 1.81 1.81 1.8 0.84 0.82 0.84 0.84 0.82 0.83 0.82 0.83 0.83 0.81 0.81 0.81 0.83 0.83 H 0.28 0.28 0.28 0.29 0.29 0.29 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 2.45 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.46 2.45 2.46 2.46 2.46 0.89 0.87 0.87 0.84 0.85 0.86 0.84 0.85 0.85 0.86 1.4 1.4 3.8 3.8 3.79 1.4 1.39