You will download the recent past 3-years of weekly price data of 4 ETFS.Set frequency to weekly and time period from 1/1/2017 to 1/1/2020.

The expected annual returns of the four assets are as listed on the project powerpoint: VTI: 7.5% VWO: 9.0% VEU: 7.5% VCIT: 3.1%

Use the following questions to help guide the further building of your spreadsheet. What is the weekly variance of the risky portfolio that has 25% weight in each of VTI, VWO, VCIT, and VEU? (5 decimal places)

What is the annual expected return of the risky portfolio that has 25% weight in each of VTI, VWO, VCIT, and VEU? (2 decimal places in %)

What is the weekly volatility of the risky portfolio that has 50% weight in VTI and 50% weight in VWO? (1 decimal place, in %)

Use solver to find the weights for VTI, VWO, VCIT, and VEU that give risky portfolio with the minimum volatility. What is the weight in VCIT? (%, rounded to 1 decimal place)