After studying the educational resources assigned in this module related to the analysis of risk and performance in companies, solve the following case study. It is recommended to use the Microsoft Excel application or a financial calculator to perform the calculations. It's important to include the procedure and briefly explain how you got each result.

Risk analysis and the search for performance in companies is decisive for financial success. In this case, consider the stock price and dividends of Power Electric Industries, Riviera Power Inc., and Nature Energy Corp. from 2014 to 2019.

	Power Electric Industries	Riviera Power Inc.	Nature Energy Corp.
Ao	Precio de las acciones	Dividendos	Precio de las acciones	Dividendos	Precio de las acciones	Dividendos
2019	$18.5	$1.50	$38.5	$4.50	$58.5	$3.50
2018	$15.93	$1.10	$40.93	$3.10	$50.93	$2.10
2017	$10.20	$1.00	$43.20	$3.00	$53.20	$3.00
2016	$9.80	$0.90	$50.80	$2.90	$50.80	$2.90
2015	$8.50	$0.85	$48.50	$2.85	$48.50	$2.75
2014	$8.00	$0.80	$45.00	$2.80	$45.00	$2.60

a. Consider company data to calculate annual rates of return.Determine the average return of each figure over the 5-year period. (You won't be able to calculate the 2014 rate of return, because you don't have data for 2013.) b. Calculates the standard deviation from the returns of Power Electric Industries, Riviera Power Inc., and Nature Energy Corp. You can use the Microsoft Excel application (STDEV) feature.

c. Calculates the coefficients of variation of the companies. d. Determines companies' Sharpe ratios from average returns and a risk-free rate of 4%. e.Produce a scatter plot showing the returns of Power Electric Industries and Rviera Power Inc. on the vertical axis and the returns of Nature Energy Corp. on the horizontal axis.

f.Calculates the percentage volatility (betas) of Power Electric Industries and Riviera Power Inc. by regressing from returns.Compare the results with those shown in the graph in the previous question.

g. It determines the percentage of volatility (beta) and performance of a portfolio composed of 40% of Power Electric Industries and 30% of Riviera Power Inc. and Nature Energy Corp., respectively.