subject
Business, 23.06.2019 17:30 sashie0

Monthly price data for mdltx and ekwax from yahoo finance is contained in the excel spreadsheet for this exercise. there are 37 months of price data for the period from september 2009 to september 2012. (note: these prices already incorporate dividend payments.) the 36 monthly returns for each fund are also provided. calculate average (arithmetic) monthly return and standard deviation for each fund. you can use the excel functions average, stdev to derive these stats. annualize these statistics. use the correl function in excel to derive the correlation coefficient between the two sets of returns. (annual correlation is the same as monthly correlation. hence, no need to annualize this stat.) using the annualized statistics derived in step 1, compute the expected return and standard deviation for portfolios containing from 0% to 100% mdltx (and 100% to 0% ekwax) by 10% increments. graph the resulting portfolios. based on your analysis, is there any potential benefit to diversification across these two funds? explain. of the 11 portfolios you graphed, which are efficient?

ansver
Answers: 1

Another question on Business

question
Business, 21.06.2019 18:10
Grace period is a period of time before the credit card company starts charging late fees.truefalse
Answers: 1
question
Business, 22.06.2019 11:00
Down under products, ltd., of australia has budgeted sales of its popular boomerang for the next four months as follows: unit salesapril 74,000may 85,000june 114,000july 92,000the company is now in the process of preparing a production budget for the second quarter. past experience has shown that end-of-month inventory levels must equal 10% of the following month’s unit sales. the inventory at the end of march was 7,400 units.required: prepare a production budget by month and in total, for the second quarter.
Answers: 3
question
Business, 22.06.2019 18:00
If you would like to ask a question you will have to spend some points
Answers: 1
question
Business, 22.06.2019 19:30
Anew firm is developing its business plan. it will require $615,000 of assets, and it projects $450,000 of sales and $355,000 of operating costs for the first year. management is reasonably sure of these numbers because of contracts with its customers and suppliers. it can borrow at a rate of 7.5%, but the bank requires it to have a tie of at least 4.0, and if the tie falls below this level the bank will call in the loan and the firm will go bankrupt. what is the maximum debt ratio the firm can use? (hint: find the maximum dollars of interest, then the debt that produces that interest, and then the related debt ratio.)a. 41.94%b. 44.15%c. 46.47%d. 48.92%e. 51.49%
Answers: 3
You know the right answer?
Monthly price data for mdltx and ekwax from yahoo finance is contained in the excel spreadsheet for...
Questions
question
Mathematics, 17.07.2019 18:40
question
Mathematics, 17.07.2019 18:40
question
Computers and Technology, 17.07.2019 18:40