Can you please help me with the third portion? I figured out the first two, but I
am stuck on the last one. If possible, please teach me how to do it in excel.
Locate the Treasury bond in Figure 8.4 maturing in August 2045. Assume a par value of $20,000.
What is its coupon rate?