Loading
Home › Business Help › Project 1: Portfolio construction: (a) Select five to eig...
Status: Completed
 View Work

Project 1: Portfolio construction: (a) Select five to eight stocks and do a Markowitz portfolio optimization in Excel. You can download the historical prices from online sources such as Yahoo Finance. The major steps will be demonstrated in class. When you write up the report, only present the input part (mean and standard deviation, correlation matrix, etc.) and the result part (optimized weights for both the global minimum variance portfolio and the optimal risky portfolio). (b) Calculate the beta of those stocks you selected. Choose an appropriate market index. (c) Explain the above results and comment on them. Duo any time tomorrow before midnight

Date Posted: 10/11/2015
Category: Business
Due Date: 11/11/2015
Instruction
Project 1: Portfolio construction: (a) Select five to eight stocks and do a Markowitz portfolio optimization in Excel. You can download the historical prices from online sources such as Yahoo Finance. The major steps will be demonstrated in class. When you write up the report, only present the input part (mean and standard deviation, correlation matrix, etc.) and the result part (optimized weights for both the global minimum variance portfolio and the optimal risky portfolio). (b) Calculate the beta of those stocks you selected. Choose an appropriate market index. (c) Explain the above results and comment on them. Duo any time tomorrow before midnight
Attached
No File uploaded yet.
Tutor Uploads
Download File 1 (xls)
Download File 2 (xls)
Download File 3 (zip)
Download File 4 (zip)
Download File 5 (zip)
Download File 6 (zip)
Download File 7 (doc)
Download File 8 (zip)
Bidders
richwhite 10 years, 11 months ago
Rated 9.35 earned 20716.09 around 553 assignments.
Hi I have reviewed the instructions and the assignment falls under my specialization. Please accept my humble bid and I promise to deliver the paper accordingly. I guarantee intense review of the instruction, analysis, stepwise implementation and presentation, and 0% plagiarism. Thank you.
$100.00
  • hello friend..
    richwhite | Oct 11, 2015, 16:06 PM
  • thats really expensive. can you lower the price?
    User_5410 | Oct 11, 2015, 16:08 PM
  • i guarantee you quality work friend
    richwhite | Oct 11, 2015, 16:09 PM
  • when will you be done with it ?
    User_5410 | Oct 11, 2015, 16:13 PM
  • when do you need it please...
    richwhite | Oct 11, 2015, 16:17 PM
  • Weds before midnight .. and the last I can pay you is $80. ok ?
    User_5410 | Oct 11, 2015, 16:19 PM
  • yae i can manage that ...but on 100 please...
    richwhite | Oct 11, 2015, 16:22 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
bishoplampz 10 years, 11 months ago
Rated 9.2 earned 29248.80 around 749 assignments.
Hello. Kindly award me this assignment and I guarantee to work on it according to the given instructions. You can rest assured have checked the assignment requirements /instructions and am well versed and competent to deliver on the field subject. I guarantee timely delivery and a plagiarism free paper. Thank you in advance for your faith in me
$100.00
  • thats really expensive. can you lower the price?
    User_5410 | Oct 11, 2015, 16:09 PM
  • no please..this orders are even more expensive..they are always a hard nut to crack.....but i guarantee the best service..thanks
    User_4523 | Oct 11, 2015, 16:12 PM
  • when will you be done with it ?
    User_5410 | Oct 11, 2015, 16:13 PM
  • its a huge project which will enatil research and analysis but i can deliver within 30 hours from now..will you be ok with that...
    User_4523 | Oct 11, 2015, 16:16 PM
  • I need it any time before Weds midnight .. so 30 hours is ok as long as it does not be late!
    User_5410 | Oct 11, 2015, 16:18 PM
  • yes please..kindly assign and I promise to deliver the best for you. I will start working on it right away
    User_4523 | Oct 11, 2015, 16:22 PM
  • I have assigned you .. please do your best.
    User_5410 | Oct 11, 2015, 16:24 PM
  • ok..thanks
    User_4523 | Oct 11, 2015, 16:25 PM
  • Hi how are you, when will you finish ?
    User_5410 | Nov 11, 2015, 21:55 PM
  • Still working it's a bit harder tan I imagined especially getting the data. How much more time do you have?
    User_4523 | Nov 11, 2015, 22:00 PM
  • less than 7 hours to submit it
    User_5410 | Nov 11, 2015, 22:06 PM
  • OK... In 5 hours I should be done
    User_4523 | Nov 11, 2015, 22:08 PM
  • thanks!!
    User_5410 | Nov 11, 2015, 22:09 PM
  • hi, how much longer you need?
    User_5410 | Dec 11, 2015, 03:48 AM
  • I can send you the first draft with calculations in 10 minutes time... but i have to write up the deductions from the calculations...can you add me 2-3 hours please
    User_4523 | Dec 11, 2015, 03:51 AM
  • ok, but please make sure it is a final draft. but please try to finish it within 2-3 hours because i dont have much time
    User_5410 | Dec 11, 2015, 03:54 AM
  • thanks...been up all nigh researching and calculating...will be done by then
    User_4523 | Dec 11, 2015, 03:56 AM
  • hey, here are some links that might help! * Correlation coefficients (including getting returns from prices) https://www.youtube.com/watch?v=OH8GgWJ2ihM * Beta calculation https://www.youtube.com/watch?v=7LiK-qbmPsw https://www.youtube.com/watch?v=LRyFn_T94IU * Optimization https://www.youtube.com/watch?v=4dQhUCiNd64
    User_5410 | Dec 11, 2015, 04:21 AM
  • ok..checking the link ..thanks
    User_4523 | Dec 11, 2015, 04:22 AM
  • attached the excel data..will be back with the complete paper soonest possible
    User_4523 | Dec 11, 2015, 04:38 AM
  • i cant open it
    User_5410 | Dec 11, 2015, 04:39 AM
  • i can only open the zip file the other 2 files i couldnt open them
    User_5410 | Dec 11, 2015, 05:24 AM
  • use the last file..the one with an word document
    User_4523 | Dec 11, 2015, 09:44 AM
  • where is the 5-4 pages?
    User_5410 | Dec 11, 2015, 13:02 PM
  • This is finance....which of course you don't expect a lot of writing.the calculations explain everything...the ms word file is already 4 pages..and have attached two excel files to accompany the work...with the limited time..that was a lot unless you suggest otherwise
    User_4523 | Dec 11, 2015, 13:06 PM
  • the last bishoplampz12112015portfolioconstructionwork.zip has three files
    User_4523 | Dec 11, 2015, 13:07 PM
  • for the Markowitz portfolio optimization in Excel you did not write the stock names!?
    User_5410 | Dec 11, 2015, 13:10 PM
  • uploaded a more defined word document separately..check above..then Two sheets are linked Data cell things are named Meanwhile, i will name for you as you wish in a shortwhile
    User_4523 | Dec 11, 2015, 13:18 PM
  • the Variance Covariance Matrix is not clear on the last doc you sent. can you clear it please?
    User_5410 | Dec 11, 2015, 13:30 PM
  • ok..checking
    User_4523 | Dec 11, 2015, 13:48 PM
  • so what should i submit as the answers?
    User_5410 | Dec 11, 2015, 13:53 PM
  • hello?
    User_5410 | Dec 11, 2015, 16:21 PM
  • 5 mminutes please..will send you a final zipped folder
    User_4523 | Dec 11, 2015, 16:29 PM
  • use the documents in this final zipped folder bishoplampz12112015Project1..portfolioconstructionn.zip
    User_4523 | Dec 11, 2015, 16:37 PM
  • and can you send me the final excel to use?
    User_5410 | Dec 11, 2015, 16:44 PM
  • they are inside the zipped folder..those two...just extract them
    User_4523 | Dec 11, 2015, 16:52 PM
  • so the only files I need are the 3 files on the last zip folder right ?
    User_5410 | Dec 11, 2015, 17:40 PM
  • Yes please
    User_4523 | Dec 11, 2015, 17:42 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

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