Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

project number 10 The following Tableau dashboard visualization represents a periodic table of bond returns for several different bond types. The far-left column represents the

project number 10 image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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 annualized returns (far-right column) during the period of 2006 to 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: - 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 issued by corporations that are in a good financial condition, meaning they are likely able to fulfill their 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 are considered the lowest risk because there is a minimal likelihood that the government would not be able to fulfill its 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. Which type of bond had the overall highest annualized return over the period of 2006 to 2014? \begin{tabular}{|l|} \hline Junk Bonds \\ \hline Corporate Bonds \\ \hline Mortgage Bonds \\ \hline Government Bonds \\ \hline \end{tabular} 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? \begin{tabular}{|l|} \hline Junk Bonds / 58.20% \\ \hline Mortgage Bonds / 8.30% \\ \hline Government Bonds / 12.40\% \\ \hline Corporate Bonds / 5.81% \\ \hline \end{tabular} Which type of bond sold at the largest discount based on rates of return in 2009 ? If you have a one-year time horizon to invest in a bond, junk bonds will always have the highest rate of return: hich of the following statements is true based on the data displayed in the visualization? 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 annualized returns (far-right column) during the period of 2006 to 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: - 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 issued by corporations that are in a good financial condition, meaning they are likely able to fulfill their 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 are considered the lowest risk because there is a minimal likelihood that the government would not be able to fulfill its 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. Which type of bond had the overall highest annualized return over the period of 2006 to 2014? \begin{tabular}{|l|} \hline Junk Bonds \\ \hline Corporate Bonds \\ \hline Mortgage Bonds \\ \hline Government Bonds \\ \hline \end{tabular} 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? \begin{tabular}{|l|} \hline Junk Bonds / 58.20% \\ \hline Mortgage Bonds / 8.30% \\ \hline Government Bonds / 12.40\% \\ \hline Corporate Bonds / 5.81% \\ \hline \end{tabular} Which type of bond sold at the largest discount based on rates of return in 2009 ? If you have a one-year time horizon to invest in a bond, junk bonds will always have the highest rate of return: hich of the following statements is true based on the data displayed in the visualization

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Auditing

Authors: Ernest Evan Spicer, Ernest Charles Pegler

17th Edition

0406678014, 9780406678010

More Books

Students also viewed these Accounting questions

Question

2. Are my sources up to date?

Answered: 1 week ago