Description
See attached .
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
HiPlease find your Quick Answer.I believe you needed Q3 which was not marked as completed.Drawn the buttons.Let me know if you have any doubt.Thank you.
InvestSMART | The Premier Tool for Ana
What can your bond yield? What kind of investment should you make? | SELECT
Tool for Analyzing Interest Rates and Yields
ou make? | SELECT AN OPTION TO GET STARTED!
InvestSMART | What Could Your Return Be
>> Change The Filter to Calculate the Average Percent Re
Years
AAA
Bond
3,28
(All)
BAA DGS10 Federal USD
Bond Bond Funds 1MTD156N
4,22
1,50
5,35
3,71
25,00
20,00
15,00
AAA Bond
BAA Bond
10,00
5,00
0,00
DGS10
Federal Funds
USD1MTD156N
Q1. Create the Yield Trends graph - completed
Q2. Create the table to show AAA, BAA, DGS10, Federal Funds and USD1MTD156N Q3. Create the button in the table for each AAA, BAA, DGS10, Federal Funds and U
uld Your Return Be? When Should You Invest?
Average Percent Return In a Range of Years
Yield Trends (%)
AAA
BAA
DGS10
FEDFUNDS
USD1MTD156N
l Funds and USD1MTD156N - Completed
DGS10, Federal Funds and USD1MTD156N and show the history graph for each bonds when clicked
Forecasted Fed Funds
Forecasted 1M Libor
Corporate Aaa Corporate Baa 10-Year Treasury
4,75
5,88
3,00
4,75
5,86
3,00
4,75
5,87
3,00
Baa Spreads
10,00
8,00
6,00
4,00
2,00
0,00
-2,00
-4,00
BAA - 10YrTreas
BAA - FEDFUNDS
BAA - 1M LIBOR
2015-09-01
2013-11-01
2012-01-01
2010-03-01
2008-05-01
2006-07-01
2004-09-01
2002-11-01
2001-01-01
1999-03-01
1997-05-01
1995-07-01
1993-09-01
1991-11-01
1990-01-01
1988-03-01
1986-05-01
1984-07-01
1982-09-01
1980-11-01
1979-01-01
1977-03-01
1975-05-01
1973-07-01
1971-09-01
1969-11-01
-6,00
1968-01-01
Bond Class
Fed Funds Output
1M Libor Output
Estimated Yield
2,50
2,65
AAA
BAA
DGS10
FEDFUNDS
USD1MTD156N
2018-01-01
2016-01-01
2014-01-01
2012-01-01
2010-01-01
2008-01-01
2006-01-01
2004-01-01
2002-01-01
2000-01-01
1998-01-01
1996-01-01
1994-01-01
1992-01-01
1990-01-01
1988-01-01
1986-01-01
1984-01-01
1982-01-01
1980-01-01
1978-01-01
1976-01-01
1974-01-01
1972-01-01
1970-01-01
1968-01-01
2017-07-01
2015-09-01
Chart Title
25,00
20,00
15,00
10,00
5,00
0,00
FRED Graph Observations
Federal Reserve Economic Data
Link: https://fred.stlouisfed.org
Help: https://fred.stlouisfed.org/help-faq
Economic Research Division
Federal Reserve Bank of St. Louis
Years
AAA
BAA
DGS10
Moody's Seasoned Aaa Corporate Bond Yield, Percent, Monthly, Not Seasonally Adjusted
Moody's Seasoned Baa Corporate Bond Yield, Percent, Monthly, Not Seasonally Adjusted
10-Year Treasury Constant Maturity Rate, Percent, Monthly, Not Seasonally Adjusted
FEDFUNDS
USD1MTD156N
Effective Federal Funds Rate, Percent, Monthly, Not Seasonally Adjusted
1-Month London Interbank Offered Rate (LIBOR), based on U.S. Dollar, Percent, Monthly
Frequency: Monthly
Corporate Aaa
observation_date
AAA
1968-01-01
1968-02-01
1968-03-01
1968-04-01
1968-05-01
1968-06-01
1968-07-01
1968-08-01
1968-09-01
1968-10-01
1968-11-01
1968-12-01
1969-01-01
1969-02-01
1969-03-01
1969-04-01
1969-05-01
1969-06-01
1969-07-01
1969-08-01
1969-09-01
1969-10-01
1969-11-01
1969-12-01
1970-01-01
1970-02-01
1970-03-01
1970-04-01
1970-05-01
1970-06-01
1970-07-01
1970-08-01
1970-09-01
1970-10-01
Corporate Baa
BAA
6,17
6,10
6,11
6,21
6,27
6,28
6,24
6,02
5,97
6,09
6,19
6,45
6,59
6,66
6,85
6,89
6,79
6,98
7,08
6,97
7,14
7,33
7,35
7,72
7,91
7,93
7,84
7,83
8,11
8,48
8,44
8,13
8,09
8,03
6,84
6,80
6,85
6,97
7,03
7,07
6,98
6,82
6,79
6,84
7,01
7,23
7,32
7,30
7,51
7,54
7,52
7,70
7,84
7,86
8,05
8,22
8,25
8,65
8,86
8,78
8,63
8,70
8,98
9,25
9,40
9,44
9,39
9,33
1972
1972
1972
1972
1972
1972
1972
1972
1972
1973
1973
1973
1973
1973
1973
1973
1973
1973
1973
1973
1973
1974
1974
1974
1974
1974
1974
1974
1974
1974
1974
1974
1974
1975
1975
1970-11-01
1970-12-01
1971-01-01
1971-02-01
1971-03-01
1971-04-01
1971-05-01
1971-06-01
1971-07-01
1971-08-01
1971-09-01
1971-10-01
1971-11-01
1971-12-01
1972-01-01
1972-02-01
1972-03-01
1972-04-01
1972-05-01
1972-06-01
1972-07-01
1972-08-01
1972-09-01
1972-10-01
1972-11-01
1972-12-01
1973-01-01
1973-02-01
1973-03-01
1973-04-01
1973-05-01
1973-06-01
1973-07-01
1973-08-01
1973-09-01
1973-10-01
1973-11-01
1973-12-01
1974-01-01
1974-02-01
1974-03-01
1974-04-01
1974-05-01
1974-06-01
1974-07-01
1974-08-01
1974-09-01
1974-10-01
1974-11-01
1974-12-01
1975-01-01
1975-02-01
8,05
7,64
7,36
7,08
7,21
7,25
7,53
7,64
7,64
7,59
7,44
7,39
7,26
7,25
7,19
7,27
7,24
7,30
7,30
7,23
7,21
7,19
7,22
7,21
7,12
7,08
7,15
7,22
7,29
7,26
7,29
7,37
7,45
7,68
7,63
7,60
7,67
7,68
7,83
7,85
8,01
8,25
8,37
8,47
8,72
9,00
9,24
9,27
8,89
8,89
8,83
8,62
9,38
9,12
8,74
8,39
8,46
8,45
8,62
8,75
8,76
8,76
8,59
8,48
8,38
8,38
8,23
8,23
8,24
8,24
8,23
8,20
8,23
8,19
8,09
8,06
7,99
7,93
7,90
7,97
8,03
8,09
8,06
8,13
8,24
8,53
8,63
8,41
8,42
8,48
8,48
8,53
8,62
8,87
9,05
9,27
9,48
9,77
10,18
10,48
10,60
10,63
10,81
10,65
1975
1975
1975
1975
1975
1975
1975
1975
1975
1975
1976
1976
1976
1976
1976
1976
1976
1976
1976
1976
1976
1976
1977
1977
1977
1977
1977
1977
1977
1977
1977
1977
1977
1977
1978
1978
1978
1978
1978
1978
1978
1978
1978
1978
1978
1978
1979
1979
1979
1979
1979
1979
1975-03-01
1975-04-01
1975-05-01
1975-06-01
1975-07-01
1975-08-01
1975-09-01
1975-10-01
1975-11-01
1975-12-01
1976-01-01
1976-02-01
1976-03-01
1976-04-01
1976-05-01
1976-06-01
1976-07-01
1976-08-01
1976-09-01
1976-10-01
1976-11-01
1976-12-01
1977-01-01
1977-02-01
1977-03-01
1977-04-01
1977-05-01
1977-06-01
1977-07-01
1977-08-01
1977-09-01
1977-10-01
1977-11-01
1977-12-01
1978-01-01
1978-02-01
1978-03-01
1978-04-01
1978-05-01
1978-06-01
1978-07-01
1978-08-01
1978-09-01
1978-10-01
1978-11-01
1978-12-01
1979-01-01
1979-02-01
1979-03-01
1979-04-01
1979-05-01
1979-06-01
8,67
8,95
8,90
8,77
8,84
8,95
8,95
8,86
8,78
8,79
8,60
8,55
8,52
8,40
8,58
8,62
8,56
8,45
8,38
8,32
8,25
7,98
7,96
8,04
8,10
8,04
8,05
7,95
7,94
7,98
7,92
8,04
8,08
8,19
8,41
8,47
8,47
8,56
8,69
8,76
8,88
8,69
8,69
8,89
9,03
9,16
9,25
9,26
9,37
9,38
9,50
9,29
10,48
10,58
10,69
10,62
10,55
10,59
10,61
10,62
10,56
10,56
10,41
10,24
10,12
9,94
9,86
9,89
9,82
9,64
9,40
9,29
9,23
9,12
9,08
9,12
9,12
9,07
9,01
8,91
8,87
8,82
8,80
8,89
8,95
8,99
9,17
9,20
9,22
9,32
9,49
9,60
9,60
9,48
9,42
9,59
9,83
9,94
10,13
10,08
10,26
10,33
10,47
10,38
1979
1979
1979
1979
1979
1979
1980
1980
1980
1980
1980
1980
1980
1980
1980
1980
1980
1980
1981
1981
1981
1981
1981
1981
1981
1981
1981
1981
1981
1981
1982
1982
1982
1982
1982
1982
1982
1982
1982
1982
1982
1982
1983
1983
1983
1983
1983
1983
1983
1983
1983
1983
1979-07-01
1979-08-01
1979-09-01
1979-10-01
1979-11-01
1979-12-01
1980-01-01
1980-02-01
1980-03-01
1980-04-01
1980-05-01
1980-06-01
1980-07-01
1980-08-01
1980-09-01
1980-10-01
1980-11-01
1980-12-01
1981-01-01
1981-02-01
1981-03-01
1981-04-01
1981-05-01
1981-06-01
1981-07-01
1981-08-01
1981-09-01
1981-10-01
1981-11-01
1981-12-01
1982-01-01
1982-02-01
1982-03-01
1982-04-01
1982-05-01
1982-06-01
1982-07-01
1982-08-01
1982-09-01
1982-10-01
1982-11-01
1982-12-01
1983-01-01
1983-02-01
1983-03-01
1983-04-01
1983-05-01
1983-06-01
1983-07-01
1983-08-01
1983-09-01
1983-10-01
9,20
9,23
9,44
10,13
10,76
10,74
11,09
12,38
12,96
12,04
10,99
10,58
11,07
11,64
12,02
12,31
12,97
13,21
12,81
13,35
13,33
13,88
14,32
13,75
14,38
14,89
15,49
15,40
14,22
14,23
15,18
15,27
14,58
14,46
14,26
14,81
14,61
13,71
12,94
12,12
11,68
11,83
11,79
12,01
11,73
11,51
11,46
11,74
12,15
12,51
12,37
12,25
10,29
10,35
10,54
11,40
11,99
12,06
12,42
13,57
14,45
14,19
13,17
12,71
12,65
13,15
13,70
14,23
14,64
15,14
15,03
15,37
15,34
15,56
15,95
15,80
16,17
16,34
16,92
17,11
16,39
16,55
17,10
17,18
16,82
16,78
16,64
16,92
16,80
16,32
15,63
14,73
14,30
14,14
13,94
13,95
13,61
13,29
13,09
13,37
13,39
13,64
13,55
13,46
1983
1983
1984
1984
1984
1984
1984
1984
1984
1984
1984
1984
1984
1984
1985
1985
1985
1985
1985
1985
1985
1985
1985
1985
1985
1985
1986
1986
1986
1986
1986
1986
1986
1986
1986
1986
1986
1986
1987
1987
1987
1987
1987
1987
1987
1987
1987
1987
1987
1987
1988
1988
1983-11-01
1983-12-01
1984-01-01
1984-02-01
1984-03-01
1984-04-01
1984-05-01
1984-06-01
1984-07-01
1984-08-01
1984-09-01
1984-10-01
1984-11-01
1984-12-01
1985-01-01
1985-02-01
1985-03-01
1985-04-01
1985-05-01
1985-06-01
1985-07-01
1985-08-01
1985-09-01
1985-10-01
1985-11-01
1985-12-01
1986-01-01
1986-02-01
1986-03-01
1986-04-01
1986-05-01
1986-06-01
1986-07-01
1986-08-01
1986-09-01
1986-10-01
1986-11-01
1986-12-01
1987-01-01
1987-02-01
1987-03-01
1987-04-01
1987-05-01
1987-06-01
1987-07-01
1987-08-01
1987-09-01
1987-10-01
1987-11-01
1987-12-01
1988-01-01
1988-02-01
12,41
12,57
12,20
12,08
12,57
12,81
13,28
13,55
13,44
12,87
12,66
12,63
12,29
12,13
12,08
12,13
12,56
12,23
11,72
10,94
10,97
11,05
11,07
11,02
10,55
10,16
10,05
9,67
9,00
8,79
9,09
9,13
8,88
8,72
8,89
8,86
8,68
8,49
8,36
8,38
8,36
8,85
9,33
9,32
9,42
9,67
10,18
10,52
10,01
10,11
9,88
9,40
13,61
13,75
13,65
13,59
13,99
14,31
14,74
15,05
15,15
14,63
14,35
13,94
13,48
13,40
13,26
13,23
13,69
13,51
13,15
12,40
12,43
12,50
12,48
12,36
11,99
11,58
11,44
11,11
10,50
10,19
10,29
10,34
10,16
10,18
10,20
10,24
10,07
9,97
9,72
9,65
9,61
10,04
10,51
10,52
10,61
10,80
11,31
11,62
11,23
11,29
11,07
10,62
1988
1988
1988
1988
1988
1988
1988
1988
1988
1988
1989
1989
1989
1989
1989
1989
1989
1989
1989
1989
1989...