Using monthly data, construct an efficient frontier using ONLY five different (5) ETFs (ARKK, ARKG, QQQ, REM, and XLE,) for the sample period January 2015 to December 2019 (60 observations). Indicate what the “optimal” asset allocation would be for each of the following two (2) scenarios:
- Average nominal return of 3 percent per annum, and
- Average nominal return of 6 percent per annum.
Show only the summary statistics and the diagram(s). Discuss briefly whether your answers make sense by analyzing the risk/return and correlation characteristics, and whether it would be reasonable to impose constraints (on the weights), based on the set of assets that you have chosen. Finally, compare and discuss the portfolio weights to each asset’s contribution to the risk of the overall portfolio. The assignment should be formatted as a report.
Length: Only 2 page, this includes any tables or charts; (so no cover page needed)
Please also hand in the data of ETF that you will use by formatting as EXCEL.
For these two scenario that u have to use ‘Solver’ from Excel. Building two models by using five ETFs rate of return, one is calculate % of each ETF that will make this portfolio has 3% per annually, another one is 6% per annually. AND create effiency frontier
0 comments