please include excel formulas and i will upvote

US TREASURY STRIP DATA Given the price and maturity dates, complete the table by computing days to maturity and annual yield Plot the Treasury Strip Yield Curve, Annual Yield Treasury Strip Yield Curve 120 000% 100.000% U.S. TREASURY Current date 22-Jun-2015 Days to Price Maturity maturity 99.996 15-Aug-2015 99.964 15-Nov-2015 99.874 15-Feb-2016 99.7095 15-May-2016 99.551 15-Aug-2016 3 99.333 15-Nov-2016 1 98.7775 15-May-2017 2 98.787 15-May-2017 3 98.4465 15-Aug-2017 24 97 2295 15-May-2018 96.0995 15-Nov-2018 26 95.4985 15-Feb-2019 27 94.09 15-Aug-2019 28 92.7465 15-Feb-2020 29 92.6395 29-Feb-2020 30 91 9615 15-May-2020 31 91.3785 15-Aug-2020 32 89 985 15-Feb-2021 33 89.113 15-May-2021 34 88.472 15-Aug-2021 80.000% 60.000% 40.000% 20.000% KUS8.00 0.000% 24 87.7725 15-Nov-2021 86.161 15-Aug-2022 85.5955 15-Nov-2022 84.67 15-Feb-2023 83.2315 15-Aug-2023 80.1955 15-Nov-2024 79.645 15-Feb-2025 78.4355 15-Aug-2025 76.9745 15-Feb-2026 75.6795 15-Aug-2026 75.022 15-Nov-2026 74.396 15-Feb-2027 73.062 15-Aug-2027 72.485 15-Nov-2027 70.593 15-Aug-2028 70.016 15-Nov-2028 69.2435 15-Feb-2029 68.0085 15-Aug-2029 66.246 15-May-2030 64.707 15-Feb-2031 53.8665 15-Feb-2036 51.283 15-Feb-2037 50.975 15-May-2037 48.71 15-Feb-2038 48.111 15-May-2038 46.614 15-Feb-2039 46.053 15-May-2039 45.6235 15-Aug-2039 45.149 15-Nov-2039 44.752 15-Feb-2040 44.3105 15-May-2040 43.919 15-Aug-2040 43.5105 15-Nov-2040 42.9975 15-Nov-2040 43.2335 15-Feb-2041 5 7 8 9 0 51 52 53 84 65 66 67 68 69 46.053 45.6235 45.149 44.752 44.3105 43.919 43.5105 42.9975 43.2335 42.9395 42.642 42.2445 41.761 41.2045 40.7815 40.3675 40.0315 39.6775 39.593 39.299 38.8095 38.4935 38.256 38.055 37.906 15-May-2039 15-Aug-2039 15-Nov-2039 15-Feb-2040 15-May-2040 15-Aug-2040 15-Nov-2040 15-Nov-2040 15-Feb-2041 15-May-2041 15-Aug-2041 15-Nov-2041 15-Feb-2042 15-May-2042 15-Aug-2042 15-Nov-2042 15-Feb-2043 15-May-2043 15-Aug-2043 15-Nov-2043 15-Feb-2044 15-May-2044 15-Aug-2044 15-Nov-2044 15-Feb-2045 5 7 7 8 9 -0 51 32 33 84 85 AG US TREASURY STRIP DATA Given the price and maturity dates, complete the table by computing days to maturity and annual yield Plot the Treasury Strip Yield Curve, Annual Yield Treasury Strip Yield Curve 120 000% 100.000% U.S. TREASURY Current date 22-Jun-2015 Days to Price Maturity maturity 99.996 15-Aug-2015 99.964 15-Nov-2015 99.874 15-Feb-2016 99.7095 15-May-2016 99.551 15-Aug-2016 3 99.333 15-Nov-2016 1 98.7775 15-May-2017 2 98.787 15-May-2017 3 98.4465 15-Aug-2017 24 97 2295 15-May-2018 96.0995 15-Nov-2018 26 95.4985 15-Feb-2019 27 94.09 15-Aug-2019 28 92.7465 15-Feb-2020 29 92.6395 29-Feb-2020 30 91 9615 15-May-2020 31 91.3785 15-Aug-2020 32 89 985 15-Feb-2021 33 89.113 15-May-2021 34 88.472 15-Aug-2021 80.000% 60.000% 40.000% 20.000% KUS8.00 0.000% 24 87.7725 15-Nov-2021 86.161 15-Aug-2022 85.5955 15-Nov-2022 84.67 15-Feb-2023 83.2315 15-Aug-2023 80.1955 15-Nov-2024 79.645 15-Feb-2025 78.4355 15-Aug-2025 76.9745 15-Feb-2026 75.6795 15-Aug-2026 75.022 15-Nov-2026 74.396 15-Feb-2027 73.062 15-Aug-2027 72.485 15-Nov-2027 70.593 15-Aug-2028 70.016 15-Nov-2028 69.2435 15-Feb-2029 68.0085 15-Aug-2029 66.246 15-May-2030 64.707 15-Feb-2031 53.8665 15-Feb-2036 51.283 15-Feb-2037 50.975 15-May-2037 48.71 15-Feb-2038 48.111 15-May-2038 46.614 15-Feb-2039 46.053 15-May-2039 45.6235 15-Aug-2039 45.149 15-Nov-2039 44.752 15-Feb-2040 44.3105 15-May-2040 43.919 15-Aug-2040 43.5105 15-Nov-2040 42.9975 15-Nov-2040 43.2335 15-Feb-2041 5 7 8 9 0 51 52 53 84 65 66 67 68 69 46.053 45.6235 45.149 44.752 44.3105 43.919 43.5105 42.9975 43.2335 42.9395 42.642 42.2445 41.761 41.2045 40.7815 40.3675 40.0315 39.6775 39.593 39.299 38.8095 38.4935 38.256 38.055 37.906 15-May-2039 15-Aug-2039 15-Nov-2039 15-Feb-2040 15-May-2040 15-Aug-2040 15-Nov-2040 15-Nov-2040 15-Feb-2041 15-May-2041 15-Aug-2041 15-Nov-2041 15-Feb-2042 15-May-2042 15-Aug-2042 15-Nov-2042 15-Feb-2043 15-May-2043 15-Aug-2043 15-Nov-2043 15-Feb-2044 15-May-2044 15-Aug-2044 15-Nov-2044 15-Feb-2045 5 7 7 8 9 -0 51 32 33 84 85 AG