# Financial modeling assignment-Portfolio Construction

Please see attached file for details.

Problem Set #7 Portfolio Construction
1. Use the following data to determine an optimal asset allocation with short sale constraints using the Excel solver. The risk free rate is 1.7%. Estimate the two asset allocations that:
Maximizes the Sharpe Ratio
Minimizes the variance.

Table 1:                  Variance Covariance Matrix
Large Cap    Bonds    Emerging Markets    Europe
Large Cap                .10           .01                  .03                       .05
Bonds                       .01          .30                  .06                      -.04
Emerging Markets   .03          .06                 .40                       .02
Europe                     .05          -.04                 .02                      .50

Table 2:    Expected Returns and Standard Deviations
E(r)     Stdev
Large Cap                  6.0%    31.6%
Bonds                         8.0%    54.8%
Emerging Markets     10.0%   63.2%
Europe                       15.0%   70.7%

2. Choose one of your asset allocations, and find an exchange traded fund (ETF) for each of the four asset classes. Make sure the ETF has data starting on January 1, 2019.

3. Generate daily return streams for each of your four ETFs starting on January 1, 2019 and ending on December 31, 2019. Next, generate a daily return stream for your portfolio over the same period (use your weightings). Simulate what would happens to \$100 invested in your portfolio on January 1, 2019. Report the total return and annualized standard deviation for your portfolio returns during 2019. Report the minimum value and draw-down of the investment during 2019.

4. Repeat and generate daily return streams for each of your four ETFs starting on January
1, 2020 and ending on December 31, 2020. Next, generate a daily return stream for your portfolio over the same period (use your weightings). Simulate what would happens to \$100 invested in your portfolio on January 1, 2020. Report the total return and annualized standard deviation for your portfolio during 2020. Report the minimum value and draw-down of the investment during 2020.

5. Discuss the performance of your portfolio in 2019 versus 2020.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.