Ĵjust need to do this part3. Create 3 Asset Allocation(s) (up to 30% - maximum 1500 words)
Investment Objectives Quarters comvisit: =DSGRID("LHAGGBD,LHGOVBD,LHMGAGG,LHCCORP,BGOVEUU,BGOVEUU,BCOREUU,LHEMAME,LHEMCOR","RY","-32Y","","Q","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")Bloomberg Barclays U.S. AggregateMSCI USA U$ Q3 19947.281119.778 Q4 19947.661178.293 Q1 19958.031182.011 Q2 19957.31297.222 Q3 19956.511425.372 Q4 19956.391541.034 Q1 19966.11633.386 Q2 19966.821727.687 Q3 19967.121811.811 Q4 19966.81871.283 Q1 19976.772026.293 Q2 19977.162084.009 Q3 19976.582455.442 Q4 19976.4862623.869 Q1 19985.9772716.982 Q2 19986.1583099.36 Q3 19986.1063206.355 Q4 19985.6042913.732 Q1 19995.6743551.723 Q2 19995.9583751.828 Q3 19996.5244001.631 Q4 19996.9153733.527 Q1 20007.3234346.659 Q2 20007.114417.244 Q3 20007.2444261.432 Q4 20006.9374163.637 Q1 20016.3543804.815 Q2 20016.1213421.967 Q3 20016.0113545.214 Q4 20015.2873182.854 Q1 20025.3623348.623 Q2 20025.6413212.058 Q3 20025.0572674.843 Q4 20024.6692578.915 Q1 20034.2372704.175 Q2 20034.0782635.724 Q3 20033.9222980.102 Q4 20034.3193125.026 Q1 20043.9223398.193 Q2 20044.3073393.086 Q3 20044.5473339.255 Q4 20044.1933360.855 Q1 20054.4213613.52 Q2 20054.6663507.828 Q3 20054.6753795.205 Q4 20055.063685.325 Q1 20065.0064034.942 Q2 20065.6224050.336 Q3 20065.7323891.377 Q4 20065.4714321.148 Q1 20075.3884557.392 Q2 20075.3924656.349 Q3 20075.7474989.372 Q4 20075.3985010.537 Q1 20084.4964488.279 Q2 20084.6344377.678 Q3 20084.9624026.294 Q4 20085.5982995.168 Q1 20093.6142816.122 Q2 20093.972871.104 Q3 20094.1233159.66 Q4 20093.6193737.235 Q1 20103.4363893.031 Q2 20103.4594173.476 Q3 20102.7433790.014 Q4 20102.4954095.297 Q1 20112.9634535.921 Q2 20113.0274655.198 Q3 20112.6964670.196 Q4 20112.534361.054 Q1 20122.1444617.087 Q2 20122.1164940.233 Q3 20121.8294902.497 Q4 20121.6635234.357 Q1 20131.7815397.793 Q2 20131.7645715.814 Q3 20132.386222.963 Q4 20132.3966340.658 Q1 20142.4396926.396 Q2 20142.3126938.2 Q3 20142.2947463.759 Q4 20142.0587073.576 Q1 20151.987604.544 Q2 20152.0198113.233 Q3 20152.4098152.422 Q4 20152.2697849.213 Q1 20162.4247303.571 Q2 20162.1278119.632 Q3 20161.9718489.174 Q4 20162.0948429.501 Q1 20172.5879032.844 Q2 20172.499301.076 Q3 20172.5489866.969 Q4 20172.52810290.437 Q1 20182.82311278.585 Q2 20183.18610819.773 Q3 20183.27511479.88 Q4 20183.56611294.231 Q1 20193.28310778.037 Q2 20193.03212076.488 Q3 20192.56812591.365 Q4 20192.32212554.967 Q1 20202.23113871.643 Q2 20201.40911793.904 Q3 20201.18413885.229 Q4 20201.1915159.345 Q1 20211.1816592.627 Q2 20211.4918327.637 EM and EAFE Sub-Cap Equities Quarters comvisit: =DSGRID("MSACWF$,MSEROP$,MSEAFE$,MSUSAML,MSLEAF$,MSMEAF$,MGSEAF$","MSRI","-32Y","","Q","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")MSCI EAFE U$MSCI EAFE :L U$MSCI EAFE :SM U$ MSCI EAFE :M U$ comvisit: =DSGRID("MSUES17,MSSUSA$,MSLUSAL,MSLUSA$","MSRI","-32Y","","Q","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")MSCI EAFE :S U$ MSCI EM U$ MSCI EM :L U$MSCI EM :SM U$MSCI EM :M U$MSCI EM :S U$ Q3 19942243.683378.919369.105360.877578.578456.149406.321379.203434.781 Q4 19942247.338378.081357.689352.181698.678535.105496.632457.042540.964 Q1 19952225.946360.262337.68333.367598.165447.132420.383383.727462.094 Q2 19952269.152378.816340.94339.935524.125435.035418.208381.062460.732 Q3 19952287.429395345.909346.052578.478490.386462.133427.8499.655 Q4 19952384.611388.66334.895334.563574.79465.771429.461400.019460.808 Q1 19962483.068407.532350.922350.249567.009492.606448.907414.914486.287 Q2 19962556.691420.355370.197370.366602.312493.701458.696425.259495.036 Q3 19962599.028415.756370.81368.682627.491492.403456.318422.575493.056 Q4 19962597.744430.572364.224367.875604.764479.809444.561409.35483.467 Q1 19972641.011424.316351.942355.748601.205508.817452.102417.693489.857 Q2 19972601.526411.663326.829334.01652.124514.212459.882424.619498.494 Q3 19972941.159495.332368.056379.519707.935550.648466.216435.722498.147 Q4 19972922.314482.461344.735357.659644.449506.519410.83389.555430.939 Q1 19982695.362439.336301.048314.997531.555362.219274.826267.589277.608 Q2 19983093.89535.584373.34392.524564.472441.432332.375317.604345.315 Q3 19983128.846544.072370.142393.572431.27351.799261.101250.65269.436 comvisit: =DSGRID("MSACWF$,MSEROP$,MSEAFE$,MSUSAML,MSLEAF$,MSMEAF$,MGSEAF$","MSRI","-32","","Q","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","") comvisit: =DSGRID("MSZEAF$,MSZEMF$","MSRI","-32Y","","Q","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")Q4 19982686.104474.85315.613338.753336.357257.497201.224187.463216.716 Q1 19993243.415543.979353.794384.01396.86264.347228.93205.502258.45 Q2 19993290.827575.916378.135403.502446.214327.423265.814248.639284.397 Q3 19993376.725604.604406.399426.97555.079384.557312.63290.337337.804 Q4 19993527.269624.532431.895446.007526.472349.19290.069271.509306.201 Q1 20004128.811725.767462.201490.872660.407485.889376.501361.04383.359 Q2 20004126.764703.309447.717473.889676.402432.395338.06317.386355.492 Q3 20003965.721697.223453.895484.294607.647427.838308.986296.652318.978 Q4 20003648.073611.563401.183429.091528.654331.628246.835235.783256.466 Q1 20013489.793593.895384.532415.25998.765487.785330.86239.677231.789241.174 Q2 20013171.831536.779363.195389.17497.42433.772289.948217.516206.964223.806 Q3 20012949.05496.775347.746371.83995.413422.132281.008212.041202.049218.032 Q4 20012689.99451.421316.494339.00786.004368.05240.241186.389176.44192.863 Q1 20022722.69452.211319.522341.85287.818454.683298.939232.912225.272235.025 Q2 20022792.434461.93335.925359.00894.019503.513328.227268.115258.69271.267 Q3 20022550.848420.042328.982344.28195.684466.153300.465248.205239.081251.286 Q4 20022313.497386.921281.694302.04178.377381.254244.913202.336194.636204.679 Q1 20032416.911402.365300.178315.79183.611443.86283.271239.114230.453241.215 Q2 20032305.228383.454292.328304.16982.507423.943266.125234.404226.45235.727 Q3 20032652.767436.691351.737359.748102.005517.347323.999285.203273.955287.781 Q4 20033003.341489.742414.039419.109124.312603.013375.464326.723318.662325.828 Q1 20043359.543546.21461.981467.178138.249681.782419.735375.089364.611375.789 Q2 20043394.496549.11483.439480.995146.363724.337448.58404.343402.782397.938 Q3 20043395.743546.582489.619488.835146.759641.729394.733361.561370.435348.283 Q4 20043483.639560.819499.26499.783149.065710.584437.612398.385408.544383.191 Q1 20053867.143617.25571.606568.867172.858806.911494.164460.248468.44445.142 Q2 20053919.717624.739584.82578.849178.876826.22509.121469.532472.933458.633 Q3 20053972.81634.186591.505583.49183.949909.287564.436507.584513.042496.61 Q4 20054221.401674.506629.956621.381196.784971.764603.234533.795537.321527.756 Q1 20064734.414750.589733.594720.917233.991193.897741.212656.68669.036645.873 Q2 20064972.989787.651773.89758.452243.8111284.901795.091708.876719.033701.038 Q3 20064791.059762.296729.423722.236221.641157.318723.784615.995629.543605.028 Q4 20065271.431837.262798.049803.811234.3331296.781806.233696.108711.086684.005 Q1 20075757.668907.27896.371896.853263.7341452.454895.865805.514819.57794.29 Q2 20076147.118964.584973.285968.72287.9951577.818965.583900.878901.015900.763 Q3 20076574.0611035.6241024.1491022.759302.6031882.7671139.2541120.2611117.1321123.585 Q4 20076659.2711054.2041003.0381007.897293.1012133.961297.891225.8861249.5721200.404 Q1 20086034.828968.762849.222856.571244.1451983.5281212.6691123.6711148.531096.863 Q2 20085929.607945.22864.5870.982248.8951918.5521182.6491034.7151060.8671006.535 Q3 20085390.802863.258773.808778.101223.4951708.0941061.864877.796912.025839.91 Q4 20083843.226617.162537.223546.258152.841057.382653.71555.885584.42524.989 Q1 20093332.516533.763472.063480.227134.236898.123555.238472.312494.524448.118 Q2 20093381.033540.048491.922494.251142.3641104.199681.823595.152612.474575.843 Q3 20093964.25633.483584.194578.22172.5871328.274813.12763.757774.067751.723 Q4 20094875.98777.176733.612720.255219.081701.9741044.376972.244978.722963.63 Q1 20104970.32794.684737.062722.952220.4061767.7691077.3731064.9041055.1081074.638 Q2 20105040.422804.035760.714741.402229.4361839.4221123.2961100.4731086.1121115.617 Q3 20104522.421718.612691.919677.653207.3231698.8331031.8751037.551033.5961041.039 Q4 20105122.014813.004791.403771.347238.6822004.0111213.2521249.8141241.0741258.272 Q1 20115323.407842.716844.41811.681259.4192078.0531262.4511284.2271261.2961307.88 Q2 20115475.897866.964867.286834.451266.1212127.5471295.1571293.1221275.4771310.7 Q3 20115356.433847.233853.252819.787262.2132067.7121255.4511261.2051258.1711262.174 Q4 20114756.297754.492744.042717.682227.5441717.791049.9211007.0511005.1991007.163 Q1 20124622.574734.166719.565693.362220.3411755.2821078.041992.26997.092985.064 Q2 20124910.673777.199782.914749.437241.6711901.3231163.0691103.1831106.1421097.823 Q3 20124702.221746.859732.856705.341224.6241740.1571064.3951018.1241012.6381022.155 Q4 20125119.943813.554797.189766.423244.7061882.3531151.3161100.0221095.7371102.635 Q1 20135620.044893.122875.859840.834269.3672036.5561245.9181197.1591183.8561209.492 Q2 20135828.111924.641916.11878.825282.0151912.9021167.9331160.7441125.4051197.459 Q3 20135943.593938.997948.481913.76290.3311839.6661122.9981112.81083.6691142.142 Q4 20136403.8741013.3091029.831977.474321.4832003.9271227.6611179.6141157.1191201.018 Q1 20146708.5021060.5171090.7791028.396343.4481908.3381165.9391151.0871118.2661184.522 Q2 20146653.0031052.5311074.3341016.626336.6721962.8341198.3581193.1241154.6831232.837 Q3 20146986.9331104.8711128.0331069.883352.4372119.3661296.8781267.9271231.7881304.847 Q4 20146210.39984.111989.298942.422307.3271965.4831203.0941183.3371140.4461228.329 Q1 20156297.743989.6871031.949990.207317.5311928.6231180.6161162.5541118.6551208.358 Q2 20156932.2911088.81141.3351092.509352.3322091.9921278.131275.0911226.1861326.133 Q3 20156915.2831084.8341147.8521095.258355.8321916.2791169.8431186.731127.9241249.912 Q4 20156497.2711013.5981112.1421052.451348.5061778.8131085.81102.6571047.7481161.981 Q1 20165818.704903.3771020.979960.38322.4811465.108891.603940.333876.5571009.599 Q2 20166324.259979.4971122.3021053.414355.5261756.7731072.431088.8741034.2761147.64 Q3 20166282.744975.471105.3381036.972350.4271823.4241114.6261116.2081066.1821169.762 Q4 20166379.607990.5471133.7891052.872364.2471895.8941163.271145.5221087.6191207.909 Q1 20176644.7571033.7691165.261088.507371.5041902.4781173.9321118.5791059.8691181.876 Q2 20176904.4791070.2431229.0171146.671392.4472046.8821260.321221.1511152.8291295.335 Q3 20177537.9431167.7731347.1031254.506431.212258.0031395.6991300.6821246.6561357.181 Q4 20177923.8461224.2611439.4261331.781464.5452442.3711514.7881386.6521324.3781452.349 Q1 20188514.6511315.2291556.3841432.315505.6362636.0751632.4721518.7121441.281601.452 Q2 20188179.8041263.0581507.11377.855493.5532558.8541581.2751487.4641414.6791564.945 Q3 20187999.9151233.4331470.371355.209476.7622381.6141474.6351357.5961297.2571421.239 Q4 20187546.3071167.1031366.1421264.148440.782166.7471342.681211.7941173.9531250.6 Q1 20197319.2631136.611300.9141207.995417.9232251.4771389.9731270.4981249.5591290.017 Q2 20197973.7271236.631424.1041322.37457.5042443.0571514.871353.3281318.391388.516 Q3 20198080.9741257.9121419.6621321.877454.4712410.1571491.9631336.4621315.0161356.266 Q4 20198084.7551254.3211435.5271338.593458.6872340.6951452.7941278.4731256.1181299.492 Q1 20208686.7111346.7051553.0961441.936498.9812625.5231631.9661414.1381396.0461429.07 Q2 20206809.8291063.1821176.0461101.274373.6982058.8751293.9591032.4651020.5211041.839 Q3 20208056.1151250.4771422.9841331.655452.3882499.3481567.1921284.8961258.9691311.163 Q4 20208132.7171248.481513.2051397.883489.3612640.241660.7011354.4921303.7561413.137 Q1 20219525.5431466.9121756.4671619.452569.423209.8262022.6991641.9041566.7351731.343 Q2 202110045.3731545.971876.9421711.612617.0113183.7311993.9361723.8861612.7891859.992 Global Equities and Bonds Quarters comvisit: =DSGRID("MSACWF$,MSEROP$,MSEAFE$,MSUSAML,MSLEAF$,MSMEAF$,MGSEAF$","MSRI","-32Y","","Q","RowHeader=true;ColHeader=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false","")MSCI AC WORLD U$Bloomberg Barclays Global Aggregate Q3 1994180.3157.367 Q4 1994186.3897.718 Q1 1995183.5028.069 Q2 1995190.017.454 Q3 1995199.1396.699 Q4 1995209.8216.574 Q1 1996219.2126.015 Q2 1996228.4826.482 Q3 1996235.5886.556 Q4 1996238.0646.338 Q1 1997248.1476.021 Q2 1997250.6346.387 Q3 1997288.1466.806 Q4 1997294.9796.483 Q1 1998285.3576.253 Q2 1998324.8856.114 Q3 1998327.5045.48 Q4 1998287.3164.721 Q1 1999348.0384.456 Q2 1999361.7984.539 Q3 1999382.2195.135 Q4 1999376.1015.465 Q1 2000441.3695.711 Q2 2000446.5215.598 Q3 2000429.5055.768 Q4 2000406.2415.076 Q1 2001378.0314.707 Q2 2001340.9384.582 Q3 2001335.8384.498 Q4 2001303.0923.994 Q1 2002316.3294.26 Q2 2002314.1044.514 Q3 2002273.1884.067 Q4 2002255.0933.781 Q1 2003268.6193.398 Q2 2003259.6923.306 Q3 2003296.6023.138 Q4 2003322.683.485 Q1 2004355.7053.228 Q2 2004357.8773.437 Q3 2004352.8993