finance case study

xlsx

School

Chandigarh University *

*We aren’t endorsed by this school

Course

101

Subject

Economics

Date

Nov 24, 2024

Type

xlsx

Pages

4

Uploaded by rcbati89

Report
Finance Case Study 1. Please research 5 tickers out of the list provided in the tabs on the excel she 2) Pick 5 securities of your choice, the same as above or different ones. Can you calculate their 0 Annual Return Column1 Column2 Column3 Column4 Column6 Annual returns for the configured portfolios Year Inflation Maximum Return at 10.00% Vo Return Balance Balance 2006 2.54% 14.45% $11,445 $11,939 2007 4.08% 13.13% $12,948 $12,941 2008 0.09% -13.08% $11,254 $10,194 2009 2.72% 15.77% $13,029 $12,577 2010 1.50% 19.75% $15,602 $14,941 2011 2.96% 11.33% $17,370 $15,545 2012 1.74% 11.18% $19,311 $17,756 2013 1.50% 3.44% $19,975 $18,546 2014 0.76% 11.64% $22,301 $20,193 2015 0.73% -2.53% $21,738 $19,401 2016 2.07% 9.67% $23,840 $21,431 2017 2.11% 16.32% $27,730 $24,842 2018 1.91% -3.03% $26,891 $23,059 2019 2.29% 24.12% $33,377 $28,195 2020 1.36% 22.92% $41,028 $31,960 2021 7.04% 10.45% $45,315 $35,502 2022 6.45% -17.17% $37,537 $29,241 Variance and co variance Stock Corelation Std Dev Variance co variance Vanguard Total Stock Market ETF 1.00 16.01% 256.32% 1.61% iShares S&P Small-Cap 600 Value ETF 0.90 20.96% 439.32% 209.60% 1. Please research 5 tickers out of the list provided in the tabs on the excel sheet, and discuss them b 1) VTI Vanguard Total Stock Market ETF An illustration of a fund that has a wide range of investments is VTI. Its massive holdings are representati small-cap stocks, which are known for higher volatility than their larger and medium-sized-company coun 2) IJS iShares S&P Small-Cap 600 Value ETF Investment performance of an index made up of small-capitalization U.S. equities that exhibit value chara 3) EFA iShares MSCI EAFE ETF It aims to mimic the performance of a market index made up of stocks from developed economies with ca 4) EEM iShares MSCI Emerging Markets ETF It aims to replicate the performance of an index made up of large and mid-cap stocks in emerging markets 5) VNQ Vanguard Real Estate ETF By buying shares issued by commercial real estate investment trusts, the fund strives to provide both stron
iShares MSCI EAFE ETF 0.88 17.73% 314.35% 0.35% iShares MSCI Emerging Markets ETF 0.76 21.84% 476.99% 2.62% Vanguard Real Estate ETF 0.75 22.70% 515.29% 0.23% 3. Allocate a portfolio of a million dollars across assets of your choice. Justify your choices using e Example; Forex.com Note that If the standard deviation is given then square the standard deviation given to find the variance Covariance is calculated by ana expected return) or multiplyin the stan The term "asset allocation" is used to describe a method of risk management in which a person's investme asset classes can be broken down into three basic groups: stocks, fixed-income, and cash and equivalents. than stocks, bonds, and currency. Deflation happens when the number of products and services grows faster than the money supply, which m corresponding increase in the money supply. Inflation occurs when the growth of the money supply outpa and services is essentially determined by the amount of money in the economy, as there is an underlying v goods and services is constrained by the profitability to suppliers.
eet, and discuss them briefly (3 sentences each max.) r annual return, variance, and covariance with the other 4 securities? Column7 Column8 Column9 Column10 Column11 VTI IJS EFA EEM VNQ 15.69% 19.37% 25.81% 31.19% 35.30% 5.37% -5.56% 9.94% 33.31% -16.50% -36.98% -29.39% -41.04% -48.88% -37.00% 28.89% 22.36% 26.95% 68.93% 30.08% 17.42% 24.69% 8.15% 16.51% 28.37% 0.97% -1.65% -12.25% -18.82% 8.62% 16.45% 18.24% 18.82% 19.10% 17.63% 33.45% 39.34% 21.40% -3.69% 2.31% 12.54% 7.56% -6.20% -3.93% 30.36% 0.36% -6.90% -1.00% -16.18% 2.42% 12.83% 31.25% 1.37% 10.87% 8.60% 21.21% 11.35% 25.10% 37.28% 4.91% -5.21% -12.84% -13.81% -15.31% -6.02% 30.67% 24.12% 22.03% 18.20% 28.87% 21.03% 2.63% 7.59% 17.03% -4.68% 25.67% 30.53% 11.46% -3.61% 40.52% -19.51% -11.33% -14.35% -20.56% -26.24% briefly (3 sentences each max.) ive of all available U.S. securities for investment. The fund's holdings include nterparts. As compared to the entire market, the fund has a beta of 1. acteristics are what the iShares S&P Small-Cap 600 Value ETF aims to replicate. apitalizations larger than those of the U.S. and Canada. s. ng current income and moderate long-term capital appreciation.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
economic forecasts and diversification arguments. alyzing at-return surprises (standard deviations from the ng the correlation between the two random variables by ndard deviation of each variable. ent portfolio is spread over various asset classes. The Alternative assets are defined as any investments other means that prices fall if the economy expands without a aces economic growth. Thus, the nominal price of goods value to products and services and as the supply of