# Regression analysis

Investments Project

1 1 Go tohttp://yahoocom/”>financeyahoocom, download monthly Adj close prices (adjusted for dividend and stock split) from 12/1/2008 through 12/31/2011 for the following three country indexes

4

2 Compute monthly holding period return using Adj close prices

3 Use the EXCEL statistical functions to compute mean (AVERAGE) and standard deviation of the monthly return for each index

5

4 To achieve international diversification, John invests in the USA and India indexes What are the weights on the two indexes to achieve the optimal international portfolio? What are the mean and standard deviation of returns on his optimal international portfolio?[All calculations should be done

in EXCEL]

5 Mary instead invests in the USA and Korean indexes What are the weights on the two indexes to achieve the optimal international portfolio? What are the mean and standard deviation of returns on her optimal international portfolio?[All calculations should be done in EXCEL]

6

6 Discuss whose optimal portfolio performs better (John or Mary), and explain why Also discuss potential reason(s) that causes the difference (At least a half or one page discussion, double space)

7 Answer the following question based on annualizedmean and standard deviation of returns

Some people argue that developing country stock market like India is much riskier than developed economy stock market, eg, Korea Based on your analysis, do you agree that from US investorsâ€™ point of view (eg, Mary and John mentioned above), Indian stock index is riskier than the Korean stock index? State your reasons why you agree or disagree Relate the discussion with your analysis as well as what you have learned from the class and the textbook (At least a half page discussion, double space)

Part II:

2 Compute monthly holding period return using Adj close prices

11

3 Suppose we consider the USA S&P 500 index (^GSPC) as the market portfolio Estimate betas of DX and IP based on the index model regressions, and show your regression output (see chapter

7, page 203-206 of the textbook)

4 Based on the regression results, is there any arbitrage opportunity of trading the three securities, ^GSPC, DX and IP? Is the arbitrage opportunity reliable? And explain why? (At least a half page discussion, double space)

## Looking for help with your homework? Grab a 30% Discount and Get your paper done!

30% OFF
Turnitin Report
Formatting
Title Page
Citation
Place an Order

Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -

What Makes Us Unique?

Outstanding Quality

TheStudyPool.com is an essay writing service that helps High-school, college, University, Master’s and PhD students from distinct regions globally. Over the years, we have generated a wide range of assignments, in almost all fields. This has enhanced our ability to deliver high quality papers and outstanding work to such extents that we have retained most of our customers.

TheStudyPool.com has invested in a highly selective hiring process that is unnatural and distinct from other companies. Additionally, our reward techniques and approaches are structured in ways that motivate our writers to give high quality work on all orders.

Free revisions

Our customers can freely place orders on revision on instances where they feel that something ought to be modified after the paper has been completed. However, we highly discourage our customers from misusing this policy.

Timely delivery

At TheStudyPool.com, all papers, regardless of how URGENT, are completed within the deadline indicated by the client. At TheCoursehero.com, we encourage our writers to submit work ahead of the deadline indicated to give ample time for the client to go through the work.

Plagiarism-Free Papers

All our papers are completed from scratch with strict adherence to the instructions provided by the clients. Customers can request for a plagiarism report at their own convenience.

You can simply get in touch with our customer support team via the chat window on the Bottom right corner or via the email: support@thestudypool.com.

Try it now!

## Grab A 14% Discount on This Paper

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

Are you struggling with your academic work? Well, we are here to ensure that we complete the most daunting assignments/homework for you at affordable fee.

## Custom Essay Writing Service

You can simply select the type of paper, which could be a research paper, essay, Coursework, Case study, among others. We understand that assignments and homework form an essential part of the learning curriculum. However, you might be held up at work, in family or other personal matters to an extent that you cannot complete a certain task yet it is mandatory for you to graduate. Simply click the place order button to get started.