Please use Excel to construct Bond Amortization Schedule:

Time , Payment, Interest Due, Principal Repaid, Oustabding Balance

A 10% bond has face amount 10,000. For each combination of the following number of coupon periods and six-month yield rates, use a computer spreadsheet program to construct the amortization table and draw the graph of OB n-1,5,10,30; j .025,.05, .075