Fill the form

Bond Face Value: $ 5,000,000

Market Rate: 9%

Consider: 7%, 9%, 11%

Excel Project \#3 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. You will NOT be able to add a new sheet. A blank sheet is provided that you can use for doing any work, but you do not need to use that sheet. After completing the requirements below, save the file and submit on Canvas. Input your name and CWID for the data to populate. Name CWID Dumbledore has decided to issue a 10 -year, $ bond with interest paid semiannually. The market rate (yield) for bonds of similar risk and maturity is %. Dumbledore is considering a stated (coupon) rate of %,%, or %. 1. 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. Excel Project \#3 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. You will NOT be able to add a new sheet. A blank sheet is provided that you can use for doing any work, but you do not need to use that sheet. After completing the requirements below, save the file and submit on Canvas. Input your name and CWID for the data to populate. Name CWID Dumbledore has decided to issue a 10 -year, $ bond with interest paid semiannually. The market rate (yield) for bonds of similar risk and maturity is %. Dumbledore is considering a stated (coupon) rate of %,%, or %. 1. 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