A 9 year bond with a face value of $11,000.00 has a coupon rate of 4.000%. It is purchased at a yield of 5.120%. For parts b), c), and d), give formulas that don't require using the spreadsheet (i.e can be done with just a calculator). (See SS2Template.) a) Construct a spreadsheet for the Bond Amortization Table for this bond. (See SS2Template) b) How much is the premium/discount? c) How much is the interest for coupon period 4 ? d) How much is the amortization of discount/premium for coupon period 4 ? A 9 year bond with a face value of $11,000.00 has a coupon rate of 4.000%. It is purchased at a yield of 5.120%. For parts b), c), and d), give formulas that don't require using the spreadsheet (i.e can be done with just a calculator). (See SS2Template.) a) Construct a spreadsheet for the Bond Amortization Table for this bond. (See SS2Template) b) How much is the premium/discount? c) How much is the interest for coupon period 4 ? d) How much is the amortization of discount/premium for coupon period 4