Question

In: Finance

The returns on Amanda Ltd’s share over the past five years are reported in table below:...

The returns on Amanda Ltd’s share over the past five years are reported in table below: Year Return 2016 6% 2017 -12% 2018 16% 2019 38% 2020 11% 6.1.1 Calculate the average return for on Amanda’s share over the five year. (2) 6.1.2 Calculate the variance and the standard deviation of Amanda’s return over this period. (8) 6.2 NEW HOPE stock is expecting a Return On Equity (ROE) of 12%, earnings per share (EPS) of $8 and dividends of $6 per share. NEW HOPE investors require a rate of return of 10%. Calculate NEW HOPE’s expected growth rate, its intrinsic value and P/E ratio. (10).Subject is Investment

Expert Solution

Avg Ret = SUm [ Ret ] / n

Variance = Sum [ (X-Avg X)^2 ] / n

SD = SQRT [Sum [ (X-Avg X)^2 ] / n ]

Growth Rate = Retention Ratio * ROE

PE Ratio = MPS / EPS

MPS = D1 / ( Ke - g )

D1 = Expected Div after 1 Year

Ke = Required Ret

6.1.1:

Avg Ret = SUm [ Ret ] / n

= [ 6% - 12% + 16% + 38% + 11% ] / 5

= 59% / 5

= 11.8%

6.1.2

Variance:

Year	Ret	X-Avg X	(X-Avg X)^2
2016	6%	-0.058	0.0034
2017	-12%	-0.238	0.0566
2018	16%	0.042	0.0018
2019	38%	0.262	0.0686
2020	11%	-0.008	0.0001
Sum [ (X-Avg X)^2 ]	0.1305
Variance =Sum [ (X-Avg X)^2 ] /n	0.0261

SD :

Year	Ret	X-Avg X	(X-Avg X)^2
2016	6%	-0.058	0.0034
2017	-12%	-0.238	0.0566
2018	16%	0.042	0.0018
2019	38%	0.262	0.0686
2020	11%	-0.008	0.0001
Sum [ (X-Avg X)^2 ]	0.1305
Variance =Sum [ (X-Avg X)^2 ] /n	0.0261
SD = SQRT [ Variance ]	0.1615

6,2:

Retention Ratio = [ EPS - DPS ] / EPS

= [ 8 - 6 ] / 8

= 2 / 8

= 0.25

Growth Rate = Retention Ratio * ROE

= 0.25 *12%

= 3%

D1 = D0 (1 + g )

= 6 ( 1 + 0.03)

= 6*1.03

= $ 6.18

MPS = D1 / [ Ke - g ]

= $ 6.18 / [ 10% - 3% ]

= $ 6.18 / 7%

= $ 88.29

PE Ratio:

= MPS / EPS
= 88.29 / 8

= 11.04 times

jeff jeffy answered 1 year ago

Below are the holding period returns for the past five years for Microsoft (MSFT) and the...

Below are the holding period returns for the past five years for Microsoft (MSFT) and the S&P 500 Date MSFT S&500 2017 15% 8% 2016 7% 9% 2015 25% 12% 2014 15% 7% 2013 6% 5% a. Calculate the average arithmetic return and standard deviation for MSFT and the S&P500. b. Assuming you are a risk averse investor and expect the next 12 months to be similar to the past twelve months. If you had to make a choice between...

Calculate the percentage returns generated over the past five years by the following three indices: TSX...

Calculate the percentage returns generated over the past five years by the following three indices: TSX Composite, Dow Jones Industrial Average (DJIA), and S&P 500. Use the Globe Investor website to chart and estimate the returns. Choose an index, then view the five-year chart by clicking on the 5Y link above the chart. Hover your cursor on the beginning and ending of the graph line to see the price (this feature may not work in Internet Explorer). Once you have...

Over the past five years, a stock produced returns of 14%, 22%, -16%, 4%, and 11%....

Over the past five years, a stock produced returns of 14%, 22%, -16%, 4%, and 11%. If the returns are normally distributed, what is the probability that an investor in this stock will NOT lose more than 7.4% nor earn more than 21.4% in any one given year? (Hint: Find average return and standard deviation first.)

. Over the past five years, a stock produced returns of 10 percent, 18 percent, 2...

. Over the past five years, a stock produced returns of 10 percent, 18 percent, 2 percent, -9 percent, and 4 percent. a) What is the geometric return? b) What is the arithmetic return? c) What is the variance of the above returns? d) What is the sample standard deviation?

You’ve observed the following returns on Bennington Corporation’s stock over the past five years: 17 percent,...

You’ve observed the following returns on Bennington Corporation’s stock over the past five years: 17 percent, −4 percent, 20 percent, 12 percent, and 10 percent. a. What was the arithmetic average return on the company's stock over this five-year period? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) b-1. What was the variance of the company's stock returns over this period? (Do not round intermediate calculations and round your...

1a. You’ve observed the following returns on Boca Inc’s stock over the past five years: 7...

1a. You’ve observed the following returns on Boca Inc’s stock over the past five years: 7 percent, ?13 percent, 21 percent, 34 percent, and 15 percent. What was the arithmetic average return on Crash-n-Burn’s stock over this five-year period? What was the variance of Crash-n-Burn’s returns over this period? The standard deviation? 1b. A stock has had the following year-end prices and dividends: Year Price Dividend 1 $51.50 - 2 59.32 $0.65 3 64.13 0.70 4 57.86 0.77 5 65.19...

The S&P 500 and Nohr Corp had the following returns over the past five years Year ...

The S&P 500 and Nohr Corp had the following returns over the past five years Year S&P 500 Nohr .12 .23 .01 -.05 .18 .20 .09 .12 .10 .20 a. What was the mean AND standard deviation of returns (population version) for Nohr for the 5 years? b. What was the beta of Nohr relative to the S&P 500? c. What was the geometric mean return for Nohr for the 5 years?

You’ve observed the following returns on Yasmin Corporation’s stock over the past five years: 17 percent,...

You’ve observed the following returns on Yasmin Corporation’s stock over the past five years: 17 percent, –15 percent, 19 percent, 29 percent, and 10 percent. a. What was the arithmetic average return on the company's stock over this five-year period? (Do not round intermediate calculations. Enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) Average return % b-1 What was the variance of the company's stock returns over this period? (Do not round intermediate calculations...

You’ve observed the following returns on SkyNet Data Corporation’s stock over the past five years: 12...

You’ve observed the following returns on SkyNet Data Corporation’s stock over the past five years: 12 percent, –9 percent, 20 percent, 17 percent, and 10 percent. a. What was the arithmetic average return on the company's stock over this five-year period? (Do not round intermediate calculations and enter your answer as a percent rounded to 1 decimal place, e.g., 32.1.) b-1. What was the variance of the company's returns over this period? (Do not round intermediate calculations and round your...

You’ve observed the following returns on Crash-n-Burn Computer’s stock over the past five years: 11 percent,...

You’ve observed the following returns on Crash-n-Burn Computer’s stock over the past five years: 11 percent, –11 percent, 18 percent, 23 percent, and 10 percent. Suppose the average inflation rate over this period was 2 percent and the average T-bill rate over the period was 3.1 percent. a. What was the average real risk-free rate over this time period? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) b. What...