Dumbledore has decided to issue a 10-year, $ bond with interest paid semiannually The market rate lyleldi far bonds of similar risk and maturityis X. Dumbledore is considering a stated (coupon) rate of X, %, or %. 5 E 2. Complete the Dond Amortization Schedules for each of the three potential stated rates. Also indicate whether the band would be icwed at a premium, discount or face amount. 9 Bond Amorization Schedule with Stated Rate of K Bond Amorization Schedule with Stated Rate of % Bond Amorization Schedule with Stated Rate of Payment Payment Balance (Carrying Value) Cash Interest Payment Interest Expense Payment Balance Amortization Carrying Value) Cash Interest Payment Interest Eupense Amortization Cash Interest Payment Balance Carrying Value) Interest Expense Amortizmion Beg Balance 10 11 12 13 1 Beg Balance 1 1 2 Bee. Balance 1 1 2 2 14 3 3 15 4 4 4 16 5 5 5 17 6 6 6 7 7 7 8 8 18 19 20 21 9 9 9 10 10 10 22 11 11 11 12 12 23 24 12 13 13 13 14 25 14 14 26 15 15 15 27 16 16 16 28 17 17 17 29 18 18 18 19 19 19 30 31 20 20 20 AS . XX A C H M N o P 0 B 19 20 20 30 31 32 33 34 This bond would be issued at This bond would be issued at This bond would be issued at 2. Place your two graphs comparing the different stated rates in the space below line graph for the carrying walue and bar graph for the interest expenset Your graphs should have clearly labeled ases, a legend, and a title. Place the graphs side by side horizonally in the space provided. 35 36 37 38 39 40 41 93 52 55 3. Give your recommendation of which started rate Hogwarts should use for their bond issuance in the space below: Responses with no explanation of why you recommend a particular rate will receive NO credit Excel Trick: Use Alt+Enter co go to a new line BE 58 6: 62 64 Dumbledore has decided to issue a 10-year, $ bond with interest paid semiannually The market rate lyleldi far bonds of similar risk and maturityis X. Dumbledore is considering a stated (coupon) rate of X, %, or %. 5 E 2. Complete the Dond Amortization Schedules for each of the three potential stated rates. Also indicate whether the band would be icwed at a premium, discount or face amount. 9 Bond Amorization Schedule with Stated Rate of K Bond Amorization Schedule with Stated Rate of % Bond Amorization Schedule with Stated Rate of Payment Payment Balance (Carrying Value) Cash Interest Payment Interest Expense Payment Balance Amortization Carrying Value) Cash Interest Payment Interest Eupense Amortization Cash Interest Payment Balance Carrying Value) Interest Expense Amortizmion Beg Balance 10 11 12 13 1 Beg Balance 1 1 2 Bee. Balance 1 1 2 2 14 3 3 15 4 4 4 16 5 5 5 17 6 6 6 7 7 7 8 8 18 19 20 21 9 9 9 10 10 10 22 11 11 11 12 12 23 24 12 13 13 13 14 25 14 14 26 15 15 15 27 16 16 16 28 17 17 17 29 18 18 18 19 19 19 30 31 20 20 20 AS . XX A C H M N o P 0 B 19 20 20 30 31 32 33 34 This bond would be issued at This bond would be issued at This bond would be issued at 2. Place your two graphs comparing the different stated rates in the space below line graph for the carrying walue and bar graph for the interest expenset Your graphs should have clearly labeled ases, a legend, and a title. Place the graphs side by side horizonally in the space provided. 35 36 37 38 39 40 41 93 52 55 3. Give your recommendation of which started rate Hogwarts should use for their bond issuance in the space below: Responses with no explanation of why you recommend a particular rate will receive NO credit Excel Trick: Use Alt+Enter co go to a new line BE 58 6: 62 64
