Loading
Home › Finance Help › CHAPTER 8, ACTIVITY #1: TWO-ASSET RETURN AND RISK In this...
Status: Completed
 View Work

CHAPTER 8, ACTIVITY #1: TWO-ASSET RETURN AND RISK In this activity, we calculate the expected return and standard deviation of a two-asset portfolio. We also build a two-way data table to show the relationship between weights and correlation. We start with risk and return of two stocks, Alpha and Bravo.

Date Posted: 20/10/2019
Category: Finance
Due Date: 20/10/2019
Instruction
CHAPTER 8, ACTIVITY #1: TWO-ASSET RETURN AND RISK In this activity, we calculate the expected return and standard deviation of a two-asset portfolio. We also build a two-way data table to show the relationship between weights and correlation. We start with risk and return of two stocks, Alpha and Bravo. Open the upload for this activity, and perform the following steps: STEP1: In cell B9, enter 0% for the weight in Alpha. In cell B10, enter the formula, =1-B9. Now, our weights will always add to 100%. STEP2: In cell B13, enter the formula for portfolio return. Make sure you use cell references for the equation. STEP 3: In cell B14, enter the formula for portfolio variance. Make sure you use cell references for the equation. Now, we have portfolio return and variance as a function of the weight and correlation. STEP 4: In cell B15, take the square root of cell B14. STEP 5: Now, refer to the standard deviation value (cell B14) in cell I6. Create a two-way data table with the correlation value as the row input, and the weight in Alpha as the column input. Make sure cell B9 has a value of 0%. You now have a data table with standard deviation as a function of weight and correlation. What do the results show you? THis activity needs to be completed in the attached Excel spredsheet
Attached
Download File 1 (docx)
Download File 2 (xlsx)
Tutor Uploads
Download File 1 (xlsx)
Download File 2 (xlsx)
Bidders
Geniuspro 6 years, 11 months ago
Rated 9.31 earned 21388.20 around 775 assignments.
Hello friend. I can work on this task and deliver within the deadline provided. I can also work on the whole class for you. Kindly accept my bid.
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
funwriter 6 years, 11 months ago
Rated 9.44 earned 21955.32 around 740 assignments.
hello dearest customer, I have read and understoods the instructions . With over 10 years of writing experience, I guarantee high-quality plagiarism free work. I am your life saver!!
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
professionalwriter_d_496 6 years, 11 months ago
Rated 8.85 earned 19649.48 around 531 assignments.
Hello dear, as I said, you will never go wrong with me
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
komatsu 6 years, 11 months ago
Rated 8.8 earned 25673.74 around 681 assignments.
Hello, I understand your assignment requirements; it categorically falls in my area of interest and expertise. I guarantee you excellent work that will give us the highest attainable grade!
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
surrogatewriter 6 years, 11 months ago
Rated 9.31 earned 75264.37 around 2854 assignments.
With over 10 years of writing experience, I guarantee high-quality plagiarism free work. I am your life saver!
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
exclusivewriter 6 years, 11 months ago
Rated 9.41 earned 74860.53 around 2443 assignments.
With over 10 years of writing experience, I guarantee high-quality plagiarism free work. I am your life saver!
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}
 
 
Kimwoods_d_924 6 years, 11 months ago
Rated 8.9 earned 9357.10 around 278 assignments.
Hello friend, I am Kimwoods and I believe I am best suited for your job because of my expertise in article writing. I pride myself in providing high-quality content, and my clients have rated me higher for this. I do all the work by myself, conduct thorough research and ensure that my client is completely satisfied with the work. I am time conscious and submit my work without delays. I understand the need for effective and timely communication in ensuring the success of the work assigned. I am into this for the long haul. Thank you for taking the time to go through my proposal. I look forward to an interview with you. Regards
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[6] $}

{$ showNewChatSuccessMsg[6] $}
Unable to send Message: {$ showChatProcessErrorMsg[6] $}
 
 
1stclasshonour 6 years, 11 months ago
Rated 9.22 earned 30856.96 around 773 assignments.
I will help you to do this assignment in the best way possible. I will follow all the instructions strictly to ensure that i submit to you quality, perfect and timely work free from plagiarism. kindly assign me this particular work and be assured of a perfect paper.
$35.00
  • hello, the instruction are very clear, i promise to do good work from this particular assignment. i will make sure that i deliver quality paperwork that is free from grammatical errors, free from plagiarism, and well structured,, please assign this order to me,, kindly,,
    User_10376 | Oct 20, 2019, 01:40 AM
  • kindly assign me this particular work and be assured of a perfect paper
    User_10376 | Oct 20, 2019, 01:40 AM
  • Please complete the assignment ASAP please!
    User_23973 | Oct 20, 2019, 01:43 AM
  • Hello, I will be able to deliver the paper after 12 hrs
    User_10376 | Oct 20, 2019, 01:50 AM
  • Hello, will you be able to wait for the paper in the next 6hrs?
    User_10376 | Oct 20, 2019, 02:29 AM
  • Hello friend am working on your assignment
    User_10376 | Oct 20, 2019, 02:48 AM
  • Please respond to me
    User_10376 | Oct 20, 2019, 02:48 AM
  • hello i have tried my best to deliver the paper please confirm and release the payment, thank you
    User_10376 | Oct 20, 2019, 04:28 AM
  • please look at the paper and release the payment
    User_10376 | Oct 20, 2019, 04:29 AM
  • Hello, did you confirmed the work?
    User_10376 | Oct 20, 2019, 13:19 PM
  • I saw the spreadsheet half way completed. I will let you know if I need it tonight and will release the payment
    User_23973 | Oct 20, 2019, 13:57 PM
  • Which part is not complete please?
    User_10376 | Oct 20, 2019, 14:21 PM
  • Hello friend, you were supposed to get back to me about the paper,
    User_10376 | Oct 21, 2019, 00:41 AM
  • the data table
    User_23973 | Oct 21, 2019, 15:09 PM
  • Hello the table is completed did you confirmed please
    User_10376 | Oct 22, 2019, 19:12 PM
  • Hello, did you confirmed the paper
    User_10376 | Oct 23, 2019, 00:29 AM
  • Hello friend, you said I complete the table and I completed it, you promised to release the payment after you have confirmed the paper
    User_10376 | Oct 23, 2019, 18:31 PM
  • hello friend, hope you are fine, am just after reminding you that you happened to forget to release the payment for the paper, please release the payment
    User_10376 | Oct 23, 2019, 22:54 PM
  • Hello friend, hope you saw the spreadsheet
    User_10376 | Oct 24, 2019, 04:51 AM
  • Hello am just after reminding you that you happened to forget to release the payment for the paper, please release the payment
    User_10376 | Oct 25, 2019, 11:54 AM
  • hello, how are you
    User_10376 | Oct 27, 2019, 23:25 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[7] $}

{$ showNewChatSuccessMsg[7] $}
Unable to send Message: {$ showChatProcessErrorMsg[7] $}
 
 
writingPro 6 years, 11 months ago
Rated 9.21 earned 7454.10 around 263 assignments.
Hi there! I’m your new writing partner and I’m excited to help you! I will go through your summary and instruction carefully and do your task. My work is top-notch with zero grammatical errors, and a 100% free from PLAGIARISM. I will also give you a discount if you give me your whole class. I'm ready to help you now. Kindly hire me, and I’ll make you proud.
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[8] $}

{$ showNewChatSuccessMsg[8] $}
Unable to send Message: {$ showChatProcessErrorMsg[8] $}
 
 
smartestwriter 6 years, 11 months ago
Rated 9.54 earned 25983.04 around 898 assignments.
hello dearest customer, I have read and understoods the instructions . With over 10 years of writing experience, I guarantee high-quality plagiarism free work. I am your life saver!!
$20.00
  • hello dear
    smartestwriter | Oct 20, 2019, 01:41 AM
  • Finance is my major
    smartestwriter | Oct 20, 2019, 01:41 AM
  • Kindly assign
    smartestwriter | Oct 20, 2019, 01:41 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[9] $}

{$ showNewChatSuccessMsg[9] $}
Unable to send Message: {$ showChatProcessErrorMsg[9] $}
 
 
Robert_d_308 6 years, 11 months ago
Rated 9.37 earned 62524.46 around 2184 assignments.
Hi there! I’m your new writing partner and I’m excited to help you! I will go through your summary and instruction carefully and do your task. My work is top-notch with zero grammatical errors, and a 100% free from PLAGIARISM. I will also give you a discount if you give me your whole class. I'm ready to help you now. Kindly hire me, and I’ll make you proud.
$20.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[10] $}

{$ showNewChatSuccessMsg[10] $}
Unable to send Message: {$ showChatProcessErrorMsg[10] $}