Business and Finance Homework

Need finance homework help? Ask an Expert

Ask an Expert,
Get an Answer ASAP!

Assignment 1. Plot in Excel the risky asset opportunity set…

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.
Submitted: 7 months ago.Category: Business and Finance Homework
Show More
Show Less
Ask Your Own Business and Finance Homework Question
Answered in 2 hours by:
12/8/2017
Business Tutor: F. Naz, Bachelor's Degree replied 7 months ago
F. Naz
F. Naz, Bachelor's Degree
Category: Business and Finance Homework
Satisfied Customers: 5,480
Experience: Have completed B.COM and CA Finalist
Verified

Please mention your deadline and also clarify that you only need the excel sheet or there is some descriptive part of the assignment, thanks.

Ask Your Own Business and Finance Homework Question
Customer reply replied 7 months ago
I attached both the study and the spreadsheet. I need this by 6pm today if that is possible.
Business Tutor: F. Naz, Bachelor's Degree replied 7 months ago

How many hours are remaining from now and will you be able to cite my work in your assignment, thanks.

Ask Your Own Business and Finance Homework Question
Customer reply replied 7 months ago
I don't think I will be able to cite it, but I really just need to understand it and how it is calculated. That 5 hours from now, but even 7 hours will work. I just need time to view it and understand it. Its for a group project and this is more for me to understand as my team has already done it. But I would need it no later than 8pm EST.
Business Tutor: F. Naz, Bachelor's Degree replied 7 months ago

Sorry opting out so other can do this as the time period is too short.

Ask Your Own Business and Finance Homework Question
Customer reply replied 7 months ago
I just need question 1-3 answered on the word file. The excel is to help with the math.
Customer reply replied 7 months ago
how you calculate yhem
Customer reply replied 7 months ago
Did you repost the question for someone else
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a business tutorLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask linda_us Your Own Question
linda_us
linda_us
linda_us, Master's Degree
Category: Business and Finance Homework
Satisfied Customers: 852
852 Satisfied Customers
Experience: A tutor for Business, Finance, Accounts and other related topics.

linda_us is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

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.
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.

What Customers are Saying:

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

Mary C.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!!!!

AlexLos 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.

GPHesperia, CA

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

JustinKernersville, 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.

EstherWoodstock, 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.

RobinElkton, 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.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

linda_us

linda_us

Master's Degree

852 satisfied customers

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

F. Naz

F. Naz

Bachelor's Degree

5,480 satisfied customers

Have completed B.COM and CA Finalist

Bizhelp

Bizhelp

Accountant

260 satisfied customers

BA degree and Certified Public Accountant

224 satisfied customers

dasdasd

Mr. Gregory White

Mr. Gregory White

Master's Degree

211 satisfied customers

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

Brittany

Brittany

Professional

30 satisfied customers

AA/Accounting BS/Business

Dimitry K., Esq.

Dimitry K., Esq.

Doctoral Degree

19 satisfied customers

JD/MBA, Business Attorney

< Previous | Next >

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
Expert
Expert
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
linda_us
linda_us
Master's Degree
852 satisfied customers
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
Expert
Expert
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
Mr. Gregory White
Mr. Gregory White
Master's Degree
Master's Degree
211 satisfied customers
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
F. Naz
F. Naz
Bachelor's Degree
5,480 satisfied customers
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
Mr. Gregory White
Mr. Gregory White
Master's Degree
Master's Degree
211 satisfied customers
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
Expert
Expert
224 satisfied customers
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
linda_us
linda_us
Master's Degree
852 satisfied customers
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
getsetgo
getsetgo
Master\u0027s Degree
496 satisfied customers
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
R.R. Jha
R.R. Jha
Bachelor\u0027s Degree
150 satisfied customers
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
Expert
Expert
224 satisfied customers
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
F. Naz
F. Naz
Bachelor's Degree
5,480 satisfied customers
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
Bizhelp
Bizhelp
Accountant
Bachelor's Degree
260 satisfied customers
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
linda_us
linda_us
Master's Degree
852 satisfied customers
$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
CPA Cindy
CPA Cindy
Bachelor\u0027s Degree
55 satisfied customers
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
Bizhelp
Bizhelp
Accountant
Bachelor's Degree
260 satisfied customers
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
ProMBA
ProMBA
Founder & CEO
Master\u0027s Degree
3 satisfied customers
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
ProMBA
ProMBA
Founder & CEO
Master\u0027s Degree
3 satisfied customers
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.

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.

Show MoreShow Less

Ask Your Question

x