{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Inputs","Returns","Correlation Matrix","Covar Matrix","Efficient Frontier"],"not_rendered":{"charts":1,"images":43,"macros":1,"external_links":0,"defined_names":100,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"row_number_cap","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":1048576,"n_cols":9,"rows_kept":4500,"cut":true,"hidden":false,"merged":[[10,4,10,5],[11,4,11,5],[24,7,24,8],[13,1,13,2]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0},"read":"row_number_cap"}
["Finding the Efficient Frontier"]
[]
[]
["Today's date",{"$f":"TODAY()","v":"2024-04-01"}]
["Start date  ",{"$f":"DATE(YEAR(endDate)-5, MONTH(endDate), 15)","v":"2019-03-15"}]
["End date  ",{"$f":"DATE(YEAR(B4), MONTH(B4)-1, 15)","v":"2024-03-15"}]
[]
[]
[]
[]
[null,null,null,null,"Risk-free Rate",null,0.03]
[null,null,null,null,"Market Risk Premium (Rm-Rf)",null,5.7000000000000002E-2]
[]
[null,"Ticker Symbols"]
[null,1,"jpm"]
[null,2,"xom"]
[null,3,"wmt"]
[null,4,"nke"]
[null,5,"msft"]
[null,6,"vz"]
[null,7,"amzn"]
[null,8,"ko"]
[]
[]
[null,null,null,null,null,null,null,"Enter Value for x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ignore everything below this point on this worksheet"]
[]
[]
[]
[]
[]
["If selected to be restricted, weights for these individual ETFs must be 0.2 or less"]
["Financial (XLF)"]
["Health (XLV)"]
["Energy (IYE)"]
["Technology (VGT)"]
["Utilities  (IDU)"]
["China (FXI)"]
["Japan (NKY)"]
["India (INP)"]
["Latin America (EWZ)"]
["Europe (EWG)"]
["Emerging Markets (VWO)"]
["Junk Bonds (HYG)"]
["Domestic Real Estate (VNQ)"]
["Global Real Estate (IFGL)"]
["Precious Metals (IAU)"]
["Natural Resources (VAW)"]
["Agricultural Commodities (RJA)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0,"Financial (XLF)",null,null,"if any of these are 1's then the weight must be less than .2"]
[0,"Health (XLV)"]
[0,"Energy (IYE)"]
[0,"Technology (VGT)"]
[0,"Utilities  (IDU)"]
[0,"China (FXI)"]
[0,"Japan (NKY)"]
[0,"India (INP)"]
[0,"Latin America (EWZ)"]
[0,"Europe (EWG)"]
[0,"Emerging Markets (VWO)"]
[0,"Junk Bonds (HYG)"]
[0,"Domestic Real Estate (VNQ)"]
[0,"Global Real Estate (IFGL)"]
[0,"Precious Metals (IAU)"]
[0,"Natural Resources (VAW)"]
[0,"Agricultural Commodities (RJA)"]
[0,"weights less than 50%..then 1"]
[0,"non-negative..then 1"]
["m"]
["^GSPC",null,null,null,null,null,null,null,"^GSPC"]

{"sheet":"Returns","index":1,"n_rows":69,"n_cols":21,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18]]}
[null,"PRICES",null,null,null,null,null,null,null,null,"RETURNS",null,null,null,null,null,null,null,null,"Rf",{"$f":"Inputs!$G$11","v":0.03}]
["Date","jpm","xom","wmt","nke","msft","vz","amzn","ko","S&P500",{"$f":"B2","v":"jpm"},{"$f":"C2","v":"xom"},{"$f":"D2","v":"wmt"},"nke","msft","vz","amzn","ko",{"$f":"J2","v":"S&P500"},"Rm-Rf",{"$f":"Inputs!$G$12","v":5.7000000000000002E-2}]
["2018-12-01",83.882491999999999,52.801025000000003,85.255370999999997,70.450774999999993,96.450569000000002,43.663429000000001,75.098502999999994,40.506672000000002,2506.8500979999999,"_1","_2","_3","_4","_5","_6","_7","_8"]
["2019-01-01",88.935028000000003,56.742313000000003,88.186867000000007,77.805633999999998,99.166427999999996,42.762507999999997,85.936501000000007,41.173943000000001,2704.1000979999999,{"$f":"LN(B4/B3)","v":5.8489165963407502E-2},{"$f":"LN(C4/C3)","v":7.1989590039755524E-2},{"$f":"LN(D4/D3)","v":3.3806934587672977E-2},{"$f":"LN(E4/E3)","v":9.9299606020938458E-2},{"$f":"LN(F4/F3)","v":2.776889082789652E-2},{"$f":"LN(G4/G3)","v":-2.084914936248795E-2},{"$f":"LN(H4/H3)","v":0.13480803791673834},{"$f":"LN(I4/I3)","v":1.6338903532413355E-2},{"$f":"LN(J4/J3)","v":7.5742151976753658E-2}]
["2019-02-01",90.402259999999998,61.194682999999998,91.094825999999998,81.46405,106.383377,44.668467999999997,81.991501,38.787163,2784.48999,{"$f":"LN(B5/B4)","v":1.6363186421566384E-2},7.5540113216775076E-2,3.2442956222716979E-2,4.5947973622377403E-2,7.0249803907181219E-2,4.360610144433745E-2,-4.6993067514913667E-2,-5.9716263446724788E-2,2.9295553154109054E-2]
["2019-03-01",87.690880000000007,63.259838000000002,89.751266000000001,80.019699000000003,112.473793,46.402774999999998,89.037497999999999,40.087482000000001,2834.3999020000001,-3.045136399291791E-2,3.3190350355173939E-2,-1.4858874803482183E-2,-1.7888976774816528E-2,5.5670909896868383E-2,3.8091424650538629E-2,8.2442011290889891E-2,3.2974774630741693E-2,1.7765510853122508E-2]
["2019-04-01",100.52876999999999,62.852707000000002,95.146979999999999,83.674294000000003,124.54702,44.880347999999998,96.325996000000004,42.335921999999997,2945.830078,0.13662605209607498,-6.4566521020442804E-3,5.8380720761063411E-2,4.4658967792758249E-2,0.10196307189183314,-3.335924828330894E-2,7.8680623611546902E-2,5.4571829525820771E-2,3.8560397496415821E-2]
["2019-05-01",92.490593000000004,55.407158000000003,93.851714999999999,73.490097000000006,117.947754,43.091068,88.753501999999997,42.396320000000003,2752.0600589999999,-8.3337013139231628E-2,-0.12608521372917234,-1.3706817172758162E-2,-0.12978114720778319,-5.4441551582423899E-2,-4.0684278541454587E-2,-8.1875343721610483E-2,1.4256204911792512E-3,-6.8040893892824417E-2]
["2019-06-01",97.588263999999995,60.682758,102.767754,80.200492999999994,128.22418200000001,45.295177000000002,94.681503000000006,43.940987,2941.76001,5.3650298237727864E-2,9.095081381348713E-2,9.0755590064539912E-2,8.7378999538365476E-2,8.3538390138344132E-2,4.9884822176080368E-2,6.4655772312536386E-2,3.5785963134581843E-2,6.6658301495081035E-2]
["2019-07-01",101.254341,58.885159000000002,102.665443,82.187561000000002,130.435303,43.820487999999997,93.338997000000006,45.771152000000001,2980.3798830000001,3.6878338854366324E-2,-3.0070515528371158E-2,-9.960513680631188E-4,2.4474302591386617E-2,1.7097187536012519E-2,-3.3099088257022569E-2,-1.4280664241588773E-2,4.0806494520712895E-2,1.3042724816945116E-2]
["2019-08-01",96.573738000000006,54.228821000000003,106.274277,80.725914000000003,131.957245,46.597172,88.814498999999998,47.867077000000002,2926.459961,-4.7328738238761409E-2,-8.2376569585454987E-2,3.4547695713294781E-2,-1.7944325606057271E-2,1.1600627223988736E-2,6.1438382022132344E-2,-4.9688081106002029E-2,4.4773916658975545E-2,-1.825728178481683E-2]
["2019-09-01",103.45681,56.610790000000001,110.928719,89.956985000000003,133.52024800000001,48.359802000000002,86.795501999999999,47.345280000000002,2976.73999,6.8847390024882271E-2,4.2987083200073849E-2,4.2864552744379274E-2,0.10827197266289501,1.177516814770148E-2,3.7129078850597221E-2,-2.299511364981853E-2,-1.0960808879420848E-2,1.7035250490979523E-2]
["2019-10-01",109.812408,54.173523000000003,109.601471,85.771377999999999,137.68824799999999,48.447926000000002,88.832999999999998,47.682673999999999,3037.5600589999999,5.9619297227498064E-2,-4.4007319529955319E-2,-1.2037027904246274E-2,-4.7646250537078133E-2,3.0738920388230284E-2,1.8205989575785005E-3,2.3203402538443885E-2,7.1009719460621663E-3,2.0225842365795155E-2]
["2019-11-01",116.753044,54.622481999999998,111.31192799999999,89.545119999999997,145.380798,48.76585,90.040001000000004,46.780346000000002,3140.9799800000001,6.1287440858981627E-2,8.253272690612521E-3,1.5485626393851912E-2,4.3057271229239184E-2,5.4364435964844034E-2,6.5407424032779627E-3,1.3495824559172798E-2,-1.9104945947415422E-2,3.3480265788399043E-2]
["2019-12-01",123.522865,56.620055999999998,111.078262,97.288353000000001,151.96571399999999,49.704898999999997,92.391998000000001,48.850811,3230.780029,5.6365311617570912E-2,3.5917712489614173E-2,-2.1014064153396829E-3,8.2936647748255293E-2,4.429843650844429E-2,1.9073226867047415E-2,2.5786346021183883E-2,4.330782274146186E-2,2.8188756355889417E-2]
["2020-01-01",117.284691,50.404662999999999,107.492363,92.477226000000002,164.0401,48.118228999999999,100.435997,51.54269,3225.5200199999999,-5.1822044998716912E-2,-0.11627957809417389,-3.2815212751546322E-2,-5.0716871274937736E-2,7.6455980518071842E-2,-3.2442413067883459E-2,8.3480305689690906E-2,5.3639416140748616E-2,-1.6294193652275938E-3]
["2020-02-01",103.546036,41.738827000000001,101.09858699999999,85.831924000000001,156.11900299999999,44.300212999999999,94.1875,47.209220999999999,2954.219971,-0.12458792954791426,-0.18865189192425563,-6.1323653516030592E-2,-7.4571396916042268E-2,-4.9492353952308832E-2,-8.2671601439485057E-2,-6.4233202468866962E-2,-8.782116265341755E-2,-8.7859536953221323E-2]
["2020-03-01",80.288071000000002,31.251480000000001,106.675545,79.675972000000002,152.39044200000001,43.948493999999997,97.486000000000004,39.054175999999998,2584.5900879999999,-0.25439525158511439,-0.28936506365367931,5.3695788369244865E-2,-7.4422952093703865E-2,-2.4172631428427852E-2,-7.9711278334599865E-3,3.442130156350344E-2,-0.18963942329190572,-0.13366772472854824]
["2020-04-01",85.398064000000005,38.247456,114.625816,83.951545999999993,173.165268,46.991272000000002,123.699997,40.856808000000001,2912.429932,6.1702376248251978E-2,0.20201031319578702,7.1881111380282803E-2,5.2271739287925986E-2,0.12780052009109191,6.6943525005142238E-2,0.23815047719600116,4.5123655537975073E-2,0.11942083884125214]
["2020-05-01",87.682106000000005,37.424399999999999,116.992828,94.929359000000005,177.06899999999999,47.438769999999998,122.1185,41.560169000000002,3044.3100589999999,2.6394411323500466E-2,-2.1754150143699285E-2,2.0439584356430656E-2,0.12289322644945028,2.2293042276691835E-2,9.4779445283704761E-3,-1.2867370355305958E-2,1.7068766706010745E-2,4.4286532959149118E-2]
["2020-06-01",84.753662000000006,37.520775,113.453537,94.654533000000001,197.19328300000001,45.578598,137.94099399999999,39.779518000000003,3100.290039,-3.3968887305247136E-2,2.5718814619699868E-3,-3.0719246303884121E-2,-2.8992567839940028E-3,0.1076448926041583,-4.0001562626397709E-2,0.12183412921787694,-4.3790075921877766E-2,1.822137420311417E-2]
["2020-07-01",87.078406999999999,35.305774999999997,122.56540699999999,94.229766999999995,198.64672899999999,47.521445999999997,158.233994,42.440842000000004,3271.1201169999999,2.7059987909234202E-2,-6.0848231282706625E-2,7.7251434716545914E-2,-4.4976392007223011E-3,7.3436362562597892E-3,4.1742839644760575E-2,0.13724889814024721,6.4758996611884362E-2,5.363680159734547E-2]
["2020-08-01",91.156859999999995,33.510277000000002,131.51628099999999,108.015244,218.52981600000001,49.551597999999998,172.54800399999999,44.498199,3500.3100589999999,4.577281617643434E-2,-5.2194380388060596E-2,7.048583165368999E-2,0.13653623576954377,9.5394446913497688E-2,4.1833406623881964E-2,8.6600569666522215E-2,4.733756312029723E-2,6.7719083177738171E-2]
["2020-09-01",87.590286000000006,29.371638999999998,133.06510900000001,121.461021,204.29428100000001,49.735526999999998,157.43649300000001,44.35445,3363,-3.9911657469664664E-2,-0.131822619007332,1.1707895948921505E-2,0.11732103118180157,-6.7360954607619802E-2,3.7049961996451857E-3,-9.1653323912149628E-2,-3.2356745023114377E-3,-4.0018120099239295E-2]
["2020-10-01",89.200691000000006,27.908612999999999,131.96185299999999,116.178421,196.65983600000001,47.645446999999997,151.80749499999999,43.527042000000002,3269.959961,1.8218684810139225E-2,-5.1094198033208284E-2,-8.3256613930900933E-3,-4.446627500119299E-2,-3.8085992859339869E-2,-4.2932432064870921E-2,-3.6408919984196417E-2,-1.8830641821242028E-2,-2.8055692266440762E-2]
["2020-11-01",108.247147,32.622795000000004,145.31497200000001,130.323395,207.92692600000001,51.042411999999999,158.401993,46.733153999999999,3621.6298830000001,0.19352822468435407,0.15607592628819905,9.6390718854112073E-2,0.11489189372038863,5.5711185242154168E-2,6.8869820330233061E-2,4.2522823452665913E-2,7.1071448430320011E-2,0.10214642793925913]
["2020-12-01",116.68615699999999,36.117348,137.097702,136.87344400000001,216.60289,49.639823999999997,162.846497,50.057003000000002,3756.070068,7.5070900985297576E-2,0.10176202677444228,-5.8209782310054491E-2,4.903771725671674E-2,4.087897637757975E-2,-2.7863480170925686E-2,2.7671959526437605E-2,6.870856750340934E-2,3.6449047693140835E-2]
["2021-01-01",118.155411,39.289226999999997,134.10517899999999,129.509491,225.89340200000001,46.260094000000002,160.30999800000001,43.950485,3714.23999,1.2512888436621098E-2,8.4177055233117568E-2,-2.2069414965432223E-2,-5.5302564440286722E-2,4.1997538388595775E-2,-7.0513726008009564E-2,-1.5698592672562395E-2,-0.13009875671560114,-1.1199137618311695E-2]
["2021-02-01",136.116928,47.639496000000001,124.015533,130.663116,226.30242899999999,47.225006,154.6465,44.717227999999999,3811.1499020000001,0.14151348075696485,0.19271180592657938,-7.8217586085473398E-2,8.8682092544274897E-3,1.8090706880184628E-3,2.064385164460375E-2,-3.5967561099888266E-2,1.7295181899274373E-2,2.5756876645442687E-2]
["2021-03-01",140.796875,49.749523000000003,129.65695199999999,129.09278900000001,230.13256799999999,49.658847999999999,154.70399499999999,48.112777999999999,3972.889893,3.3803967819397672E-2,4.3338710532889305E-2,4.4485307946264006E-2,-1.2090936916802198E-2,1.6783239365798723E-2,5.0253041627369884E-2,3.7171429554038723E-4,7.3188955480437648E-2,4.1562807478931027E-2]
["2021-04-01",142.25824,51.005951000000003,134.109116,128.830536,246.150192,49.351418000000002,173.371002,49.682124999999999,4181.169922,1.0325748639709836E-2,2.4941436572583044E-2,3.3761635262030056E-2,-2.0335740505615721E-3,6.7286360728857561E-2,-6.2100830636268407E-3,0.11392023710632282,3.2097413745106024E-2,5.1097330391763854E-2]
["2021-05-01",152.79956100000001,52.012878000000001,136.14122,132.56079099999999,243.709946,48.760254000000003,161.153503,50.887821000000002,4204.1098629999997,7.148300617656847E-2,1.9549029574907707E-2,1.5038962245738216E-2,2.8543473893341793E-2,-9.9631139433851712E-3,-1.2050985215296114E-2,-7.3076472990903529E-2,2.3978411379160833E-2,5.4714926199284086E-3]
["2021-06-01",144.705566,57.028785999999997,135.70396400000001,150.37844799999999,265.03317299999998,48.363194,172.00799599999999,49.801769,4297.5,-5.4425905002702835E-2,9.2064816133537689E-2,-3.2169514328320129E-3,0.12611376316554013,8.3876227011085588E-2,-8.1764439024600791E-3,6.518361856816951E-2,-2.1573116353559955E-2,2.1970872633021454E-2]
["2021-07-01",141.20747399999999,52.047348,137.17626999999999,163.05190999999999,278.739777,48.147399999999998,166.379501,52.884785000000001,4395.2597660000001,-2.4470843019317321E-2,-9.1402315145681715E-2,1.07909632388238E-2,8.0913512989538236E-2,5.0423648378549485E-2,-4.4719310218645347E-3,-3.3269634412303593E-2,6.0065173858707355E-2,2.2493176007570441E-2]
["2021-08-01",149.66587799999999,49.289935999999997,142.517044,160.35566700000001,295.34222399999999,48.007458,173.53950499999999,52.217120999999999,4522.6801759999998,5.8175073902886551E-2,-5.443392047565928E-2,3.8194858424953335E-2,-1.6674349409547446E-2,5.7856117658988709E-2,-2.9107650245915355E-3,4.213393830025404E-2,-1.2705249728905058E-2,2.8578143122840471E-2]
["2021-09-01",153.16546600000001,53.982315,134.619339,141.59814499999999,276.34255999999999,47.143321999999998,164.25199900000001,48.656235000000002,4307.5400390000004,2.3113484569010762E-2,9.0936570645811218E-2,-5.7010515120755043E-2,-0.12440118606394476,-6.6493509785511939E-2,-1.8164007875788098E-2,-5.5003440230443415E-2,-7.0630468868808069E-2,-4.8737792845709803E-2]
["2021-10-01",158.966812,59.167633000000002,144.31639100000001,163.10649100000001,325.059235,46.253002000000002,168.62150600000001,52.667278000000003,4605.3798829999996,3.7176636731915652E-2,9.1718159583917297E-2,6.9556964619443537E-2,0.14141022561387909,0.16236617172476309,-1.9065996002555437E-2,2.6254766017016092E-2,7.9214391137365683E-2,6.6858175339211984E-2]
["2021-11-01",149.513474,54.918427000000001,135.82662999999999,165.007721,324.04965199999998,44.399929,175.3535,49.004764999999999,4567,-6.1308935013596862E-2,-7.452571367936206E-2,-6.0628755970768652E-2,1.1588960239969465E-2,-3.1106762957818939E-3,-4.088849962230081E-2,3.9147342687309496E-2,-7.2076813605819121E-2,-8.3686256959183726E-3]
["2021-12-01",149.06163000000001,56.912109000000001,139.74795499999999,162.502014,330.26943999999997,45.892581999999997,166.716995,55.749729000000002,4766.1801759999998,-3.0266712721992092E-3,3.5659191612832104E-2,2.8461185552617976E-2,-1.5301871206029417E-2,1.9012055201780852E-2,3.3065621467603466E-2,-5.0506202296509706E-2,0.12895501106125926,4.2688648207292887E-2]
["2022-01-01",139.88355999999999,70.649520999999993,135.57836900000001,144.62661700000001,305.38531499999999,47.014282000000001,149.57350199999999,57.44453,4515.5498049999997,-6.3549482330276047E-2,0.21622319876480756,-3.0290636521882301E-2,-0.11653502944821993,-7.8334499017516518E-2,2.4147936085230658E-2,-0.10850980998699417,2.9947237190936383E-2,-5.401822997597449E-2]
["2022-02-01",134.28251599999999,72.937538000000004,131.06912199999999,133.37451200000001,293.41461199999998,47.974018000000001,153.56300400000001,58.602657000000001,4373.9399409999996,-4.0864453353534766E-2,3.1872101834008119E-2,-3.3825009234150646E-2,-8.0994315332306444E-2,-3.9987640362622937E-2,2.020814479936758E-2,2.632300814397032E-2,1.9960250319206993E-2,-3.1862761183796384E-2]
["2022-03-01",129.09304800000001,77.667572000000007,144.412598,131.43078600000001,303.389343,45.533755999999997,162.99749800000001,58.376674999999999,4530.4101559999999,-3.9412462230073914E-2,6.2834390441372526E-2,9.6949633522117745E-2,-1.4680679912803496E-2,3.34302742638855E-2,-5.2205631687639184E-2,5.9623918668408965E-2,-3.863627484457381E-3,3.5148286309219845E-2]
["2022-04-01",113.032166,80.169044,148.933258,122.078011,273.09072900000001,41.386200000000002,124.281502,61.299819999999997,4131.9301759999998,-0.1328610136006686,3.1699633841650393E-2,3.0823806287126818E-2,-7.3820096037411631E-2,-0.10521286041895138,-9.5506449072332758E-2,-0.27118568093075529,4.8860497191835675E-2,-9.2067824799298315E-2]
["2022-05-01",126.148048,90.278335999999996,125.21917000000001,116.351028,267.53094499999997,46.404860999999997,120.209503,60.132835,4132.1499020000001,0.1097837682517724,0.11876006490950777,-0.17343271074658451,-4.8048549688733115E-2,-2.0568838742999081E-2,0.11445672474596023,-3.3313091188743461E-2,-1.9220874773002505E-2,5.3176154630096034E-5]
["2022-06-01",107.430466,81.360748000000001,118.786331,100.051109,253.319626,45.916289999999996,106.209999,59.686915999999997,3785.3798830000001,-0.16061239094754132,-0.1040045748281475,-5.2739220574864992E-2,-0.150930579693587,-5.4583206634731783E-2,-1.0584260611511877E-2,-0.12381782195806545,-7.4431978864967973E-3,-8.7651581672096149E-2]
["2022-07-01",110.05398599999999,92.086617000000004,129.015762,112.782387,276.90277099999997,41.790610999999998,134.949997,61.322231000000002,4130.2900390000004,2.4127216839273047E-2,0.12383667785154263,8.2608241557876674E-2,0.11977903782917224,8.901440209602289E-2,-9.4148258988876299E-2,0.23948606031541886,2.7029602351210852E-2,8.7201384625051226E-2]
["2022-08-01",109.458702,90.813559999999995,129.50427199999999,104.469933,257.89617900000002,38.303702999999999,126.769997,58.971404999999997,3955,-5.4236997841741958E-3,-1.3921009592259965E-2,3.7792860683981003E-3,-7.6560875738482595E-2,-7.1109340392209799E-2,-8.712512148949958E-2,-6.2529919947827542E-2,-3.9089770848442132E-2,-4.3367030648273505E-2]
["2022-09-01",100.57534,83.753235000000004,127.271637,81.573898,230.204285,34.785736,113,53.533915999999998,3585.6201169999999,-8.4640229040509496E-2,-8.0933816839457398E-2,-1.7390192672758927E-2,-0.24738997416939457,-0.11358998659443961,-9.6339157888987767E-2,-0.11498657857338955,-9.6737268433029308E-2,-9.8049166673284727E-2]
["2022-10-01",121.15239,106.295914,139.665176,91.217338999999996,229.44319200000001,34.236052999999998,102.44000200000001,57.610939000000002,3871.9799800000001,0.18614207628644064,0.23835204940234134,9.2924281826328628E-2,0.1117356662763108,-3.3116409146449542E-3,-1.5928147600904351E-2,-9.8110537857392613E-2,7.3397065895434155E-2,7.6834564400085875E-2]
["2022-11-01",134.180283,106.804321,149.56626900000001,107.958878,252.18687399999999,36.312874000000001,96.540001000000004,61.230269999999997,4080.110107,0.10213511656133907,4.7715382819666328E-3,6.8491607352182862E-2,0.16850539573406076,9.4514906732763512E-2,5.8893063946528101E-2,-5.9319840264200417E-2,6.0929212218214367E-2,5.2357976115313107E-2]
["2022-12-01",130.21839900000001,106.658455,139.13528400000001,115.16336099999999,237.712234,36.704132000000001,84,61.664527999999997,3839.5,-2.9971258084955994E-2,-1.3666647219438869E-3,-7.2292839516937005E-2,6.4601255441409114E-2,-5.9109534902159686E-2,1.0717003236027698E-2,-0.13914064174743387,7.0671796444549745E-3,-6.0781825273270251E-2]
["2023-01-01",135.908783,112.179947,141.70854199999999,125.70515399999999,245.63200399999999,38.725658000000003,103.129997,59.444564999999997,4076.6000979999999,4.2770914317279154E-2,5.047253183788266E-2,1.8325701164960989E-2,8.7587466343104603E-2,3.2773655950725143E-2,5.3613040487298307E-2,0.20517350039516502,-3.6664657132617587E-2,5.9921181918672232E-2]
["2023-02-01",140.22886700000001,106.281342,139.99468999999999,117.274124,247.227844,36.722884999999998,94.230002999999996,57.689922000000003,3970.1499020000001,3.1291904650367783E-2,-5.4014503790245444E-2,-1.2167933847682316E-2,-6.9424982578319375E-2,6.4758595511543787E-3,-5.3102247561916727E-2,-9.0251665182819671E-2,-2.9961701381311913E-2,-2.6459479030699447E-2]
["2023-03-01",127.47277800000001,106.85556,145.23477199999999,121.074997,286.48190299999999,36.798583999999998,103.290001,60.132851000000002,4109.3100590000004,-9.5373016201875854E-2,5.3882681403774621E-3,3.6747056986208351E-2,3.1896028947320069E-2,0.14736501158482779,2.0592359695596656E-3,9.1801941644362395E-2,4.1473801650141293E-2,3.4451292883708143E-2]
["2023-04-01",135.23014800000001,115.31356,149.31137100000001,125.459648,305.32235700000001,36.741810000000001,105.449997,62.665024000000003,4169.4799800000001,5.9075290995876231E-2,7.6177010629292316E-2,2.7682313429934647E-2,3.5574013478283296E-2,6.3692758304209424E-2,-1.5440224940628975E-3,2.0696302775259703E-2,4.124716318837842E-2,1.4536177438277171E-2]
["2023-05-01",133.79710399999999,99.566849000000005,145.25640899999999,104.213089,326.31906099999998,34.271853999999998,120.58000199999999,58.278961000000002,4179.830078,-1.0653623701632618E-2,-0.14682575878341111,-2.7533345051854941E-2,-0.1855464413556277,6.6507490791752652E-2,-6.9590909460729558E-2,0.13407657117247682,-7.2562307612441965E-2,2.4792715157910205E-3]
["2023-06-01",143.389938,105.41404,156.04364000000001,109.272263,339.13220200000001,35.772387999999999,130.36000100000001,58.826000000000001,4450.3798829999996,6.9243255124912653E-2,5.7066566246029994E-2,7.1635193035481007E-2,4.7404857901758524E-2,3.8514390298949965E-2,4.285187667829736E-2,7.7986411992667704E-2,9.3427806040659624E-3,6.2718864986678322E-2]
["2023-07-01",155.733475,105.40419799999999,158.704285,109.65181699999999,334.53131100000002,32.780937000000002,133.679993,60.957149999999999,4588.9599609999996,8.2578294180492728E-2,-9.3369531028466337E-5,1.6906916079634137E-2,3.4674520983574808E-3,-1.365952719185828E-2,-8.7329153487313085E-2,2.5148970282857275E-2,3.5587224273033902E-2,3.0663950879192357E-2]
["2023-08-01",145.258163,109.286591,161.43440200000001,101.029861,326.40505999999999,34.248958999999999,138.009995,58.890141,4507.6601559999999,-6.9633458711506419E-2,3.6171242425156042E-2,1.7056252784910738E-2,-8.1893919024301265E-2,-2.4591355147968279E-2,4.3809012675838241E-2,3.1877278147406395E-2,-3.4497467068919159E-2,-1.78752039120747E-2]
["2023-09-01",143.957764,116.514557,159.33819600000001,94.980591000000004,315.11044299999998,31.732669999999999,127.120003,55.100619999999999,4288.0498049999997,-8.9926428106871011E-3,6.4042511028238339E-2,-1.3069918396775116E-2,-6.1743561145512993E-2,-3.5215935346994E-2,-7.6309420536351424E-2,-8.2194564242480769E-2,-6.6512722883895273E-2,-4.9946167794944075E-2]
["2023-10-01",138.04141200000001,104.890846,162.805328,102.425163,337.42514,34.395823999999998,133.08999600000001,56.043747000000003,4193.7998049999997,-4.1966223901316331E-2,-0.10509597045599391,2.1526218119533393E-2,7.5459849375796334E-2,6.8420488228499443E-2,8.0588412112116592E-2,4.5894015215405808E-2,1.6971613824445602E-2,-2.2224840999765658E-2]
["2023-11-01",156.08000200000001,101.809021,155.11390700000001,109.900002,378.142517,38.330002,146.08999600000001,57.978340000000003,4567.7998049999997,0.12281498203215575,-2.9821532411922213E-2,-4.8395449410359628E-2,7.0438464767921649E-2,0.11392747536022954,0.10829776990940912,9.3197281720426225E-2,3.3936910332773525E-2,8.5424448194651656E-2]
["2023-12-01",166.550003,101.269997,153.14123499999999,121.022552,370.61999500000002,37.299999,152.11999499999999,57.610000999999997,4698.3500979999999,{"$f":"LN(B63/B62)","v":6.4926873523499976E-2},{"$f":"LN(C63/C62)","v":-5.3085274011738463E-3},-1.2799130726693734E-2,9.640602878746761E-2,-2.0093888217549875E-2,-2.7239631730794613E-2,4.044680742723001E-2,-6.3733114189952044E-3,2.8179758239330784E-2]
[]
["Monthly Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"STDEV(K4:K63)","v":8.1231682626832932E-2},{"$f":"STDEV(L4:L63)","v":9.8949978987207435E-2},5.1635107113244705E-2,8.8395763881872411E-2,6.2147722381988936E-2,5.1135989659646511E-2,9.3423350784131873E-2,5.6198582506427661E-2,5.3393912244192987E-2]
["Annualized Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"K65*SQRT(12)","v":0.28139480298796943},{"$f":"L65*SQRT(12)","v":0.34277278202743211},0.17886925794880193,0.30621190843452978,0.21528602548058065,0.17714026437164898,0.3236279803428922,0.19467760042896839,0.18496193764363245]
["Correlation with S&P",null,null,null,null,null,null,null,null,null,{"$f":"CORREL(K4:K63,$S$4:$S$63)","v":0.7445474951920209},{"$f":"CORREL(L4:L63,$S$4:$S$63)","v":0.52675999678610763},0.47780961538434968,0.69650261919012868,0.74609741786841999,0.4055887677267232,0.65227243500032484,0.57973659863339344,1]
["Beta",null,null,null,null,null,null,null,null,null,{"$f":"K67*(K66/$S$66)","v":1.1327292436155854},{"$f":"L67*(L66/$S$66)","v":0.97619538300371655},0.46207048019397379,1.153088029726316,0.86841838791553017,0.38843722366117023,1.1412813547574918,0.6101889466591367,1]
["Expected Return from CAPM",null,null,null,null,null,null,null,null,null,{"$f":"$U$1+K68*$U$2","v":9.4565566886088373E-2},{"$f":"$U$1+L68*$U$2","v":8.5643136831211844E-2},5.6338017371056509E-2,9.5726017694400006E-2,7.9499848111185212E-2,5.2140921748686703E-2,9.5053037221177028E-2,6.47807699595708E-2,{"$f":"$U$1+S68*$U$2","v":8.6999999999999994E-2}]

{"sheet":"Correlation Matrix","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,2,0,9]]}
[null,null,"Correlation Matrix"]
[null,null,{"$f":"Returns!K3","v":"_1"},{"$f":"Returns!L3","v":"_2"},{"$f":"Returns!M3","v":"_3"},{"$f":"Returns!N3","v":"_4"},{"$f":"Returns!O3","v":"_5"},{"$f":"Returns!P3","v":"_6"},{"$f":"Returns!Q3","v":"_7"},{"$f":"Returns!R3","v":"_8"}]
[null,null,{"$f":"Returns!B2","v":"jpm"},{"$f":"Returns!C2","v":"xom"},{"$f":"Returns!D2","v":"wmt"},{"$f":"Returns!E2","v":"nke"},{"$f":"Returns!F2","v":"msft"},{"$f":"Returns!G2","v":"vz"},{"$f":"Returns!H2","v":"amzn"},{"$f":"Returns!I2","v":"ko"},null,null,"Stand Dev","Expect Ret"]
[{"$f":"C2","v":"_1"},{"$f":"C3","v":"jpm"},{"$f":"CORREL(INDIRECT(C$2),INDIRECT($A4))","v":1.0000000000000002},0.58158022765930439,0.17012713684211014,0.5165028605751314,0.3593419007356693,0.31660694291629843,0.2278393634650106,0.45685187386624043,null,{"$f":"B4","v":"jpm"},{"$f":"Returns!K66","v":0.28139480298796943},{"$f":"Returns!K69","v":9.4565566886088373E-2}]
[{"$f":"D2","v":"_2"},{"$f":"D3","v":"xom"},0.58158022765930439,1.0000000000000002,0.1318646175756579,0.3089286865386916,0.18103165679875835,0.21588011532571807,9.6631783918056074E-2,0.37355794403034775,null,{"$f":"B5","v":"xom"},{"$f":"Returns!L66","v":0.34277278202743211},{"$f":"Returns!L69","v":8.5643136831211844E-2}]
[{"$f":"E2","v":"_3"},{"$f":"E3","v":"wmt"},0.17012713684211014,0.1318646175756579,0.99999999999999989,0.4478645053269168,0.39397759040063673,6.7759021082515233E-2,0.30091238862336495,0.33655050536383557,null,"wmt",{"$f":"Returns!M66","v":0.17886925794880193},{"$f":"Returns!M69","v":5.6338017371056509E-2}]
[{"$f":"F2","v":"_4"},{"$f":"F3","v":"nke"},0.5165028605751314,0.3089286865386916,0.4478645053269168,1,0.56910334052326705,0.38791809790450665,0.32759997335904906,0.46875020344913765,null,"nke",{"$f":"Returns!N66","v":0.30621190843452978},{"$f":"Returns!N69","v":9.5726017694400006E-2}]
[{"$f":"G2","v":"_5"},{"$f":"G3","v":"msft"},0.3593419007356693,0.18103165679875835,0.39397759040063673,0.56910334052326705,0.99999999999999989,0.32228336134725943,0.69022838437505751,0.34380475687562001,null,"msft",{"$f":"Returns!O66","v":0.21528602548058065},{"$f":"Returns!O69","v":7.9499848111185212E-2}]
[{"$f":"H2","v":"_6"},{"$f":"H3","v":"vz"},0.31660694291629843,0.21588011532571807,6.7759021082515233E-2,0.38791809790450665,0.32228336134725943,1.0000000000000002,0.21789183462802766,0.34745163543917962,null,"vz",{"$f":"Returns!P66","v":0.17714026437164898},{"$f":"Returns!P69","v":5.2140921748686703E-2}]
[{"$f":"I2","v":"_7"},{"$f":"I3","v":"amzn"},0.2278393634650106,9.6631783918056074E-2,0.30091238862336495,0.32759997335904906,0.69022838437505751,0.21789183462802766,0.99999999999999978,8.2799193068602769E-2,null,"amzn",{"$f":"Returns!Q66","v":0.3236279803428922},{"$f":"Returns!Q69","v":9.5053037221177028E-2}]
[{"$f":"J2","v":"_8"},{"$f":"J3","v":"ko"},0.45685187386624043,0.37355794403034775,0.33655050536383557,0.46875020344913765,0.34380475687562001,0.34745163543917962,8.2799193068602769E-2,0.99999999999999989,null,"ko",{"$f":"Returns!R66","v":0.19467760042896839},{"$f":"Returns!R69","v":6.47807699595708E-2}]

{"sheet":"Covar Matrix","index":3,"n_rows":1048530,"n_cols":10,"rows_kept":4500,"cut":true,"hidden":false,"merged":[[0,3,0,8],[11,3,11,8]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
[null,null,null,"Var/Cov Matrix"]
[null,null,{"$f":"'Correlation Matrix'!C3","v":"jpm"},{"$f":"'Correlation Matrix'!D3","v":"xom"},{"$f":"'Correlation Matrix'!E3","v":"wmt"},{"$f":"'Correlation Matrix'!F3","v":"nke"},{"$f":"'Correlation Matrix'!G3","v":"msft"},{"$f":"'Correlation Matrix'!H3","v":"vz"},{"$f":"'Correlation Matrix'!I3","v":"amzn"},{"$f":"'Correlation Matrix'!J3","v":"ko"}]
[null,{"$f":"C2","v":"jpm"},{"$f":"'Correlation Matrix'!C4*'Correlation Matrix'!$M$4*'Correlation Matrix'!M4","v":7.9183035148638142E-2},{"$f":"'Correlation Matrix'!D4*'Correlation Matrix'!$M$5*'Correlation Matrix'!M4","v":5.6096018127903047E-2},{"$f":"'Correlation Matrix'!E4*'Correlation Matrix'!$M$6*'Correlation Matrix'!M4","v":8.5629886955550533E-3},{"$f":"'Correlation Matrix'!F4*'Correlation Matrix'!$M$7*'Correlation Matrix'!M4","v":4.4505212562994056E-2},{"$f":"'Correlation Matrix'!G4*'Correlation Matrix'!$M$8*'Correlation Matrix'!M4","v":2.1769064845329967E-2},{"$f":"'Correlation Matrix'!H4*'Correlation Matrix'!$M$9*'Correlation Matrix'!M4","v":1.5781700423845507E-2},{"$f":"'Correlation Matrix'!I4*'Correlation Matrix'!$M$10*'Correlation Matrix'!M4","v":2.0748700118993425E-2},{"$f":"'Correlation Matrix'!J4*'Correlation Matrix'!$M$11*'Correlation Matrix'!M4","v":2.5026923576638545E-2}]
[null,{"$f":"D2","v":"xom"},{"$f":"'Correlation Matrix'!C5*'Correlation Matrix'!$M$4*'Correlation Matrix'!M5","v":5.6096018127903047E-2},{"$f":"'Correlation Matrix'!D5*'Correlation Matrix'!$M$5*'Correlation Matrix'!M5","v":0.11749318009882551},{"$f":"'Correlation Matrix'!E5*'Correlation Matrix'!$M$6*'Correlation Matrix'!M5","v":8.0848192366581688E-3},{"$f":"'Correlation Matrix'!F5*'Correlation Matrix'!$M$7*'Correlation Matrix'!M5","v":3.2425497153010234E-2},{"$f":"'Correlation Matrix'!G5*'Correlation Matrix'!$M$8*'Correlation Matrix'!M5","v":1.335908445711366E-2},{"$f":"'Correlation Matrix'!H5*'Correlation Matrix'!$M$9*'Correlation Matrix'!M5","v":1.310799476429185E-2},{"$f":"'Correlation Matrix'!I5*'Correlation Matrix'!$M$10*'Correlation Matrix'!M5","v":1.0719447199112145E-2},{"$f":"'Correlation Matrix'!J5*'Correlation Matrix'!$M$11*'Correlation Matrix'!M5","v":2.4927589853233505E-2}]
[null,{"$f":"E2","v":"wmt"},{"$f":"'Correlation Matrix'!C6*'Correlation Matrix'!$M$4*'Correlation Matrix'!M6","v":8.5629886955550533E-3},{"$f":"'Correlation Matrix'!D6*'Correlation Matrix'!$M$5*'Correlation Matrix'!M6","v":8.0848192366581688E-3},{"$f":"'Correlation Matrix'!E6*'Correlation Matrix'!$M$6*'Correlation Matrix'!M6","v":3.199421143915504E-2},{"$f":"'Correlation Matrix'!F6*'Correlation Matrix'!$M$7*'Correlation Matrix'!M6","v":2.4530388482617287E-2},{"$f":"'Correlation Matrix'!G6*'Correlation Matrix'!$M$8*'Correlation Matrix'!M6","v":1.5171309390027416E-2},{"$f":"'Correlation Matrix'!H6*'Correlation Matrix'!$M$9*'Correlation Matrix'!M6","v":2.1469410352056859E-3},{"$f":"'Correlation Matrix'!I6*'Correlation Matrix'!$M$10*'Correlation Matrix'!M6","v":1.7418944537085288E-2},{"$f":"'Correlation Matrix'!J6*'Correlation Matrix'!$M$11*'Correlation Matrix'!M6","v":1.1719307152360236E-2}]
[null,{"$f":"F2","v":"nke"},{"$f":"'Correlation Matrix'!C7*'Correlation Matrix'!$M$4*'Correlation Matrix'!M7","v":4.4505212562994063E-2},{"$f":"'Correlation Matrix'!D7*'Correlation Matrix'!$M$5*'Correlation Matrix'!M7","v":3.2425497153010227E-2},{"$f":"'Correlation Matrix'!E7*'Correlation Matrix'!$M$6*'Correlation Matrix'!M7","v":2.4530388482617283E-2},{"$f":"'Correlation Matrix'!F7*'Correlation Matrix'!$M$7*'Correlation Matrix'!M7","v":9.3765732867116855E-2},{"$f":"'Correlation Matrix'!G7*'Correlation Matrix'!$M$8*'Correlation Matrix'!M7","v":3.7517081878914497E-2},{"$f":"'Correlation Matrix'!H7*'Correlation Matrix'!$M$9*'Correlation Matrix'!M7","v":2.1041631293561028E-2},{"$f":"'Correlation Matrix'!I7*'Correlation Matrix'!$M$10*'Correlation Matrix'!M7","v":3.2464745069945768E-2},{"$f":"'Correlation Matrix'!J7*'Correlation Matrix'!$M$11*'Correlation Matrix'!M7","v":2.7943418170386307E-2}]
[null,{"$f":"G2","v":"msft"},{"$f":"'Correlation Matrix'!C8*'Correlation Matrix'!$M$4*'Correlation Matrix'!M8","v":2.1769064845329967E-2},{"$f":"'Correlation Matrix'!D8*'Correlation Matrix'!$M$5*'Correlation Matrix'!M8","v":1.335908445711366E-2},{"$f":"'Correlation Matrix'!E8*'Correlation Matrix'!$M$6*'Correlation Matrix'!M8","v":1.5171309390027417E-2},{"$f":"'Correlation Matrix'!F8*'Correlation Matrix'!$M$7*'Correlation Matrix'!M8","v":3.7517081878914497E-2},{"$f":"'Correlation Matrix'!G8*'Correlation Matrix'!$M$8*'Correlation Matrix'!M8","v":4.6348072767225218E-2},{"$f":"'Correlation Matrix'!H8*'Correlation Matrix'!$M$9*'Correlation Matrix'!M8","v":1.2290541375383887E-2},{"$f":"'Correlation Matrix'!I8*'Correlation Matrix'!$M$10*'Correlation Matrix'!M8","v":4.8089993448419292E-2},{"$f":"'Correlation Matrix'!J8*'Correlation Matrix'!$M$11*'Correlation Matrix'!M8","v":1.4409327288968383E-2}]
[null,{"$f":"H2","v":"vz"},{"$f":"'Correlation Matrix'!C9*'Correlation Matrix'!$M$4*'Correlation Matrix'!M9","v":1.578170042384551E-2},{"$f":"'Correlation Matrix'!D9*'Correlation Matrix'!$M$5*'Correlation Matrix'!M9","v":1.3107994764291848E-2},{"$f":"'Correlation Matrix'!E9*'Correlation Matrix'!$M$6*'Correlation Matrix'!M9","v":2.1469410352056863E-3},{"$f":"'Correlation Matrix'!F9*'Correlation Matrix'!$M$7*'Correlation Matrix'!M9","v":2.1041631293561028E-2},{"$f":"'Correlation Matrix'!G9*'Correlation Matrix'!$M$8*'Correlation Matrix'!M9","v":1.2290541375383886E-2},{"$f":"'Correlation Matrix'!H9*'Correlation Matrix'!$M$9*'Correlation Matrix'!M9","v":3.1378673261657698E-2},{"$f":"'Correlation Matrix'!I9*'Correlation Matrix'!$M$10*'Correlation Matrix'!M9","v":1.2491204171791679E-2},{"$f":"'Correlation Matrix'!J9*'Correlation Matrix'!$M$11*'Correlation Matrix'!M9","v":1.1981953594945815E-2}]
[null,{"$f":"I2","v":"amzn"},{"$f":"'Correlation Matrix'!C10*'Correlation Matrix'!$M$4*'Correlation Matrix'!M10","v":2.0748700118993425E-2},{"$f":"'Correlation Matrix'!D10*'Correlation Matrix'!$M$5*'Correlation Matrix'!M10","v":1.0719447199112145E-2},{"$f":"'Correlation Matrix'!E10*'Correlation Matrix'!$M$6*'Correlation Matrix'!M10","v":1.7418944537085288E-2},{"$f":"'Correlation Matrix'!F10*'Correlation Matrix'!$M$7*'Correlation Matrix'!M10","v":3.2464745069945768E-2},{"$f":"'Correlation Matrix'!G10*'Correlation Matrix'!$M$8*'Correlation Matrix'!M10","v":4.8089993448419292E-2},{"$f":"'Correlation Matrix'!H10*'Correlation Matrix'!$M$9*'Correlation Matrix'!M10","v":1.249120417179168E-2},{"$f":"'Correlation Matrix'!I10*'Correlation Matrix'!$M$10*'Correlation Matrix'!M10","v":0.1047350696608194},{"$f":"'Correlation Matrix'!J10*'Correlation Matrix'!$M$11*'Correlation Matrix'!M10","v":5.2166073845971673E-3}]
[null,{"$f":"J2","v":"ko"},{"$f":"'Correlation Matrix'!C11*'Correlation Matrix'!$M$4*'Correlation Matrix'!M11","v":2.5026923576638542E-2},{"$f":"'Correlation Matrix'!D11*'Correlation Matrix'!$M$5*'Correlation Matrix'!M11","v":2.4927589853233508E-2},{"$f":"'Correlation Matrix'!E11*'Correlation Matrix'!$M$6*'Correlation Matrix'!M11","v":1.1719307152360236E-2},{"$f":"'Correlation Matrix'!F11*'Correlation Matrix'!$M$7*'Correlation Matrix'!M11","v":2.7943418170386307E-2},{"$f":"'Correlation Matrix'!G11*'Correlation Matrix'!$M$8*'Correlation Matrix'!M11","v":1.4409327288968383E-2},{"$f":"'Correlation Matrix'!H11*'Correlation Matrix'!$M$9*'Correlation Matrix'!M11","v":1.1981953594945815E-2},{"$f":"'Correlation Matrix'!I11*'Correlation Matrix'!$M$10*'Correlation Matrix'!M11","v":5.2166073845971682E-3},{"$f":"'Correlation Matrix'!J11*'Correlation Matrix'!$M$11*'Correlation Matrix'!M11","v":3.789936810878107E-2}]
[]
[null,null,null,"Weighted Var/Cov Matrix"]
[null,null,{"$f":"C2","v":"jpm"},{"$f":"D2","v":"xom"},"wmt","nke","msft","vz","amzn","ko"]
[null,"Weights",{"$f":"B15","v":5.616452581701066E-2},{"$f":"B16","v":2.4351039850789645E-2},{"$f":"B17","v":0.42106919194851194},{"$f":"B18","v":-0.17957608571734537},{"$f":"B19","v":0.14348273773947512},{"$f":"B20","v":0.401135356540956},{"$f":"B21","v":-1.2705057601571939E-2},{"$f":"B22","v":0.14607831173377309}]
[{"$f":"B3","v":"jpm"},5.616452581701066E-2,{"$f":"C3*$B$15*C14","v":2.4977923880920938E-4},{"$f":"D3*B15*$D$14","v":7.6720538551863868E-5},{"$f":"E3*B15*$E$14","v":2.0250741697058118E-4},{"$f":"F3*B15*$F$14","v":-4.4887092665390512E-4},{"$f":"G3*B15*$G$14","v":1.7542905515919305E-4},{"$f":"H3*B15*$H$14","v":3.5555503628759209E-4},{"$f":"I3*B15*$I$14","v":-1.4805723304468653E-5},{"$f":"J3*B15*$J$14","v":2.0533137007362182E-4}]
[{"$f":"B4","v":"xom"},2.4351039850789645E-2,{"$f":"C4*B16*$C$14","v":7.6720538551863882E-5},6.9670300145006277E-5,8.2897473109849938E-5,-1.4179230278667969E-4,4.6676024766374693E-5,1.2803971935192705E-4,-3.3163971953848463E-6,8.8671395369047457E-5]
["wmt",0.42106919194851194,{"$f":"C5*B17*$C$14","v":2.0250741697058115E-4},8.2897473109849938E-5,5.6725501534817362E-3,-1.85483974743107E-3,9.1659226217033723E-4,3.6263066523389332E-4,-9.3186272828389423E-5,7.2084376230548413E-4]
["nke",-0.17957608571734537,-4.4887092665390517E-4,-1.4179230278667967E-4,-1.8548397474310693E-3,3.0237170868890528E-3,-9.6666769828308028E-4,-1.5157195423841803E-3,7.4069111682250577E-5,-7.3301653576756309E-4]
["msft",0.14348273773947512,1.7542905515919303E-4,4.6676024766374693E-5,9.1659226217033745E-4,-9.6666769828308028E-4,9.5418149444246344E-4,7.0739438908487562E-4,-8.7665963631997732E-5,3.020154090523651E-4]
["vz",0.401135356540956,3.555550362875922E-4,1.2803971935192705E-4,3.6263066523389343E-4,-1.5157195423841803E-3,7.0739438908487562E-4,5.0491289556041635E-3,-6.3660770156582101E-5,7.0210863955574008E-4]
["amzn",-1.2705057601571939E-2,-1.4805723304468653E-5,-3.3163971953848458E-6,-9.3186272828389436E-5,7.4069111682250577E-5,-8.7665963631997746E-5,-6.3660770156582128E-5,1.6906176654271876E-5,-9.6816756967513461E-6]
["ko",0.14607831173377309,2.0533137007362176E-4,8.867139536904747E-5,7.2084376230548413E-4,-7.3301653576756309E-4,3.0201540905236516E-4,7.0210863955574008E-4,-9.6816756967513478E-6,8.0872980887912677E-4]
["Sum",{"$f":"SUM(B15:B22)","v":1.0000000203115993}]
[]
["Port. Var",{"$f":"SUM(C15:J22)","v":1.4273180640114918E-2}]
["Port. S.D.",{"$f":"SQRT(B25)","v":0.11947041742672082}]
["Port. E(R.)",{"$f":"SUMPRODUCT('Correlation Matrix'!N4:N11,B15:B22)","v":5.4506663840547157E-2}]
[]
["Sharpe",{"$f":"(B27-Returns!U1)/'Covar Matrix'!B26","v":0.20512746475987439}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$b$17",{"$f":"IF(ISBLANK(A1048500)=TRUE,\"\",INDIRECT(A1048500))","v":0.42106919194851194},"this is foreign investments"]
["$b$18",{"$f":"IF(ISBLANK(A1048501)=TRUE,\"\",INDIRECT(A1048501))","v":-0.17957608571734537}]
["$b$19",{"$f":"IF(ISBLANK(A1048502)=TRUE,\"\",INDIRECT(A1048502))","v":0.14348273773947512}]
["$b$22",0.14607831173377309]
["$b$20",0.401135356540956]
["$b$21",-1.2705057601571939E-2]
[null,{"$f":"SUM(B1048500:B1048505)","v":0.9194844546437988}]
["$b$16",{"$f":"IF(ISBLANK(A1048507)=TRUE,\"\",INDIRECT(A1048507))","v":2.4351039850789645E-2},"this is fixed income"]
["$b$17",{"$f":"IF(ISBLANK(A1048508)=TRUE,\"\",INDIRECT(A1048508))","v":0.42106919194851194}]
["$b$18",{"$f":"IF(ISBLANK(A1048509)=TRUE,\"\",INDIRECT(A1048509))","v":-0.17957608571734537}]
["$b$19",0.14348273773947512]
["$b$20",0.401135356540956]
[null,{"$f":"SUM(B1048507:B1048511)","v":0.81046224036238734}]
[]
[]
[]
[]
["$b$15",{"$f":"IF(ISBLANK(A1048517)=TRUE,\"\",INDIRECT(A1048517))","v":5.616452581701066E-2},"this is real estate"]
["$b$22",{"$f":"IF(ISBLANK(A1048518)=TRUE,\"\",INDIRECT(A1048518))","v":0.14607831173377309}]
[]
[]
[]
[null,{"$f":"SUM(B1048517:B1048521)","v":0.20224283755078376}]
[]
[]
["$b$16",{"$f":"IF(ISBLANK(A1048525)=TRUE,\"\",INDIRECT(A1048525))","v":2.4351039850789645E-2},"This is for commodities"]
["$b$18",{"$f":"IF(ISBLANK(A1048526)=TRUE,\"\",INDIRECT(A1048526))","v":-0.17957608571734537}]
["$b$20",{"$f":"IF(ISBLANK(A1048527)=TRUE,\"\",INDIRECT(A1048527))","v":0.401135356540956}]
[]
[]
[null,{"$f":"SUM(B1048525:B1048529)","v":0.24591031067440028}]

{"sheet":"Efficient Frontier","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,"Efficient Frontier"]
["Expect. Ret.","Stand. Dev.",{"$f":"'Covar Matrix'!C13","v":"jpm"},{"$f":"'Covar Matrix'!D13","v":"xom"},{"$f":"'Covar Matrix'!E13","v":"wmt"},{"$f":"'Covar Matrix'!F13","v":"nke"},{"$f":"'Covar Matrix'!G13","v":"msft"},{"$f":"'Covar Matrix'!H13","v":"vz"},{"$f":"'Covar Matrix'!I13","v":"amzn"},{"$f":"'Covar Matrix'!J13","v":"ko"}]
[1.9999995507970943E-2,0.19884531993744145,-0.16224568121742058,-3.1187486218638122E-2,0.80858100919015663,-0.48994130928101348,0.1363082322310889,0.88473444535501666,-0.26866480669753012,0.12241559663833977]
[2.9999996158548731E-2,0.16436886427607758,-9.895068803569726E-2,-1.5092453548283005E-2,0.69628006260685016,-0.39999767511773093,0.13838734168685712,0.74458802772101373,-0.1944879217341724,0.12927330642116283]
[3.9999996677542074E-2,0.13688932207095664,-3.5654833296600678E-2,1.0017876747197044E-3,0.58398004498742984,-0.31005354648101219,0.14046625999039739,0.60444150677611919,-0.12031153994656729,0.1361303202955135]
[4.9999997330973905E-2,0.12126066923508667,2.763965947539334E-2,1.7097479577384739E-2,0.4716794077196953,-0.22011065348702552,0.14254562596160225,0.46429475759134814,-4.613403609893714E-2,0.14298775926053853]
[5.9999998136331834E-2,0.12212089885753025,9.0934666394041047E-2,3.3192670934680785E-2,0.35937869769532016,-0.13016730498660534,0.14462493594549533,0.32414804546880233,2.8042868627737319E-2,0.14984541992052869]
[6.9999998703508107E-2,0.13916457357084025,0.15422986600178032,4.9287483884183809E-2,0.2470779950401483,-4.0223573014014448E-2,0.14670413107574742,0.18400161889704264,0.10221962181401112,0.15670285630110106]
[8.0000077259706828E-2,0.16752321640089299,0.21752547805700997,6.5382650363302597E-2,0.13477634235076721,4.9720564169810758E-2,0.14878345173003532,4.3854035350829365E-2,0.17639707851705844,0.16356039946118642]
[8.9999999944728737E-2,0.20249693690309964,0.28082010852628353,8.1477548815073728E-2,2.2476546907839623E-2,0.13966333073012643,0.15086274508051703,-9.6291479020716081E-2,0.25057333304200796,0.17041786591886779]
[0.10000000059816408,0.24122598496980382,0.34411529639988214,9.7572515185721506E-2,-8.9824106941205073E-2,0.22960682584198827,0.15294205913996345,-0.23643805902438175,0.32475012873972403,0.17727534065830747]
[0.11000000125159959,0.28216811086086874,0.40741033709053392,0.11366758694584062,-0.20212488431119052,0.31955028091512633,0.15502147167023766,-0.3765846780663839,0.39892693892111047,0.18413294683472534]
[0.12000000188557877,0.32448668738097391,0.47070537243723259,0.12976250826413316,-0.31442550398307545,0.40949399713841317,0.15710069746430544,-0.51673117261064772,0.47310377719924063,0.1909903240903984]
[0.13000000253354127,0.36770678319698741,0.53400052054249125,0.14585758526473247,-0.42672641236660436,0.49943726000190103,0.15918017826111133,-0.65687778930751184,0.54728060563357195,0.19784805197030789]
[5.4506663840547157E-2,0.11947041742672082,5.616452581701066E-2,2.4351039850789645E-2,0.42106919194851194,-0.17957608571734537,0.14348273773947512,0.401135356540956,-1.2705057601571939E-2,0.14607831173377309,"MVP"]
[8.1956008823491744E-2,0.17395807079160869,0.22995062602138544,6.8477624368557463E-2,0.11301070039604266,6.7587672951535824E-2,0.14747276691636665,1.6594831546722047E-2,0.19157131164364627,0.16533446565083698,"MVE"]