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

$(3)$ Your recommendation of which stated rate they should use when issuing the bonds and WHY. Any additional insights you have would be greatly appreciated.Dumbledore has decided to issue a $10-$year, $$1,000,000$ bond with interest paid semiannually.

The market rate $($yield$)$ for bonds of similar risk and maturity is $6\%.$

Dumbledore is considering a stated $($coupon$)$ rate of $4\%,6\%,$ or $8\%.$

Complete the Bond Amortization Schedules for each of the three potential stated rates.

Also indicate whether the bond would be issued at a premium, discount or face amount.