Problem Four (15 marks) You work for a small investment management firm. You have been provided...

Problem Four

You work for a small investment management firm. You have been provided with the following historical information for three stocks and the market index. The information is shown in the table below.

	AAA Inc.		BBB Inc.		CCC Inc.
	Stock Price	Dividend	Stock Price	Dividend	Stock Price	Dividend	Market Index
2012	$35	$1.20	$110	$0.45	$100	$1.50	10,840
2013	$40	$1.40	$120	$0.50	$85	$1.50	11,320
2014	$45	$1.40	$98	$0.55	$95	$1.60	12,220
2015	$50	$1.70	$115	$0.65	$110	$1.65	13,325
2016	$42	$1.85	$140	$0.75	$105	$1.65	12,500
2017	$52	$1.85	$150	$0.90	$125	$1.75	13,820
2018	$70	$1.90	$120	$1.00	$140	$1.90	14,400

Using the data provided you are to calculate the following for each of the stocks and the market index.

What is the annual return for the past six years?
What is the average annual return for the past six years?
What is the geometric average annual return (effective annual rate of return) for the past six years?
What is the population standard deviation and the sample standard deviation?
What is the sample covariance and correlation coefficient between Stocks AAA and BBB? Between Stocks AAA and CCC? Between Stocks BBB and CCC?
What is the coefficient of variation for each of the stocks and the market index?
What is the beta of each of the stocks? You can use Excel’s “slope” function to estimate this.
Assuming that the beta of stock AAA is 0.80, the beta of stock BBB is 1.2 and the beta of stock CCC is 1.6. What is the beta of a portfolio where the weight in stock AAA is 20% the weight in stock BBB is 50% and the weight in stock CCC is 30%.
Assuming the risk free rate is 3% and the expected return on the market is 7% what is the expected return on the portfolio in part (h) above?

Please answer question using excel functions with in cell viewing.

Expert Solution

jeff jeffy answered 1 year ago

You work for a small investment management firm. You have been provided with the following historical...

You work for a small investment management firm. You have been provided with the following historical information for three stocks and the market index. The information is shown in the table below. AAA Inc. BBB Inc. CCC Inc. Stock Price Dividend Stock Price Dividend Stock Price Dividend Market Index 2012 $47 $125 $145 20,840 2013 $52 $1.40 $135 $1.50 $160 $3.50 23,320 2014 $57 $1.40 $103 $1.55 $170 $3.60 22,220 2015 $62 $1.70 $130 $1.65 $185 $3.65 25,325 2016...

Scenario: You work for an investment banking firm and have been asked by management of Vestor...

Scenario: You work for an investment banking firm and have been asked by management of Vestor Corporation (not real), a software development company, to calculate its weighted average cost of capital, to use in evaluating a new company investment. The firm is considering a new investment in a warehousing facility, which it believes will generate an internal rate of return of 11.5%. The market value of Vestor's capital structure is as follows: Source of Capital Market Value Bonds $10,000,000 Preferred...

You work for a large investment management firm. The analysts with your firm have made the...

You work for a large investment management firm. The analysts with your firm have made the following forecasts for the returns of stock A and stock B: Probability Stock A Stock B very very weak 10.00% 65.00% -65.00% Weak 15.00% 30.00% -20.00% Moderate 30.00% 25.00% 35.00% strongly Moderate 20.00% 15.00% 40.00% Strong 15.00% -20.00% 45.00% Very Very Strong 10.00% -55.00% 65.00% 100.0% Answer the following questions: Calculate the expected returns, variance and the standard deviations for stock A and B....

QUESTION FOUR You have been provided with the following information for a small private company, Formosa...

QUESTION FOUR You have been provided with the following information for a small private company, Formosa Pty Ltd, whose competitors are predominately large public companies. 2017 2018 2019 Industry average 2019 Net profit margin 8.2% 7.5% 6.8% 8.0% Return on equity 13.1% 12.3% 11.1% 13.5% Current ratio 1.8 2.1 2.4 2.0 Quick ratio 1.2 1.1 0.9 1.2 Receivables turnover 12.2 12.6 13.0 13.0 Inventory turnover 4.7 4.5 4.2 4.8 REQUIRED: Comment on the trend of each of the six ratios...

You work for a private wealth management firm that follows an “external investment” model, whereby it...

You work for a private wealth management firm that follows an “external investment” model, whereby it decides which outside managers it should recommend to clients. One mutual fund that is a candidate for inclusion on your Premier Recommended List of approved managers is Active Fund (AFNDX), an actively managed stock portfolio benchmarked to the Standard & Poor’s 500 (SPX) Index. You have been asked to perform an evaluation of AFNDX’s past investment performance, using a sample of monthly returns on...

In Option #1 you have been hired as an IT expert by a small firm to...

In Option #1 you have been hired as an IT expert by a small firm to set up an office for 20 staff members, half of whom will work with desktop computers, and the remaining with laptop computers using wireless networks. The office will use one networked laser printer, accessible from both the desktop and laptop computers. The desktop computers will use a wired network, while the laptop computers will employ a wireless network to print and access the Internet....

You have been hired as an IT expert by a small firm to set up an...

You have been hired as an IT expert by a small firm to set up an office for 20 staff members, half of whom will work with desktop computers and the remaining with laptop computers using wireless networks. The office would use one networked laser printer, accessible from both the desktop and laptop computers. The desktop computers will use a wired network, while the laptop computers will employ a wireless network to print and access the internet. Start making a...

You have recently been employed by a consulting firm as a management accounting specialist. The firm...

You have recently been employed by a consulting firm as a management accounting specialist. The firm specialises in the provision of information to companies that have discrete, short term problems. Your first assignment is to a company called Malvern who specialises in construction equipment and is having trouble identifying the reasons for volatility in the profitability of its main product: The Hammer. The managers of Malvern are aware that there are a number of factors which are potentially causing them...

A. Four basic activities involved in interaction design (Marks: 15) Consider the background information provided. If...

A. Four basic activities involved in interaction design (Marks: 15) Consider the background information provided. If a website was to be created to raise awareness and provide support to parents of children diagnosed with autism or parents who suspect that their child might have autism, explain how you would apply the four basic activities involved in interaction design.

You are working for an investment firm in the City of London and have been asked...

You are working for an investment firm in the City of London and have been asked to perform some analysis of the European-style call options of a company called Elevation Matters Plc (EM). The most recent closing share price for EM was £38. The risk-free rate is 3%. The time to expiry for the options is one year. The volatility (standard deviation) of EM’s shares is 25% and the company has decided not to pay any dividends this year. On...

Question