Business and Finance Homework

Need finance homework help? Ask an Expert

Ask an Expert,

Get an Answer ASAP!

Customer Question

Assignment 1. Plot in...

Assignment

1. Plot in Excel the risky asset opportunity set for Portfolios A & B. Hint: create the

following table in excel assuming weights of portfolio A & B in 10 percentage

point increments. Then calculate expected return and standard deviation for

each allocation to A & B.

Weight Port A

Weight Port B

Return

Standard

Deviation

Sharpe Ratio

0%

100%

10

90

20

80

30

70

40

60

50

50

60

40

70

30

80

20

90

10

100

0

Determine the optimal allocation of A & B and draw in the Capital Allocation Line

(CAL). You can arrive at an approximate optimal allocation using a table similar to

the one shown above OR you can obtain a more precise optimal allocation using the

formula shown in Chapter 7 (equation 7.13). When drawing the CAL on the efficient

frontier graph plotted in Excel, you can manually draw a line starting at the risk free

rate to the tangent point.

2. Find the optimal complete portfolio based on your client’s indifference curve.

Hint: Plot an indifference curve on the same graph you just created using the

utility function formula from Chapter 6. Use the range of expected return and

standard deviations shown in the table below. Assume U = 9% and a risk

aversion coefficient (A) of 10 to complete the table below.

Expected Return

Standard Deviation

5%

7.5

10

12.5

15

17.5

20

22.5

25

3. Use the capital asset pricing model (CAPM) to determine the beta and alpha of

Portfolio A & Portfolio B. Show the CAPM relationship graphically for BOTH

Portfolio A and Portfolio B (separate graphs). The market portfolio is represented

by the S&P 500 and the risk free rate is represented by 90 day Treasury Bill.

Determine the beta for portfolio A & B using: i) the slope function in Excel; and ii)

the formula for beta – the co-variance between the asset and the market dividedby the variance of the market. This is explained in the Modules 6& 7 notes and

pages 296 & 297 in the text. Recall the covariance between two assets is the

volatility of asset 1 times the volatility of asset 2 times the correlation between

them.

Calculate the expected alpha for each portfolio A & B using the intercept function

in Excel and the index model of CAPM formula (equation 9.9 on page 302 – note

that the terms are in excess return form). Ignore the error term and you have all

the information to solve for alpha based on the monthly returns. Compare the

betas and y-intercepts using the two different methods.

1. Plot in Excel the risky asset opportunity set for Portfolios A & B. Hint: create the

following table in excel assuming weights of portfolio A & B in 10 percentage

point increments. Then calculate expected return and standard deviation for

each allocation to A & B.

Weight Port A

Weight Port B

Return

Standard

Deviation

Sharpe Ratio

0%

100%

10

90

20

80

30

70

40

60

50

50

60

40

70

30

80

20

90

10

100

0

Determine the optimal allocation of A & B and draw in the Capital Allocation Line

(CAL). You can arrive at an approximate optimal allocation using a table similar to

the one shown above OR you can obtain a more precise optimal allocation using the

formula shown in Chapter 7 (equation 7.13). When drawing the CAL on the efficient

frontier graph plotted in Excel, you can manually draw a line starting at the risk free

rate to the tangent point.

2. Find the optimal complete portfolio based on your client’s indifference curve.

Hint: Plot an indifference curve on the same graph you just created using the

utility function formula from Chapter 6. Use the range of expected return and

standard deviations shown in the table below. Assume U = 9% and a risk

aversion coefficient (A) of 10 to complete the table below.

Expected Return

Standard Deviation

5%

7.5

10

12.5

15

17.5

20

22.5

25

3. Use the capital asset pricing model (CAPM) to determine the beta and alpha of

Portfolio A & Portfolio B. Show the CAPM relationship graphically for BOTH

Portfolio A and Portfolio B (separate graphs). The market portfolio is represented

by the S&P 500 and the risk free rate is represented by 90 day Treasury Bill.

Determine the beta for portfolio A & B using: i) the slope function in Excel; and ii)

the formula for beta – the co-variance between the asset and the market dividedby the variance of the market. This is explained in the Modules 6& 7 notes and

pages 296 & 297 in the text. Recall the covariance between two assets is the

volatility of asset 1 times the volatility of asset 2 times the correlation between

them.

Calculate the expected alpha for each portfolio A & B using the intercept function

in Excel and the index model of CAPM formula (equation 9.9 on page 302 – note

that the terms are in excess return form). Ignore the error term and you have all

the information to solve for alpha based on the monthly returns. Compare the

betas and y-intercepts using the two different methods.

Show More

Show Less

Was this answer helpful?

Describe your issueThe assistant will guide you

Chat 1:1 with a business tutorLicensed Experts are available 24/7

100% satisfaction guaranteeGet all the answers you need

Related Business and Finance Homework Questions

Here is the mini case study that I need help with--it is due

Here is the mini case study that I need help with--it is due tonight so please help ASAP! You are discusing your 401K with Dan Ervin, when he mentions that SarahBrown, a representative from Bledsoe Fi… read more

Part One: The CAPM Olter, Inc. is starting its risk management

Part One: The CAPM Olter, Inc. is starting its risk management program for the company and has asked for your help in determining critical risk measurements for the firm. The company has identified se… read more

I need this in one hour please help thanksQuestion 1.1.

I need this in one hour please help thanks Question 1.1. Consider the following information and then calculate the required rate of return for the Scientific Investment Fund, which holds 4 stocks. The… read more

1. In which of the following situations would you get the

1. In which of the following situations would you get the largest benefit from diversifying your investment across two stocks? a. there is perfect positive correlation b. there is perfect negative cor… read more

1. Buxton Corporation is planning to invest in a security that

1. Buxton Corporation is planning to invest in a security that has several potential rates of return. Using the following probability distribution of returns during different states of the economy, wh… read more

1. Portfolio management involves identifying objectives, constraints,

1. Portfolio management involves identifying objectives, constraints, and preferences for an investor, resulting in the development of an investment: a. Preference list b. Policy statement c. Guiding … read more

True/FalseIndicate whether the sentence or statement is true

True/False Indicate whether the sentence or statement is true or false. 1. It takes longer than eight years to retire a $24,000 loan at 8% if the annual payment is $3,000. 2. An annuity of $100 for te… read more

Hello Ms Linda! Im back with more questions!!! I just tried

Hello Ms Linda! I'm back with more questions!!! I just tried to do one on my own - I made a 60 =( So I think I will just let you do the rest!!! I'm sending you two different emails. This one first. Yo… read more

Consider the following capital market: a risk-free asset yielding

Consider the following capital market: a risk-free asset yielding 1.50% per year and a mutual fund consisting of 55% stocks and 45% bonds. The expected return on stocks is 9.00% per year and the expec… read more

Consider the following capital market: a risk-free asset yielding

Consider the following capital market: a risk-free asset yielding 1.50% per year and a mutual fund consisting of 55% stocks and 45% bonds. The expected return on stocks is 9.00% per year and the expec… read more

1. Which one of the following terms is another name for systematic

1. Which one of the following terms is another name for systematic risk? (Points : 1) unique risk firm risk market risk asset-specific risk diversifiable risk 2. You own a stock which is expected to r… read more

I need to calculate the return on holding the stock for a day

I need to calculate the return on holding the stock for a day: This stock is "The Cheesecake Factory" Opening at $29.07, It previously closed at $29.00 (Last trade was 28.63) and the daily range was $… read more

1. In a simple CAPM world which of the following statements

1. In a simple CAPM world which of the following statements is/are correct? I. All investors will choose to hold the market portfolio, which includes all risky assets in the world II. Investors' compl… read more

Corporate Finance $80 dollar bonus. I could use some

Corporate Finance $80 dollar bonus. I could use some help with the folllowing questions. Please use excel. Would need this by tomorrow night. Thank you. A2. (Realized return) Andy Fields bought $15,00… read more

$25 dollar bonus, Corporate Finance Need help with the following

$25 dollar bonus, Corporate Finance Need help with the following question. Please use excel. (Dividend discount model) Assume RHM is expected to pay a total cash dividend of $5.60 next year and its di… read more

Use the Captial Asset Pricing Model to answer the following

Use the Captial Asset Pricing Model to answer the following questions: a. Find the Expected Rate of Return on the Market Portfolio given that the Expected Rate of Return on Asset "i" is 12%, the Risk-… read more

For each of the scenarios below, explain whether or not it

For each of the scenarios below, explain whether or not it represents a diversifiable or an undiversifiable risk. Please consider the issues from the viewpoint of investors. Explain your reasoning a. … read more

Using Yahoo! Finance find the value of beta bby best buy a.

Using Yahoo! Finance find the value of beta bby best buy a. What is the estimated beta coefficient of your company? What does this beta mean in terms of your choice to include this company in your ove… read more

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.

JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.

Web sites like justanswer.com/legal

...leave nothing to chance.

...leave nothing to chance.

Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.

Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.

I will tell you that...the things you have to go through to be an Expert are quite rigorous.

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

Los Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

Hesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

Kernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

Woodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

Elkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

Dallas, TX

< Previous | Next >

linda_us

Master's Degree

852 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

F. Naz

Bachelor's Degree

5,499 satisfied customers

Have completed B.COM and CA Finalist

Bizhelp

Accountant

260 satisfied customers

BA degree and Certified Public Accountant

224 satisfied customers

dasdasd

Mr. Gregory White

Master's Degree

211 satisfied customers

M.A., M.S. Education / Educational Administration

Brittany

Professional

30 satisfied customers

AA/Accounting BS/Business

Dimitry K., Esq.

Doctoral Degree

19 satisfied customers

JD/MBA, Business Attorney

< Previous | Next >

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.