Hogwarts School of Witchcraft and Wizardry is building an addition to its castle, funded through a bond issuance. Specific information about the bond is provided below. Albus Dumbledore, the school's headmaster, would like some assistance in relation to bond issuance and asks that you provide the following: (1) An amortization schedule for the three different pontential stated rates of the bond (2) Two graphs to help him understand how the different stated rates would affect the school's financial statements (a line graph of the bond's carrying value and a column or bar graph of the interest expense) Dumbledoor has decided to issue a 10-year, 5,000,000 bond with interest pif semiannually. The market rate (yield) for bonds of similar risk and maturity is 9%. Dumbledoor is considering a stated(coupon) rate of 7%, 9%, or 11%.

(1) Ah amortiontion schedide for the theet of ferent pontential tated raterof the bond Aher completine the requirementa below, Gove the fie and submit on Canvas