Question: I am trying to use solver in excel to find the max sharpe ratio for a portfolio of 5 stocks. I need to somehow set

I am trying to use solver in excel to find the max sharpe ratio for a portfolio of 5 stocks. I need to somehow set a constraint where the weights of all five stocks still add up to 1.

How would I set a constraint of this nature? I have been unable to enter weight1+weight2+weight3+weight4+weight5=1. Is there a way to do this? or another solution.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Sentinel Systems Inc. prepared the following sales budget for 20Y8: At the end of December 20Y8, the following unit sales data were reported for the year: For the year ending December 31, 20Y9, unit...

Calculate expected returns (use arithmetic mean if you have short investment horizon, and geometric mean if you have long investment horizon; e.g. 1 month versus 20 years) and volatility (use...

Question 4. Using the covariance matrix, yearly mean returns, and risk-free rate from Question 3 to answer the following. Use Solver in Excel to find 12 portfolios (each portfolio is a set of weights...

Find the optimal complete portfolio graphically using the clients indifference curve. Plot an indifference curve on the same graph you just created using the utility function formula from Chapter 6....

Investment opportunity set: (a) Using the expected returns and volatility numbers from previous question, plot your assets on the expected return-risk space. (b) Use Solver in Excel to find 5...

BF4221 Investments Group project: Portfolio optimization Objective: To engage you in an asset allocation exercise. The project will require you to apply fundamental concepts of portfolio theory to...

The average 30-day Treasury bill rate from Jan 2016 to Feb 2017 was 0.4%. Given a two asset portfolio find the optimal weights for the highest sharp ratio. Use excel solver. BAC Weight: 0.740739366...

PART 2: - OPTIMAL PORTFOLIO CONSTRUCTION: (9 marks) In its simplest form, portfolio theory is about finding the balance between maximizing your return and minimizing your risk. The objective is to...

intructions are provided The Excel supplement has the returns of three market indices - Australia, Germany, and France from 1981 to 1997. Please provide the Excel file with your submission. Question:...

1) Sharpe Ratio (20 points): i) Similar to what we did in class, please use the DAX data provided to calculate the Sharpe Ratio. Assume that the risk free rate is the 1-Year LIBOR rate of 1.78%....

This question is based to the stock data that can be obtained from the following link: http://biz.yahoo.com/r/ "Choose Research Tools" and then "Historical Quotes". Obtain monthly stock data for 5...

Le Chteau Inc. manufactures and sells fashion apparel, accessories, and footwear at various retail locations across Canada. Its annual report for the year ended January 28, 2012, included the...

What is the IUPAC name of the following compound? Br, H. H H3C Br CH2CH3

Question 7 Which of the items below would be included under Other income and expense ? Salaries, interest expense, equity losses. Equity earnings, gains from sale of assets, interest income. Research...

How would you extend the Rabin-Karp method to the problem of searching a text string for an occurrence of any one of a given set of k patterns? Start by assuming that all k patterns have the same...

A particle in an infinite square well makes a transition from a higher to a lower energy state; the corresponding energy decrease is 33 times the ground-state energy. Find the quantum numbers of the...

Consider the following statement: The essence of project management is risk management. What does it mean in terms of completing a project successfully? Support your response with evidence from the...

Perrys model of intellectual development was applied to undergraduate engineering students at Penn State (Journal of Engineering Education, Jan. 2005). Perry scores (ranging from 1 to 5) were...

Solve for the unknown discount rate in each of the following: Present Value Years Discount Rate Future Value $2,970 $2,400 11.24% 11.61 10.95 10,800 1,853,820 5,316,180 3,600 10 390,000 382,610 15 30...

what do process capability indexes represent?

3. Why are proactive measures the most appropriate for addressing ergonomic injuries?

3. Write a short position paper on what we should do to get all our employees to behave more safely at work.

4. What role did negotiating skills seem to play in the WGA producers negotiations? Provide examples.