Consider a bond with the following features and a settlement date of 10/6/2020. Annual Coupon 8% Coupon Payment Frequency Semiannual Interest Payment Dates 30 May and 30 Nov. Maturity Date 11/30/2030 Day-Count Convention 30/360 Annual Yield-to-Maturity 6% 14. (10 pts.) What is the full price of the bond as of the settlement date? You must show all of the work (timeline + mathematical equation + Excel/calculator formula) for this question. 15. (5 pts.) What is the amount of accrued interest? Your Excel file is a sufficient means of showing your work for this problem. 16. (5 pts.) What is the bond's flat, or quoted, price? Your Excel file is a sufficient means of showing your work for this problem. Consider the following table you would complete to calculate the bond's Macaulay duration: Time to Receipt Cash Flow PV of CF Weight Weight Time X 17.(10 pts.) What is the value of x in the last row of the table? Round your answer to 4 decimal places. Your Excel file is a sufficient means of showing your work here. Consider a bond with the following features and a settlement date of 10/6/2020. Annual Coupon 8% Coupon Payment Frequency Semiannual Interest Payment Dates 30 May and 30 Nov. Maturity Date 11/30/2030 Day-Count Convention 30/360 Annual Yield-to-Maturity 6% 14. (10 pts.) What is the full price of the bond as of the settlement date? You must show all of the work (timeline + mathematical equation + Excel/calculator formula) for this question. 15. (5 pts.) What is the amount of accrued interest? Your Excel file is a sufficient means of showing your work for this problem. 16. (5 pts.) What is the bond's flat, or quoted, price? Your Excel file is a sufficient means of showing your work for this problem. Consider the following table you would complete to calculate the bond's Macaulay duration: Time to Receipt Cash Flow PV of CF Weight Weight Time X 17.(10 pts.) What is the value of x in the last row of the table? Round your answer to 4 decimal places. Your Excel file is a sufficient means of showing your work here