regarding this document how do I find the weights using excel? and how is the rest solved
Fantastic news! We've Found the answer you've been seeking!
Question:
regarding this document how do I find the weights using excel? and how is the rest solved using Excel?
Transcribed Image Text:
MONTHLY Expected Returns, Standard Deviations, and Correlations (1975-2014, 480 months), Portfolios are Top or Bottom Decile in Size or Book-to-Market Ratio Asset Class Large Stocks Small Stocks Value Stocks Growth Stocks Gold Expected Return 1.01% 1.35% 1.51% 0.95% 0.54% Std. Deviation 4.30% 6.10% 5.94% 5.13% 5.66% Large Stocks 1.00 0.65 0.75 0.93 -0.01 Small Stocks 0.65 1.00 0.75 0.69 0.07 Correlation with: Value Stocks 0.75 0.75 1.00 0.65 0.01 Growth Stocks 0.93 0.69 0.65 1.00 0.00 Gold -0.01 0.07 0.01 0.00 1.00 For the questions below, assume a risk-free rate of 0.4% per month. 1. Suppose you are currently invested 100% in LARGE stocks, and you CANNOT short (i.e., portfolio weights cannot be negative): a. Find the portfolio that maximizes expected return if you want the same risk of LARGE stocks. b. What is the expected return of this portfolio and what are the portfolio weights in this case? c. How much are expected returns increased on a monthly basis by switching from 100% LARGE stocks to this new portfolio? MONTHLY Expected Returns, Standard Deviations, and Correlations (1975-2014, 480 months), Portfolios are Top or Bottom Decile in Size or Book-to-Market Ratio Asset Class Large Stocks Small Stocks Value Stocks Growth Stocks Gold Expected Return 1.01% 1.35% 1.51% 0.95% 0.54% Std. Deviation 4.30% 6.10% 5.94% 5.13% 5.66% Large Stocks 1.00 0.65 0.75 0.93 -0.01 Small Stocks 0.65 1.00 0.75 0.69 0.07 Correlation with: Value Stocks 0.75 0.75 1.00 0.65 0.01 Growth Stocks 0.93 0.69 0.65 1.00 0.00 Gold -0.01 0.07 0.01 0.00 1.00 For the questions below, assume a risk-free rate of 0.4% per month. 1. Suppose you are currently invested 100% in LARGE stocks, and you CANNOT short (i.e., portfolio weights cannot be negative): a. Find the portfolio that maximizes expected return if you want the same risk of LARGE stocks. b. What is the expected return of this portfolio and what are the portfolio weights in this case? c. How much are expected returns increased on a monthly basis by switching from 100% LARGE stocks to this new portfolio? MONTHLY Expected Returns, Standard Deviations, and Correlations (1975-2014, 480 months), Portfolios are Top or Bottom Decile in Size or Book-to-Market Ratio Asset Class Large Stocks Small Stocks Value Stocks Growth Stocks Gold Expected Return 1.01% 1.35% 1.51% 0.95% 0.54% Std. Deviation 4.30% 6.10% 5.94% 5.13% 5.66% Large Stocks 1.00 0.65 0.75 0.93 -0.01 Small Stocks 0.65 1.00 0.75 0.69 0.07 Correlation with: Value Stocks 0.75 0.75 1.00 0.65 0.01 Growth Stocks 0.93 0.69 0.65 1.00 0.00 Gold -0.01 0.07 0.01 0.00 1.00 For the questions below, assume a risk-free rate of 0.4% per month. 1. Suppose you are currently invested 100% in LARGE stocks, and you CANNOT short (i.e., portfolio weights cannot be negative): a. Find the portfolio that maximizes expected return if you want the same risk of LARGE stocks. b. What is the expected return of this portfolio and what are the portfolio weights in this case? c. How much are expected returns increased on a monthly basis by switching from 100% LARGE stocks to this new portfolio?
Expert Answer:
Related Book For
Fundamentals of Investments
ISBN: 978-0132926171
3rd edition
Authors: Gordon J. Alexander, William F. Sharpe, Jeffery V. Bailey
Posted Date:
Students also viewed these finance questions
-
How to access the real payoff of a college degree by Scott Carlson Do the benefits of college still outweigh the costs? By Richard Deitz & jaison R Abel Annotated mini bibliography Research essay...
-
QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...
-
Data collected at elementary schools in DeKalb County, GA suggest that each year roughly 25% of students miss exactly one day of school, 15% miss 2 days, and 28% miss 3 or more days due to sickness....
-
Sandra Company and Nova Inc. each signed lease agreements on January 1, 2017. Nova's lease qualified for capital lease treatment, but Sandra's lease did not. All other information for both companies...
-
Find the moment-generating function of the negative binomial distribution by making use of the fact that if k independent random variables have geometric distributions with the same parameter , their...
-
A ball in motion collides elastically with an identical ball at rest. If we treat each ball as a separate system, is the work done on each ball the same?
-
Multiple Choice Questions The following questions deal with audit evidence for the sales and collection cycle. Choose the best response. a. An auditor is performing substantive tests of transactions...
-
2.9.When gas is injected into a column of water, a liquid circulation pattern develops. Thus, upflow at a rate Q, (m/s) rises in the central core and downflow occurs at a rate Q, in the annulus. If...
-
Find the open-circuit voltage The circuit you should use to find the open-circuit voltage, voc, is shown here. Note that the resistor to the right of terminals a and b has been removed to create the...
-
Construct a letter of inquiry assuming you are the acquisition supervisor of a certain company. Inquire products of Apple Philippines, PowerMac Center or BeyonTheBox Philippines. You can invent...
-
Suppose that yet no supply side effects took hold but due to the demand side effects of the policy inflation build up to %70. And monetary authorities decided to fight with inflation using...
-
Since short-term liabilities consist of debts due within one year, what would the balance sheet show for a loan with monthly payments of $4,000?
-
what is the out come of AICPA rule if Maria is a Partner of CPA practice and Bidding on a consulting engagement with Western Construction Company and her husband become CFO of this company?
-
Submit a response to the article Ontario court recognizes new foundation for liability for family violence. Does the expanded definition of family violence in the Divorce Act change your...
-
Identify government safety net programs and who they are designed to help. Who would qualify for the Earned Income Tax Credit (EITC)?
-
2. A 500-N diver stands at the end of a 4.0-m diving board. The board is attracted by two supports 1.5 m apart as shown below. Find the tension in each of the two supports if the diving board weighs...
-
1. Which of the four major types of information systems do you think is the most valuable to an organization? 2. How do you critically associate the ideas of business agility and business efficiency...
-
Nellie Fox acquired at par a bond for $1,000 that offered a 9% coupon rate. At the time of purchase, the bond had four years to maturity. Assuming annual interest payments, calculate Nellie's actual...
-
Consider a 10-year zero-coupon Treasury security selling for a price of $300, with a face value of $1,000. What is the before-tax annual rate of return to an investor who buys and holds this security...
-
Why does diversification lead to a reduction in unique risk but not in market risk? Explain both intuitively and mathematically.
-
The percentage of heights less than 147 centimeters
-
The percentage of heights between 148 centimeters and 170 centimeters
-
The percentage of heights between 146 centimeters and 156 centimeters
Study smarter with the SolutionInn App