+1 (208) 254-6996 [email protected]
  

My formulas are not working and some are bringing inflated numbers and “na” as return fields. Who can fix?

Date

May 2021
May 31 2021

Benchmark

As of Date:May 31 2021
BENCHMARKSRETURNSStandard DeviationStandard DeviationBest Month ReturnWorst Month ReturnStandard DeviationStandard Deviation
Inception DateOne MonthThree MonthYTD1 Year3 year Annualized5 year AnnualizedSince Inception201320122011201020092008Standard DeviationStandard DeviationBest Month ReturnWorst Month ReturnStandard DeviationStandard Deviation
Test Program3 year lookbackSince Inception1 year lookback5 year lookback
CA Test 1CLIENT:/SF_CA2_BENCH.CSTM5/1/180.691.820.878.937.810.00%7.815.354.13-4.027.6794469523
CA Test 2CLIENT:/SF_CA3_BENCH.CSTM5/1/180.902.942.3114.928.770.00%8.777.385.27-6.0010.5385501716
CA Test 3CLIENT:/SF_CA4_BENCH.CSTM5/1/181.104.304.4721.979.860.00%9.8610.117.12-8.0114.1959516109
CA Test 4CLIENT:/SF_CA5_BENCH.CSTM5/1/181.375.826.9630.5011.050.00%11.0513.479.54-10.2718.6696483797
CA Test 5CLIENT:/SF_CA6_BENCH.CSTM5/1/181.516.958.8837.0712.140.00%12.1416.0711.54-11.5822.0101213893
CA Test 6CLIENT:/SF_TA2_BENCH.CSTM5/1/180.532.562.159.536.850.00%6.854.993.37-5.167.4918755384
CA Test 7CLIENT:/SF_TA3_BENCH.CSTM5/1/180.733.844.1316.788.330.00%8.337.275.15-6.8910.5698369723
CA Test 8CLIENT:/SF_TA4_BENCH.CSTM5/1/180.984.915.9323.399.660.00%9.669.966.98-8.5714.0451788511
CA Test 9CLIENT:/SF_TA5_BENCH.CSTM5/1/181.226.208.0831.6411.490.00%11.4913.189.15-10.4518.2112767377
CA Test 10CLIENT:/SF_TA6_BENCH.CSTM5/1/181.477.069.2537.5412.230.00%12.2316.0411.38-11.8321.9554902864

BM Output

CodeStrategyMonthly Return3MonthYTD1 Year3 year Annualized5 year AnnualizedSince InceptionThree Month3 year St DevStd Dev. Since InceptionStd Dev. Since Inception %
V0B1CA20.691.820.878.937.810.00%7.811.031.03%
V0B2CA30.902.942.3114.928.770.00%8.771.611.61%
V0B3CA41.104.304.4721.979.860.00%9.862.282.28%
V0B4CA51.375.826.9630.5011.050.00%11.053.073.07%
V0B5CA61.516.958.8837.0712.140.00%12.143.693.69%
V0A1TA20.532.562.159.536.850.00%6.850.940.94%
V0A2TA30.733.844.1316.788.330.00%8.331.551.55%
V0A3TA40.984.915.9323.399.660.00%9.662.242.24%
V0A4TA51.226.208.0831.6411.490.00%11.493.023.02%
V0A5TA61.477.069.2537.5412.230.00%12.233.693.69%

Test Vendor

TemplateIdReturnTypeBenchmarkIdReturn1MoReturn3MoReturn1YrReturnYTDReturn3YrCumReturn3YrAnnReturn5YrCumReturn5YrAnnReturnInceptCumReturnInceptAnnCalReturnYr-2CalReturnYr-1CalReturnYrStdDev3YrAnnDownsideStdDev3YrAnnBeta3YrAlpha3YrRSquared3YrTrErr3YrInfoRatio3YrBestReturnWorstReturnBestDateWorstDate
V0A1GV0A1G0.602.7714.062.3323.239567.2136423.247.2110.310.073.51-4.542020-112020-03
V0A1NV0A1N0.602.5713.431.9520.813696.505520.816.519.52-0.113.51-4.532020-112020-03
V0A2GV0A2G0.814.0923.084.3929.15338.9018329.158.9013.230.205.60-7.382020-112020-03
V0A2NV0A2N0.813.9022.394.0026.520768.1568226.528.1612.390.015.60-7.372020-112020-03
V0A3GV0A3G1.035.1831.236.4734.6140710.4155334.6110.4216.200.387.47-9.182020-112020-03
V0A3NV0A3N1.044.9830.476.0732.012469.6995832.019.7015.380.197.46-9.172020-112020-03
V0A4GV0A4G1.196.3740.468.5042.1963212.4508642.2012.4519.980.199.61-11.392020-112020-03
V0A4NV0A4N1.196.1839.708.1039.3623311.6987939.3611.7019.120.019.61-11.392020-112020-03
V0A5GV0A5G1.427.1647.489.9145.7460213.378945.7513.3822.680.2111.40-12.822020-112020-03
V0A5NV0A5N1.436.9746.629.4842.8725412.6288342.8712.6321.850.0211.39-12.802020-112020-03
V0B1GV0B1G0.592.0113.011.1426.305988.0955926.318.1012.03-0.513.90-4.932020-042020-03
V0B1NV0B1N0.591.8212.380.7623.754967.3628923.757.3611.20-0.693.86-4.932020-112020-03
V0B2GV0B2G0.773.1520.682.7830.821469.3686930.829.3714.67-0.355.80-7.202020-112020-03
V0B2NV0B2N0.772.9620.022.4128.186598.6294428.198.6313.84-0.535.80-7.182020-112020-03
V0B3GV0B3G1.014.5229.535.2135.5911310.6820235.5910.6817.29-0.097.75-9.332020-112020-03
V0B3NV0B3N1.014.3328.824.8132.835349.9270432.849.9316.43-0.277.75-9.332020-112020-03
V0B4GV0B4G1.306.0539.797.8840.6003612.0285840.6012.0320.370.049.90-11.882020-112020-03
V0B4NV0B4N1.305.8639.017.4937.8002811.2798937.8011.2819.52-0.149.88-11.892020-112020-03
V0B5GV0B5G1.517.1947.539.9945.7064413.3686345.7113.3722.790.2511.52-12.962020-112020-03
V0B5NV0B5N1.517.0046.759.5942.8420712.6208342.8412.6221.920.0611.51-12.952020-112020-03

MS Output

Template IDReturn TypeTemplate IDReturn Type1 Month Return (%)3 Month Return (%)1 Year Return (%)Year to Date Return (%)3 Year Annualized Return (%)Since Inception Annualized Return (%)5 Year Annualized Return (%)Standard DeviationAnnual Downside Semi-DeviationBest ReturnWorst ReturnBestDateWorstDateBestDateWorstDate
V0A1GV0A1G0.60%2.77%14.06%2.33%23.24%7.21%
V0A1NV0A1N0.60%2.57%13.43%1.95%20.81%6.51%
V0A2GV0A2G0.81%4.09%23.08%4.39%29.15%8.90%
V0A2NV0A2N0.81%3.90%22.39%4.00%26.52%8.16%
V0A3GV0A3G1.03%5.18%31.23%6.47%34.61%10.42%
V0A3NV0A3N1.04%4.98%30.47%6.07%32.01%9.70%
V0A4GV0A4G1.19%6.37%40.46%8.50%42.20%12.45%
V0A4NV0A4N1.19%6.18%39.70%8.10%39.36%11.70%
V0A5GV0A5G1.42%7.16%47.48%9.91%45.75%13.38%
V0A5NV0A5N1.43%6.97%46.62%9.48%42.87%12.63%
V0B1GV0B1G0.59%2.01%13.01%1.14%26.31%8.10%
V0B1NV0B1N0.59%1.82%12.38%0.76%23.75%7.36%
V0B2GV0B2G0.77%3.15%20.68%2.78%30.82%9.37%
V0B2NV0B2N0.77%2.96%20.02%2.41%28.19%8.63%
V0B3GV0B3G1.01%4.52%29.53%5.21%35.59%10.68%
V0B3NV0B3N1.01%4.33%28.82%4.81%32.84%9.93%
V0B4GV0B4G1.30%6.05%39.79%7.88%40.60%12.03%
V0B4NV0B4N1.30%5.86%39.01%7.49%37.80%11.28%
V0B5GV0B5G1.51%7.19%47.53%9.99%45.71%13.37%
V0B5NV0B5N1.51%7.00%46.75%9.59%42.84%12.62%

AP Final

Program Performance
May 2021
Risk CategoriesMay 20213 MonthsYTD1 Year3 Year5 YearSince Composite Start*
Advice Portfolio Non-Taxable
V0B1I. ConservativeGross0.59%2.01%1.14%13.01%N/AN/A8.10%
V0B1*5/1/2018Net0.59%1.82%0.76%12.38%N/AN/A7.36%
V0B1Benchmark69.00%182.00%87.00%8.93%N/AN/A781.00%
V0B2II. Moderately ConservativeGross0.77%3.15%2.78%20.68%N/AN/A9.37%
V0B2*5/1/2018Net0.77%2.96%2.41%20.02%N/AN/A8.63%
V0B2Benchmark90.00%294.00%231.00%14.92%N/AN/A877.00%
V0B3III. ModerateGross1.01%4.52%5.21%29.53%N/AN/A10.68%
V0B3*5/1/2018Net1.01%4.33%4.81%28.82%N/AN/A9.93%
V0B3Benchmark110.00%430.00%447.00%21.97%N/AN/A986.00%
V0B4IV. Moderately AggressiveGross1.30%6.05%7.88%39.79%N/AN/A12.03%
V0B4*5/1/2018Net1.30%5.86%7.49%39.01%N/AN/A11.28%
V0B4Benchmark137.00%582.00%696.00%30.50%N/AN/A1105.00%
V0B5V. AggressiveGross1.51%7.19%9.99%47.53%N/AN/A13.37%
V0B5*5/1/2018Net1.51%7.00%9.59%46.75%N/AN/A12.62%
V0B5Benchmark151.00%695.00%888.00%37.07%N/AN/A1214.00%
Advice Portfolio Taxable
V0A1I. ConservativeGross0.60%2.77%2.33%14.06%N/AN/A7.21%
V0A1*5/1/2018Net0.60%2.57%1.95%13.43%N/AN/A6.51%
V0A1Benchmark53.00%256.00%215.00%9.53%N/AN/A685.00%
V0A2II. Moderately ConservativeGross0.81%4.09%4.39%23.08%N/AN/A8.90%
V0A2*5/1/2018Net0.81%3.90%4.00%22.39%N/AN/A8.16%
V0A2Benchmark73.00%384.00%413.00%16.78%N/AN/A833.00%
V0A3III. ModerateGross1.03%5.18%6.47%31.23%N/AN/A10.42%
V0A3*5/1/2018Net1.04%4.98%6.07%30.47%N/AN/A9.70%
V0A3Benchmark98.00%491.00%593.00%23.39%N/AN/A966.00%
V0A4IV. Moderately AggressiveGross1.19%6.37%8.50%40.46%N/AN/A12.45%
V0A4*5/1/2018Net1.19%6.18%8.10%39.70%N/AN/A11.70%
V0A4Benchmark122.00%620.00%808.00%31.64%N/AN/A1149.00%
V0A5V. AggressiveGross1.42%7.16%9.91%47.48%N/AN/A13.38%
V0A5*5/1/2018Net1.43%6.97%9.48%46.62%N/AN/A12.63%
V0A5Benchmark147.00%706.00%925.00%37.54%N/AN/A1223.00%
Portfolio
IIIIIIIVV
Global Equity16%32%49%68%85%
US Gov / Credit FI69%53%37%19%10%
Emerging Markets FI5%5%4%3%0%
US Corporate High Yield FI5%5%5%5%0%
Money Market5%5%5%5%5%
Global Equities16%32%49%68%85%
US Fixed Income77%59%42%23%10%
Emerging Markets FI2%2%2%2%0%
US Corporate High Yield FI0%2%2%2%0%
Money Market5%5%5%5%5%

Page &P of &NNon-TaxableTaxableI. Conservative II. Moderately Conservative III. Moderate IV. Moderately Aggressive V. Aggressive

Don't use plagiarized sources. Get Your Custom Essay on
Excel Macro Help
Just from $13/Page
Order Essay

Disclosures

Page &P of &N

Sheet1

0.47335
0.1048
-1.51047
-1.9092
-3.72326
-4.01748
-5.73068
-6.09466
-8.10336
-8.43413
-0.14818
-0.52739
-2.12369
-2.50914
-4.33597
-4.71685
-6.6934
-7.04552
-8.23559
-8.5857

Order your essay today and save 10% with the discount code ESSAYHELP