KThe following spreadsheet contains monthly returns for Cola Co. and Gas Co. for2013. Using these data, estimate the average monthly return and the volatility foreach stock. (Click on the following icon in order to copy its contents intoa spreadsheet.)The average monthly return for Cola Co. is% (Round to two decimal places)JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberCELLSMonthCola Co-0.20%-7.20%6.26%-7.10%1.60%-4.90%3.00%-2.70%0.00%10.50%4.90%Gas Co.0.30%-3.90%-3.70%4.90%-5.70%-4.60%0,70%-6.40%-0.90%10.20%-6.70%

Average monthly return is the mathematical average of all monthly returns given above.Rate of return…

The following spreadsheet contains monthly returns for Cola Co. and Gas Co, for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon in order to copy its contents into a spreadsheet) January February March April May June Judy August September October November Month Cola Co. -0.20% -7.20% 6.26% -7.10% 1.60% -4.90% 3.00% -2.70% 0.00% 10.50% 4.90% Gas Co. 0.30% -3.90% -3.70% 4.90% -5.70% -4.60% 0,70% -6.40% -0.90% 10.20% -6.70%

The following spreadsheet contains monthly returns for Cola Co. and Gas Co, for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon in order to copy its contents into a spreadsheet) January February March April May June Judy August September October November Month Cola Co. -0.20% -7.20% 6.26% -7.10% 1.60% -4.90% 3.00% -2.70% 0.00% 10.50% 4.90% Gas Co. 0.30% -3.90% -3.70% 4.90% -5.70% -4.60% 0,70% -6.40% -0.90% 10.20% -6.70%

International Financial Management

14th Edition

ISBN:9780357130698

Author:Madura

Publisher:Madura

Chapter13: Direct Foreign Investment

Section: Chapter Questions

Problem 1IEE

See similar textbooks

Similar questions

The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon in order to copy its contents into a spreadsheet.) Month January February March April May June July August September October November December The average monthly return for Cola Co. is%. (Round to two decimal places.) Cola Co. - 6.80% 7.40% -2.10% 4.30% 11.30% 1.40% 4.10% - 0.60% 0.80% 1.90% 0.70% - 2.90% Gas Co. - 3.00% - 7.70% 0.20% 3.10% - 1.00% 0.00% 4.80% - 3.80% - 5.80% 1.20% - 2.30% 4.70%
The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2013. Using these data, estimate the average monthly return and the volatility for each stock. (Click on the following icon in order to copy its contents into a spreadsheet.) Month January February March April May June July August September October November The average monthly return for Cola Co. is%. (Round to two decimal places.) Cola Co. -7.10% -2.10% -3.80% -4.10% 1.50% 1.20% -21.10% - 14.50% - 28.80% 22.90% -13.40% Gas Co. -8.10% -2.00% -2.60% -5.00% -4.70% -3.20% 6.70% -8.50% - 12.60% 16.50% -6.10%
Using the data in the table to the right, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid. (Click on the following icon in order to copy its contents into a spreadsheet.) Return for the entire period is %. (Round to two decimal places.) Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 Price $32.09 $30.63 $31.95 $31.34 $36.15 $40.39 Dividend $0.21 $0.18 $0.18 $0.21
Using Microsoft Office / Excel 365 STOCKHISTORY and FORECASTING functions available, prepare a line graph of the weekly share price history (from 1/7/2022 to 31/3/2024) for any two (2) listed companies that you have been allocated (separate graphs). Forecast the share price for the next 6 months (i.e ., 30/9/2024). Please note, graphs should also include a trendline and formula. Predicted weekly share price figures should be shown using the FORECAST SHEET function or FORECAST formula function available.
Using the data in the table to the right, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid (Click on the following icon in order to copy its contents into a spreadsheet.) Return for the entire period is 29 22 %. (Round to two decimal places.) Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 Price $33.57 $29.72 $29.95 $30.94 $36.07 $40.72 Dividend $0.18 $0.21 $0.18 $0.22 SEZON
The monthly rates of return for two corporations are given below:Month ABC Ltd. XYZ Ltd.January -.06 .09February .08 -.04March -.09 -.12April .14 .17May -.02 -.08June .05 .04Compute the following:a. Expected monthly rate of return [E(Ri)] for each stock. b. Standard deviation of returns for each stock. c. The covariance between the rates of return. d. The correlation coefficient between the rates of return.Considering the correlation coefficient, would these two stocks offer a good chance fordiversification? Why or why not?
The following table contains prices and dividends for a stock. All prices are after the dividend has been paid. If you bought the stock on January 1 and sold it on December 31, what is your realized return? Hint: Make sure to round all intermediate calculations to at least five decimal places. (Click on the following icon in order to copy its contents into a spreadsheet.) Jan 1 Mar 31 Jun 30 Sep 30 Dec 31 Price 10.09 11.09 10.59 11.19 11.09 Dividend 0.16 0.16 0.16 0.16 Your realized return is%. (Round to one decimal place.)
Using the data in the following table, E, calculate the return for investing in this stock from January 1 to December 31. Prices are after the dividend has been paid. The return for investing in this stock from January 1 to December 31 is ☐ %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Stock Price Dividend Jan 1 $49.96 Mar 31 $51.07 $0.59 Jun 30 $49.52 $0.58 Sep 30 $52.02 $0.77 Dec 31 $52.39 $0.77 Print Done - X
Using the data in the following table, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid. The realized return for the entire period is%. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Stock and Dividend Data Price $31.49 $29.52 $30.58 $31.41 $36.79 $43.08 Date Jan 1 Feb 5 May 14 Aug 13 Nov 12 Dec 31 Dividend $0.17 $0.22 $0.21 $0.21 - X
Based on five years of monthly data, you derive the following information forthe companies listed: Company SDi rm Padma 11.10% 0.82 Meghna 12.60% 0.63 Jamuna 6.60% 0.45 Karnafully 9.70% 0.70 SD on Market 7.60% 1.00 Compute the beta coefficient for each stock.
Based on five years of monthly data, you derive the following information forthe companies listed: Company SDi rm Padma 11.10% 0.82 Meghna 12.60% 0.63 Jamuna 6.60% 0.45 Karnafully 9.70% 0.70 SD on Market 7.60% 1.00 Plot the following estimated returns for the nest year on the SML and indicate which stocks are undervalued or overvalued.a. Padma – 22 percentb. Meghan – 17 percentc. Jamuna – 16 percentd. Karnafully – 12 percent.
The following information was available for the year ended December 31, 2022: Dividends per share Earnings per share 1.35 3.00 28.20 Market price per share at year-end Required: a. Calculate the price/earnings ratio for 2022. Note: Round your answer to 2 decimal places. b. Calculate the dividend payout ratio for 2022. Note: Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34). c. Calculate the dividend yield for 2022. Note: Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34). a. Price/Earning ratio b. Dividend payout ratio c. Dividend yield % Ji di %