Using the URL provided in the excel sheet solve of the problemand question from excel attached including imagine, chart data, and discussion please use the same excel sheet as submitted in the same...

1 answer below ยป
Using the URL provided in the excel sheet solve of the problemand question from excel attached including imagine, chart data, and discussion please use the same excel sheet as submitted in the same format as it is now
Answered Same DayApr 16, 2021

Answer To: Using the URL provided in the excel sheet solve of the problemand question from excel attached...

Tanmoy answered on Apr 16 2021
154 Votes
Sheet1
            1 Mo    2 Mo    3 Mo    6 Mo    1 Yr    2 Yr    3 Yr    5 Yr    7 Yr    10 Yr    20 Yr    30 Yr
        2-Jan-20    1.53    1.55    1.54    1.57    1.56    1.58    1.59    1.67    1.79    1.88    2.19    2.33
        18-Feb-20    1.61    1.6    1.58    1.56    1.47    1.41    1.37    1.39    1.48    1.55    1.85    2
        2-Mar-20    1.41    1.27    1.13    0.95    0.89    0.84    0.85    0.88    1.01    1.1    1.46    1.66
        27-Mar-20    0.01    0.03    0.03    0.02    0.11    0.25    0.3    0.41    0.6    0.72    1.09    1.29
        Date    ZM    CCL
            Adj Close    Adj Close
        02/01/20    68.720001    50.718056
        03/01/20    67.279999    49.314434
        06/01/20    70.32    47.821857
        07/01/20    71.900002    47.970123
        08/01/20    72.550003    48.197472
        09/01/20    72.620003    48.632397
        10/01/20    73.089996    48.286434
        13/01/20    74.029999    48.79055
        14/01/20    73.160004    49.630745
        15/01/20    76.940002    49.858089
        16/01/20    76.110001    50.757591
        17/01/20    75.559998    51.30125
        21/01/20    76.730003    50.105206
        22/01/20    75.540001    49.304554
        23/01/20    74.470001    48.879513
        24/01/20    73    46.971779
        27/01/20    70.440002    44.747734
        28/01/20    71.510002    45.963547
        29/01/20    73.580002    45.963547
        30/01/20    74.540001    44.233734
        31/01/20    76.300003    43.027809
        03
/02/20    87.660004    42.256809
        04/02/20    85.790001    43.057465
        05/02/20    86.989998    43.630772
        06/02/20    87.260002    43.274925
        07/02/20    88.639999    41.713154
        10/02/20    89.669998    41.297997
        11/02/20    88.68    42.454502
        12/02/20    88.279999    43.551697
        13/02/20    89.860001    42.701618
        14/02/20    90.949997    42.108536
        18/02/20    96.389999    42.424847
        19/02/20    103.93    42.84
        20/02/20    105.290001    42.5
        21/02/20    101.760002    41.689999
        24/02/20    105.010002    37.759998
        25/02/20    107.080002    35.84
        26/02/20    106.879997    33.139999
        27/02/20    113.550003    31.85
        28/02/20    105    33.459999
        02/03/20    113.110001    33.060001
        03/03/20    117.470001    31.83
        04/03/20    116.800003    32.459999
        05/03/20    125    27.870001
        06/03/20    114.32    27.15
        09/03/20    113.75    21.74
        10/03/20    108.489998    24.02
        11/03/20    110.300003    21.75
        12/03/20    109.470001    14.97
        13/03/20    107.470001    17.58
        16/03/20    107.860001    14.57
        17/03/20    111.099998    12.71
        18/03/20    118.709999    9.3
        19/03/20    123.769997    10
        20/03/20    130.550003    12
        23/03/20    159.559998    12
        24/03/20    135.179993    13.68
        25/03/20    138.110001    15.55
        26/03/20    141.149994    17.82
        27/03/20    151.699997    14.41
        30/03/20    150.880005    12.8
        31/03/20    146.119995    13.17
        01/04/20    137    8.8
        02/04/20    121.93    7.97
        03/04/20    128.199997    8.49
        06/04/20    122.940002    10.21
        07/04/20    113.75    11.3
        08/04/20    117.809998    11.99
        09/04/20    124.510002    12.42
        13/04/20    135.919998    11.5
        14/04/20    141.889999    12.51
        15/04/20    151.559998    12.38
        16/04/20    150.259995    11.85
        17/04/20    150.059998    12.56
        20/04/20    148.990005    12.22
        21/04/20    143.270004    11.84
        22/04/20    150.25    11.64
        23/04/20    169.089996    12.17
        24/04/20    158.800003    11.91
        27/04/20    164.600006    12.98
        28/04/20    156.720001    14.46
        29/04/20    146.479996    16.690001
        30/04/20    135.169998    15.9
        01/05/20    138.559998    13.93
        04/05/20    143.440002    14.34
        05/05/20    144.820007    13.09
        06/05/20    149.589996    12.82
        07/05/20    157.800003    13.53
        08/05/20    155.399994    14.21
        11/05/20    166.479996    13.85
        12/05/20    161.039993    13.19
        13/05/20    167.139999    12.26
        14/05/20    167.910004    12.27
        15/05/20    174.830002    12.78
        18/05/20    164.690002    14.72
        19/05/20    173.679993    14.11
        20/05/20    175.479996    14.15
        21/05/20    172.029999    14.6
        22/05/20    171.059998    14.46
        26/05/20    164    16.280001
        27/05/20    161.970001    17.24
        28/05/20    163.550003    15.93
        29/05/20    179.479996    15.74
        01/06/20    204.149994    16.799999
        02/06/20    208.080002    16.870001
        03/06/20    223.869995    17.25
        04/06/20    210.350006    18.48
        05/06/20    207.600006    21.51
        08/06/20    209.830002    24.91
        09/06/20    205.429993    23.040001
        10/06/20    221.020004    20.59
        11/06/20    222.070007    17.440001
        12/06/20    219.520004    19.98
        15/06/20    239.020004    19.440001
        16/06/20    242.559998    20.42
        17/06/20    236.759995    19.09
        18/06/20    241.570007    18.82
        19/06/20    243.479996    17.83
        22/06/20    251.270004    17.23
        23/06/20    252.809998    18
        24/06/20    255.899994    16
        25/06/20    259.51001    16
        26/06/20    256.799988    15.78
        29/06/20    248.559998    16.780001
        30/06/20    253.539993    16.42
        01/07/20    259.130005    16.360001
        02/07/20    261.73999    15.88
        06/07/20    261    15.61
        07/07/20    262.100006    14.57
        08/07/20    266.320007    15.32
        09/07/20    269.519989    14.58
        10/07/20    275.869995    16.16
        13/07/20    260.299988    15.28
        14/07/20    260.01001    15.04
        15/07/20    256.220001    17.48
        16/07/20    248.539993    15.78
        17/07/20    246.539993    15.47
        20/07/20    268.579987    15
        21/07/20    260.440002    15.19
        22/07/20    261.179993    15.14
        23/07/20    251.5    14.8
        24/07/20    246.559998    14.8
        27/07/20    252.330002    13.75
        28/07/20    252.179993    14.33
        29/07/20    252.389999    14.65
        30/07/20    250    14.34
        31/07/20    253.910004    13.88
        03/08/20    268    13.07
        04/08/20    267.339996    13.74
        05/08/20    272.899994    14.02
        06/08/20    268.25    13.78
        07/08/20    258.730011    14.22
        10/08/20    250    15.44
        11/08/20    231.039993    15.82
        12/08/20    236.720001    15.19
        13/08/20    247.25    15.22
        14/08/20    244.910004    15.47
        17/08/20    266.149994    14.68
        18/08/20    276.799988    14.41
        19/08/20    273.51001    14.6
        20/08/20    290.690002    14.54
        21/08/20    289.679993    14.65
        24/08/20    282.279999    16.139999
        25/08/20    290.440002    15.89
        26/08/20    295.269989    15.28
        27/08/20    294.679993    16.120001
        28/08/20    299.269989    17.209999
        31/08/20    325.100006    16.48
        01/09/20    457.690002    16.51
        02/09/20    423.559998    16.709999
        03/09/20    381.320007    17.58
        04/09/20    369.890015    18.530001
        08/09/20    350.880005    18.290001
        09/09/20    389.649994    17.66
        10/09/20    384.480011    17.879999
        11/09/20    383    17.690001
        14/09/20    403.51001    17.85
        15/09/20    410.940002    15.93
        16/09/20    408.170013    16.459999
        17/09/20    413.125    16.24
        18/09/20    438.730011    15.31
        21/09/20    468.470001    14.29
        22/09/20    492.600006    14.41
        23/09/20    500.529999    14.13
        24/09/20    464.980011    13.74
        25/09/20    496.5    15.07
        28/09/20    487.660004    15.31
        29/09/20    465.5    15.07
        30/09/20    470.109985    15.18
        01/10/20    482.98999    15.03
        02/10/20    482.230011    15.16
        05/10/20    485.369995    14.96
        06/10/20    478.25    15.19
        07/10/20    480.609985    15.99
        08/10/20    478.549988    15.61
        09/10/20    492.410004    15.69
        12/10/20    491.540009    15.21
        13/10/20    518.789978    14.03
        14/10/20    509.25    13.97
        15/10/20    536.400024    14.02
        16/10/20    559    14.08
        19/10/20    568.340027    14.15
        20/10/20    537.02002    14.61
        21/10/20    513.190002    14.48
        22/10/20    520.539978    15.19
        23/10/20    511.519989    15.36
        26/10/20    517.789978    14.03
        27/10/20    538.98999    13.76
        28/10/20    516.01001    12.3
        29/10/20    489.679993    12.98
        30/10/20    460.910004    13.71
        02/11/20    453    13.55
        03/11/20    451.51001    13.71
        04/11/20    483.700012    13.34
        05/11/20    496.730011    14.18
        06/11/20    500.109985    13.82
        09/11/20    413.23999    19.25
        10/11/20    376.01001    16.73
        11/11/20    413.339996    16.209999
        12/11/20    428.640015    14.93
        13/11/20    403.579987    16.01
        16/11/20    399.149994    17.57
        17/11/20    401.630005    18.049999
        18/11/20    415.040009    17.59
        19/11/20    414.290009    18.190001
        20/11/20    439.600006    17.370001
        23/11/20    430.279999    18.18
        24/11/20    427.549988    20.23
        25/11/20    443.720001    20.65
        27/11/20    471.609985    21.58
        30/11/20    478.359985    19.98
        01/12/20    406.309998    20.15
        02/12/20    412.859985    21.16
        03/12/20    413.540009    22.879999
        04/12/20    410.01001    23.450001
        07/12/20    407.850006    23.200001
        08/12/20    412    23.57
        09/12/20    385.359985    22.690001
        10/12/20    397.959991    22.32
        11/12/20    397.01001    21.32
        14/12/20    395.98999    20.93
        15/12/20    399.429993    21.530001
        16/12/20    404    21.76
        17/12/20    401.619995    21.629999
        18/12/20    406.01001    21.459999
        21/12/20    408.970001    21.059999
        22/12/20    409    19.809999
        23/12/20    383.880005    20.940001
        24/12/20    375.170013    20.84
        28/12/20    351.390015    21.709999
        29/12/20    353.75    21.43
        30/12/20    353.399994    21.790001
        31/12/20    337.320007    21.66
        04/01/21    359.980011    20.379999
        05/01/21    360.829987    20.6
        06/01/21    344.410004    20.4
        07/01/21    342.5    20.74
        08/01/21    349.609985    20.469999
        11/01/21    337.709991    20.139999
        12/01/21    356.809998    20.129999
        13/01/21    364.630005    20.1
        14/01/21    383.23999    20.92
        15/01/21    384.529999    20.790001
        19/01/21    393.869995    20.870001
        20/01/21    382.799988    20.780001
        21/01/21    382.809998    20.74
        22/01/21    383.399994    20.219999
        25/01/21    391.829987    19.219999
        26/01/21    374.390015    18.719999
        27/01/21    370.73999    18.98
        28/01/21    378.589996    19.74
        29/01/21    372.070007    18.67
        01/02/21    381.929993    18.799999
        02/02/21    391.839996    19.450001
        03/02/21    380.470001    20.440001
        04/02/21    389.980011    21.049999
        05/02/21    419.589996    21.309999
        08/02/21    410.809998    21.610001
        09/02/21    430.029999    21.049999
        10/02/21    431    20.93
        11/02/21    432.769989    20.719999
        12/02/21    433.109985    20.6
        16/02/21    444.51001    22.469999
        17/02/21    429.420013    23.200001
        18/02/21    417.910004    22.889999
        19/02/21    417.26001    24.59
        22/02/21    394.339996    25.969999
        23/02/21    388.160004    26.459999
        24/02/21    385.230011    27.01
        25/02/21    364.730011    25.469999
        26/02/21    373.609985    26.75
        01/03/21    409.660004    26.309999
        02/03/21    372.790009    27.59
        03/03/21    341.570007    28.67
        04/03/21    343.089996    27.4
        05/03/21    337.429993    26.09
        08/03/21    310.929993    26.690001
        09/03/21    342.109985    27.58
        10/03/21    336.029999    26.700001
        11/03/21    355.170013    27.469999
        12/03/21    346.390015    28.459999
        15/03/21    350    29.790001
        16/03/21    335.079987    28.25
        17/03/21    336.649994    28.93
        18/03/21    316.320007    28.27
        19/03/21    326.26001    28.959999
        22/03/21    328.5    27.48
        23/03/21    339.76001    25.33
        24/03/21    314.959991    24.85
        25/03/21    314.850006    25.85
        26/03/21    319.950012    26.059999
        29/03/21    308.390015    25.629999
        30/03/21    313.190002    26.65
        31/03/21    321.290009    26.540001
        01/04/21    326.230011    26.860001
        05/04/21    323.959991    28.110001
        06/04/21    329.790009    28.6
        07/04/21    323.079987    29
        08/04/21    331.279999    28.559999
        09/04/21    322.649994    29.299999
        12/04/21    321.51001    27.75
        13/04/21    342.75    27.82
        14/04/21    329.200012    27.940001
        15/04/21    332.380005    27.32
Daily Treasury Yield Curve Rates
02-Jan-20    1 Mo    2 Mo    3 Mo    6 Mo    1 Yr    2 Yr    3 Yr    5 Yr    7 Yr    10 Yr    20 Yr    30 Yr    1.53    1.55    1.54    1.57    1.56    1.58    1.59    1.67    1.79    1.88    2.19    2.33    18-Feb-20    1 Mo    2 Mo    3 Mo    6 Mo    1 Yr    2 Yr    3 Yr    5 Yr    7 Yr    10 Yr    20 Yr    30 Yr    1.61    1.6    1.58    1.56    1.47    1.41    1.37    1.39    1.48    1.55    1.85    2    02-Mar-20    1 Mo    2 Mo    3 Mo    6 Mo    1 Yr    2 Yr    3 Yr    5 Yr    7 Yr    10 Yr    20 Yr    30 Yr    1.41    1.27    1.1299999999999999    0.95    0.89    0.84    0.85    0.88    1.01    1.1000000000000001    1.46    1.66    27-Mar-20    1 Mo    2 Mo    3 Mo    6 Mo    1 Yr    2 Yr    3 Yr    5 Yr    7 Yr    10 Yr    20 Yr    30 Yr    0.01    0.03    0.03    0.02    0.11    0.25    0.3    0.41    0.6    0.72    1.0900000000000001    1.29    Length of Securities
Rates
Historical daily prices for ZM and...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here