CBO-iShares 1-5 year Laddered Corporate Bond Index ETF- and XIU-iShares S&P/TSX 60 Index ETF- are two iShares ETFs tracking and Canadian bond market and Canadian equity market, respectively. Thus, they are popularly used by Canadian investors as proxies for Canadian bond and equity markets.
You can find out the historical closing prices of CBO and XIU from the following website:http://ca.ishares.com/product_info/fund/index.htm Download the most recent three years weekly date.
Suppose that now you have $80 million to invest for six months and you want to invest those money into CBO, XIU and the Canadian 6-month T-bill. Assume that the interest rate of the 6-month T-bill is 2% per annum.
Use EXCEL to answer following questions: 1. Estimate the weekly expected returns, standard deviations of CBO and XIU, respectively, and their correlation and covariance. Then convert them into those with six-month (26 weeks) horizon. 2. Draw the opportunity set offered by these two securities. 3. What is the optimal portfolio of CBO and XIU? What are the expected return and standard deviation of this portfolio? 4. Choose your degree of risk aversion with a range of the A value from 1 to 8. 5. Determine your optimal asset allocation among CBO, XIU, and T-bill, in percentage, dollar amounts, and number of shares. What are the expected return and standard deviation of your complete portfolio?
Attach first and last pages of your spreadsheets to your assignment. However, you should answer the questions in a separate paper.
Also read:
- principles of economics Which statement is true? A) Today more workers in the U.S. are members of labor unions than any time in our history. B) Today labor unions are weaker than any time in the last 100 years. C) No major labor union has called a strike since the 1940s.D) Labor unions are relatively strong in the public (government) sector. 2. Exclusive union strategy involves A) increasing the demand for the final product, thereby increasing the demand for labor. B) restricting the supply of union labor. C) setting job standards and entry qualifications for members. D) organizing all workers and bargaining for a wage.E) negotiating only after a strike has been called. 3. An example of an exclusive union would be A) the International Brotherhood of the Teamsters. B) the Communications Workers of America. C) the American Medical Association. D) the United Steel Workers. 4. In which one of these years was labor union membership the highest? A) 1940 B) 1960 C) 1980 D) 1990 5. Which of the following laws stated that attempts to monopolize, conspiracies in restraint of trade, and conspiracies to monopolize were illegal? A) The Federal Trade Commission Act B) The Clayton Act C) The Sherman Antitrust Act D) All of the choices. E) None of the choices 6.Until the passage of the Airline Deregulation Act of 1978, the Civil Aeronautics Board controlled all of the following except A) fares. B) assigned routes. C) profits. D) entry into the industry. 7. The Clayton Act prohibited A) interlocking directorates. B) all forms of monopoly. C) foreign control of U.S. corporations. D) false and deceptive advertising. 8. Which statement is true? A) Microsoft is subject to American antitrust laws, but not those of Europe, Asia, or elsewhere. B) Microsoft has never been involved in an antitrust suit. C) The European Commission fined Microsoft over $600 billion for its anticompetitive behavior. D) Microsoft has always gone out of its way to be helpful to its competitors. 9. A monopolist operates at the minimum point of her ATC curve A) only in the short run. B) only in the long run. C) in both the short run and the long run. D) in neither the short run nor the long run. 10. Which of the following is characteristic of a monopoly? A) The absence of political power B) Close substitute products C) The ability to make an economic profit in the long run D) Operating at peak efficiency. (I will send the image) 11. This firm will charge a price of A). $8. B) $9.65. C) $10. D) $12. E) $16 12. Statement I. Only natural monopolies are legal in the United States. Statement II. Large firms generally operate at peak efficiency. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 13. The nation's largest bank has assets over A) $2.5 billion. B) $25 billion. C) $250 billion. D) $800 billion. E) $1.8 trillion. 14. Which statement is true? A) Our money supply is fixed by law and can be raised by only a very small percentage each year. B) Our money supply is backed by gold. C) Credit cards are a form of money. D) Money makes an excellent store of value during times of inflation. E) One of the basic jobs of money is a standard of value. 15. The first bankers were A) goldsmiths. B) printers. C) storekeepers. D) innkeepers. E) blacksmiths. 16. Suppose you had no money in your checking account and your bank granted you overdraft privileges. You then went out and charged $20 on your debit card. How much would your bank charge you in fees for using your overdraft privileges? A) 0 B) $5 C) 15 D) 35 E) $50 17. Statement I: John Maynard Keynes called the hoarding of money at very low interest rates a "liquidity trap." Statement II: Since the late 1990s, Japan has been caught in a liquidity trap. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 18. Banks can A) create money, but not destroy money. B) destroy money, but not create money. C) create and destroy money. D) neither create nor destroy money. 19. The Federal Open Market Committee is made up of all of the following, except A) the board of governors. B) the chairman of the board of governors. C) the president of the United States. D) the president of the Federal Reserve Bank of New York. E) the presidents of four Federal Reserve Banks other than the New York Bank. 20. The Federal Reserve System A) has regional Federal Reserve Banks that make most of the decisions. B) makes decisions subject to the approval of the President. C) makes its major policy decisions in its Open Market Committee. D) makes decisions subject to the approval of Congress. 21. With economic development comes each of the following, except A) a decline in the birth rate. B) an increase in the stock of capital. C) rising per capita GDP D) a declining wage rate. 22. Our educational standards today. A) are the highest in history. B) are much higher than they were 50 years ago. C) are the same as they were 50 years ago. D) are much lower than they were 50 years ago. 23. Brazil should be classified as a(n) A) very poor LDC. B) middle-rank LDC. C) NIC. D) industrial country. 24. The most important reason for our slow rate of productivity growth over the last three decades (of those listed below) is A) lagging business sales. B) foreign imports. C) our low savings rate. D) high tax rates. 25. Structural unemployment occurs when A) workers have quit one job and are looking for a better one. B) high school graduates enter the labor market every June. C) the business cycle is in a downturn and people are laid off. D) the people without jobs have skills that don't match the available job openings. 26. Unemployment caused by economic decline or recession is called A) frictional unemployment. B) cyclical unemployment. C) natural unemployment. D) necessary unemployment. E) structural unemployment.. 27. The recession of 2001 was caused by A) the events of 9/11. B) a decline in consumer spending. C) a decline in investment spending. D) the war in Iraq. 28. A budget deficit is the A) annual excess of government spending over revenue raised by taxes, fees, and charges. B) shortfall of Social Security collections toward payment of benefits. C) amount by which tax revenues and borrowed funds fall short of government expenditures. D) excess of tax revenues over expenditures. E) amount by which tax revenues exceed borrowed funds. 29. The consumer price index is created by A) calculating the cost of a "basket" of consumer goods typically bought by an American family in any year as a percentage of their cost in a base year. B) the Congressional Budget Office. C) averaging the price increases for all consumer goods in the GDP and adding 100. D) dividing nominal dollar consumer expenditures by base year consumer expenditures. 30. Statement I: When equilibrium GDP and full employment GDP are equal, there is no inflationary gap and no deflationary gap.Statement II: Equilibrium GDP is an ideal goal that can never be attained. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 31. When government expenditures in a given year are less than tax receipts, there exists A) a budget deficit. B) public revenue. C) full-employment taxation. D) a budget surplus .32. As price rises, the quantity ______________ rises. A) demanded B) supplied C) demanded and supplied 33. If the MPC were .75, what change in government spending (in billions of dollars) would be required to cause the equilibrium level of GDP to fall by 100? A) A decrease of 25. B) A decrease of 50. C) A decrease of 75. D) A decrease of 100. E) A decrease of 125. (I will send the image) 34. When price is $8 A) quantity demanded is greater than quantity supplied and, therefore, price must fall to get to equilibrium price. B) quantity demanded is greater than quantity supplied and, therefore, price must rise to get to equilibrium price. C) quantity supplied is greater than quantity demanded and, therefore, price must fall to get to equilibrium price. D) quantity supplied is greater than quantity demanded and, therefore, price must rise to get to equilibrium price. 35. Usury is considered the charging of A) higher interest rates than people are willing to pay. B) lower interest rates than people are willing to pay C) unconscionably high interest rates. D) extremely low rates of interest. 36. The present value of a dollar rises as A) the interest rate declines and the number of years you wait for your money declines. B) the interest rate rises and the number of years you wait for your money rises. C) the interest rate declines and the number of years you wait for your money rises. D) the interest rate rises and the number of years you wait for your money declines. 37. In economics we say the amount of land is A) fixed. B) variable. C) both fixed and variable. D) neither fixed nor variable. 38. Which is not determined by supply and demand? A) The wage rate B) The interest rate C) Rent D) Profits 39. Which of the following is false? A) The supply of land is fixed. B) When the demand for a plot of land rises, its supply will rise. C) Land is most efficiently used in cities. D) The rent on a particular piece of land is based on the MRP schedule of the highest bidder. 40. If you knew that interest rates would be rising, then you would predict that the present value of $1 received 5 years from now A) would be higher. B) would be about the same. C) would be lower. D) could be higher or lower. 41. Changes in rent on a plot of land are chiefly due to A) changes in demand. B) changes in supply. C) changes in both demand and supply. D) changes in neither supply nor demand. (I will send the image) 42. The horizontal dotted line is A) a price ceiling. B) a price floor. C) either a price ceiling or a price floor. D) neither a price ceiling nor a price floor. 43. These lenders avoid using the term "interest," but their borrowers still do pay a charge for borrowing money. This would be considered ___________ lending. A) Islamic B) payday C) fringe D) sub-prime 44. __________ sees the entrepreneur as an exploiter of labor. A) Joseph Schumpeter B) Frank Knight C) Henry George D) Karl Marx 45. A more equal distribution of income A) might hurt the incentive to work .B) would not hurt the incentive to work C) would be opposed by nearly all Americans D) would hurt the poor. 46. Between 1994 and 2005 our welfare rolls A) declined substantially every year. B) declined slightly every year .C) declined most years. D) stayed about the same. E) rose most years 47.Who expressed this view? "Unlike the present period, (black) inner-city communities prior to 1960 exhibited the features of social organization—including a sense of community, positive neighborhood identification, and explicit norms and sanctions against aberrant behavior." A) Charles Murray B) William Julius Wilson C) Mickey Kaus D) Lisabeth Schorr E) Celia Dugger 48. According to Darity and Myers A) black men are becoming increasingly marginal to our economy B) the basic cause of poverty is welfare dependency C) the best solution to poverty is the negative income tax D) as our economy continues to expand, black poverty will decline (I will send the image) 49. The percentage share of income of the bottom quintile on curve X is A) 0. B) 5. C) 10. D) 15. E) 20. 50. The percentage of people living in poverty in 2006 in the U.S. was _______. A) 6 B) 11.7 C) 12.3 D) 15.2 51. Child poverty is A) much more of a problem in France, Germany, and Japan than it is in the U.S. B) less of a problem in the United States than in Canada, Britain, or Italy. C) more of a problem in Sweden, Denmark, and Ireland than it is in the U.S. D) much more of a problem in the U.S. than in virtually all other industrialized countries. 52. Statement I: Social Security payments help mostly the poor. Statement II: Poverty may be defined as a relative concept and as an absolute concept. A) Statement I is true and statement II is false. B) Statement II is true and statement I is false. C) Both statements are true. D) Both statements are false. 53. Compared to their levels in 1999, the poverty line has ______ and the minimum hourly wage has ________. A) gone up; gone up B) stayed the same; stayed the same C) gone up; stayed the same D) stayed the same; gone up 54. In which year was the poverty rate the lowest? A) 1960 B) 1973 C) 1984 D) 1993 E) 2006 55. Which statement is true? A) Most economists support rent control laws. B) Usury laws and rent control are price ceilings. C) Usury laws have never had any effect because they are set well above interest rates. D) None of the choices. (I will send the image) 56. If price were set by the government at $3, there would be a price _____________, that would cause a ___________ of _______ units. A) floor, surplus, 12 B) floor, shortage, 12 C) ceiling, surplus, 14 D) ceiling, shortage, 14 57. Sue Ann Buchanan, can make $800,000 on the pro tennis tour, but would be willing to do it for $200,000. Her economic rent is A) $200,000. B) $600,000. C) $800,000. D) $1,000,000. 58. Despite their fantastic employment gains, African American men earn ____% of what white men earn. A) 65 B) 55 C) 60 D) 76 59. Since 1996, productivity growth has ________ and real wages have ______. A) risen; risen B) fallen; fallen C) risen; fallen D) fallen; risen. 60. Which statement is false? A) The minimum wage has NOT kept up with the rate of inflation .B) The average real hourly earnings fell steadily from 1973 to 1993. C) Workers with some high school education make about the same average annual earnings as those with high school diplomas. D) It is harder for a middle class student to get a college degree because since 1979, the cost of going to college has gone up twice as fast as the rate of inflation.
- A 25-year, $1,000 par value bond has an 8.5% annual payment coupon. The bond currently sells for $900. If the yield to maturity remains at its current rate, what will the price be 5 years from now?
- Articulate your 5 year goal, including what goals you need to achieve next year (1 year) to get on that path. Develop your 5-year career action plan.
- X Corporation issues a $1000 bond. The bond is priced at $1,052.42. It
- X Corporation issues a $1000 bond. The bond is priced at $1,052.42. It
- 3-1 staff revenue after taxation An investor recently purchased a corporate bond
- 4. An investor buys a three-year bond with a 4% coupon rate paid annua
- 1) IBM has just issued a callable (at par) 9 year, 12% coupon bond wit