1. Method of Averages: Det par (a) Input appropriate values into cells B2 and 13 in the Method of Average worksheet in the MA270Lab Report 2.xlsx Excel file, (b) Similar to last week, do an internet search for "FINRA bond center". Use the site to complete columns D to G for each of the bonds listed in the Method of Averages worksheet. Notes: i. Find each bond by inputting the "Bond Symbol" from the Excel file into the "Symbol/CUSIP"search field on the website. il. For the purposes of this wignment, we will me that all of the bonds are non-callable. (c) Complete column H (yield rate for each bond) using the YIELD(...) function in Excel (d) Complete column 1 (Years to maturity) using the YEARFRACC...) function in Excel (e) Complete column) using a formula (referencing previously filled cells) for the number of coupons to be paid from the purchase date of the bond to maturity Note: Asume the bond was purchased immediately after a coupon payment and the first coupon received is one period after the purchasing date (1) Complete column K by entering a formu (referencing previously filled cells) that approximates the yield (as an anal rate compounded m times per year) for each bond using the Method of Average Note: You have completed this worksheet correctly if the JPMorgan Chase & Co. boul h 15 years to muturity, 18 coupon payments, and an approximate yield of 0.993890% using Method of Averages 1. Method of Averages: Det par (a) Input appropriate values into cells B2 and 13 in the Method of Average worksheet in the MA270Lab Report 2.xlsx Excel file, (b) Similar to last week, do an internet search for "FINRA bond center". Use the site to complete columns D to G for each of the bonds listed in the Method of Averages worksheet. Notes: i. Find each bond by inputting the "Bond Symbol" from the Excel file into the "Symbol/CUSIP"search field on the website. il. For the purposes of this wignment, we will me that all of the bonds are non-callable. (c) Complete column H (yield rate for each bond) using the YIELD(...) function in Excel (d) Complete column 1 (Years to maturity) using the YEARFRACC...) function in Excel (e) Complete column) using a formula (referencing previously filled cells) for the number of coupons to be paid from the purchase date of the bond to maturity Note: Asume the bond was purchased immediately after a coupon payment and the first coupon received is one period after the purchasing date (1) Complete column K by entering a formu (referencing previously filled cells) that approximates the yield (as an anal rate compounded m times per year) for each bond using the Method of Average Note: You have completed this worksheet correctly if the JPMorgan Chase & Co. boul h 15 years to muturity, 18 coupon payments, and an approximate yield of 0.993890% using Method of Averages
