The chosen company is STC (Saudi Telecommunication Company)

4. Use Tadawul as a proxy for a well-diversified portfolio. Calculate the annualized historical market returns (including dividend yield) for the past 5 years. Calculate the historical Risk-Free rate based on 10-year or 5-year government bond rates for the past 5 years. Use a currently issued Government bond for the Rf (future). 5. Show all your work including any Excel sheets for your calculations. 6. You must calculate the Beta for the selected firm using Excel. (You will need the stock returns and total market returns for the past 5 years). 7. You may use published Betas for the sector companies but you must identify the source and provide the online web link. 8. Do not forget to account for the dividend yield when calculating individual stock returns and total market returns. 4. Use Tadawul as a proxy for a well-diversified portfolio. Calculate the annualized historical market returns (including dividend yield) for the past 5 years. Calculate the historical Risk-Free rate based on 10-year or 5-year government bond rates for the past 5 years. Use a currently issued Government bond for the Rf (future). 5. Show all your work including any Excel sheets for your calculations. 6. You must calculate the Beta for the selected firm using Excel. (You will need the stock returns and total market returns for the past 5 years). 7. You may use published Betas for the sector companies but you must identify the source and provide the online web link. 8. Do not forget to account for the dividend yield when calculating individual stock returns and total market returns