Closed

Financial Analysis

This project was awarded to professionalbba for $2 AUD / hour.

Get free quotes for a project like this
Employer working
Project Budget
$2 - $8 AUD / hour
Total Bids
3
Project Description

1. Calculate calendar year returns for each index from 2004 through 2015.

2. For each of the eight rolling five year periods from 2004 to 2015 and the entire period from 2004 to 2015, calculate the average return and standard deviation of each index, and the correlation coefficient between the indices.

3. For each of the nine time periods, calculate and graph the opportunity set using 5% increments. For each graph also calculate and graph the minimum variance portfolio and the optimal portfolio.

4. Create another graph which shows all the opportunity sets on one graph.

5. Comment on your results.

YOU HAVE TO COMPLETE 3,4,5 USING EXCEL

1 and 2 are already completed.

Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online