1 2 3 The following tables contain coupon, pricing, and other information for a series of bonds with different maturities. Bond Characteristics Bond A Bond B Bond C Bond D 4 Settlement date 5 Maturity date 3/15/2023 3/15/2023 3/15/2023 3/15/2023 11/14/2027 11/14/2027 11/14/2047 11/14/2047 6 Annual coupon rate 4.00% 7 Yield to maturity 5.00% 4.00% 5.00% 7.50% 7.50% 5.00% 5.00% 8 Redemption value (% of face value) 100 100 100 100 9 Coupon payments per year 1 2 1 2 10 11 Required: 12 Note: Use cells A2 to E10 from the given information to complete this question. 13 Using the information above, please calculate the flat (or quoted) price as well as days since last coupon, days in a coupon period, accrued interest, and finally the invoice 14 price. All prices are expressed as percent of par. 15 16 17 Flat price (% of par) 18 Days since last coupon 19 Days in coupon period 20 Accrued interest (% of par) 21 Invoice price (% of par) 22 23 24 Bond A Bond B Bond C Bond D