Investment Homework

1) Calculate the monthly returns of one Bond Index ETF and one Stock Index ETF using the past 4-5 years’ prices from Yahoo Finance.

2) Calculate the average return, standard deviation of the two ETFs and their correlation coefficient.

3) Now compute the return and the standard deviation of a portfolio (of the 2 ETFs) as you change the portfolio combinations (weights of the two ETFs).

4) Draw the Hyperbola (also known as Markowitz Bullet). Mark the Axes, Minimum Variance Portfolio, and Efficient Frontier.

5) Finally find the risk-free rate (US Treasury yield – take 5 or 10 years bond); and draw the tangent line.

Refer to this file:

Work on Excel and Submit in a word document. Ensure that all the details are available in the word document [ETF names and symbols, all the statistical numbers, portfolio risk/return, risk-free rates, the and chart(s)].


Place your order now to enjoy great discounts on this or a similar topic.

People choose us because we provide:

Essays written from scratch, 100% original,

Delivery within deadlines,

Competitive prices and excellent quality,

24/7 customer support,

Priority on their privacy,

Unlimited free revisions upon request, and

Plagiarism free work,


Order Similar Assignment Now!

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered within 4 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page: