Use the info from the first photo for bond information. Answers can be given as excel formulas

The bond you will use, to answer all questions is as follows: $1,000 par value, 5-year, 8.6% coupon bond Coupons payable semi-annually Redemption value equals par value The coupon rate, as usual in the bond world, is a nominal rate payable semi-annually B C D E G F Construct the amortization schedule for Your Bond assuming you pay $1100 for it at time zero. Time (yrs) Beg Balance Interest Payment End Balance 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5