SAVO 4 Tableau Dashboard Activity 10-1: Bond Returns 3 points The following Tableau dashboard visualization represents a "periodic table of bond returns for several different bond types: The far left column represents the color key for each bond type, ranked in order of annualed returns (fareight column during the period of 2006 10 2014 The columns in the middle show the annual return each year for all bond types as indicated in the color key For example, in 2006, we can see that mortgage bonds (colored orange) had a return of 5 20%, and the overall return on mortgage bonds for the entire period was 4 86(shown in the far-right column) To assist you in better understanding this visualization, each bond type is defined as follows -ellook Junk Bonds - These are bonds normally issued by companies with a risk of default. For this reason, they are considered high risk with the trade-off being that they normally promise higher returns than other types of bonds Corporate Bonds - These are bonds wsued by corporations that are in a good financial condition, meaning they are likely able to fulfill the debt obligation. As such, these bonds are considered lower risk, but also come with a lower rate of return than junk bonds Mortgage Bonds - These are bonds that are backed by holdings in real estate, meaning that in the event of default, the property could be sold to cover the cost of the bond . Government Bonds These are bonds issued by the government. They we considered the lowest is because there is minimalikelihood that the government would not be able to us debt obligation As such, these bonds often carry lower rates of return than other types of bonds Now that you have a better understanding of the visualization answer the following questions about the data and what it shows about these different bond types at you have a better understanding of the visualization, answer the following questions about the data and what it shows about lifferent bond types Bond Type 2006 2007 2008 2009 2010 2011 2012 2013 2014 Annualized Junk Bonds 11.80% 2.70 12.40 58.20% 15.10% 9.00% 15.60% 7.40% 5.70% 10.5196 Homework Assignment 5.10 3:10 5.00 COON 520 2.00 200 100 Government bonds 3.50 1.50 2.2016 SSON 5.00% 2.00% 2.60% 2.500 4.31 tableau 1971-1 Required: 1. Which type of bond had the overall highest annualized return over the period of 2006 to 2017 2. In 2008which type of bond was feast impacted by the decline in the stock market lle performed the best as a result of the sub prime housing market crisis? What is the annual return in 2008 for this bond type? 3. Which type of bond sold at the largest discount based on rates of return in 2009 4. If you have a one year time horton to invest in a bondjunk bonds will always have the highest rate of return 5. Which of the following statements is true based on the data displayed in the visualization Required: 1. Which type of bond had the overall highest annualized return over the period of 2006 to 2014? 2 In 2008, which type of bond was least impacted by the decline in the stock market (i e, performed the best) as a result of the sub prime housing market crisis? What is the annual return in 2008 for this bond type? 3. Which type of bond sold at the largest discount based on rates of return in 2009? 4. If you have a one-year time horizon to invest in a bond junk bonds will always have the highest rate of return 5. Which of the following statements is true based on the data displayed in the visualization? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Req3 Reg4 Reg 5 Which type of bond had the overall highest annualized return over the period of 2006 to 2014? Junk Bonds Corporate Bonds Mortgage Bonds Government Bonds Reg 2 > cbook Required: 1. Which type of bond had the overall highest annualized return over the period of 2006 to 2014? 2. In 2008, which type of bond was least impacted by the decline in the stock market (le, performed the best, as a result of the sub- prime housing market crisis? What is the annual return in 2008 for this bond type? 3. Which type of bond sold at the largest discount based on rates of return in 2009? 4. If you have a one-year time horizon to invest in a bond, junk bonds will always have the highest rate of return 5. Which of the following statements is true based on the data displayed in the visualization? Print References Complete this question by entering your answers in the tobs below. Red 1 Req? Reg 3 Reg 4 Reg 5 In 2008, which type of bond was least impacted by the decline in the stock market (le, performed the best) as a result of the sub-prime housing market crisis? What is the annual return in 2008 for this bond type? Junk Bonds / 58 20% Mortgage Bonds/8.30% Government Bonds / 12.40% Corporate Bonds 581% Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 Reg 4 Req 5 which type of bond sold at the largest discount based on rates of return in 2009? Junk Bonds Corporate Bonds Mortgage Bonds O Government Bonds Complete this question by entering your answers in the tabs below. + Reg 1 Reg 2 Reg 3 Reg 4 Reg 5 If you have a one-year time horizon to invest in a bond, junk bonds will always have the highest rate of return: True Falso Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 Reg 4 Reg 5 Which of the following statements is true based on the data displayed in the visualization? ORates of return for mortgage bonds consistently outperform corporate bonds over the period Rates of return for government bonds consistently yield a higher rate of return than junk bonds over the period Bonds that are considered more (less) risky tend to yield higher (lower) rates of return During a recession, holders of junk bonds fare better than holders of govemment bondo Homework Assignment 5.10 3:10 5.00 COON 520 2.00 200 100 Government bonds 3.50 1.50 2.2016 SSON 5.00% 2.00% 2.60% 2.500 4.31 tableau 1971-1 Required: 1. Which type of bond had the overall highest annualized return over the period of 2006 to 2017 2. In 2008which type of bond was feast impacted by the decline in the stock market lle performed the best as a result of the sub prime housing market crisis? What is the annual return in 2008 for this bond type? 3. Which type of bond sold at the largest discount based on rates of return in 2009 4. If you have a one year time horton to invest in a bondjunk bonds will always have the highest rate of return 5. Which of the following statements is true based on the data displayed in the visualization Required: 1. Which type of bond had the overall highest annualized return over the period of 2006 to 2014? 2 In 2008, which type of bond was least impacted by the decline in the stock market (i e, performed the best) as a result of the sub prime housing market crisis? What is the annual return in 2008 for this bond type? 3. Which type of bond sold at the largest discount based on rates of return in 2009? 4. If you have a one-year time horizon to invest in a bond junk bonds will always have the highest rate of return 5. Which of the following statements is true based on the data displayed in the visualization? Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Req3 Reg4 Reg 5 Which type of bond had the overall highest annualized return over the period of 2006 to 2014? Junk Bonds Corporate Bonds Mortgage Bonds Government Bonds Reg 2 > cbook Required: 1. Which type of bond had the overall highest annualized return over the period of 2006 to 2014? 2. In 2008, which type of bond was least impacted by the decline in the stock market (le, performed the best, as a result of the sub- prime housing market crisis? What is the annual return in 2008 for this bond type? 3. Which type of bond sold at the largest discount based on rates of return in 2009? 4. If you have a one-year time horizon to invest in a bond, junk bonds will always have the highest rate of return 5. Which of the following statements is true based on the data displayed in the visualization? Print References Complete this question by entering your answers in the tobs below. Red 1 Req? Reg 3 Reg 4 Reg 5 In 2008, which type of bond was least impacted by the decline in the stock market (le, performed the best) as a result of the sub-prime housing market crisis? What is the annual return in 2008 for this bond type? Junk Bonds / 58 20% Mortgage Bonds/8.30% Government Bonds / 12.40% Corporate Bonds 581% Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 Reg 4 Req 5 which type of bond sold at the largest discount based on rates of return in 2009? Junk Bonds Corporate Bonds Mortgage Bonds O Government Bonds Complete this question by entering your answers in the tabs below. + Reg 1 Reg 2 Reg 3 Reg 4 Reg 5 If you have a one-year time horizon to invest in a bond, junk bonds will always have the highest rate of return: True Falso Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 Reg 4 Reg 5 Which of the following statements is true based on the data displayed in the visualization? ORates of return for mortgage bonds consistently outperform corporate bonds over the period Rates of return for government bonds consistently yield a higher rate of return than junk bonds over the period Bonds that are considered more (less) risky tend to yield higher (lower) rates of return During a recession, holders of junk bonds fare better than holders of govemment bondo