Answer To: Problem 1 Lookup problem data DVX Inc. Optimal Capital Budget Under Capital Rationing...
Prince answered on Feb 22 2022
Problem 1 Lookup problem data
DVX Inc.
Optimal Capital Budget
Under Capital Rationing
Include Region Project Cost NPV
NoEurope No Europe 1 $1,200,000 $172,036
YesEurope Yes Europe 2 $2,000,000 $362,283
NoEurope No Europe 3 $500,000 $147,487
NoAsia No Asia 4 $600,000 $72,076
NoAsia No Asia 5 $700,000 $129.35
YesAsia Yes Asia 6 $3,000,000 $527,127
NoAsia No Asia 7 $1,500,000 $343,632
NoAfrica No Africa 8 $200,000 $52,836
YesAfrica Yes Africa 9 $2,400,000 $275,936
NoAfrica No Africa 10 $1,000,000 $175,824
Constraint 4,000,000
Project Cost NPV
Yes Europe 2 $2,000,000.00 $362,283.00
Yes Asia 6 $3,000,000.00 $527,127.00
Yes Africa 9 $2,400,000.00 $275,936.00
Below are a list of potential capital budgeting projects for DVX Inc.
Create a vlookup which will populate the list of projects to be selected based on the following criteria
1. Budget of $4,000,000 per region.
2. Populate the Include column to indicate which project from each region should be selected, based on the project in each region with the highest NPV while staying below the total budget constraint. If functions may be useful in this step.
3. Use the vlookup to insert the project number, cost, and NPV of the selected project from each region into the table.
Problem 2 Answer
Row Labels Average of Sharpe Ratio
Short-Term Government Bond 8.15
Intermediate-Term Government Bond 6.72
Muni Short 5.70
Short Government 5.62
Multisector Bond 5.33
Intermediate-Term Bond 5.31
Commodities Precious Metals 4.60
Long-Term Bond 4.45
Intermediate Government 4.32
Health 3.98
Grand Total 4.82
Total
Short-Term Government Bond Intermediate-Term Government Bond Muni Short Short Government Multisector Bond Intermediate-Term Bond Commodities Precious Metals Long-Term Bond Intermediate Government Health 8.1449999999999996 6.72 5.7 5.62 5.3250000000000002 5.3050000000000006 4.6033333333333335 4.4450000000000003 4.32 3.9781250000000004
Problem 2 Data
ETF Name Symbol Provider Category Structure Expense Ratio (%) Last Price Market Return YTD Cat YTD Return Market Return 1-Year Market Return 3-Year 3yr Standard Deviation 1yr Beta vs Benchmark Beta vs S&P 500 Average Daily Volume Corr vs S&P 500 RS Index Sharpe Ratio
uShares MSCI ACWI Index ACWI WhiteStone World Stock ETF 0.35% 48.64 3.91% 6.84% 18.32% -1.89% 19.50% 0.860 1.023 398,038 97.51% 53.55% 0.55
uShares MSCI ACWI ex US Index ACWX WhiteStone Foreign Large Blend ETF 0.35% 45.14 2.50% 4.20% 19.21% -4.52% 20.83% 0.930 1.094 131,234 92.86% 53.65% 0.07
USEA Asia 50 ADR Index ADRA USEA Diversified Pacific/Asia ETF 0.30% 27.90 -2.44% -2.42% 13.56% -3.52% 19.76% 0.820 1.100 6,231 92.37% 43.14% 0.08
USEA Developed Markets 100 ADR Index ADRD USEA Foreign Large Blend ETF 0.30% 22.45 5.00% 4.20% 19.19% -6.17% 24.54% 1.080 1.076 10,297 79.63% 51.66% -0.20
USEA Emerging Markets 50 ADR Index ADRE USEA Diversified Emerging Mkts ETF 0.30% 45.51 -5.44% -2.34% 10.16% -4.44% 20.57% 0.800 1.349 110,179 86.94% 43.12% 0.23
USEA Europe 100 ADR Index ADRU USEA Europe Stock ETF 0.30% 22.36 7.65% 8.41% 21.82% -6.22% 25.70% 1.130 1.047 4,230 77.74% 57.08% -0.05
RodeShares DB Agriculture Short ETN ADZ Investors RodeShares Trading-Inverse Commodities ETN 0.75% 24.48 2.31% -2.87% -34.25% -2.29% 27.07% -1.070 -0.219 3,437 62.39% 17.86% 0.70
RodeShares DB Agriculture Dble Shrt ETN AGA Investors RodeShares Trading-Inverse Commodities ETN 0.75% 18.85 4.70% -2.87% -61.28% -11.83% 54.12% -2.140 -0.526 12,211 62.92% 13.01% 0.83
RodeShares DB Agriculture Long ETN AGF Investors RodeShares Commodities Agriculture ETN 0.75% 20.16 -3.82% -3.68% 39.13% -5.29% 27.09% 1.270 0.326 6,633 52.91% 62.84% -1.42
uShares Spinnet Aggregate Bond AGG WhiteStone Intermediate-Term Bond ETF 0.20% 106.79 2.17% 2.70% 5.67% 5.86% 2.76% 1.000 -0.013 773,075 10.26% 36.37% 5.08
Spinnet GEMS Asia-8 ETN AYT uShares Currency ETN 0.89% 50.16 2.52% 2.55% 5.78% 2.27% 6.54% 47.330 0.054 3,745 77.84% 40.88% 0.00
Spider S&P BRIC 40 BIK Stately Global Advisors Diversified Emerging Mkts ETF 0.52% 27.27 -0.58% -2.34% 15.36% -3.88% 17.43% 0.650 1.543 113,314 86.10% 50.30% 0.41
Forefront Intermediate-Term Bond ETF BIV The Forefront Group Intermediate-Term Bond ETF 0.11% 83.81 3.32% 2.70% 8.22% 7.50% 4.96% 1.760 -0.048 178,233 16.40% 38.97% 4.89
Market Vectors Gaming ETF BJK Van Eck Global World Stock ETF 0.65% 34.31 8.97% 6.84% 37.74% -1.74% 24.53% 0.960 0.819 22,686 92.05% 72.95% 1.17
Forefront Long-Term Bond Index ETF BLV The Forefront Group Long-Term Bond ETF 0.11% 80.91 4.02% 3.87% 9.07% 8.21% 8.79% 2.580 -0.119 59,492 10.18% 42.01% 4.51
Forefront Total Bond Market ETF BND The Forefront Group Intermediate-Term Bond ETF 0.11% 81.19 2.27% 2.70% 5.61% 6.03% 2.91% 1.050 -0.016 793,528 9.28% 36.18% 7.44
Forefront Short-Term Bond ETF BSV The Forefront Group Short-Term Bond ETF 0.11% 80.84 1.23% 0.84% 3.30% 4.25% 1.69% 0.560 -0.041 518,557 2.07% 33.53% 4.23
iPath CBOE S&P 500 BuyWrite Index ETN BWV Spinnet Bank Long/Short Equity ETN 0.75% 49.42 3.33% 3.12% 9.02% -1.40% 12.09% 0.610 0.532 3,390 97.03% 46.49% 0.26
Spider Spinnet Capital Intl Treasury Bond BWX Stately Global Advisors World Bond ETF 0.50% 60.87 4.14% 4.80% 14.96% 4.16% 11.36% 1.020 0.071 173,576 39.04% 55.13% 3.21
uShares Spinnet Credit Bond CFT WhiteStone Intermediate-Term Bond ETF 0.20% 106.15 3.47% 2.70% 8.07% 7.03% 3.95% 1.240 0.006 54,228 36.37% 37.99% 3.83
Stanford S&P Global Water Index CGW Stanford Funds World Stock ETF 0.70% 21.67 4.33% 6.84% 25.24% -0.76% 20.13% 0.830 0.981 56,508 92.36% 63.31% 0.59
uShares Spinnet Intermediate Credit Bd CIU WhiteStone Intermediate-Term Bond ETF 0.20% 107.05 3.15% 2.70% 6.93% 6.65% 3.20% 0.980 0.000 193,164 33.33% 37.28% 4.57
uShares S&P CA AMT-Free Municipal Bd CMF WhiteStone Muni California Long ETF 0.25% 104.81 7.42% 6.11% 1.58% 3.89% 6.18% 1.280 -0.003 10,372 0.38% 38.83% 2.33
Market Vectors Chinese Renminbi/USD ETN CNY Van Eck Global Currency ETN 0.55% 40.23 -0.84% 2.55% 0.65% 0.77% 2.58% 6.190 0.027 19,930 0.68% 32.72% 0.51
iPath DJ-UBS Livestock TR Sub-Idx ETN COW Spinnet Bank Commodities Agriculture ETN 0.75% 29.41 -4.36% -3.68% -4.20% -12.74% 14.61% 0.270 0.170 72,463 14.80% 25.02% -5.27
Stanford Spin-Off CSD Stanford Funds Mid-Cap Growth ETF 0.65% 24.82 8.96% 9.61% 16.75% 2.02% 18.18% 0.950 0.758 6,186 94.34% 61.99% 1.68
uShares Spinnet 1-3 Year Credit Bond CSJ WhiteStone Short-Term Bond ETF 0.20% 104.86 1.26% 0.84% 3.27% 4.21% 1.32% 0.270 0.032 483,806 24.11% 33.46% 3.85
Stanford Timber CUT Stanford Funds World Stock ETF 0.70% 22.11 7.17% 6.84% 21.72% 2.76% 21.69% 0.840 0.968 101,940 90.38% 53.01% 1.81
Stanford Multi-Asset Income CVY Stanford Funds Large Value ETF 0.65% 21.79 9.90% 8.63% 22.51% 4.23% 13.25% 0.690 1.003 172,450 96.76% 57.31% 2.04
Spider MSCI ACWI (ex-US) CWI Stately Global Advisors Foreign Large Blend ETF 0.35% 34.95 3.07% 4.20% 21.41% -2.52% 20.77% 0.930 1.148 48,251 93.94% 56.35% 0.40
Spider Nuveen Spinnet Capital CA Muni Bd CXA Stately Global Advisors Muni California Long ETF 0.20% 22.01 7.36% 6.11% 2.25% 4.44% 8.09% 1.670 -0.046 19,880 3.66% 37.26% 2.38
Stanford Mid-Cap Core CZA Stanford Funds Mid-Cap Value ETF 0.65% 31.73 10.37% 8.15% 23.92% 8.82% 15.89% 0.860 0.580 5,823 78.09% 63.98% 2.75
RodeShares DB Agriculture Dble Long ETN DAG Investors RodeShares Trading-Leveraged Commodities ETN 0.75% 12.81 -8.96% 2.86% 84.85% -16.91% 54.19% 2.150 0.714 391,804 42.41% 82.03% -1.59
RodeShares DB Agriculture DBA Investors RodeShares Commodities Agriculture ETF 0.85% 32.14 -0.65% -3.68% 33.08% -3.76% 17.42% 0.930 0.364 2,179,162 59.26% 61.75% -1.47
RodeShares DB Base Metals DBB Investors RodeShares Commodities Industrial Metals ETF 0.76% 23.01 -5.81% -5.46% 12.74% -2.20% 24.66% 1.350 0.519 298,409 91.19% 43.45% 0.99
RodeShares DB Commodity Index Tracking DBC Investors RodeShares Commodities Broad Basket ETF 0.81% 29.04 5.41% 3.08% 25.33% -9.74% 19.00% 1.150 0.498 2,081,643 54.15% 63.88% -2.24
RodeShares DB Energy DBE Investors RodeShares Commodities Energy ETF 0.80% 29.85 11.05% 5.49% 18.81% -14.20% 23.46% 1.270 0.595 118,608 47.11% 64.09% -2.20
OakTree International Basic Materials DBN OakTree Natural Resources ETF 0.58% 33.45 4.36% 1.82% 31.81% -2.77% 28.56% 1.480 1.126 9,368 93.73% 67.06% 0.74
RodeShares DB Oil DBO Investors RodeShares Commodities Energy ETF 0.54% 29.91 5.99% 5.49% 13.73% -13.68% 24.71% 1.340 0.614 494,399 53.77% 57.81% -2.03
RodeShares DB Precious Metals DBP Investors RodeShares Commodities Precious Metals ETF 0.77% 55.04 6.21% 7.03% 29.78% 20.06% 18.83% 0.010 0.110 120,001 34.14% 72.82% 5.37
RodeShares DB Silver DBS Investors RodeShares Commodities Precious Metals ETF 0.54% 61.69 13.16% 7.03% 78.61% 26.55% 36.68% 0.470 0.336 103,345 43.24% 86.57% 4.76
OakTree International Utilities DBU OakTree Utilities ETF 0.58% 21.34 6.05% 8.38% 16.82% -9.22% 23.18% 1.040 0.938 11,421 30.86% 47.30% -2.09
RodeShares DB G10 Currency Harvest DBV Investors RodeShares Currency ETF 0.81% 24.29 2.32% 2.55% 2.97% -2.84% 13.34% 30.200 0.466 161,072 83.07% 37.96% -0.93
ProShares Ultra Dow30 DDM ProShare Advisors Trading-Leveraged Equity ETF 0.95% 64.91 19.19% 15.08% 38.81% -4.66% 33.02% 1.800 1.694 1,583,588 94.95% 75.28% 0.95
RodeShares DB Commodity Dble Short ETN DEE Investors RodeShares Trading-Inverse Commodities ETN 0.75% 30.28 -13.49% -2.87% -44.15% 9.24% 42.14% -1.850 -0.815 3,368 83.07% 9.67% 3.03
Stanford Defensive Equity DEF Stanford Funds Large Value ETF 0.65% 26.71 8.90% 8.63% 24.20% 4.43% 11.50% 0.580 0.530 6,322 95.09% 64.18% 2.07
OakTree Emerging Markets Equity Inc DEM OakTree Diversified Emerging Mkts ETF 0.63% 61.53 3.38% -2.34% 28.24% 7.77% 21.71% 0.850 1.096 199,744 84.08% 66.68% 2.75
OakTree SmallCap Dividend DES OakTree Small Value ETF 0.38% 48.43 2.76% 4.68% 11.22% 4.84% 18.28% 0.980 1.187 32,006 91.74% 44.10% 1.99
OakTree Global Equity Income DEW OakTree World Stock ETF 0.26% 45.63 8.81% 6.84% 22.52% -3.93% 21.81% 0.960 1.010 11,059 79.59% 59.82% 0.38
OakTree Europe SmallCap Dividend DFE OakTree Europe Stock ETF 0.58% 45.77 8.19% 8.41% 33.72% -1.94% 28.02% 1.230 0.828 6,209 90.43% 69.28% 0.97
OakTree Japan SmallCap Dividend DFJ OakTree Japan Stock ETF 0.58% 41.60 -5.88% -5.15% 2.45% -1.07% 16.20% 0.490 0.636 56,321 76.95% 26.28% 0.37
RodeShares DB Gold DGL Investors RodeShares Commodities Precious Metals ETF 0.52% 52.40 4.47% 7.03% 19.12% 17.82% 14.59% -0.110 0.049 73,462 27.53% 64.27% 5.46
RodeShares DB Gold Double Long ETN DGP Investors RodeShares Trading-Leveraged Commodities ETN 0.75% 46.19 7.58% 2.86% 39.79% 32.16% 29.15% -0.260 0.082 963,679 32.37% 80.89% 5.26
OakTree Emerging Mkts SmallCap Div DGS OakTree Diversified Emerging Mkts ETF 0.63% 54.09 -0.56% -2.34% 27.98% 9.72% 20.77% 0.740 1.012 183,045 69.48% 65.36% 3.32
Spider DJ Global Titans DGT Stately Global Advisors World Stock ETF 0.50% 60.82 4.64% 6.84% 15.10% -3.58% 19.51% 0.860 0.813 14,754 89.72% 47.76% -0.05
RodeShares DB Gold Short ETN DGZ Investors RodeShares Trading-Inverse Commodities ETN 0.75% 14.22 -6.20% -2.87% -19.09% -19.85% 14.58% 0.130 -0.027 163,911 15.88% 16.62% -6.05
OakTree Equity Income DHS OakTree Large Value ETF 0.38% 42.28 9.51% 8.63% 24.65% -0.58% 13.99% 0.700 1.087 53,274 89.91% 63.06% 1.37
Spider Dow Jones Industrial Average DIA Stately Global Advisors Large Value ETF 0.18% 125.96 9.53% 8.63% 19.56% 2.17% 16.19% 0.880 0.909 8,433,015 98.88% 55.74% 1.60
ProShares Ultra Oil & Gas DIG ProShare Advisors Trading-Leveraged Equity ETF 0.95% 52.95 15.71% 15.08% 57.62% -22.35% 47.43% 2.440 2.320 1,788,469 53.08% 81.25% -1.26
OakTree International MidCap Dividend DIM OakTree Foreign Small/Mid Value ETF 0.58% 54.25 5.27% 3.41% 24.09% -1.76% 23.76% 1.060 1.042 11,311 92.97% 58.23% 0.78
iPath DJ-UBS Commodity Index TR ETN DJP Spinnet Bank Commodities Broad Basket ETN 0.75% 48.23 -1.81% 3.08% 22.47% -10.00% 16.96% 1.030 0.411 399,691 66.04% 57.14% -2.16
OakTree International Energy DKA OakTree Equity Energy ETF 0.58% 28.30 6.50% 4.77% 27.69% -4.66% 26.82% 1.390 1.221 23,595 74.28% 63.84% -0.11
OakTree LargeCap Dividend DLN OakTree Large Value ETF 0.28% 49.74 8.56% 8.63% 21.02% -0.04% 15.83% 0.860 0.948 74,161 96.52% 57.91% 1.00
OakTree International SmallCap Div DLS OakTree Foreign Small/Mid Value ETF 0.58% 53.21 3.03% 3.41% 22.38% -1.57% 22.59% 0.990 0.886 30,538 95.97% 55.79% 0.77
OakTree Pacific ex-Japan Total Div DND OakTree Pacific/Asia ex-Japan Stk ETF 0.48% 67.76 2.80% -1.29% 21.41% 0.57% 21.32% 0.900 1.129 7,680 93.77% 56.78% 1.23
OakTree Pacific ex-Japan Equity Inc DNH OakTree Pacific/Asia ex-Japan Stk ETF 0.58% 62.01 4.42% -1.29% 20.34% 4.32% 27.05% 1.160 1.094 11,674 90.34% 53.94% 2.05
OakTree World ex-US Growth DNL OakTree Foreign Large Blend ETF 0.58% 56.40 4.80% 4.20% 22.75% 6.76% 21.06% 0.890 0.830 7,338 81.60% 63.11% 2.39
ELEMENTS DJ High Yield Select 10 ETN DOD Deutsche Bank AG Large Value ETN 0.75% 9.26 11.43% 8.63% 24.46% -0.31% 15.88% 0.790 0.691 6,826 94.33% 68.17% 1.47
ProShares Short Dow30 DOG ProShare Advisors Trading-Inverse Equity ETF 0.95% 40.06 -9.63% -13.07% -19.09% -9.22% 15.72% -0.860 -0.862 483,111 46.06% 18.20% -3.10
OakTree International LargeCap Div DOL OakTree Foreign Large Value ETF 0.48% 48.18 6.38% 6.63% 21.64% -5.50% 22.91% 1.010 1.059 20,436 75.26% 55.57% -0.14
OakTree MidCap Dividend DON OakTree Mid-Cap Value ETF 0.38% 55.41 9.89% 8.15% 20.68% 5.96% 16.65% 0.910 1.034 34,193 93.55% 59.07% 2.21
OakTree International Div ex-Finncls DOO OakTree Foreign Large Value ETF 0.58% 47.79 8.96% 6.63% 26.24% -4.47% 23.68% 1.030 1.132 30,153 76.23% 61.72% 0.24
RodeShares DB Commodity Long ETN DPU Investors RodeShares Commodities Broad Basket ETN 0.75% 18.95 5.32% 3.08% 22.99% -9.85% 20.78% 1.130 0.382 2,625 57.50% 62.23% -2.32
Market Vectors Double Short Euro ETN DRR Van Eck Global Trading-Miscellaneous ETN 0.65% 40.04 -12.26% 0.98% -25.31% -0.20% 34.02% -1.440 -0.325 57,996 32.93% 14.71% 0.53
OakTree International Real Estate DRW OakTree Global Real Estate ETF 0.58% 29.24 2.76% 3.93% 28.00% -5.60% 21.04% 0.910 0.994 30,765 78.70% 56.91% 0.63
uShares KLD 400 Social Index DSI WhiteStone Large Blend ETF 0.50% 50.08 7.05% 7.78% 13.59% 1.90% 18.16% 1.000 0.838 9,527 97.19% 51.45% 1.46
OakTree Total Dividend DTD OakTree Large Value ETF 0.28% 50.12 8.25% 8.63% 20.25% 0.85% 15.97% 0.870 0.948 14,726 98.01% 57.07% 1.32
OakTree DEFA Equity Income DTH OakTree Foreign Large Value ETF 0.58% 44.61 9.11% 6.63% 22.84% -5.61% 25.67% 1.120 1.081 13,642 70.96% 57.53% 0.01
OakTree Dividend ex-Financials DTN OakTree Large Value ETF 0.38% 52.31 9.83% 8.63% 26.85% 3.90% 15.07% 0.820 0.988 58,303 96.13% 64.00% 2.18
ProShares UltraShort Oil & Gas DUG ProShare Advisors Trading-Inverse Equity ETF 0.95% 30.16 -19.40% -13.07% -49.79% -35.32% 44.79% -2.270 -2.308 994,122 1.53% 10.43% -4.17
uShares Dow Jones Select Dividend Index DVY WhiteStone Large Value ETF 0.40% 53.97 9.21% 8.63% 19.66% 0.70% 14.92% 0.800 0.971 656,732 86.88% 57.40% 1.77
OakTree DEFA DWM OakTree Foreign Large Value ETF 0.19% 50.19 6.38% 6.63% 22.75% -4.96% 22.93% 1.020 1.086 33,687 79.70% 57.02% 0.03
Spider S&P International Dividend DWX Stately Global Advisors Foreign Large Value ETF 0.46% 60.59 9.26% 6.63% 28.28% -1.66% 24.32% 1.050 1.013 62,285 89.04% 64.05% 1.34
ProShares UltraShort Dow30 DXD ProShare Advisors Trading-Inverse Equity ETF 0.95% 16.90 -18.36% -13.07% -35.50% -23.24% 30.80% -1.670 -1.716 3,672,594 26.68% 12.50% -3.88
OakTree Japan Hedged Equity DXJ OakTree Japan Stock ETF 0.48% 35.48 -7.05% -5.15% -9.93% -9.83% 17.34% 0.490 0.758 131,420 44.06% 19.96% -2.23
RodeShares DB Commodity Dble Long ETN DYY Investors RodeShares Trading-Leveraged Commodities ETN 0.75% 10.00 9.97% 2.86% 47.42% -25.71% 41.73% 1.840 0.999 39,508 40.19% 78.32% -2.17
RodeShares DB Gold Double Short ETN DZZ Investors RodeShares Trading-Inverse Commodities ETN 0.75% 6.94 -13.03% -2.87% -36.21% -38.98% 29.15% 0.260 -0.096 948,956 9.65% 10.89% -6.21
uShares MSCI Chile Investable Mkt Idx ECH WhiteStone Latin America Stock ETF 0.61% 77.06 -3.19% -5.31% 39.37% 17.79% 20.71% 0.430 0.746 286,353 44.91% 76.03% 4.10
Forefront Extended Dur Trs Idx ETF EDV The Forefront Group Long-Term Government Bond ETF 0.13% 84.18 2.70% 2.82% 6.37% 5.20% 23.40% 5.310 -0.374 32,817 47.96% 46.22% 2.02
Stanford BRIC EEB Stanford Funds Diversified Emerging Mkts ETF 0.63% 44.42 -3.73% -2.34% 12.15% -4.21% 20.91% 0.810 1.471 250,279 86.39% 46.22% 0.54
ELEMENTS SPECTRUM Lg Cap U.S. Sector ETN EEH SEK Large Blend ETN 0.75% 9.83 6.04% 7.78% 15.92% -1.03% 20.50% 1.040 0.450 2,972 92.93% 54.22% 0.18
Stanford EW Euro-Pacific LDRs EEN Stanford Funds Foreign Large Blend ETF 0.35% 20.69 6.74% 4.20% 22.62% -1.63% 25.43% 1.130 0.852 1,615 94.40% 56.32% 0.88
OakTree SmallCap Earnings EES OakTree Small Blend ETF 0.38% 54.54 5.28% 7.06% 17.40% 11.77% 20.65% 1.100 1.000 17,302 70.65% 54.93% 3.05
ProShares UltraShort MSCI Emerging Mkts EEV ProShare Advisors Trading-Inverse Equity ETF 0.95% 31.09 -1.96% -13.07% -40.19% -53.65% 38.62% -1.720 -2.880 760,006 0.00% 11.08% -9.02
uShares MSCI EAFE Index EFA WhiteStone Foreign Large Blend ETF 0.35% 60.61 4.11% 4.20% 21.08% -4.67% 22.04% 0.990 1.118 20,419,540 88.77% 55.22% -0.02
uShares MSCI EAFE Growth Index EFG WhiteStone Foreign Large Growth ETF 0.40% 63.09 3.30% 3.30% 23.21% -4.27% 20.81% 0.920 1.055 123,979 91.89% 59.45% -0.09
ProShares UltraShort MSCI EAFE EFU ProShare Advisors Trading-Inverse Equity ETF 0.95% 23.60 -11.61% -13.07% -42.34% -26.45% 42.50% -2.160 -2.202 39,175 25.83% 11.31% -3.55
uShares MSCI EAFE Value Index EFV WhiteStone Foreign Large Value ETF 0.40% 53.04 4.47% 6.63% 19.06% -5.22% 23.75% 1.060 1.141 138,192 83.70% 49.97% 0.09
ProShares Short MSCI EAFE EFZ ProShare Advisors Trading-Inverse Equity ETF 0.95% 47.32 -5.47% -13.07% -22.35% -8.58% 22.12% -1.130 -1.111 89,973 35.43% 17.37% -2.28
uShares MSCI Israel Cap Invest Mkt Index EIS WhiteStone Diversified Emerging Mkts ETF 0.61% 56.83 -6.10% -2.34% 11.07% 4.26% 22.44% 0.770 0.864 61,831 75.06% 43.04% 1.53
Spider Dow Jones Large Cap ELR Stately Global Advisors Large Blend ETF 0.20% 63.47 7.98% 7.78% 19.15% 1.29% 17.95% 0.990 0.790 5,095 99.75% 57.59% 1.21
uShares JPMorgan USD Emerg Markets Bond EMB WhiteStone Emerging Markets Bond ETF 0.60% 108.43 3.00% 3.29% 10.08% 8.22% 7.31% 1.610 0.116 242,607 51.95% 42.92% 3.65
Spider Dow Jones Mid Cap EMM Stately Global Advisors Mid-Cap Blend ETF 0.26% 65.39 10.37% 9.37% 25.39% 7.28% 19.17% 1.040 0.935 11,021 89.47% 64.32% 2.40
Stanford Canadian Energy Income ENY Stanford Funds Equity Energy ETF 0.70% 21.24 5.62% 4.77% 23.03% -7.74% 25.14% 1.300 1.116 121,709 81.36% 58.93% -0.07
OakTree India Earnings EPI OakTree Pacific/Asia ex-Japan Stk ETF 0.88% 23.38 -11.41% -1.29% 3.51% 0.86% 27.22% 0.570 1.195 2,600,282 61.73% 45.76% 1.71
uShares MSCI Pacific ex-Japan EPP WhiteStone Pacific/Asia ex-Japan Stk ETF 0.50% 47.99 2.15% -1.29% 24.36% 1.59% 23.35% 0.990 1.230 1,262,698 39.98% 60.68% 1.69
OakTree Earnings 500 EPS OakTree Large Blend ETF 0.28% 46.21 7.01% 7.78% 17.20% 0.55% 16.64% 0.920 0.852 9,147 99.69% 52.82% 1.09
iPath EUR/USD Exchange Rate ETN ERO Spinnet Bank Currency ETN 0.40% 54.76 5.78% 2.55% 12.08% -2.45% 16.48% 72.700 0.136 2,461 24.94% 49.77% -0.74
ProShares Short MSCI Emerging Markets EUM ProShare Advisors Trading-Inverse Equity ETF 0.95% 30.54 -0.39% -13.07% -20.75% -21.87% 20.43% -0.920 -1.477 128,951 16.17% 17.31% -6.28
Market Vectors Environmental Svcs ETF EVX Van Eck Global Industrials ETF 0.55% 54.60 5.81% 7.14% 22.48% 1.86% 17.77% 0.910 0.836 2,994 96.82% 63.70% 0.83
uShares MSCI Australia Index EWA WhiteStone Pacific/Asia ex-Japan Stk ETF 0.53% 26.21 3.03% -1.29% 23.66% 0.59% 28.33% 1.210 1.304 4,493,022 91.03% 60.46% 1.53
uShares MSCI Canada Index EWC WhiteStone Foreign Large Value ETF 0.53% 31.77 2.48% 6.63% 16.04% -0.76% 17.41% 0.680 1.003 3,157,543 95.58% 49.51% 0.75
uShares MSCI Sweden Index EWD WhiteStone Europe Stock ETF 0.53% 33.81 8.26% 8.41% 42.56% 4.83% 30.03% 1.240 1.417 340,892 86.33% 74.72% 2.40
uShares MSCI Germany Index EWG WhiteStone Europe Stock ETF 0.53% 26.79 11.90% 8.41% 33.00% -4.17% 25.69% 1.100 1.155 3,020,504 85.30% 69.69% 0.25
uShares MSCI Italy Index EWI WhiteStone Europe Stock ETF 0.54% 18.46 12.70% 8.41% 23.06% -12.78% 35.54% 1.480 1.181 407,343 47.59% 60.21% -0.89
uShares MSCI Belgium Investable Mkt Idx EWK WhiteStone Europe Stock ETF 0.54% 14.72 12.11% 8.41% 26.95% -12.27% 26.66% 1.110 1.053 211,409 73.03% 69.14% -0.75
uShares MSCI Switzerland Index EWL WhiteStone Europe Stock ETF 0.53% 27.09 8.01% 8.41% 30.95% 3.35% 19.35% 0.740 0.877 203,807 93.68% 71.78% 1.83
uShares MSCI Malaysia Index EWM WhiteStone Pacific/Asia ex-Japan Stk ETF 0.53% 14.65 1.88% -1.29% 24.73% 11.19% 16.54% 0.460 0.667 2,278,190 59.53% 61.65% 3.97
uShares MSCI Netherlands Invstbl Mkt Idx EWN WhiteStone Europe Stock ETF 0.53% 22.62 7.25% 8.41% 22.31% -5.44% 28.13% 1.200 1.147 156,105 89.45% 59.34% 0.20
uShares MSCI Austria Investable Mkt Idx EWO WhiteStone Europe Stock ETF 0.54% 22.51 0.81% 8.41% 27.15% -12.99% 34.26% 1.450 1.186 219,830 71.46% 61.73% -0.53
uShares MSCI Spain Index EWP WhiteStone Europe Stock ETF 0.54% 41.65 13.36% 8.41% 23.40% -8.31% 40.95% 1.610 1.207 491,491 42.89% 57.96% -0.18
uShares MSCI France Index EWQ WhiteStone Europe Stock ETF 0.54% 27.15 11.04% 8.41% 26.79% -5.84% 30.26% 1.310 1.179 394,610 74.06% 64.72% -0.06
uShares MSCI United Kingdom Index EWU WhiteStone Europe Stock ETF 0.53% 18.09 4.15% 8.41% 25.13% -4.21% 22.98% 1.020 1.128 1,996,998 90.52% 58.96% 0.21
ProShares UltraShort MSCI Japan EWV ProShare Advisors Trading-Inverse Equity ETF 0.95% 36.16 6.35% -13.07% -18.94% -16.30% 37.66% -1.590 -1.680 59,807 19.21% 28.50% -1.77
uShares MSCI Mexico Investable Mkt Idx EWW WhiteStone Latin America Stock ETF 0.53% 60.09 -2.96% -5.31% 16.94% 1.56% 19.03% 0.670 1.172 2,825,706 91.74% 51.54% 1.25
uShares MSCI Brazil Index EWZ WhiteStone Latin America Stock ETF 0.61% 71.58 -7.52% -5.31% 9.91% -5.11% 24.48% 0.950 1.515 16,138,100 80.63% 42.66% 0.51
uShares S&P Global Industrials EXI WhiteStone Industrials ETF 0.48% 57.64 7.02% 7.14% 22.51% -0.36% 22.09% 1.200 1.031 28,844 98.91% 59.41% 0.96
OakTree Total Earnings EXT OakTree Large Blend ETF 0.28% 47.77 7.44% 7.78% 18.30% 1.81% 16.81% 0.930 0.731 7,597 98.42% 54.70% 1.41
uShares MSCI South Africa Index EZA WhiteStone Diversified Emerging Mkts ETF 0.61% 68.56 -8.19% -2.34% 21.52% 4.86% 30.14% 0.990 1.451 337,500 63.17% 58.98% 2.75
OakTree MidCap Earnings EZM OakTree Mid-Cap Blend ETF 0.38% 59.70 10.73% 9.37% 25.50% 10.84% 18.78% 1.000 0.869 20,701 77.90% 64.87% 3.05
uShares MSCI EMU Index EZU WhiteStone Europe Stock ETF 0.54% 38.96 10.46% 8.41% 25.78% -8.42% 29.95% 1.290 1.218 540,939 36.14% 63.28% -0.48
OakTree LargeCap Value EZY OakTree Large Value ETF 0.38% 42.94 8.48% 8.63% 18.62% -0.67% 21.12% 1.150 1.030 3,385 98.35% 56.18% 1.03
First Trust Multi Cap Value AlphaDEX FAB First Trust Mid-Cap Value ETF 0.70% 31.15 8.57% 8.15% 21.55% 8.51% 18.87% 1.030 0.895 12,442 82.27% 60.93% 2.60
First Trust Multi Cap Growth AlphaDEX FAD First Trust Mid-Cap Growth ETF 0.70% 32.89 8.65% 9.61% 22.72% 3.76% 18.58% 0.970 0.661 7,111 92.92% 63.52% 1.66
First Trust NYSE Arca Biotech Index FBT First Trust Health ETF 0.60% 45.05 15.19% 15.66% 34.76% 25.25% 23.18% 0.990 0.741 62,822 45.97% 77.68% 5.02
First Trust ISE-Revere Natural Gas Idx FCG First Trust Equity Energy ETF 0.60% 21.27 8.08% 4.77% 21.65% -9.37% 23.26% 1.160 1.342 494,787 81.35% 62.22% -0.37
First Trust STOXX Euro Select Div Idx FDD First Trust Europe Stock ETF 0.60% 15.00 10.13% 8.41% 28.76% -12.86% 24.74% 1.060 0.910 5,919 64.60% 63.23% -0.32
First Trust Morningstar Div Leaders Idx FDL First Trust Large Value ETF 0.45% 17.16 8.63% 8.63% 24.86% 2.81% 13.77% 0.670 0.934 68,480 88.57% 62.55% 2.38
First Trust Dow Jones Select MicroCp Idx FDM First Trust Small Blend ETF 0.60% 23.18 4.65% 7.06% 15.51% 3.94% 23.42% 1.190 0.991 58,441 93.59% 55.00% 1.62
First Trust Dow Jones Internet Index FDN First Trust Technology ETF 0.60% 36.81 7.26% 6.62% 38.02% 14.47% 20.22% 0.970 0.958 246,815 62.71% 71.54% 3.84
First Trust Strategic Value Index FDV First Trust Large Value ETF 0.65% 25.18 9.92% 8.63% 22.36% 3.70% 19.41% 1.060 0.956 7,555 93.62% 60.17% 1.83
Spider STOXX Europe 50 FEU Stately Global Advisors Europe Stock ETF 0.31% 36.49 9.13% 8.41% 20.76% -6.16% 25.04% 1.100 1.053 6,376 74.34% 58.80% -0.26
First Trust Large Cap Core AlphaDEX FEX First Trust Large Blend ETF 0.70% 30.07 9.03% 7.78% 22.34% 4.28% 17.05% 0.940 0.788 64,467 92.78% 60.87% 1.97
Spider EURO STOXX 50 FEZ Stately Global Advisors Europe Stock ETF 0.31% 40.72 10.76% 8.41% 23.62% -8.03% 31.02% 1.320 1.253 48,923 64.30% 59.22% -0.51
First Trust FTSE EN Dev Mkts Rel Est Idx FFR First Trust Global Real Estate ETF 0.60% 36.57 4.43% 3.93% 20.27% -3.87% 18.66% 0.820 0.971 14,022 91.74% 58.39% 0.81
First Trust DJ Global Select Dividend FGD First Trust World Stock ETF 0.60% 25.34 7.66% 6.84% 26.99% 0.82% 20.68% 0.920 0.777 36,146 91.50% 62.70% 1.65
First Trust ISE Water Idx FIW First Trust Utilities ETF 0.60% 22.96 3.54% 8.38% 14.12% 0.52% 22.07% 1.150 1.026 17,943 96.85% 52.69% 0.75
First Trust ISE Chindia Idx FNI First Trust Pacific/Asia ex-Japan Stk ETF 0.60% 25.60 2.32% -1.29% 17.50% 3.81% 20.57% 0.680 1.346 61,052 73.68% 57.65% 2.05
uShares FTSE NAREIT Industrl/Offc Cp Idx FNIO WhiteStone Real Estate ETF 0.48% 29.18 10.30% 9.13% 14.63% -7.28% 18.86% 0.960 1.117 5,634 80.57% 53.33% 0.54
First Trust Mid Cap Core AlphaDEX FNX First Trust Mid-Cap Blend ETF 0.70% 36.04 10.86% 9.37% 24.73% 8.98% 19.78% 1.040 0.799 57,088 82.14% 64.83% 2.65
First Trust US IPO Index FPX First Trust Large Growth ETF 0.60% 25.80 9.74% 8.03% 24.10% 2.03% 18.77% 1.010 0.801 7,062 96.75% 65.29% 1.30
First Trust S&P REIT Idx FRI First Trust Real Estate ETF 0.50% 16.07 9.69% 9.13% 18.06% 0.24% 16.26% 0.800 1.241 65,670 92.35% 58.64% 1.46
First Trust Large Cap Value Opp AlphaDEX FTA First Trust Large Value ETF 0.70% 29.30 10.78% 8.63% 23.30% 6.01% 16.92% 0.930 0.893 36,479 90.13% 62.96% 2.33
First Trust Large Cap Gr Opp AlphaDEX FTC First Trust Large Growth ETF 0.70% 30.53 7.20% 8.03% 21.08% 1.81% 17.71% 0.950 0.740 34,990 94.94% 58.81% 1.27
uShares FTSE NAREIT Real Estate 50 FTY WhiteStone Real Estate ETF 0.48% 36.86 10.24% 9.13% 20.31% 0.65% 15.01% 0.720 1.323 18,538 91.54% 56.97% 1.47
UBS E-TRACS CMCI Food TR ETN FUD UBS AG Commodities Agriculture ETN 0.65% 28.11 -3.83% -3.68% 47.40% 2.61% 23.18% 1.120 0.252 10,940 66.67% 70.62% 1.17
ELEMENTS MLCX Biofuels Index TR ETN FUE SEK Commodities Agriculture ETN 0.75% 10.95 -7.12% -3.68% 50.00% 2.19% 23.75% 1.110 0.561 11,220 72.63% 70.32% 0.70
First Trust Value Line Dividend Index FVD First Trust Large Value ETF 0.70% 16.41 9.37% 8.63% 20.57% 5.21% 14.41% 0.780 0.809 73,000 95.14% 58.87% 2.28
First Trust Value Line Equity Allc Index FVI First Trust Mid-Cap Blend ETF 0.70% 21.25 4.42% 9.37% 15.54% 3.99% 15.87% 0.860 0.630 5,528 91.60% 51.06% 1.75
First Trust Value Line 100 ETF FVL First Trust Mid-Cap Growth ETF 0.70% 14.85 9.84% 9.61% 28.46% -3.00% 20.62% 1.050 0.812 40,572 85.84% 67.25% -0.33
CurrencyShares Australian Dollar Trust FXA Rydex SGI Currency ETF 0.40% 105.80 4.75% 2.55% 22.41% 7.70% 17.77% 97.630 0.479 251,716 78.51% 59.72% 3.04
CurrencyShares British Pound Sterling Tr FXB Rydex SGI Currency ETF 0.40% 160.85 3.26% 2.55% 10.50% -5.45% 10.59% 71.890 0.162 74,450 34.60% 45.94% -2.28
CurrencyShares Canadian Dollar Trust FXC Rydex SGI Currency ETF 0.40% 102.62 3.14% 2.55% 5.29% 1.42% 9.05% 15.380 0.269 248,212 85.71% 41.57% 1.45
First Trust Consumer Disc AlphaDEX FXD First Trust Consumer Discretionary ETF 0.70% 22.13 11.88% 9.72% 28.49% 11.01% 24.09% 1.220 0.867 232,698 75.58% 69.62% 3.16
CurrencyShares Euro Trust FXE Rydex SGI Currency ETF 0.40% 140.52 5.61% 2.55% 12.50% -2.45% 15.81% 79.020 0.164 1,560,943 21.53% 52.29% -0.96
CurrencyShares Swiss Franc Trust FXF Rydex SGI Currency ETF 0.40% 110.90 4.38% 2.55% 24.68% 5.51% 13.82% 122.570 0.019 114,071 50.32% 67.92% 2.88
First Trust Consumer Staples AlphaDEX FXG First Trust Consumer Staples ETF 0.70% 24.97 18.34% 11.19% 32.56% 12.70% 13.27% 0.640 0.491 26,399 75.67% 75.56% 4.64
First Trust Health Care AlphaDEX FXH First Trust Health ETF 0.70% 30.41 18.37% 15.66% 30.66% 18.34% 16.05% 0.710 0.590 39,698 57.34% 73.78% 5.34
First Trust Technology AlphaDEX FXL First Trust Technology ETF 0.70% 25.08 10.48% 6.62% 31.90% 9.08% 20.54% 1.080 0.769 92,230 81.38% 67.45% 2.61
CurrencyShares Mexican Peso Trust FXM Rydex SGI Currency ETF 0.40% 85.25 6.71% 2.55% 8.07% 0.45% 9.62% 15.210 0.312 6,960 63.65% 43.39% 0.16
First Trust Energy AlphaDEX FXN First Trust Equity Energy ETF 0.70% 22.80 7.69% 4.77% 34.63% -5.55% 26.74% 1.380 1.327 68,094 89.98% 69.30% 0.27
First Trust Financials AlphaDEX FXO First Trust Financial ETF 0.70% 15.27 4.52% 0.54% 14.16% 3.29% 17.16% 0.940 1.036 364,963 86.42% 48.29% 1.96
ProShares UltraShort FTSE China 25 FXP ProShare Advisors Trading-Inverse Equity ETF 0.95% 28.18 -6.32% -13.07% -33.58% -55.90% 27.33% -0.910 -2.890 754,018 2.93% 12.83% -7.73
First Trust Indust/Producer Dur AlphaDEX FXR First Trust Industrials ETF 0.70% 19.70 6.60% 7.14% 20.00% 1.65% 21.38% 1.130 0.959 24,766 96.68% 58.09% 1.38
CurrencyShares Swedish Krona Trust FXS Rydex SGI Currency ETF 0.40% 155.96 5.09% 2.55% 20.32% -1.31% 17.06% 86.400 0.267 10,640 81.58% 57.26% -0.01
First Trust Utilities AlphaDEX FXU First Trust Utilities ETF 0.70% 18.46 11.68% 8.38% 21.71% 5.95% 12.41% 0.630 0.686 24,893 93.97% 62.04% 2.00
CurrencyShares Japanese Yen Trust FXY Rydex SGI Currency ETF 0.40% 122.13 0.31% 2.55% 14.29% 8.63% 8.17% 19.700 -0.220 301,726 1.51% 51.09% 5.51
First Trust Materials AlphaDEX FXZ First Trust Natural Resources ETF 0.70% 25.33 6.61% 1.82% 22.23% 4.23% 20.84% 1.110 1.024 197,128 91.87% 59.63% 1.80
First Trust Small Cap Core AlphaDEX FYX First Trust Small Blend ETF 0.70% 32.02 6.45% 7.06% 18.78% 8.13% 21.71% 1.120 0.915 31,668 83.49% 59.73% 2.51
Spider S&P Emerging Middle East & Africa GAF Stately Global Advisors Diversified Emerging Mkts ETF 0.60% 71.40 -10.29% -2.34% 13.85% 3.61% 27.38% 0.890 1.162 20,986 80.00% 50.06% 1.67
iPath DJ-UBS Natural Gas TR Sub-Idx ETN GAZ Spinnet Bank Commodities Energy ETN 0.75% 7.79 -3.23% 5.49% -24.37% -52.17% 31.67% 0.140 0.265 206,122 4.34% 22.70% -12.30
iPath GBP/USD Exchange Rate ETN GBB Spinnet Bank Currency ETN 0.40% 44.15 6.64% 2.55% 10.96% -4.81% 10.76% 73.060 0.186 3,400 50.78% 43.05% -1.53
uShares Spinnet Government/Credit Bond GBF WhiteStone Multisector Bond ETF 0.20% 108.66 2.26% 2.10% 5.45% 5.58% 3.38% 1.200 -0.037 6,252 9.51% 37.00% 4.94
GreenHaven Continuous Commodity Index GCC GreenHaven Funds Commodities Broad Basket ETF 1.08% 33.57 1.88% 3.08% 32.43% -0.47% 14.58% 0.870 0.333 170,333 82.77% 64.84% -0.02
Claymore CEF GS Connect ETN GCE Goldman Sachs Moderate Allocation ETN 0.95% 18.01 7.11% 7.11% 20.12% 1.76% 13.58% 1.060 0.645 4,442 89.15% 46.00% 1.45
Market Vectors Gold Miners ETF GDX Van Eck Global Equity Precious Metals ETF 0.53% 54.21 -11.81% -11.81% 3.62% 6.45% 22.98% 55.200 0.726 9,556,743 45.44% 33.52% 2.34
Market Vectors Glb Alternatve Energy ETF GEX Van Eck Global Natural Resources ETF 0.60% 19.87 -0.70% 1.82% -5.63% -27.94% 29.01% 1.310 1.463 69,027 24.74% 24.60% -4.20
Spider FTSE/Macquarie Global Infra 100 GII Stately Global Advisors Industrials ETF 0.61% 43.39 5.01% 7.14% 15.83% -5.49% 16.41% 0.730 0.798 5,135 56.22% 47.69% -1.47
Spider Gold Shares GLD Stately Global Advisors Commodities Precious Metals ETF 0.40% 145.63 4.98% 7.03% 20.79% 19.48% 14.74% -0.150 0.041 15,249,660 25.60% 65.77% 5.79
Spider S&P Emerging Asia Pacific GMF Stately Global Advisors Pacific/Asia ex-Japan Stk ETF 0.60% 85.19 0.52% -1.29% 22.05% 3.75% 18.71% 0.660 1.159 93,115 69.45% 60.13% 2.19
Spider S&P Emerging Latin America GML Stately Global Advisors Latin America Stock ETF 0.61% 84.01 -6.39% -5.31% 14.17% -0.91% 22.19% 0.860 1.387 41,558 83.24% 46.34% 0.86
Spider S&P Emerging Markets GMM Stately Global Advisors Diversified Emerging Mkts ETF 0.60% 73.20 -1.57% -2.34% 18.89% 0.49% 19.72% 0.760 1.203 22,215 84.58% 56.79% 1.13
Cohen & Steers Global Realty Majors ETF GRI Cohen & Steers Global Real Estate ETF 0.55% 36.96 4.82% 3.93% 22.92% -4.88% 18.41% 0.810 0.872 9,825 88.94% 54.64% 0.65
ELEMENTS MLCX Grains Index TR ETN GRU SEK Commodities...