Business > QUESTIONS & ANSWERS > BUSN1-UC MISC Risk Management - New York University: DMA Durham AM HW Write-Up _ Decision Models & A (All)
BUSN1-UC MISC Risk Management - New York University: DMA Durham AM HW Write-Up _ Decision Models & Analytics DMA Durham AM HW Write-Up 1. Use the information in the file dam.xls to create a history o... f 24 monthly returns for the 15 companies. Compute the historical average return of each stock. In particular, what was the historical return of ALCOA from 12/29/89 to 1/31/90? What was the historical return of Boeing from 5/31/90 to 6/29/90? Explain how you account for dividends and stock splits in computing monthly returns. (Note: This has already been done for you in dam.xls. If you are interested, take a look and see how “if” statements were used to deal with the stock splits.) 2. Develop 24 future scenario returns for each of the 15 stocks using equation (i). What is the explanation underlying it? In particular, what is the return of ALCOA if scenario 1 occurs? What is the return of Reynolds Metals if scenario 3 occurs? 3. Compute and graph the mean-standard deviation efficient frontier, with no shorting allowed. Compute at least six points on the efficient frontier (including the minimum standard deviation and maximum expected return points). Create a table of results showing the following for each of your points on the efficient frontier: (1) the optimal portfolio weights, (2) mean portfolio return, and (3) standard deviation. (Briefly explain the equations and optimization model used in the spreadsheet.) [Show More]
Last updated: 1 year ago
Preview 1 out of 2 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Add to cartInstant download
We Accept:
Connected school, study & course
About the document
Uploaded On
Apr 10, 2023
Number of pages
2
Written in
This document has been written for:
Uploaded
Apr 10, 2023
Downloads
0
Views
28
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·